SAP MSR1_CUSTOMER Table in S/4 HANA - MSR: Customer Master
MSR1_CUSTOMER is a standard SAP Table which is used to store MSR: Customer Master data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MSR1_CUSTOMER table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Structure
Database Table: MSR1_CUSTOMER
MSR1_CUSTOMER table structure field list
Below is the full MSR1_CUSTOMER field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
CUSTOMER_CODE | Customer Number | KUNNR | CHAR | 10(0) | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR |
SORT_FIELD | Search Term 1 | AD_SORT1 | CHAR | 20(0) | CHAR20 | |||||
FORM_OF_AD | Form of address for contact person (Mr, Mrs...etc) | ANRED_AP | CHAR | 30(0) | TEXT30 | |||||
NAME | Name 1 | AD_NAME1 | CHAR | 40(0) | TEXT40 | |||||
NAME_2 | Name 2 | AD_NAME2 | CHAR | 40(0) | TEXT40 | |||||
NAME_3 | Name 3 | AD_NAME3 | CHAR | 40(0) | TEXT40 | |||||
NAME_4 | Name 4 | AD_NAME4 | CHAR | 40(0) | TEXT40 | |||||
DATE_BIRTH | Date of Birth | GBDAT | DATS | 8(0) | PDATE | GBDAT | ||||
HOUSE_NO | House Number | AD_HSNM1 | CHAR | 10(0) | TEXT10 | |||||
STREET | Street | AD_STR_OLD | CHAR | 40(0) | TEXT40 | |||||
POSTL_COD1 | City postal code | AD_PSTCD1 | CHAR | 10(0) | CHAR10 | |||||
CITY | City | AD_CITY1 | CHAR | 40(0) | TEXT40 | CLCITYNAME | CITY_NAME | |||
REGION | Region (State, Province, County) | REGIO | CHAR | 3(0) | T005S | REGIO | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3(0) | T005 | LAND1 | LND | |||
COUNTRYISO | Country ISO code | INTCA | CHAR | 2(0) | INTCA | F4_INTCA | INTCA | |||
E_MAIL | E-Mail Address | AD_SMTPADR | CHAR | 241(0) | SXIDN | AD_SMTPADR | ||||
FAX_NUMBER | First fax no.: dialling code+number | AD_FXNMBR1 | CHAR | 30(0) | CHAR30 | |||||
FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR | 10(0) | CHAR10 | |||||
TEL1_NUMBR | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30(0) | CHAR30 | |||||
TEL1_EXT | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10(0) | CHAR10 | |||||
LANGU | Language Key | SPRAS | LANG | 1(0) | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 | SPRAS |
LANGU_ISO | 2-Character SAP Language Code | LAISO | CHAR | 2(0) | LAISO | |||||
CURRENCY | Currency Key | WAERS | CUKY | 5(0) | TCURC | WAERS | FWS | |||
CURRENCY_ISO | ISO code currency | WAERS_ISO | CHAR | 3(0) | ISOCD | |||||
ONLY_CHANGE_COMADDRESS | Checkbox | XFELD | CHAR | 1(0) | XFELD | |||||
ONE_TIME_FLAG | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1(0) | XFELD | |||||
BLOCKED | Central order block for customer | AUFSD_X | CHAR | 2(0) | Assigned to domain | KAUFS | ||||
SAL_DIS | Distribution Channel | VTWEG | CHAR | 2(0) | Assigned to domain | VTWEG | VTW | C_VTWEG | VTWEG | |
SAL_DIV | Division | SPART | CHAR | 2(0) | Assigned to domain | SPART | SPA | C_SPART | SPART | |
SALES_ORG | Sales Organization | VKORG | CHAR | 4(0) | Assigned to domain | VKORG | VKO | C_VKORG | VKORG | |
ZTERM | Terms of payment key | DZTERM | CHAR | 4(0) | ZTERM | |||||
VWERK | Delivering Plant | DWERK | CHAR | 4(0) | Assigned to domain | WERKS | ||||
VSORT | Item proposal | VSORT | CHAR | 10(0) | Assigned to domain | ALPHA | VBELN | |||
SHIPPING_COND | Shipping Conditions | VSBED | CHAR | 2(0) | Assigned to domain | VSBED | ||||
PARTNER_EMPLOYEE | Partner in SD document | PARTNER_VB | CHAR | 25(0) | CHAR25 | |||||
PAR_EMP_UNAME | User Name | USNAM | CHAR | 12(0) | Assigned to domain | XUBNAME | USR |
Search for further information about these or an SAP related objects