SAP MSR20_CUSTOMER table - MSR: Customer Master details in SAP


SAP MSR20_CUSTOMER table summary

Object Name: MSR20_CUSTOMER
Dictionary Type: Structure
Description: MSR: Customer Master


Field list for MSR20_CUSTOMER table on an S/4 SAP system

Details
MSR20_CUSTOMER-CUSTOMER_CODE table field - Customer Number

Description: Customer Number
Field Name: CUSTOMER_CODE
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 CUSTOMER_CODE

MSR20_CUSTOMER-SORT_FIELD table field - Search Term 1

Description: Search Term 1
Field Name: SORT_FIELD
Data Element: AD_SORT1
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORT_FIELD

MSR20_CUSTOMER-FORM_OF_AD table field - Form of address for contact person (Mr, Mrs...etc)

Description: Form of address for contact person (Mr, Mrs...etc)
Field Name: FORM_OF_AD
Data Element: ANRED_AP
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FORM_OF_AD

MSR20_CUSTOMER-NAME table field - Name 1

Description: Name 1
Field Name: NAME
Data Element: AD_NAME1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

MSR20_CUSTOMER-NAME_2 table field - Name 2

Description: Name 2
Field Name: NAME_2
Data Element: AD_NAME2
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_2

MSR20_CUSTOMER-NAME_3 table field - Name 3

Description: Name 3
Field Name: NAME_3
Data Element: AD_NAME3
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_3

MSR20_CUSTOMER-NAME_4 table field - Name 4

Description: Name 4
Field Name: NAME_4
Data Element: AD_NAME4
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_4

MSR20_CUSTOMER-DATE_BIRTH table field - Date of Birth

Description: Date of Birth
Field Name: DATE_BIRTH
Data Element: GBDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine: PDATE
Domain Name: GBDAT
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit: PDATE

See all SAP tables containing field DATE_BIRTH

MSR20_CUSTOMER-HOUSE_NO table field - House Number

Description: House Number
Field Name: HOUSE_NO
Data Element: AD_HSNM1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSE_NO

MSR20_CUSTOMER-STREET table field - Street

Description: Street
Field Name: STREET
Data Element: AD_STR_OLD
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STREET

MSR20_CUSTOMER-POSTL_COD1 table field - City postal code

Description: City postal code
Field Name: POSTL_COD1
Data Element: AD_PSTCD1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTL_COD1

MSR20_CUSTOMER-CITY table field - City

Description: City
Field Name: CITY
Data Element: AD_CITY1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLCITYNAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field CITY

MSR20_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: T005S
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGION

MSR20_CUSTOMER-COUNTRY table field - Country/Region Key

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

See all SAP tables containing field COUNTRY

MSR20_CUSTOMER-COUNTRYISO table field - ISO Code of the Country/Region

Description: ISO Code of the Country/Region
Field Name: COUNTRYISO
Data Element: INTCA
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: INTCA
MemoryID:
AppClass:
SHLP: F4_INTCA
SHLP Field: INTCA
ConvExit:

See all SAP tables containing field COUNTRYISO

MSR20_CUSTOMER-E_MAIL table field - E-Mail Address

Description: E-Mail Address
Field Name: E_MAIL
Data Element: AD_SMTPADR
Data Type: CHAR
length (Dec): 241(0)
Check table:
Conversion Routine: SXIDN
Domain Name: AD_SMTPADR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: SXIDN

See all SAP tables containing field E_MAIL

MSR20_CUSTOMER-FAX_NUMBER table field - First Fax No.: Area Code + Number

Description: First Fax No.: Area Code + Number
Field Name: FAX_NUMBER
Data Element: AD_FXNMBR1
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAX_NUMBER

MSR20_CUSTOMER-FAX_EXTENS table field - First fax no.: extension

Description: First fax no.: extension
Field Name: FAX_EXTENS
Data Element: AD_FXXTNS1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAX_EXTENS

MSR20_CUSTOMER-TEL1_NUMBR table field - First telephone no.: dialling code+number

Description: First telephone no.: dialling code+number
Field Name: TEL1_NUMBR
Data Element: AD_TLNMBR1
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEL1_NUMBR

MSR20_CUSTOMER-TEL1_EXT table field - First Telephone No.: Extension

Description: First Telephone No.: Extension
Field Name: TEL1_EXT
Data Element: AD_TLXTNS1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEL1_EXT

