1. Home
  2. Resources
  3. SAP Tables
  4. EMG_KNA1 - Business Partner: Migration of Customer Master (Gen. Part)

SAP Table EMG_KNA1

Business Partner: Migration of Customer Master (Gen. Part)

EMG_KNA1 (Business Partner: Migration of Customer Master (Gen. Part)) 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 EMG_KNA1 to other SAP tables.

EMG_KNA1 table fields

Field Data element Checktable Datatype Length Decimals
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 German Standard Company Number (Batch Input Field) BBBNR_BI CHAR 7 0
BBSNR German Standard Company Number (Additional) (Batch Input) BBSNR_BI CHAR 5 0
BEGRU_KNA1 Authorization Group BRGRU CHAR 4 0
BRSCH Industry key BRSCH CHAR 4 0
BUBKZ German Standard Company Number Check Digit (Batch Input) BUBKZ_BI CHAR 1 0
DATLT Data communication line no. DATLT CHAR 14 0
ERDAT Date for Direct Input DATUM_DI CHAR 10 0
ERNAM Name of Person who Created the Object ERNAM_RF CHAR 12 0
EXABL Indicator: Unloading points exist EXABL CHAR 1 0
X Yes
NULL No
FAKSD Central billing block for customer FAKSD_X CHAR 2 0
FISKN_KNA1 Account number of the master record with the fiscal address FISKN_D CHAR 10 0
KNAZK Working Time Calendar KNAZK CHAR 2 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
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
NAME3 Name 3 NAME3_GP CHAR 35 0
NAME4 Name 4 NAME4_GP CHAR 35 0
NIELS Nielsen ID NIELS CHAR 2 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
COUNC_KNA1 County Code COUNC CHAR 3 0
CITYC_KNA1 City Code CITYC CHAR 4 0
RPMKR Regional Market RPMKR CHAR 5 0
SPERR Central posting block SPERB_X CHAR 1 0
X Yes
NULL No
SPRAS Language key (batch input) SPRAS_BI CHAR 1 0
STCD1_KNA1 Tax Number 1 STCD1 CHAR 16 0
STCD2_KNA1 Tax Number 2 STCD2 CHAR 11 0
STKZA_KNA1 Indicator: Business Partner Subject to Equalization Tax? STKZA CHAR 1 0
NULL Not subject to equalization tax
X Subject to equalization tax
STKZU_KNA1 Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
TELBX Telebox number TELBX CHAR 15 0
TELF2 Second telephone number TELF2 CHAR 16 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: Is an alternative payer allowed in document? XREGU CHAR 1 0
X Yes
NULL No
VBUND Company ID of trading partner RASSC CHAR 6 0
STCEG_KNA1 VAT Registration Number STCEG CHAR 20 0
DEAR1 Indicator: Competitor DEAR1 CHAR 1 0
X Yes
NULL No
DEAR2 Indicator: Sales partner DEAR2 CHAR 1 0
X Yes
NULL No
DEAR3 Indicator: Sales prospect DEAR3 CHAR 1 0
X yes
NULL No
DEAR4 Indicator for customer type 4 DEAR4 CHAR 1 0
X Yes
NULL No
DEAR5 ID for default sold-to party DEAR5 CHAR 1 0
X Yes
NULL No
GFORM Legal status GFORM CHAR 2 0
BRAN1_KNA1 Industry Code 1 BRAN1_D CHAR 10 0
BRAN2_KNA1 Industry code 2 BRAN2 CHAR 10 0
BRAN3_KNA1 Industry code 3 BRAN3 CHAR 10 0
BRAN4_KNA1 Industry code 4 BRAN4 CHAR 10 0
BRAN5_KNA1 Industry code 5 BRAN5 CHAR 10 0
EKONT Initial contact EKONT CHAR 10 0
UMSAT Character Field Length = 10 CHAR10 CHAR 10 0
UMJAH Sales Year (Batch Input) UMJAH_BI CHAR 4 0
UWAER Currency key (BTCI) WAERS_BI CHAR 5 0
JMZAH No.of employees for the year (batch input) JMZAH_BI CHAR 6 0
JMJAH Year for which number is given (batch input) JMJAH_BI 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 Char 20 CHAR20 CHAR 20 0
TXJCD_KNA1 Tax Jurisdiction TXJCD CHAR 15 0
PERIV Fiscal Year Variant PERIV CHAR 2 0
ABRVW Usage Indicator ABRVW CHAR 3 0
INSPBYDEBI Inspection Carried Out By Customer (No Inspection Lot) QINSPBYDEB CHAR 1 0
NULL Indicator is not set
X Indicator is set
INSPATDEBI Inspection for a Delivery Note After Outbound Delivery QINSPATDEB CHAR 1 0
NULL Indicator is not set
X Indicator is set
KTOCD Reference Account Group for One-Time Account (Customer) KTOCD CHAR 4 0
PFORT PO Box city PFORT_GP CHAR 35 0
WERKS Plant WERKS_D CHAR 4 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
DUEFL Status of Data Transfer into Subsequent Release DUEFL_BKPF CHAR 1 0
NULL Not transferred yet
A Transfer taken place, document changed later
X Transfer taken place, document unchanged
HZUOR Hierarchy assignment (batch input) HZUOR_BI CHAR 2 0
SPERZ Payment Block SPERZ CHAR 1 0
X Yes
NULL No
ETIKG IS-R Labeling: customer/plant group ETIKG CHAR 10 0
CIVVE ID for mainly non-military use CIVVE CHAR 1 0
X Yes
NULL No
MILVE ID for mainly military use MILVE CHAR 1 0
X Yes
NULL No
KDKG1 Customer condition group 1 KDKG1 CHAR 2 0
KDKG2 Customer condition group 2 KDKG2 CHAR 2 0
KDKG3 Customer condition group 3 KDKG3 CHAR 2 0
KDKG4 Customer condition group 4 KDKG4 CHAR 2 0
KDKG5 Customer condition group 5 KDKG5 CHAR 2 0
XKNZA Indicator: Alternative payer using account number XKNZA CHAR 1 0
X Yes
NULL No
FITYP Tax type J_1AFITP_D CHAR 2 0
STCDT Tax Number Type J_1ATOID CHAR 2 0
STCD3 Tax Number 3 STCD3 CHAR 18 0
STCD4 Tax Number 4 STCD4 CHAR 18 0
XICMS Customer is ICMS-exempt J_1BTCICMS CHAR 1 0
X Yes
NULL No
XXIPI Customer is IPI-exempt J_1BTCIPI CHAR 1 0
X Yes
NULL No
XSUBT Customer group for Substitui�ao Tribut�ria calculation J_1BTCST CHAR 3 0
CFOPC Customer's CFOP category J_1BINDUS1 CHAR 2 0
00 industry (cooperative)
01 electric co.
02 communication co.
03 transport co.
04 service co.
05 consumer industry (cooperative)
06 non-contributing customer
07 agricultural customer
08 trading company
09 producer establishment
TXLW1 Tax law: ICMS J_1BTAXLW1 CHAR 3 0
TXLW2 Tax law: IPI J_1BTAXLW2 CHAR 3 0
CCC01 Indicator for biochemical warfare for legal control CCC01 CHAR 1 0
X Yes
NULL No
CCC02 Indicator for nuclear nonproliferation for legal control CCC02 CHAR 1 0
X Yes
NULL No
CCC03 Indicator for national security for legal control CCC03 CHAR 1 0
X Yes
NULL No
CCC04 Indicator for missile technology for legal control CCC04 CHAR 1 0
X Yes
NULL No
CASSD Central sales block for customer CASSD_X CHAR 2 0
KNURL Uniform Resource Locator URL CHAR 132 0
J_1KFREPRE Name of Representative REPRES CHAR 10 0
J_1KFTBUS Type of Business GESTYP CHAR 30 0
J_1KFTIND Type of Industry INDTYP CHAR 30 0
NODEL_KNA1 Central deletion block for master record NODEL_X CHAR 1 0
X Yes
NULL No
DEAR6 Indicator: Consumer DEAR6 CHAR 1 0
X Yes
NULL No