SAP table BAPICUSGEN (BAPI Structure: Customer, General Data)

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
ORDR_BLK_G Central order block for customer CHAR 2 0 TVAST 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 TVFS FAKSD_X
FISK_ADDR Account number of the master record with the fiscal address CHAR 10 0 KNA1 FISKN_D
WORK_TIME Working Time Calendar CHAR 2 0 TFACD KNAZK
ALT_PAYER Account Number of an Alternative Payer CHAR 10 0 KNA1 KNRZA
GROUPKEY Group key CHAR 10 0 KONZS
ACCNT_GRP Customer Account Group CHAR 4 0 T077D KTOKD
CLASSIFIC Customer Classification CHAR 2 0 TKUKL KUKLA
VENDOR_NO Account Number of Supplier CHAR 10 0 LFA1 LIFNR
DELI_BLK_G Central delivery block for the customer CHAR 2 0 TVLS LIFSD_X
LOC_CODE City Coordinates CHAR 10 0 LOCCO
DEL_FLAG_G Central Deletion Flag for Master Record CHAR 1 0 LOEVM_X
NIELSEN_ID Nielsen ID CHAR 2 0 TNLS NIELS
COUNTY_CDE County Code CHAR 3 0 * COUNC
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
TELEBOX Telebox number CHAR 15 0 TELBX
TRANSPZONE Transportation zone to or from which the goods are delivered CHAR 10 0 * LZONE
PAYER_DOC Indicator: Is an alternative payer allowed in document? CHAR 1 0 XREGU
TRADE_ID Company ID of Trading Partner CHAR 6 0 T880 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 TVGF GFORM
IND_CODE_1 Industry code 1 CHAR 10 0 TBRC BRAN1_D
IND_CODE_2 Industry code 2 CHAR 10 0 TBRC BRAN2
IND_CODE_3 Industry code 3 CHAR 10 0 TBRC BRAN3
IND_CODE_4 Industry code 4 CHAR 10 0 TBRC BRAN4
IND_CODE_5 Industry code 5 CHAR 10 0 TBRC BRAN5
INITCONTCT Initial contact CHAR 10 0 * EKONT
ANN_SALES Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
SALES_YEAR Year For Which Sales are Given NUMC 4 0 UMJAH
CURRENCY Currency in which book was purchased CUKY 5 0 TCURC UWAEHR
CURREN_ISO ISO code currency CHAR 3 0 WAERS_ISO
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 TVK1 KATR1
ATTRIB_2 Attribute 2 CHAR 2 0 TVK2 KATR2
ATTRIB_3 Attribute 3 CHAR 2 0 TVK3 KATR3
ATTRIB_4 Attribute 4 CHAR 2 0 TVK4 KATR4
ATTRIB_5 Attribute 5 CHAR 2 0 TVK5 KATR5
ATTRIB_6 Attribute 6 CHAR 3 0 TVK6 KATR6
ATTRIB_7 Attribute 7 CHAR 3 0 TVK7 KATR7
ATTRIB_8 Attribute 8 CHAR 3 0 TVK8 KATR8
ATTRIB_9 Attribute 9 CHAR 3 0 TVK9 KATR9
ATTRIB_10 Attribute 10 CHAR 3 0 TVK0 KATR10
SOLE_PROP Natural Person CHAR 1 0 STKZN
Legal person
X Natural person
FY_VARIANT Fiscal Year Variant CHAR 2 0 T009 PERIV
DLVSCHEUSE Usage Indicator CHAR 3 0 TVLV 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 T077D KTOCD
PLANT Plant CHAR 4 0 T001W 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
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 TWEK ETIKG
NON_MILIT ID for mainly non-military use CHAR 1 0 CIVVE
MILIT_USE ID for mainly military use CHAR 1 0 MILVE
CUSCOND_G1 Customer condition group 1 CHAR 2 0 TVKGG KDKG1
CUSCOND_G2 Customer condition group 2 CHAR 2 0 TVKGG KDKG2
CUSCOND_G3 Customer condition group 3 CHAR 2 0 TVKGG KDKG3
CUSCOND_G4 Customer condition group 4 CHAR 2 0 TVKGG KDKG4
CUSCOND_G5 Customer condition group 5 CHAR 2 0 TVKGG KDKG5
ALTPAYERAC Indicator: Alternative payer using account number CHAR 1 0 XKNZA
TAX_TYPE Tax type CHAR 2 0 J_1AFITPV J_1AFITP_D
TAX_NO_TY Tax Number Type CHAR 2 0 J_1ATODC 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_1BTXSTG 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_1BATL1 J_1BTAXLW1
TAXLAWIPI Tax law: IPI CHAR 3 0 J_1BATL2 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 BUSTYPE GESTYP
IND_TYPE Type of Industry CHAR 30 0 INDUSTYPE 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
DEL_BLOCK Central deletion block for master record CHAR 1 0 NODEL_X
CONSUMER Indicator: Consumer CHAR 1 0 DEAR6
HU_MANDAT Handling unit requirement CHAR 1 0 XHUPF

