1. Home
  2. Resources
  3. SAP Tables
  4. BAPICUSTOMER_KNA1 - BAPI Interface Structure with KNA1 Fields Without Address

SAP Table BAPICUSTOMER_KNA1

BAPI Interface Structure with KNA1 Fields Without Address

BAPICUSTOMER_KNA1 (BAPI Interface Structure with KNA1 Fields Without Address) 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 BAPICUSTOMER_KNA1 to other SAP tables.

Source: BAPICUSTOMER_KNA1 (BAPI Interface Structure with KNA1 Fields Without Address)

BAPICUSTOMER_KNA1 table fields

Field Data element Checktable Datatype Length Decimals
CUSTOMER Customer Number KUNNR KNA1 CHAR 10 0
ACC_1_TIME Indicator: Is the account a one-time account? XCPDK CHAR 1 0
X Yes
NULL No
ADDRESS Address ADRNR CHAR 10 0
ORDR_BLK_G Central order block for customer AUFSD_X CHAR 2 0
EXPR_STAT Express train station BAHNE CHAR 25 0
TRAIN_STAT Train station BAHNS CHAR 25 0
LOC_NO_1 International location number (part 1) BBBNR NUMC 7 0
LOC_NO_2 International location number (Part 2) BBSNR NUMC 5 0
AUTH_GROUP Authorization Group BRGRU CHAR 4 0
INDUSTRY Industry key BRSCH T016 CHAR 4 0
CHK_DIGIT Check digit for the international location number BUBKZ NUMC 1 0
DATA_LINE Data communication line no. DATLT CHAR 14 0
CREAT_DATE Date on which the Record Was Created ERDAT_RF DATS 8 0
ENTERED_BY Name of Person who Created the Object ERNAM_RF CHAR 12 0
UNLOAD_PT Indicator: Unloading points exist EXABL CHAR 1 0
X Yes
NULL No
BILL_BLK_G Central billing block for customer FAKSD_X CHAR 2 0
FISK_ADDR Account number of the master record with the fiscal address FISKN_D CHAR 10 0
WORK_TIME Working Time Calendar KNAZK TFACD CHAR 2 0
ALT_PAYER Account number of an alternative payer KNRZA CHAR 10 0
GROUPKEY Group key KONZS CHAR 10 0
ACCNT_GRP Customer Account Group KTOKD T077D CHAR 4 0
CLASSIFIC Customer classification KUKLA CHAR 2 0
VENDOR_NO Account Number of Vendor or Creditor LIFNR CHAR 10 0
DELI_BLK_G Central delivery block for the customer LIFSD_X CHAR 2 0
LOC_CODE City Coordinates LOCCO CHAR 10 0
DEL_FLAG_G Central Deletion Flag for Master Record LOEVM_X CHAR 1 0
X Yes
NULL No
REG_MARKET Regional Market RPMKR CHAR 5 0
PSTG_BLK_G Central posting block SPERB_X CHAR 1 0
X Yes
NULL No
TAX_NO_1 Tax Number 1 STCD1 CHAR 16 0
TAX_NO_2 Tax Number 2 STCD2 CHAR 11 0
EQUAL_TAX Indicator: Business Partner Subject to Equalization Tax? STKZA CHAR 1 0
NULL Not subject to equalization tax
X Subject to equalization tax
SLS_PUR_TX Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
PAYER_DOC Indicator: Is an alternative payer allowed in document? XREGU CHAR 1 0
X Yes
NULL No
TRADE_ID Company ID of trading partner RASSC CHAR 6 0
VAT_REG_NO VAT Registration Number STCEG CHAR 20 0
COMPETITOR Indicator: Competitor DEAR1 CHAR 1 0
X Yes
NULL No
SLSPARTNER Indicator: Sales partner DEAR2 CHAR 1 0
X Yes
NULL No
PROSPECT Indicator: Sales prospect DEAR3 CHAR 1 0
X yes
NULL No
CUSTTYPE_4 Indicator for customer type 4 DEAR4 CHAR 1 0
X Yes
NULL No
DFLT_SP ID for default sold-to party DEAR5 CHAR 1 0
X Yes
NULL No
LEGALSTAT Legal status GFORM CHAR 2 0
IND_CODE_1 Industry Code 1 BRAN1_D CHAR 10 0
IND_CODE_2 Industry code 2 BRAN2 CHAR 10 0
IND_CODE_3 Industry code 3 BRAN3 CHAR 10 0
IND_CODE_4 Industry code 4 BRAN4 CHAR 10 0
IND_CODE_5 Industry code 5 BRAN5 CHAR 10 0
INITCONTCT Initial contact EKONT CHAR 10 0
ANN_SALES Currency amount in BAPI interfaces BAPICURR_D DEC 23 4
SALES_YEAR Year For Which Sales are Given UMJAH NUMC 4 0
CURRENCY Currency Key WAERS CUKY 5 0
CURRENCY_ISO ISO currency code ISOCD CHAR 3 0
EMPLOYEES Yearly number of employees JMZAH NUMC 6 0
EMPL_YEAR Year for which the number of employees is given JMJAH NUMC 4 0
ATTRIBUTE Attribute 1 KATR1 CHAR 2 0
ATTRIB_2 Attribute 2 KATR2 CHAR 2 0
ATTRIB_3 Attribute 3 KATR3 CHAR 2 0
ATTRIB_4 Attribute 4 KATR4 CHAR 2 0
ATTRIB_5 Attribute 5 KATR5 CHAR 2 0
ATTRIB_6 Attribute 6 KATR6 CHAR 3 0
ATTRIB_7 Attribute 7 KATR7 CHAR 3 0
ATTRIB_8 Attribute 8 KATR8 CHAR 3 0
ATTRIB_9 Attribute 9 KATR9 CHAR 3 0
ATTRIB_10 Attribute 10 KATR10 CHAR 3 0
SOLE_PROP Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
ANN_SALES1 Currency amount in BAPI interfaces BAPICURR_D DEC 23 4
TAXJURCODE Tax Jurisdiction TXJCD CHAR 15 0
FY_VARIANT Fiscal Year Variant PERIV CHAR 2 0
DLVSCHEDUSE Usage Indicator ABRVW CHAR 3 0
INSPBYCUST Inspection Carried Out By Customer (No Inspection Lot) QINSPBYDEB CHAR 1 0
NULL Indicator is not set
X Indicator is set
INSPAFTDEL Inspection for a Delivery Note After Outbound Delivery QINSPATDEB CHAR 1 0
NULL Indicator is not set
X Indicator is set
REF_ACTGR Reference Account Group for One-Time Account (Customer) KTOCD CHAR 4 0
PLANT Plant WERKS_D CHAR 4 0
DME_IND 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
INSTR_KEY Instruction key for data medium exchange DTAWS CHAR 2 0
DATA_TRANS 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
ASSIGN_HI Assignment to Hierarchy HZUOR NUMC 2 0
PMNT_BLOCK Payment Block SPERZ CHAR 1 0
X Yes
NULL No
LABCUSTGRP IS-R Labeling: customer/plant group ETIKG CHAR 10 0
NON_MILIT ID for mainly non-military use CIVVE CHAR 1 0
X Yes
NULL No
MILIT_USE ID for mainly military use MILVE CHAR 1 0
X Yes
NULL No
CUST_COND_GRP1 Customer condition group 1 KDKG1 CHAR 2 0
CUST_COND_GRP2 Customer condition group 2 KDKG2 CHAR 2 0
CUST_COND_GRP3 Customer condition group 3 KDKG3 CHAR 2 0
CUST_COND_GRP4 Customer condition group 4 KDKG4 CHAR 2 0
CUST_COND_GRP5 Customer condition group 5 KDKG5 CHAR 2 0
ALTPAYERAC Indicator: Alternative payer using account number XKNZA CHAR 1 0
X Yes
NULL No
TAX_TYPE Tax type J_1AFITP_D CHAR 2 0
TAX_NO_TY Tax Number Type J_1ATOID CHAR 2 0
TAX_NO_3 Tax Number 3 STCD3 CHAR 18 0
TAX_NO_4 Tax Number 4 STCD4 CHAR 18 0
NO_ICMS Customer is ICMS-exempt J_1BTCICMS CHAR 1 0
X Yes
NULL No
NO_IPI Customer is IPI-exempt J_1BTCIPI CHAR 1 0
X Yes
NULL No
SUBT_GRP Customer group for Substituiçao Tributária calculation J_1BTCST CHAR 3 0
CFOP_CAT 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
TAXLAWICMS Tax law: ICMS J_1BTAXLW1 CHAR 3 0
TAXLAWIPI Tax law: IPI J_1BTAXLW2 CHAR 3 0
BCW Indicator for biochemical warfare for legal control CCC01 CHAR 1 0
X Yes
NULL No
NUCL_NONP Indicator for nuclear nonproliferation for legal control CCC02 CHAR 1 0
X Yes
NULL No
NATL_SEC Indicator for national security for legal control CCC03 CHAR 1 0
X Yes
NULL No
MISS_TECH Indicator for missile technology for legal control CCC04 CHAR 1 0
X Yes
NULL No
SALES_BLKG Central sales block for customer CASSD_X CHAR 2 0
URL Uniform Resource Locator URL CHAR 132 0
REP_NAME Name of Representative REPRES CHAR 10 0
BUS_TYPE Type of Business GESTYP CHAR 30 0
IND_TYPE Type of Industry INDTYP CHAR 30 0
CONF_ST Status of Change Authorization (Central) CONFS_X CHAR 1 0
CONF_DATE Date on Which the Changes Were Confirmed UPDAT_RF DATS 8 0
CONF_TIME Time of Last Change Confirmation UPTIM_RF TIMS 6 0
NO_DELETE Central deletion block for master record NODEL_X CHAR 1 0
X Yes
NULL No
CONSUMER Indicator: Consumer DEAR6 CHAR 1 0
X Yes
NULL No
TAX_NO_5 Tax Number 5 STCD5 CHAR 60 0

BAPICUSTOMER_KNA1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPICUSTOMER_KNA1 ACCNT_GRP SYST MANDT T077D Customer account groups MANDT
BAPICUSTOMER_KNA1 ACCNT_GRP BAPICUSTOMER_KNA1 ACCNT_GRP T077D Customer account groups KTOKD
BAPICUSTOMER_KNA1 CUSTOMER SYST MANDT KNA1 General Data in Customer Master MANDT
BAPICUSTOMER_KNA1 CUSTOMER BAPICUSTOMER_KNA1 CUSTOMER KNA1 General Data in Customer Master KUNNR
BAPICUSTOMER_KNA1 INDUSTRY SYST MANDT T016 Industries MANDT
BAPICUSTOMER_KNA1 INDUSTRY BAPICUSTOMER_KNA1 INDUSTRY T016 Industries BRSCH
BAPICUSTOMER_KNA1 WORK_TIME BAPICUSTOMER_KNA1 WORK_TIME TFACD Factory calendar definition IDENT