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_CODECustomer NumberKUNNRCHAR10(0) Assigned to domainALPHAKUNNRKUNC_KUNNRKUNNR
SORT_FIELDSearch Term 1AD_SORT1CHAR20(0) CHAR20
FORM_OF_ADForm of address for contact person (Mr, Mrs...etc)ANRED_APCHAR30(0) TEXT30
NAMEName 1AD_NAME1CHAR40(0) TEXT40
NAME_2Name 2AD_NAME2CHAR40(0) TEXT40
NAME_3Name 3AD_NAME3CHAR40(0) TEXT40
NAME_4Name 4AD_NAME4CHAR40(0) TEXT40
DATE_BIRTHDate of BirthGBDATDATS8(0) PDATEGBDAT
HOUSE_NOHouse NumberAD_HSNM1CHAR10(0) TEXT10
STREETStreetAD_STR_OLDCHAR40(0) TEXT40
POSTL_COD1City postal codeAD_PSTCD1CHAR10(0) CHAR10
CITYCityAD_CITY1CHAR40(0) TEXT40CLCITYNAMECITY_NAME
REGIONRegion (State, Province, County)REGIOCHAR3(0) T005SREGIO
COUNTRYCountry KeyLAND1CHAR3(0) T005LAND1LND
COUNTRYISOCountry ISO codeINTCACHAR2(0) INTCAF4_INTCAINTCA
E_MAILE-Mail AddressAD_SMTPADRCHAR241(0) SXIDNAD_SMTPADR
FAX_NUMBERFirst fax no.: dialling code+numberAD_FXNMBR1CHAR30(0) CHAR30
FAX_EXTENSFirst fax no.: extensionAD_FXXTNS1CHAR10(0) CHAR10
TEL1_NUMBRFirst telephone no.: dialling code+numberAD_TLNMBR1CHAR30(0) CHAR30
TEL1_EXTFirst Telephone No.: ExtensionAD_TLXTNS1CHAR10(0) CHAR10
LANGULanguage KeySPRASLANG1(0) Assigned to domainISOLASPRASSPRH_T002SPRAS
LANGU_ISO2-Character SAP Language CodeLAISOCHAR2(0) LAISO
CURRENCYCurrency KeyWAERSCUKY5(0) TCURCWAERSFWS
CURRENCY_ISOISO code currencyWAERS_ISOCHAR3(0) ISOCD
ONLY_CHANGE_COMADDRESSCheckboxXFELDCHAR1(0) XFELD
ONE_TIME_FLAGIndicator: Is the account a one-time account?XCPDKCHAR1(0) XFELD
BLOCKEDCentral order block for customerAUFSD_XCHAR2(0) Assigned to domainKAUFS
SAL_DISDistribution ChannelVTWEGCHAR2(0) Assigned to domainVTWEGVTWC_VTWEGVTWEG
SAL_DIVDivisionSPARTCHAR2(0) Assigned to domainSPARTSPAC_SPARTSPART
SALES_ORGSales OrganizationVKORGCHAR4(0) Assigned to domainVKORGVKOC_VKORGVKORG
ZTERMTerms of payment keyDZTERMCHAR4(0) ZTERM
VWERKDelivering PlantDWERKCHAR4(0) Assigned to domainWERKS
VSORTItem proposalVSORTCHAR10(0) Assigned to domainALPHAVBELN
SHIPPING_CONDShipping ConditionsVSBEDCHAR2(0) Assigned to domainVSBED
PARTNER_EMPLOYEEPartner in SD documentPARTNER_VBCHAR25(0) CHAR25
PAR_EMP_UNAMEUser NameUSNAMCHAR12(0) Assigned to domainXUBNAMEUSR




Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!