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


SAP /SAPXCQM/CUSTOMER table summary

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


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table