SAP table VBKD (Sales Document: Business Data)

SAP table VBKD has 3 primary key fields being MANDT,VBELN,POSNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
POSNR Item number of the SD document NUMC 6 0 POSNR
KONDA Customer Price Group CHAR 2 0 T188 KONDA
KDGRP Customer Group CHAR 2 0 T151 KDGRP
BZIRK Sales District CHAR 6 0 T171 BZIRK
PLTYP Price List Type CHAR 2 0 T189 PLTYP
INCO1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
KZAZU Order Combination Indicator CHAR 1 0 KZAZU_D
PERFK Invoice Dates (Calendar Identification) CHAR 2 0 TFACD PERFK
PERRL Invoice List Schedule (calendar identification) CHAR 2 0 TFACD PERRL
MRNKZ Manual Invoice Maintenance CHAR 1 0 MRNKZ
KURRF Exchange Rate for Postings to Financial Accounting DEC 9 5 KURRF
VALTG Additional Value Days NUMC 2 0 VALTG
VALDT Fixed Value Date DATS 8 0 VALDT
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZLSCH Payment Method CHAR 1 0 T042Z SCHZW_BSEG
KTGRD Account Assignment Group for this Customer CHAR 2 0 TVKT KTGRD
KURSK Exchange Rate for Price Determination DEC 9 5 KURSK
PRSDT Date for Pricing and Exchange Rate DATS 8 0 PRSDT
FKDAT Billing Date DATS 8 0 FKDAT
FBUDA Date on which services are rendered DATS 8 0 FBUDA
GJAHR Fiscal Year NUMC 4 0 GJAHR
POPER Posting period NUMC 3 0 POPER
STCUR Exchange rate for statistics DEC 9 5 STCUR
MSCHL Dunning Key CHAR 1 0 T040 MSCHL
MANSP Dunning Block CHAR 1 0 T040S MANSP
FPLNR Billing plan number / invoicing plan number CHAR 10 0 FPLA FPLNR
WAKTION Promotion CHAR 10 0 WAKH WAKTION
ABSSC Payment Guarantee Procedure CHAR 6 0 T691M ABSSCHE_CM
LCNUM Financial doc. processing: Internal financial doc. number CHAR 10 0 LCNUM
J_1AFITP Tax type CHAR 2 0 J_1AFITP J_1AFITP_D
J_1ARFZ Reason for Zero VAT CHAR 1 0 J_1ARFZ J_1ARFZVAT
J_1AREGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
J_1AGICD Activity Code for Gross Income Tax CHAR 2 0 J_1AGICD J_1AGICD_D
J_1ADTYP Distribution Type for Employment Tax CHAR 2 0 J_1ADTYP J_1ADTYP_D
J_1ATXREL Tax relevant classification CHAR 10 0 J_1ATXREL J_1ATXREL_
ABTNR Department number CHAR 4 0 TSAB ABTNR
EMPST Receiving Point CHAR 25 0 EMPST
BSTKD Customer Reference CHAR 35 0 BSTKD
BSTDK Customer Reference Date DATS 8 0 BSTDK
BSARK Customer Purchase Order Type CHAR 4 0 T176 BSARK
IHREZ Your Reference CHAR 12 0 IHREZ
BSTKD_E Ship-to Party's Customer Reference CHAR 35 0 BSTKD_E
BSTDK_E Ship-to Party's Customer Reference Date DATS 8 0 BSTDK_E
BSARK_E Ship-to Party Purchase Order Type CHAR 4 0 T176 BSARK_E
IHREZ_E Ship-to Party Character CHAR 12 0 IHREZ_E
POSEX_E Item Number of the Underlying Purchase Order CHAR 6 0 POSEX_E
KURSK_DAT Translation date DATS 8 0 WWERT_D
KURRF_DAT Translation date DATS 8 0 WWERT_D
KDKG1 Customer condition group 1 CHAR 2 0 TVKGG KDKG1
KDKG2 Customer condition group 2 CHAR 2 0 TVKGG KDKG2
KDKG3 Customer condition group 3 CHAR 2 0 TVKGG KDKG3
KDKG4 Customer condition group 4 CHAR 2 0 TVKGG KDKG4
KDKG5 Customer condition group 5 CHAR 2 0 TVKGG KDKG5
WKWAE Value contract currency CUKY 5 0 TCURC WKWAE
WKKUR Exchange rate in value contract currency DEC 9 5 WKKUR
AKWAE Currency key for letter-of-credit procg in foreign trade CUKY 5 0 TCURC AKWAE
AKKUR Exchange rate for letter-of-credit procg in foreign trade DEC 9 5 AKKUR
AKPRZ Depreciation percentage for financial document processing DEC 5 2 AKPRZ
J_1AINDXP Inflation Index CHAR 5 0 J_1AINFT20 J_1AINDXP
J_1AIDATEP Indexing base date DATS 8 0 J_1AIDATES
BSTKD_M Customer Reference as Matchcode Field CHAR 35 0 BSTKD_M
DELCO Agreed Delivery Time CHAR 3 0 TVDC DELCO
FFPRF Dynamic Item Processor Profile CHAR 8 0 AD01C_PROF AD01PROFNR
BEMOT Accounting Indicator CHAR 2 0 TBMOT BEMOT
FAKTF Billing form CHAR 2 0 FAKTF
01 Fixed rate
02 Costs
RRREL Revenue recognition category CHAR 1 0 RR_RELTYP
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
ACDATV Proposed start date for accrual period CHAR 1 0 RR_ACDATV
Not relevant
A Proposal based on contract start date
B Proposal based on billing plan start date
VSART Shipping Type CHAR 2 0 T173 VSARTTR
TRATY Means-of-Transport Type CHAR 4 0 TVTY TRATY
TRMTYP Means of Transport CHAR 40 0 MARA TRMTYP
SDABW Special Processing Indicator CHAR 4 0 TVSAK SDABW
WMINR Product catalog number CHAR 10 0 WWMI WMINR
FKBER Functional Area CHAR 16 0 TFKB FKBER
PODKZ Relevant for POD processing CHAR 1 0 PODKZ
CAMPAIGN Generic project planning: GUID from external R/3 system RAW 16 0 CGPL_GUID16_R3
VKONT Contract Account Number CHAR 12 0 CORR_VKONT_KK
DPBP_REF_FPLNR Billing plan number / invoicing plan number CHAR 10 0 FPLNR
DPBP_REF_FPLTR Item for billing plan/invoice plan/payment cards NUMC 6 0 FPLTR
REVSP Revenue Distribution Type CHAR 1 0 RR_REVSP
Total Value: Linear and Correction Value Undistributed
A Total Val.: Linear and Correction Value Linearly Distributed
B Total Value: Billing-Plan-Reld and Corr. Value Undistributed
C Total Val.: Bill.Plan-Reld and Corr. Val. Linearly Distribtd
REVEVTYP Revenue Event Type (Customizing) CHAR 1 0 RR_REVEVTYP_CUST
Not Event-Related
A Incoming Invoice
B Acceptance Date
N Not POD-Relevant
X Customer-Specific Event: X
Y Customer-Specific Event: Y
Z Customer-Specific Event: Z
FARR_RELTYPE Revenue Accounting Type CHAR 10 0 FARR_RELTYPE
Not Relevant
C Call-Off Order with Reference to Contract
G Relevant for Revenue Accounting by Invoice
M Credit/Debit Memo with Reference to Preceding Document
X Relevant for Revenue Accounting
VTREF Reference Specifications from Contract CHAR 20 0 CORR_VTREF_KK
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
J_1TPBUPL Branch Code CHAR 5 0 BCODE
INCOV Incoterms Version CHAR 4 0 TINCV INCOV
INCO2_L Incoterms Location 1 CHAR 70 0 INCO2_L
INCO3_L Incoterms Location 2 CHAR 70 0 INCO3_L
INCO2_KEY Incoterm Location 1 - Place of Destination RAW 16 0 /SCMTMS/INC_LOC_1_KEY
INCO3_KEY Incoterm Location 2 - Place of Delivery RAW 16 0 /SCMTMS/INC_LOC_2_KEY
INCO4_KEY Incoterm - Deviating Place of Destination RAW 16 0 /SCMTMS/INC_DEV_PLACE_DEST_KEY
PACKNO Package number NUMC 10 0 ESLH PACKNO
PEROP_BEG Period of Performance Start Date DATS 8 0 FM_PEROP_SD_LOW
PEROP_END Period of Performance End Date DATS 8 0 FM_PEROP_SD_HIGH
STCODE LST CST applicability code CHAR 3 0 * J_1ISTCODE
FORMC1 Form Type CHAR 3 0 * J_1IFORTYP
FORMC2 Form Type CHAR 3 0 * J_1IFORTYP
STEUC Control code for consumption taxes in foreign trade CHAR 16 0 STEUC
COMPREAS Abbreviation for Complaints Reason CHAR 4 0 CMP_COMPREAS_COPY
MNDID Unique Reference to Mandate for each Payee CHAR 35 0 SEPA_MNDID
PAY_TYPE SEPA: Payment Type CHAR 1 0 SEPA_PAY_TYPE
1 One-Time Mandate
N Recurring Use Mandate
SEPON SEPA-Relevance CHAR 1 0 SD_SEPA_FLAG
No SEPA Relevance
0 SEPA Relevance - No Mandate Assigned
1 SEPA Relevance - Mandate Assigned
MNDVG SEPA-Relevance CHAR 1 0 SD_SEPA_FLAG
No SEPA Relevance
0 SEPA Relevance - No Mandate Assigned
1 SEPA Relevance - Mandate Assigned

