SAP Table BAPICUSGEN

BAPI Structure: Customer, General Data

BAPICUSGEN (BAPI Structure: Customer, General Data) 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 BAPICUSGEN to other SAP tables.

Source: BAPICUSGEN (BAPI Structure: Customer, General Data)

BAPICUSGEN 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
ORDR_BLK_G Central order block for customer AUFSD_X TVAST 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 TVFS CHAR 2 0
FISK_ADDR Account number of the master record with the fiscal address FISKN_D KNA1 CHAR 10 0
WORK_TIME Working Time Calendar KNAZK TFACD CHAR 2 0
ALT_PAYER Account number of an alternative payer KNRZA KNA1 CHAR 10 0
GROUPKEY Group key KONZS CHAR 10 0
ACCNT_GRP Customer Account Group KTOKD T077D CHAR 4 0
CLASSIFIC Customer classification KUKLA TKUKL CHAR 2 0
VENDOR_NO Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
DELI_BLK_G Central delivery block for the customer LIFSD_X TVLS 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
NIELSEN_ID Nielsen ID NIELS TNLS CHAR 2 0
COUNTY_CDE County Code COUNC CHAR 3 0
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
TELEBOX Telebox number TELBX CHAR 15 0
TRANSPZONE Transportation zone to or from which the goods are delivered LZONE CHAR 10 0
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 T880 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 TVGF CHAR 2 0
IND_CODE_1 Industry Code 1 BRAN1_D TBRC CHAR 10 0
IND_CODE_2 Industry code 2 BRAN2 TBRC CHAR 10 0
IND_CODE_3 Industry code 3 BRAN3 TBRC CHAR 10 0
IND_CODE_4 Industry code 4 BRAN4 TBRC CHAR 10 0
IND_CODE_5 Industry code 5 BRAN5 TBRC CHAR 10 0
INITCONTCT Initial contact EKONT VBUK CHAR 10 0
ANN_SALES Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
SALES_YEAR Year For Which Sales are Given UMJAH NUMC 4 0
CURRENCY Currency in which book was purchased UWAEHR TCURC CUKY 5 0
CURREN_ISO ISO code currency WAERS_ISO 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 TVK1 CHAR 2 0
ATTRIB_2 Attribute 2 KATR2 TVK2 CHAR 2 0
ATTRIB_3 Attribute 3 KATR3 TVK3 CHAR 2 0
ATTRIB_4 Attribute 4 KATR4 TVK4 CHAR 2 0
ATTRIB_5 Attribute 5 KATR5 TVK5 CHAR 2 0
ATTRIB_6 Attribute 6 KATR6 TVK6 CHAR 3 0
ATTRIB_7 Attribute 7 KATR7 TVK7 CHAR 3 0
ATTRIB_8 Attribute 8 KATR8 TVK8 CHAR 3 0
ATTRIB_9 Attribute 9 KATR9 TVK9 CHAR 3 0
ATTRIB_10 Attribute 10 KATR10 TVK0 CHAR 3 0
SOLE_PROP Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
FY_VARIANT Fiscal Year Variant PERIV T009 CHAR 2 0
DLVSCHEUSE Usage Indicator ABRVW TVLV 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 T077D CHAR 4 0
PLANT Plant WERKS_D T001W 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
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 TWEK 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
CUSCOND_G1 Customer condition group 1 KDKG1 TVKGG CHAR 2 0
CUSCOND_G2 Customer condition group 2 KDKG2 TVKGG CHAR 2 0
CUSCOND_G3 Customer condition group 3 KDKG3 TVKGG CHAR 2 0
CUSCOND_G4 Customer condition group 4 KDKG4 TVKGG CHAR 2 0
CUSCOND_G5 Customer condition group 5 KDKG5 TVKGG 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 J_1AFITPV CHAR 2 0
TAX_NO_TY Tax Number Type J_1ATOID J_1ATODC 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 J_1BTXSTG 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 J_1BATL1 CHAR 3 0
TAXLAWIPI Tax law: IPI J_1BTAXLW2 J_1BATL2 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 BUSTYPE CHAR 30 0
IND_TYPE Type of Industry INDTYP INDUSTYPE 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
DEL_BLOCK 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
HU_MANDAT Handling unit requirement XHUPF CHAR 1 0
X Yes
NULL No

BAPICUSGEN foreign key relationships

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