1. Home
  2. Resources
  3. SAP Tables
  4. E2KNA1M - Master customer master basic data (KNA1)

SAP Table E2KNA1M

Master customer master basic data (KNA1)

E2KNA1M (Master customer master basic data (KNA1)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link E2KNA1M to other SAP tables.

Source: E2KNA1M (Master customer master basic data (KNA1))

E2KNA1M table fields

Field Data element Checktable Datatype Length Decimals
MSGFN Function MSGFN CHAR 3 0
003 Delete: Message contains objects to be deleted
004 Change: Message contains changes
005 Replace: This message replaces previous messages
009 Original: First message for process
023 Wait/Adjust: Data should not be imported
018 Resend
KUNNR Customer Number KUNNR CHAR 10 0
ANRED Title ANRED CHAR 15 0
AUFSD Central order block for customer AUFSD_X CHAR 2 0
BAHNE Express train station BAHNE CHAR 25 0
BAHNS Train station BAHNS CHAR 25 0
BBBNR Character Field With Field Length 7 CHAR07 CHAR 7 0
BBSNR R/2 table CHAR5 CHAR 5 0
BEGRU Authorization Group BRGRU CHAR 4 0
BRSCH Industry key BRSCH CHAR 4 0
BUBKZ Character field of length 1 CHAR_LG_01 CHAR 1 0
DATLT Data communication line no. DATLT CHAR 14 0
FAKSD Central billing block for customer FAKSD_X CHAR 2 0
FISKN Account number of the master record with the fiscal address FISKN_D CHAR 10 0
KNRZA Account number of an alternative payer KNRZA CHAR 10 0
KONZS Group key KONZS CHAR 10 0
KTOKD Customer Account Group KTOKD CHAR 4 0
KUKLA Customer classification KUKLA CHAR 2 0
LAND1 Country Key LAND1_GP CHAR 3 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
LIFSD Central delivery block for the customer LIFSD_X CHAR 2 0
LOCCO City Coordinates LOCCO CHAR 10 0
LOEVM Central Deletion Flag for Master Record LOEVM_X CHAR 1 0
X Yes
NULL No
NAME1 Name 1 NAME1_GP CHAR 35 0
NAME2 Name 2 NAME2_GP CHAR 35 0
NAME3 Name 3 NAME3_GP CHAR 35 0
NAME4 Name 4 NAME4_GP CHAR 35 0
NIELS Nielsen ID NIELS CHAR 2 0
ORT01 City ORT01_GP CHAR 35 0
ORT02 District ORT02_GP CHAR 35 0
PFACH PO Box PFACH CHAR 10 0
PSTL2 P.O. Box Postal Code PSTL2 CHAR 10 0
PSTLZ Postal Code PSTLZ CHAR 10 0
REGIO Region (State, Province, County) REGIO CHAR 3 0
COUNC County Code COUNC CHAR 3 0
CITYC City Code CITYC CHAR 4 0
RPMKR Regional Market RPMKR CHAR 5 0
SORTL Sort field SORTL CHAR 10 0
SPERR Central posting block SPERB_X CHAR 1 0
X Yes
NULL No
SPRAS Character field of length 1 CHAR_LG_01 CHAR 1 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
STKZA Indicator: Business Partner Subject to Equalization Tax? STKZA CHAR 1 0
NULL Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
STRAS House number and street STRAS_GP CHAR 35 0
TELBX Telebox number TELBX CHAR 15 0
TELF1 First telephone number TELF1 CHAR 16 0
TELF2 Second telephone number TELF2 CHAR 16 0
TELFX Fax Number TELFX CHAR 31 0
TELTX Teletex number TELTX CHAR 30 0
TELX1 Telex number TELX1 CHAR 30 0
LZONE Transportation zone to or from which the goods are delivered LZONE CHAR 10 0
XZEMP Indicator: Alternative payee in document allowed ? XZEMP CHAR 1 0
X Yes
NULL No
VBUND Company ID of trading partner RASSC CHAR 6 0
STCEG VAT Registration Number STCEG CHAR 20 0
GFORM Legal status GFORM CHAR 2 0
BRAN1 Industry Code 1 BRAN1_D CHAR 10 0
BRAN2 Industry code 2 BRAN2 CHAR 10 0
BRAN3 Industry code 3 BRAN3 CHAR 10 0
BRAN4 Industry code 4 BRAN4 CHAR 10 0
BRAN5 Industry code 5 BRAN5 CHAR 10 0
UMJAH Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
UWAER R/2 table CHAR5 CHAR 5 0
JMZAH Character field of length 6 CHAR6 CHAR 6 0
JMJAH Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
KATR1 Attribute 1 KATR1 CHAR 2 0
KATR2 Attribute 2 KATR2 CHAR 2 0
KATR3 Attribute 3 KATR3 CHAR 2 0
KATR4 Attribute 4 KATR4 CHAR 2 0
KATR5 Attribute 5 KATR5 CHAR 2 0
KATR6 Attribute 6 KATR6 CHAR 3 0
KATR7 Attribute 7 KATR7 CHAR 3 0
KATR8 Attribute 8 KATR8 CHAR 3 0
KATR9 Attribute 9 KATR9 CHAR 3 0
KATR10 Attribute 10 KATR10 CHAR 3 0
STKZN Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
UMSA1 Field of length 16 CHAR16 CHAR 16 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
PERIV Fiscal Year Variant PERIV CHAR 2 0
KTOCD Reference Account Group for One-Time Account (Customer) KTOCD CHAR 4 0
PFORT PO Box city PFORT_GP CHAR 35 0
DTAMS Indicator for Data Medium Exchange DTAMS CHAR 1 0
1 Single data record not to be forwarded to the Bundesbank
0 Single data record can be forwarded to the Bundesbank
NULL Use house bank default value
DTAWS Instruction key for data medium exchange DTAWS CHAR 2 0