VBKD foreign key relationships

Table Field Check Table Check Field
0 VBKD ABSSC T691M Payment guarantee procedure MANDT
0 VBKD ABSSC T691M Payment guarantee procedure ABSSC
1 VBKD ABTNR TSAB Contact persons: standard departments MANDT
1 VBKD ABTNR TSAB Contact persons: standard departments ABTNR
0 VBKD AKWAE TCURC Currency Codes MANDT
0 VBKD AKWAE TCURC Currency Codes WAERS
1 VBKD BEMOT TBMOT Accounting indicators MANDT
1 VBKD BEMOT TBMOT Accounting indicators BEMOT
0 VBKD BSARK T176 Sales Documents: Customer Order Types MANDT
0 VBKD BSARK T176 Sales Documents: Customer Order Types BSARK
1 VBKD BSARK_E T176 Sales Documents: Customer Order Types MANDT
1 VBKD BSARK_E T176 Sales Documents: Customer Order Types BSARK
0 VBKD BZIRK T171 Customers: Sales Districts MANDT
0 VBKD BZIRK T171 Customers: Sales Districts BZIRK
1 VBKD DELCO TVDC Delivery Times:Categories MANDT
1 VBKD DELCO TVDC Delivery Times:Categories DELCO
0 VBKD FFPRF AD01C_PROF DIP profile: Usage MANDT
0 VBKD FFPRF AD01C_PROF DIP profile: Usage PROFNR
1 VBKD FKBER TFKB Functional areas FKBER
0 VBKD FPLNR FPLA Billing Plan FPLNR
1 VBKD INCO1 TINC Customers: Incoterms INCO1
0 VBKD INCOV TINCV Incoterms Versions MANDT
0 VBKD INCOV TINCV Incoterms Versions INCOV
1 VBKD J_1ADTYP J_1ADTYP Distribution Types for Gross Income Tax MANDT
1 VBKD J_1ADTYP J_1ADTYP Distribution Types for Gross Income Tax BUKRS
0 VBKD J_1AFITP J_1AFITP Tax Types MANDT
1 VBKD J_1AGICD J_1AGICD Activity codes for gross income tax declaration MANDT
1 VBKD J_1AGICD J_1AGICD Activity codes for gross income tax declaration LAND1
0 VBKD J_1AINDXP J_1AINFT20 Inflation: Index Definition MANDT
1 VBKD J_1AREGIO T005S Taxes: Region (Province) Key LAND1
0 VBKD J_1ARFZ J_1ARFZ Definition of reasons for zero VAT MANDT
1 VBKD J_1ATXREL J_1ATXREL Tax relevant classification MANDT
1 VBKD J_1ATXREL J_1ATXREL Tax relevant classification J_1ATXREL
0 VBKD KDGRP T151 Customers: Customer Groups MANDT
0 VBKD KDGRP T151 Customers: Customer Groups KDGRP
1 VBKD KDKG1 TVKGG Customer Condition Groups (Customer Master) MANDT
1 VBKD KDKG1 TVKGG Customer Condition Groups (Customer Master) KDKGR
0 VBKD KDKG2 TVKGG Customer Condition Groups (Customer Master) MANDT
0 VBKD KDKG2 TVKGG Customer Condition Groups (Customer Master) KDKGR
1 VBKD KDKG3 TVKGG Customer Condition Groups (Customer Master) MANDT
1 VBKD KDKG3 TVKGG Customer Condition Groups (Customer Master) KDKGR
0 VBKD KDKG4 TVKGG Customer Condition Groups (Customer Master) MANDT
0 VBKD KDKG4 TVKGG Customer Condition Groups (Customer Master) KDKGR
1 VBKD KDKG5 TVKGG Customer Condition Groups (Customer Master) MANDT
1 VBKD KDKG5 TVKGG Customer Condition Groups (Customer Master) KDKGR
0 VBKD KONDA T188 Conditions: Groups for Customer Classifications MANDT
0 VBKD KONDA T188 Conditions: Groups for Customer Classifications KONDA
1 VBKD KTGRD TVKT Customers: Account Assignment Groups KTGRD
0 VBKD MANDT T000 Clients MANDT
1 VBKD MSCHL T040 Dunning keys MSCHL
0 VBKD PACKNO ESLH Service Package Header Data PACKNO
1 VBKD PLTYP T189 Conditions: Price List Types MANDT
1 VBKD PLTYP T189 Conditions: Price List Types PLTYP
0 VBKD SDABW TVSAK Special Processing Indicator SDABW
1 VBKD TRATY TVTY Packaging Material Types MANDT
1 VBKD TRATY TVTY Packaging Material Types TRATY
0 VBKD TRMTYP MARA General Material Data MANDT
0 VBKD TRMTYP MARA General Material Data MATNR
1 VBKD VSART T173 Routes: Mode of Transport for Each Shipping Type MANDT
1 VBKD VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
0 VBKD WAKTION WAKH Promotion Header Data, IS-R MANDT
0 VBKD WAKTION WAKH Promotion Header Data, IS-R AKTNR
1 VBKD WKWAE TCURC Currency Codes MANDT
1 VBKD WKWAE TCURC Currency Codes WAERS
0 VBKD WMINR WWMI Product catalog MANDT
0 VBKD WMINR WWMI Product catalog WMINR
1 VBKD ZLSCH T042Z Payment Methods for Automatic Payment MANDT
1 VBKD ZLSCH T042Z Payment Methods for Automatic Payment LAND1
1 VBKD ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH