SAP table E2KNA1M (Master customer master basic data (KNA1))

Field Description Data Type Length Decimals Checktable Data Element
MSGFN Function CHAR 3 0 MSGFN
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
018 Resend
023 Wait/Adjust: Do not import data
KUNNR Customer Number CHAR 10 0 * KUNNR
ANRED Title CHAR 15 0 ANRED
AUFSD Central order block for customer CHAR 2 0 * AUFSD_X
BAHNE Express train station CHAR 25 0 BAHNE
BAHNS Train station CHAR 25 0 BAHNS
BBBNR Character Field With Field Length 7 CHAR 7 0 CHAR07
BBSNR R/2 table CHAR 5 0 CHAR5
BEGRU Authorization Group CHAR 4 0 * BRGRU
BRSCH Industry key CHAR 4 0 * BRSCH
BUBKZ Character field of length 1 CHAR 1 0 CHAR_LG_01
DATLT Data communication line no. CHAR 14 0 DATLT
FAKSD Central billing block for customer CHAR 2 0 * FAKSD_X
FISKN Account number of the master record with the fiscal address CHAR 10 0 * FISKN_D
KNRZA Account Number of an Alternative Payer CHAR 10 0 * KNRZA
KONZS Group key CHAR 10 0 KONZS
KTOKD Customer Account Group CHAR 4 0 * KTOKD
KUKLA Customer Classification CHAR 2 0 * KUKLA
LAND1 Country/Region Key CHAR 3 0 * LAND1_GP
LIFNR Account Number of Supplier CHAR 10 0 * LIFNR
LIFSD Central delivery block for the customer CHAR 2 0 * LIFSD_X
LOCCO City Coordinates CHAR 10 0 LOCCO
LOEVM Central Deletion Flag for Master Record CHAR 1 0 LOEVM_X
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAME2 Name 2 CHAR 35 0 NAME2_GP
NAME3 Name 3 CHAR 35 0 NAME3_GP
NAME4 Name 4 CHAR 35 0 NAME4_GP
NIELS Nielsen ID CHAR 2 0 * NIELS
ORT01 City CHAR 35 0 ORT01_GP
ORT02 District CHAR 35 0 ORT02_GP
PFACH PO Box CHAR 10 0 PFACH
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
PSTLZ Postal Code CHAR 10 0 PSTLZ
REGIO Region (State, Province, County) CHAR 3 0 * REGIO
COUNC County Code CHAR 3 0 * COUNC
CITYC City Code CHAR 4 0 * CITYC
RPMKR Regional market CHAR 5 0 RPMKR
SORTL Sort field CHAR 10 0 SORTL
SPERR Central posting block CHAR 1 0 SPERB_X
SPRAS Character field of length 1 CHAR 1 0 CHAR_LG_01
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
STKZA Indicator: Business Partner Subject to Equalization Tax? CHAR 1 0 STKZA
Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT CHAR 1 0 STKZU
STRAS Street and House Number CHAR 35 0 STRAS_GP
TELBX Telebox number CHAR 15 0 TELBX
TELF1 First telephone number CHAR 16 0 TELF1
TELF2 Second telephone number CHAR 16 0 TELF2
TELFX Fax Number CHAR 31 0 TELFX
TELTX Teletex number CHAR 30 0 TELTX
TELX1 Telex number CHAR 30 0 TELX1
LZONE Transportation zone to or from which the goods are delivered CHAR 10 0 * LZONE
XZEMP Indicator: Alternative Payee in Document Allowed? CHAR 1 0 XZEMP
VBUND Company ID of Trading Partner CHAR 6 0 * RASSC
STCEG VAT Registration Number CHAR 20 0 STCEG
GFORM Legal status CHAR 2 0 * GFORM
BRAN1 Industry code 1 CHAR 10 0 * BRAN1_D
BRAN2 Industry code 2 CHAR 10 0 * BRAN2
BRAN3 Industry code 3 CHAR 10 0 * BRAN3
BRAN4 Industry code 4 CHAR 10 0 * BRAN4
BRAN5 Industry code 5 CHAR 10 0 * BRAN5
UMJAH Undefined range (can be used for patch levels) CHAR 4 0 CHAR4
UWAER R/2 table CHAR 5 0 CHAR5
JMZAH Character field of length 6 CHAR 6 0 CHAR6
JMJAH Undefined range (can be used for patch levels) CHAR 4 0 CHAR4
KATR1 Attribute 1 CHAR 2 0 * KATR1
KATR2 Attribute 2 CHAR 2 0 * KATR2
KATR3 Attribute 3 CHAR 2 0 * KATR3
KATR4 Attribute 4 CHAR 2 0 * KATR4
KATR5 Attribute 5 CHAR 2 0 * KATR5
KATR6 Attribute 6 CHAR 3 0 * KATR6
KATR7 Attribute 7 CHAR 3 0 * KATR7
KATR8 Attribute 8 CHAR 3 0 * KATR8
KATR9 Attribute 9 CHAR 3 0 * KATR9
KATR10 Attribute 10 CHAR 3 0 * KATR10
STKZN Natural Person CHAR 1 0 STKZN
Legal person
X Natural person
UMSA1 Field of length 16 CHAR 16 0 CHAR16
TXJCD Tax Jurisdiction CHAR 15 0 * TXJCD
PERIV Fiscal Year Variant CHAR 2 0 * PERIV
KTOCD Reference Account Group for One-Time Account (Customer) CHAR 4 0 * KTOCD
PFORT PO Box city CHAR 35 0 PFORT_GP
DTAMS Report key for data medium exchange CHAR 1 0 DTAMS
Use house bank default value
0 Single data record can be forwarded to the Bundesbank
1 Single data record not to be forwarded to the Bundesbank
DTAWS Instruction Key for Data Medium Exchange CHAR 2 0 * DTAWS