MSR20_CUSTOMER-LANGU table field - Language Key

Description: Language Key
Field Name: LANGU
Data Element: SPRAS
Data Type: LANG
length (Dec): 1(0)
Check table: *
Conversion Routine: ISOLA
Domain Name: SPRAS
MemoryID: SPR
AppClass: STXD
SHLP: H_T002
SHLP Field: SPRAS
ConvExit: ISOLA

See all SAP tables containing field LANGU

MSR20_CUSTOMER-LANGU_ISO table field - 2-Character SAP Language Code

Description: 2-Character SAP Language Code
Field Name: LANGU_ISO
Data Element: LAISO
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: LAISO
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LANGU_ISO

MSR20_CUSTOMER-CURRENCY table field - Currency Key

Description: Currency Key
Field Name: CURRENCY
Data Element: WAERS
Data Type: CUKY
length (Dec): 5(0)
Check table: TCURC
Conversion Routine:
Domain Name: WAERS
MemoryID: FWS
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CURRENCY

MSR20_CUSTOMER-CURRENCY_ISO table field - ISO code currency

Description: ISO code currency
Field Name: CURRENCY_ISO
Data Element: WAERS_ISO
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ISOCD
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CURRENCY_ISO

MSR20_CUSTOMER-ONLY_CHANGE_COMADDRESS table field - Checkbox

Description: Checkbox
Field Name: ONLY_CHANGE_COMADDRESS
Data Element: XFELD
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 ONLY_CHANGE_COMADDRESS

MSR20_CUSTOMER-ONE_TIME_FLAG table field - Indicator: Is the account a one-time account?

Description: Indicator: Is the account a one-time account?
Field Name: ONE_TIME_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 ONE_TIME_FLAG

MSR20_CUSTOMER-BLOCKED table field - Central order block for customer

Description: Central order block for customer
Field Name: BLOCKED
Data Element: AUFSD_X
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: KAUFS
MemoryID:
AppClass: VA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCKED

MSR20_CUSTOMER-SAL_DIS table field - Distribution Channel

Description: Distribution Channel
Field Name: SAL_DIS
Data Element: VTWEG
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: VTWEG
MemoryID: VTW
AppClass: MG
SHLP: C_VTWEG
SHLP Field: VTWEG
ConvExit:

See all SAP tables containing field SAL_DIS

MSR20_CUSTOMER-SAL_DIV table field - Division

Description: Division
Field Name: SAL_DIV
Data Element: SPART
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: SPART
MemoryID: SPA
AppClass: V
SHLP: C_SPART
SHLP Field: SPART
ConvExit:

See all SAP tables containing field SAL_DIV

MSR20_CUSTOMER-SALES_ORG table field - Sales Organization

Description: Sales Organization
Field Name: SALES_ORG
Data Element: VKORG
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: VKORG
MemoryID: VKO
AppClass: MG
SHLP: C_VKORG
SHLP Field: VKORG
ConvExit:

See all SAP tables containing field SALES_ORG

MSR20_CUSTOMER-ZTERM table field - Terms of payment key

Description: Terms of payment key
Field Name: ZTERM
Data Element: DZTERM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ZTERM

MSR20_CUSTOMER-VWERK table field - Delivering Plant

Description: Delivering Plant
Field Name: VWERK
Data Element: DWERK
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: WERKS
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VWERK

MSR20_CUSTOMER-VSORT table field - Item proposal

Description: Item proposal
Field Name: VSORT
Data Element: VSORT
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: VBELN
MemoryID:
AppClass: V
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field VSORT

MSR20_CUSTOMER-SHIPPING_COND table field - Shipping Conditions

Description: Shipping Conditions
Field Name: SHIPPING_COND
Data Element: VSBED
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: VSBED
MemoryID:
AppClass: VV
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SHIPPING_COND

MSR20_CUSTOMER-PARTNER_EMPLOYEE table field - Partner in SD document

Description: Partner in SD document
Field Name: PARTNER_EMPLOYEE
Data Element: PARTNER_VB
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTNER_EMPLOYEE

MSR20_CUSTOMER-PAR_EMP_UNAME table field - User Name

Description: User Name
Field Name: PAR_EMP_UNAME
Data Element: USNAM
Data Type: CHAR
length (Dec): 12(0)
Check table: *
Conversion Routine:
Domain Name: XUBNAME
MemoryID: USR
AppClass: SUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAR_EMP_UNAME


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table