SAP table BAPICUSTOMER_KNA1 (BAPI Interface Structure with KNA1 Fields Without Address)

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

BAPICUSTOMER_KNA1 foreign key relationships

Table Field Check Table Check Field
0 BAPICUSTOMER_KNA1 ACCNT_GRP T077D Customer account groups MANDT
1 BAPICUSTOMER_KNA1 CUSTOMER KNA1 General Data in Customer Master MANDT
1 BAPICUSTOMER_KNA1 CUSTOMER KNA1 General Data in Customer Master KUNNR
0 BAPICUSTOMER_KNA1 INDUSTRY T016 Industries BRSCH