SAP Table BAPISDBUSI

BAPI Structure of VBKD with English Field Names

BAPISDBUSI (BAPI Structure of VBKD with English Field Names) 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 BAPISDBUSI to other SAP tables.

BAPISDBUSI table fields

Field Data element Checktable Datatype Length Decimals
OPERATION Function MSGFN CHAR 3 0
003 Delete: Message contains objects to be deleted
004 Change: Message contains changes
005 Replace: This message replaces previous messages
009 Original: First message for process
023 Wait/Adjust: Data should not be imported
018 Resend
SD_DOC Sales and Distribution Document Number VBELN CHAR 10 0
ITM_NUMBER Item number of the SD document POSNR NUMC 6 0
PRICE_GRP Price group (customer) KONDA CHAR 2 0
CUST_GROUP Customer group KDGRP CHAR 2 0
SALES_DIST Sales district BZIRK CHAR 6 0
PRICE_LIST Price list type PLTYP CHAR 2 0
INCOTERMS1 Incoterms (Part 1) INCO1 CHAR 3 0
INCOTERMS2 Incoterms (Part 2) INCO2 CHAR 28 0
ORDCOMBIND Order Combination Indicator KZAZU_D CHAR 1 0
X Yes
NULL No
BILL_SCHED Invoice dates (calendar identification) PERFK CHAR 2 0
INVO_SCHED Invoice list schedule (calendar identification) PERRL CHAR 2 0
MN_INVOICE Manual invoice maintenance MRNKZ CHAR 1 0
X Yes
NULL No
EXCHRATEFI Directly quoted exchange rate for FI postings KURRF_P DEC 9 5
ADD_VAL_DY Additional value days VALTG NUMC 2 0
FIX_VAL_DY Fixed value date VALDT DATS 8 0
PMNTTRMS Terms of Payment Key DZTERM CHAR 4 0
PAYMETHODE Payment Method SCHZW_BSEG CHAR 1 0
ACCNT_ASGN Account assignment group for this customer KTGRD CHAR 2 0
EXCHG_RATE Directly quoted exchange rate for pricing and statistics KURSK_P DEC 9 5
PRICE_DATE Date for pricing and exchange rate PRSDT DATS 8 0
BILL_DATE Billing date for billing index and printout FKDAT DATS 8 0
SERV_DATE Date on which services rendered FBUDA DATS 8 0
FISC_YEAR Fiscal Year GJAHR NUMC 4 0
POSTPERIOD Posting period POPER NUMC 3 0
EXCHRATEST Directly quoted exchange rate for statistics STCUR_P DEC 9 5
DUNN_KEY Dunning key MSCHL CHAR 1 0
DUNN_BLOCK Dunning block MANSP CHAR 1 0
BILL_PLAN Billing plan number / invoicing plan number FPLNR CHAR 10 0
PROMOTION Promotion WAKTION CHAR 10 0
PAY_GUARAN Payment guarantee procedure ABSSCHE_CM CHAR 6 0
FINDOCPROC Financial doc. processing: Internal financial doc. number LCNUM CHAR 10 0
J_1AFITP_D Tax type J_1AFITP_D CHAR 2 0
REAS_0_VAT Reason for zero VAT J_1ARFZVAT CHAR 1 0
REGION Region (State, Province, County) REGIO CHAR 3 0
ACTIVICODE Activity Code for Gross Income Tax J_1AGICD_D CHAR 2 0
DISTRIBTYP Distribution Type for Employment Tax J_1ADTYP_D CHAR 2 0
TAX_CLASS Tax relevant classification J_1ATXREL_ CHAR 10 0
DEPART_NO Department number ABTNR CHAR 4 0
REC_POINT Receiving point EMPST CHAR 25 0
PURCH_NO_C Customer purchase order number BSTKD CHAR 35 0
PURCH_DATE Customer purchase order date BSTDK DATS 8 0
PO_METHOD Customer purchase order type BSARK CHAR 4 0
REF_1 Your Reference IHREZ CHAR 12 0
PURCH_NO_S Ship-to Party's Purchase Order Number BSTKD_E CHAR 35 0
PO_DAT_S Ship-to party's PO date BSTDK_E DATS 8 0
PO_METH_S Ship-to party purchase order type BSARK_E CHAR 4 0
REF_1_S Ship-to party character IHREZ_E CHAR 12 0
POITMNOS Item Number of the Underlying Purchase Order POSEX_E CHAR 6 0
TRANS_DATE Translation Date WWERT_D DATS 8 0
TRANSDATE Translation Date WWERT_D DATS 8 0
CUSTCONGR1 Customer condition group 1 KDKG1 CHAR 2 0
CUSTCONGR2 Customer condition group 2 KDKG2 CHAR 2 0
CUSTCONGR3 Customer condition group 3 KDKG3 CHAR 2 0
CUSTCONGR4 Customer condition group 4 KDKG4 CHAR 2 0
CUSTCONGR5 Customer condition group 5 KDKG5 CHAR 2 0
VALCONTCUR Value contract currency WKWAE CUKY 5 0
ISOVALCONT ISO code currency WAERS_ISO CHAR 3 0
EXCHRATECO Direct noted exchange rate in value contract currency WKKUR_P DEC 9 5
CURRENCKEY Currency key for letter-of-credit procg in foreign trade AKWAE CUKY 5 0
ISOCURRKEY ISO code currency WAERS_ISO CHAR 3 0
EXCHRATELC Price-quotation rate for processing letters of credit in FT AKKUR_P DEC 9 5
CEPRPERCEN Depreciation percentage for financial document processing AKPRZ DEC 5 2
INFLAT_IDX Inflation Index J_1AINDXP CHAR 5 0
BASDATEIDX Indexing base date J_1AIDATES DATS 8 0
CUST_PO_NO Customer PO number as matchcode field BSTKD_M CHAR 35 0
DLV_TIME Agreed delivery time DELCO CHAR 3 0
DLI_PROFIL Dynamic Item Processor Profile AD01PROFNR CHAR 8 0
CALC_MOTIVE Accounting Indicator BEMOT CHAR 2 0
BILL_FORM Billing form FAKTF CHAR 2 0
01 Fixed rate
02 Costs
REVENUETYP Revenue recognition category RR_RELTYP CHAR 1 0
NULL Standard revenue recognition
A Time-related revenue recognition
B Service-related revenue recognition
D Billing-related, time-related revenue recognition
E Billing-related, service-related revenue recognition (IS-M)
F Credit/Debit Memos with reference to predecessor
BEGDEMAPER Proposed start date for accrual period RR_ACDATV CHAR 1 0
NULL Not relevant
A Proposal based on contract start date
B Proposal based on billing plan start date
EXCHRATELC_V Indir.-quotation rate for processing letters of credit in FT AKKUR_V DEC 9 5
EXCH_RATE_FI_V Indirectly quoted exchange rate for FI postings KURRF_V DEC 9 5
EXCHG_RATE_V Indirectly quoted exchange rate for pricing and statistics KURSK_V DEC 9 5
EXCHRATEST_V Indirectly quoted exchange rate for statistics STCUR_V DEC 9 5
EXCHRATECO_V Indirect noted exchange rate in value contract currency WKKUR_V DEC 9 5
DELIV_TYPE Shipping type VSARTTR CHAR 2 0
TRANS_CAT Means-of-Transport Type TRATY CHAR 4 0
TRANS_MAT Means of Transport TRMTYP CHAR 18 0
SPEC_PROC Special processing indicator SDABW CHAR 4 0
PRODCAT Product catalog number WMINR CHAR 10 0
FUNC_AREA Functional Area FKBER_SHORT CHAR 4 0
POD_PROC Relevant for POD processing PODKZ CHAR 1 0
X Yes
NULL No
CAMPAIGN Generic project planning: GUID from external R/3 system CGPL_GUID16_R3 RAW 16 0
FKK_CONACCT Character field of length 12 CHAR012 CHAR 12 0
FUNC_AREA_LONG Functional Area FKBER_LONG CHAR 16 0
FKK_CONACCT_GUID GUID in 'RAW' format GUID_16 RAW 16 0
TRANS_MAT_EXTERNAL Long Material Number for TRANS_MAT Field MGV_TRANS_MAT_EXTERNAL CHAR 40 0
TRANS_MAT_GUID External GUID for TRANS_MAT Field MGV_TRANS_MAT_GUID CHAR 32 0
TRANS_MAT_VERSION Version Number for TRANS_MAT Field MGV_TRANS_MAT_VERSION CHAR 10 0
SEPA_MANDATE_ID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0