BAPICUSGEN foreign key relationships

Table Field Check Table Check Field
0 BAPICUSGEN ACCNT_GRP T077D Customer account groups MANDT
1 BAPICUSGEN ALT_PAYER KNA1 General Data in Customer Master MANDT
1 BAPICUSGEN ALT_PAYER KNA1 General Data in Customer Master KUNNR
0 BAPICUSGEN ATTRIBUTE TVK1 Attribute 1 (customer master) MANDT
0 BAPICUSGEN ATTRIBUTE TVK1 Attribute 1 (customer master) KATR1
1 BAPICUSGEN ATTRIB_10 TVK0 Attribute 10 (customer master) MANDT
0 BAPICUSGEN ATTRIB_2 TVK2 Attribute 2 (customer master) MANDT
0 BAPICUSGEN ATTRIB_2 TVK2 Attribute 2 (customer master) KATR2
1 BAPICUSGEN ATTRIB_3 TVK3 Attribute 3 (customer master) MANDT
1 BAPICUSGEN ATTRIB_3 TVK3 Attribute 3 (customer master) KATR3
0 BAPICUSGEN ATTRIB_4 TVK4 Attribute 4 (customer master) MANDT
0 BAPICUSGEN ATTRIB_4 TVK4 Attribute 4 (customer master) KATR4
1 BAPICUSGEN ATTRIB_5 TVK5 Attribute 5 (customer master) MANDT
1 BAPICUSGEN ATTRIB_5 TVK5 Attribute 5 (customer master) KATR5
0 BAPICUSGEN ATTRIB_6 TVK6 Attribute 6 (customer master) MANDT
1 BAPICUSGEN ATTRIB_7 TVK7 Attribute 7 (customer master) MANDT
0 BAPICUSGEN ATTRIB_8 TVK8 Attribute 8 (customer master) MANDT
1 BAPICUSGEN ATTRIB_9 TVK9 Attribute 9 (customer master) MANDT
0 BAPICUSGEN BILL_BLK_G TVFS Billing: Reasons for Blocking FAKSP
1 BAPICUSGEN BUS_TYPE BUSTYPE Type of Business GESTYP
0 BAPICUSGEN CLASSIFIC TKUKL Customers: Customer Classifications KUKLA
1 BAPICUSGEN CURRENCY TCURC Currency Codes WAERS
0 BAPICUSGEN CUSCOND_G1 TVKGG Customer Condition Groups (Customer Master) MANDT
0 BAPICUSGEN CUSCOND_G1 TVKGG Customer Condition Groups (Customer Master) KDKGR
1 BAPICUSGEN CUSCOND_G2 TVKGG Customer Condition Groups (Customer Master) MANDT
1 BAPICUSGEN CUSCOND_G2 TVKGG Customer Condition Groups (Customer Master) KDKGR
0 BAPICUSGEN CUSCOND_G3 TVKGG Customer Condition Groups (Customer Master) MANDT
0 BAPICUSGEN CUSCOND_G3 TVKGG Customer Condition Groups (Customer Master) KDKGR
1 BAPICUSGEN CUSCOND_G4 TVKGG Customer Condition Groups (Customer Master) MANDT
1 BAPICUSGEN CUSCOND_G4 TVKGG Customer Condition Groups (Customer Master) KDKGR
0 BAPICUSGEN CUSCOND_G5 TVKGG Customer Condition Groups (Customer Master) MANDT
0 BAPICUSGEN CUSCOND_G5 TVKGG Customer Condition Groups (Customer Master) KDKGR
1 BAPICUSGEN CUSTOMER KNA1 General Data in Customer Master MANDT
1 BAPICUSGEN CUSTOMER KNA1 General Data in Customer Master KUNNR
0 BAPICUSGEN DELI_BLK_G TVLS Deliveries: Blocking Reasons/Criteria MANDT
0 BAPICUSGEN DELI_BLK_G TVLS Deliveries: Blocking Reasons/Criteria LIFSP
1 BAPICUSGEN DLVSCHEUSE TVLV Check table for release orders: Usage ID ABRVW
0 BAPICUSGEN FISK_ADDR KNA1 General Data in Customer Master MANDT
0 BAPICUSGEN FISK_ADDR KNA1 General Data in Customer Master KUNNR
1 BAPICUSGEN FY_VARIANT T009 Fiscal Year Variants MANDT
1 BAPICUSGEN FY_VARIANT T009 Fiscal Year Variants PERIV
0 BAPICUSGEN INDUSTRY T016 Industries BRSCH
1 BAPICUSGEN IND_CODE_1 TBRC Industry Code (Customer Master) MANDT
1 BAPICUSGEN IND_CODE_1 TBRC Industry Code (Customer Master) BRACO
0 BAPICUSGEN IND_CODE_2 TBRC Industry Code (Customer Master) MANDT
0 BAPICUSGEN IND_CODE_2 TBRC Industry Code (Customer Master) BRACO
1 BAPICUSGEN IND_CODE_3 TBRC Industry Code (Customer Master) MANDT
1 BAPICUSGEN IND_CODE_3 TBRC Industry Code (Customer Master) BRACO
0 BAPICUSGEN IND_CODE_4 TBRC Industry Code (Customer Master) MANDT
0 BAPICUSGEN IND_CODE_4 TBRC Industry Code (Customer Master) BRACO
1 BAPICUSGEN IND_CODE_5 TBRC Industry Code (Customer Master) MANDT
1 BAPICUSGEN IND_CODE_5 TBRC Industry Code (Customer Master) BRACO
0 BAPICUSGEN IND_TYPE INDUSTYPE Type of Industry MANDT
0 BAPICUSGEN IND_TYPE INDUSTYPE Type of Industry INDTYPE
1 BAPICUSGEN LABCUSTGRP TWEK IS-R Labeling: Check Table Customer/Plant Groups MANDT
1 BAPICUSGEN LABCUSTGRP TWEK IS-R Labeling: Check Table Customer/Plant Groups KUNGR
0 BAPICUSGEN LEGALSTAT TVGF Legal Status (Customer Master) MANDT
0 BAPICUSGEN LEGALSTAT TVGF Legal Status (Customer Master) GFORM
1 BAPICUSGEN NIELSEN_ID TNLS Nielsen ID MANDT
1 BAPICUSGEN NIELSEN_ID TNLS Nielsen ID NIELS
0 BAPICUSGEN ORDR_BLK_G TVAST Sales Document Blocking Reasons: Texts MANDT
0 BAPICUSGEN ORDR_BLK_G TVAST Sales Document Blocking Reasons: Texts SPRAS
1 BAPICUSGEN PLANT T001W Plants/Branches MANDT
1 BAPICUSGEN PLANT T001W Plants/Branches WERKS
0 BAPICUSGEN REF_ACTGR T077D Customer account groups MANDT
1 BAPICUSGEN SUBT_GRP J_1BTXSTG Tax calc.: Sub.Trib. customer group MANDT
0 BAPICUSGEN TAX_NO_TY J_1ATODC Type of identification J_1ATODC
1 BAPICUSGEN TAX_TYPE J_1AFITPV Tax Type: Possible Entries MANDT
1 BAPICUSGEN TAX_TYPE J_1AFITPV Tax Type: Possible Entries J_1AFITP
0 BAPICUSGEN TRADE_ID T880 Global Company Data (for KONS Ledger) MANDT
0 BAPICUSGEN TRADE_ID T880 Global Company Data (for KONS Ledger) RCOMP
1 BAPICUSGEN VENDOR_NO LFA1 Supplier Master (General Section) MANDT
1 BAPICUSGEN VENDOR_NO LFA1 Supplier Master (General Section) LIFNR