SAP /SAPXCQM/CUSTOMER table - Customer Master data (KNA1) details in SAP

SAP /SAPXCQM/CUSTOMER table summary

Warning: Undefined array key "id" in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 101

Object Name: /SAPXCQM/CUSTOMER
Dictionary Type: Structure
Description: Customer Master data (KNA1)

Field list for /SAPXCQM/CUSTOMER table on an S/4 SAP system

Details

/SAPXCQM/CUSTOMER-CUSTNR table field - Customer Number ▼

Description: Customer Number
Field Name: CUSTNR
Data Element: KUNNR
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: KUNNR
MemoryID: KUN
AppClass: V
SHLP: C_KUNNR
SHLP Field: KUNNR
ConvExit: ALPHA

See all SAP tables containing field CUSTNR

/SAPXCQM/CUSTOMER-COUNTRY table field - Country/Region Key ▼

Description: Country/Region Key
Field Name: COUNTRY
Data Element: LAND1_GP
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: LAND1
MemoryID:
AppClass: SAP
SHLP: C_LAND1
SHLP Field: LAND1
ConvExit:

See all SAP tables containing field COUNTRY

/SAPXCQM/CUSTOMER-FIRSTNAME table field - Name 1 ▼

Description: Name 1
Field Name: FIRSTNAME
Data Element: NAME1_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: NAME
MemoryID:
AppClass: VP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRSTNAME

/SAPXCQM/CUSTOMER-LASTNAME table field - Name 2 ▼

Description: Name 2
Field Name: LASTNAME
Data Element: NAME2_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: NAME
MemoryID:
AppClass: VP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTNAME

/SAPXCQM/CUSTOMER-COMPANYNAME table field - Name 1 ▼

Description: Name 1
Field Name: COMPANYNAME
Data Element: NAME1_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: NAME
MemoryID:
AppClass: VP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMPANYNAME

/SAPXCQM/CUSTOMER-CITY table field - City ▼

Description: City
Field Name: CITY
Data Element: ORT01_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: TEXT35
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CITY

/SAPXCQM/CUSTOMER-ZIP table field - Postal Code ▼

Description: Postal Code
Field Name: ZIP
Data Element: PSTLZ
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: PSTLZ
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ZIP

/SAPXCQM/CUSTOMER-REGION table field - Region (State, Province, County) ▼

Description: Region (State, Province, County)
Field Name: REGION
Data Element: REGIO
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGION

/SAPXCQM/CUSTOMER-STREET table field - Street and House Number ▼

Description: Street and House Number
Field Name: STREET
Data Element: STRAS_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: TEXT35
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STREET

/SAPXCQM/CUSTOMER-TELF1 table field - First telephone number ▼

Description: First telephone number
Field Name: TELF1
Data Element: TELF1
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: TEXT16
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TELF1

/SAPXCQM/CUSTOMER-TELFX table field - Fax Number ▼

Description: Fax Number
Field Name: TELFX
Data Element: TELFX
Data Type: CHAR
length (Dec): 31(0)
Check table:
Conversion Routine:
Domain Name: TEXT31
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TELFX

/SAPXCQM/CUSTOMER-ONEUSE_FLAG table field - Indicator: Is the account a one-time account? ▼

Description: Indicator: Is the account a one-time account?
Field Name: ONEUSE_FLAG
Data Element: XCPDK
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ONEUSE_FLAG

/SAPXCQM/CUSTOMER-ADDRESS table field - Address ▼

Description: Address
Field Name: ADDRESS
Data Element: ADRNR
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: ADRNR
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ADDRESS

/SAPXCQM/CUSTOMER-RECORD_STATUS table field - Status of record: New, Changed, Deleted ▼

Description: Status of record: New, Changed, Deleted
Field Name: RECORD_STATUS
Data Element: /SAPXCQM/STATUS_FLAG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: /SAPXCQM/ONECHAR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECORD_STATUS

/SAPXCQM/CUSTOMER-CREATION_DATE table field - External Document Creation date ▼

Description: External Document Creation date
Field Name: CREATION_DATE
Data Element: /SAPXCQM/DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: /SAPXCQM/DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATION_DATE

/SAPXCQM/CUSTOMER-EXTRA_DATA table field - Name + Value pairs (255 char limit) ▼

Description: Name + Value pairs (255 char limit)
Field Name: EXTRA_DATA
Data Element: /SAPXCQM/EXTRA_DATA
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: /SAPXCQM/CHAR255
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTRA_DATA

Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 234 Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 278 Warning: Undefined variable $obj1 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj2 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj3 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj4 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj5 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj6 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj7 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj8 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj9 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj10 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj11 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279

View list of all SAP tables(S4H/ECC)

Select data from SAP table