1. Home
  2. Resources
  3. SAP Tables
  4. VBKD - Sales Document: Business Data

SAP Table VBKD

Sales Document: Business Data

VBKD (Sales Document: Business 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 VBKD to other SAP tables.

VBKD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN Sales and Distribution Document Number VBELN VBUK CHAR 10 0
POSNR Item number of the SD document POSNR VBUP NUMC 6 0
KONDA Price group (customer) KONDA T188 CHAR 2 0
KDGRP Customer group KDGRP T151 CHAR 2 0
BZIRK Sales district BZIRK T171 CHAR 6 0
PLTYP Price list type PLTYP T189 CHAR 2 0
INCO1 Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
KZAZU Order Combination Indicator KZAZU_D CHAR 1 0
X Yes
NULL No
PERFK Invoice dates (calendar identification) PERFK TFACD CHAR 2 0
PERRL Invoice list schedule (calendar identification) PERRL TFACD CHAR 2 0
MRNKZ Manual invoice maintenance MRNKZ CHAR 1 0
X Yes
NULL No
KURRF Exchange rate for FI postings KURRF DEC 9 5
VALTG Additional value days VALTG NUMC 2 0
VALDT Fixed value date VALDT DATS 8 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZLSCH Payment Method SCHZW_BSEG T042Z CHAR 1 0
KTGRD Account assignment group for this customer KTGRD TVKT CHAR 2 0
KURSK Exchange Rate for Price Determination KURSK DEC 9 5
PRSDT Date for pricing and exchange rate PRSDT DATS 8 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
FBUDA Date on which services rendered FBUDA DATS 8 0
GJAHR Fiscal Year GJAHR NUMC 4 0
POPER Posting period POPER NUMC 3 0
STCUR Exchange rate for statistics STCUR DEC 9 5
MSCHL Dunning key MSCHL T040 CHAR 1 0
MANSP Dunning block MANSP T040S CHAR 1 0
FPLNR Billing plan number / invoicing plan number FPLNR FPLA CHAR 10 0
WAKTION Promotion WAKTION WAKH CHAR 10 0
ABSSC Payment guarantee procedure ABSSCHE_CM T691M CHAR 6 0
LCNUM Financial doc. processing: Internal financial doc. number LCNUM AKKP CHAR 10 0
J_1AFITP Tax type J_1AFITP_D J_1AFITP CHAR 2 0
J_1ARFZ Reason for zero VAT J_1ARFZVAT J_1ARFZ CHAR 1 0
J_1AREGIO Region (State, Province, County) REGIO T005S CHAR 3 0
J_1AGICD Activity Code for Gross Income Tax J_1AGICD_D J_1AGICD CHAR 2 0
J_1ADTYP Distribution Type for Employment Tax J_1ADTYP_D J_1ADTYP CHAR 2 0
J_1ATXREL Tax relevant classification J_1ATXREL_ J_1ATXREL CHAR 10 0
ABTNR Department number ABTNR TSAB CHAR 4 0
EMPST Receiving point EMPST CHAR 25 0
BSTKD Customer purchase order number BSTKD CHAR 35 0
BSTDK Customer purchase order date BSTDK DATS 8 0
BSARK Customer purchase order type BSARK T176 CHAR 4 0
IHREZ Your Reference IHREZ CHAR 12 0
BSTKD_E Ship-to Party's Purchase Order Number BSTKD_E CHAR 35 0
BSTDK_E Ship-to party's PO date BSTDK_E DATS 8 0
BSARK_E Ship-to party purchase order type BSARK_E T176 CHAR 4 0
IHREZ_E Ship-to party character IHREZ_E CHAR 12 0
POSEX_E Item Number of the Underlying Purchase Order POSEX_E CHAR 6 0
KURSK_DAT Translation Date WWERT_D DATS 8 0
KURRF_DAT Translation Date WWERT_D DATS 8 0
KDKG1 Customer condition group 1 KDKG1 TVKGG CHAR 2 0
KDKG2 Customer condition group 2 KDKG2 TVKGG CHAR 2 0
KDKG3 Customer condition group 3 KDKG3 TVKGG CHAR 2 0
KDKG4 Customer condition group 4 KDKG4 TVKGG CHAR 2 0
KDKG5 Customer condition group 5 KDKG5 TVKGG CHAR 2 0
WKWAE Value contract currency WKWAE TCURC CUKY 5 0
WKKUR Exchange rate in value contract currency WKKUR DEC 9 5
AKWAE Currency key for letter-of-credit procg in foreign trade AKWAE TCURC CUKY 5 0
AKKUR Exchange rate for letter-of-credit procg in foreign trade AKKUR DEC 9 5
AKPRZ Depreciation percentage for financial document processing AKPRZ DEC 5 2
J_1AINDXP Inflation Index J_1AINDXP J_1AINFT20 CHAR 5 0
J_1AIDATEP Indexing base date J_1AIDATES DATS 8 0
BSTKD_M Customer PO number as matchcode field BSTKD_M CHAR 35 0
DELCO Agreed delivery time DELCO TVDC CHAR 3 0
FFPRF Dynamic Item Processor Profile AD01PROFNR AD01C_PROF CHAR 8 0
BEMOT Accounting Indicator BEMOT TBMOT CHAR 2 0
FAKTF Billing form FAKTF CHAR 2 0
01 Fixed rate
02 Costs
RRREL 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
ACDATV 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
VSART Shipping type VSARTTR T173 CHAR 2 0
TRATY Means-of-Transport Type TRATY TVTY CHAR 4 0
TRMTYP Means of Transport TRMTYP MARA CHAR 18 0
SDABW Special processing indicator SDABW TVSAK CHAR 4 0
WMINR Product catalog number WMINR WWMI CHAR 10 0
FKBER Functional Area FKBER TFKB CHAR 16 0
PODKZ 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
VKONT Contract Account Number CORR_VKONT_KK CHAR 12 0
DPBP_REF_FPLNR Billing plan number / invoicing plan number FPLNR CHAR 10 0
DPBP_REF_FPLTR Item for billing plan/invoice plan/payment cards FPLTR NUMC 6 0
REVSP Revenue Distribution Type RR_REVSP CHAR 1 0
NULL 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) RR_REVEVTYP_CUST CHAR 1 0
NULL Not Event-Related
A Incoming Invoice
B Acceptance Date
X Customer-Specific Event: X
Y Customer-Specific Event: Y
Z Customer-Specific Event: Z
N Not POD-Relevant
VTREF Reference Specifications from Contract CORR_VTREF_KK CHAR 20 0
PEROP_BEG Period of Performance Start Date FM_PEROP_SD_LOW DATS 8 0
PEROP_END Period of Performance End Date FM_PEROP_SD_HIGH DATS 8 0
STCODE LST CST applicability code J_1ISTCODE CHAR 3 0
FORMC1 Form Type J_1IFORTYP CHAR 3 0
FORMC2 Form Type J_1IFORTYP CHAR 3 0
STEUC Control code for consumption taxes in foreign trade STEUC CHAR 16 0
OIC_TIME Time for time-pricing OIC_TIME TIMS 6 0
OITITLE Location of title transfer for Incoterms purposes OIC_TITLE CHAR 1 0
NULL Title passes at plant
1 Title passes at Ship-to
OIPTRM1 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM2 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM3 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM4 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM5 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM6 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM7 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM8 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM9 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPFLIC IS-OIL partner function for tax exemption license OIH_PFLIC TPAR CHAR 2 0
COMPREAS Abbreviation for Complaints Reason CMP_COMPREAS_COPY CHAR 4 0
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
PAY_TYPE SEPA: Transaction Type SEPA_PAY_TYPE CHAR 1 0
1 One-Time Mandate
N Recurring Use Mandate
SEPON SEPA-Relevance SD_SEPA_FLAG CHAR 1 0
NULL No SEPA Relevance
0 SEPA Relevance - No Mandate Assigned
1 SEPA Relevance - Mandate Assigned
MNDVG SEPA-Relevance SD_SEPA_FLAG CHAR 1 0
NULL No SEPA Relevance
0 SEPA Relevance - No Mandate Assigned
1 SEPA Relevance - Mandate Assigned

VBKD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBKD ABSSC VBKD MANDT T691M Payment guarantee procedure MANDT
VBKD ABSSC VBKD ABSSC T691M Payment guarantee procedure ABSSC
VBKD ABTNR VBKD MANDT TSAB Contact persons: standard departments MANDT
VBKD ABTNR VBKD ABTNR TSAB Contact persons: standard departments ABTNR
VBKD AKWAE VBKD MANDT TCURC Currency Codes MANDT
VBKD AKWAE VBKD AKWAE TCURC Currency Codes WAERS
VBKD BEMOT VBKD MANDT TBMOT Accounting indicators MANDT
VBKD BEMOT VBKD BEMOT TBMOT Accounting indicators BEMOT
VBKD BSARK VBKD MANDT T176 Sales Documents: Customer Order Types MANDT
VBKD BSARK VBKD BSARK T176 Sales Documents: Customer Order Types BSARK
VBKD BSARK_E VBKD MANDT T176 Sales Documents: Customer Order Types MANDT
VBKD BSARK_E VBKD BSARK_E T176 Sales Documents: Customer Order Types BSARK
VBKD BZIRK VBKD MANDT T171 Customers: Sales Districts MANDT
VBKD BZIRK VBKD BZIRK T171 Customers: Sales Districts BZIRK
VBKD DELCO VBKD MANDT TVDC Delivery Times:Categories MANDT
VBKD DELCO VBKD DELCO TVDC Delivery Times:Categories DELCO
VBKD FFPRF VBKD MANDT AD01C_PROF DIP profile: Usage MANDT
VBKD FFPRF VBKD FFPRF AD01C_PROF DIP profile: Usage PROFNR
VBKD FFPRF * AD01C_PROF DIP profile: Usage DPUS
VBKD FKBER VBKD MANDT TFKB Functional areas MANDT
VBKD FKBER VBKD FKBER TFKB Functional areas FKBER
VBKD FPLNR VBKD MANDT FPLA Billing Plan MANDT
VBKD FPLNR VBKD FPLNR FPLA Billing Plan FPLNR
VBKD INCO1 VBKD INCO1 TINC Customers: Incoterms INCO1
VBKD INCO1 VBKD MANDT TINC Customers: Incoterms MANDT
VBKD J_1ADTYP T001 BUKRS J_1ADTYP Distribution Types for Gross Income Tax BUKRS
VBKD J_1ADTYP VBKD J_1ADTYP J_1ADTYP Distribution Types for Gross Income Tax J_1ADTYP
VBKD J_1ADTYP VBKD MANDT J_1ADTYP Distribution Types for Gross Income Tax MANDT
VBKD J_1AFITP VBKD MANDT J_1AFITP Tax Types MANDT
VBKD J_1AFITP 'D' J_1AFITP Tax Types KOART
VBKD J_1AFITP VBKD J_1AFITP J_1AFITP Tax Types J_1AFITP
VBKD J_1AGICD T001 LAND1 J_1AGICD Activity codes for gross income tax declaration LAND1
VBKD J_1AGICD VBKD J_1AGICD J_1AGICD Activity codes for gross income tax declaration J_1AGICD
VBKD J_1AGICD VBKD MANDT J_1AGICD Activity codes for gross income tax declaration MANDT
VBKD J_1AINDXP VBKD MANDT J_1AINFT20 Inflation: Index Definition MANDT
VBKD J_1AINDXP VBKD J_1AINDXP J_1AINFT20 Inflation: Index Definition J_1AINDX
VBKD J_1AREGIO VBKD MANDT T005S Taxes: Region (Province) Key MANDT
VBKD J_1AREGIO T001 LAND1 T005S Taxes: Region (Province) Key LAND1
VBKD J_1AREGIO VBKD J_1AREGIO T005S Taxes: Region (Province) Key BLAND
VBKD J_1ARFZ VBKD J_1ARFZ J_1ARFZ Definition of reasons for zero VAT J_1ARFZ
VBKD J_1ARFZ VBKD MANDT J_1ARFZ Definition of reasons for zero VAT MANDT
VBKD J_1ATXREL VBKD MANDT J_1ATXREL Tax relevant classification MANDT
VBKD J_1ATXREL VBKD J_1ATXREL J_1ATXREL Tax relevant classification J_1ATXREL
VBKD KDGRP VBKD MANDT T151 Customers: Customer Groups MANDT
VBKD KDGRP VBKD KDGRP T151 Customers: Customer Groups KDGRP
VBKD KDKG1 VBKD MANDT TVKGG Customer Condition Groups (Customer Master) MANDT
VBKD KDKG1 VBKD KDKG1 TVKGG Customer Condition Groups (Customer Master) KDKGR
VBKD KDKG2 VBKD KDKG2 TVKGG Customer Condition Groups (Customer Master) KDKGR
VBKD KDKG2 VBKD MANDT TVKGG Customer Condition Groups (Customer Master) MANDT
VBKD KDKG3 VBKD MANDT TVKGG Customer Condition Groups (Customer Master) MANDT
VBKD KDKG3 VBKD KDKG3 TVKGG Customer Condition Groups (Customer Master) KDKGR
VBKD KDKG4 VBKD MANDT TVKGG Customer Condition Groups (Customer Master) MANDT
VBKD KDKG4 VBKD KDKG4 TVKGG Customer Condition Groups (Customer Master) KDKGR
VBKD KDKG5 VBKD KDKG5 TVKGG Customer Condition Groups (Customer Master) KDKGR
VBKD KDKG5 VBKD MANDT TVKGG Customer Condition Groups (Customer Master) MANDT
VBKD KONDA VBKD KONDA T188 Conditions: Groups for Customer Classifications KONDA
VBKD KONDA VBKD MANDT T188 Conditions: Groups for Customer Classifications MANDT
VBKD KTGRD VBKD MANDT TVKT Customers: Account Assignment Groups MANDT
VBKD KTGRD VBKD KTGRD TVKT Customers: Account Assignment Groups KTGRD
VBKD LCNUM VBKD MANDT AKKP Documentary Payment Guarantee: Fin.Doc.Master - Header Data MANDT
VBKD LCNUM VBKD LCNUM AKKP Documentary Payment Guarantee: Fin.Doc.Master - Header Data LCNUM
VBKD MANDT VBKD MANDT T000 Clients MANDT
VBKD MANSP VBKD MANDT T040S Blocking reasons for dunning notices MANDT
VBKD MANSP VBKD MANSP T040S Blocking reasons for dunning notices MANSP
VBKD MSCHL VBKD MANDT T040 Dunning keys MANDT
VBKD MSCHL VBKD MSCHL T040 Dunning keys MSCHL
VBKD OIPFLIC VBKD MANDT TPAR Business Partner: Functions MANDT
VBKD OIPFLIC VBKD OIPFLIC TPAR Business Partner: Functions PARVW
VBKD PERFK VBKD PERFK TFACD Factory calendar definition IDENT
VBKD PERRL VBKD PERRL TFACD Factory calendar definition IDENT
VBKD PLTYP VBKD MANDT T189 Conditions: Price List Categories MANDT
VBKD PLTYP VBKD PLTYP T189 Conditions: Price List Categories PLTYP
VBKD POSNR VBKD VBELN VBUP Sales Document: Item Status VBELN
VBKD POSNR VBKD POSNR VBUP Sales Document: Item Status POSNR
VBKD POSNR VBKD MANDT VBUP Sales Document: Item Status MANDT
VBKD SDABW VBKD MANDT TVSAK Special Processing Indicator MANDT
VBKD SDABW VBKD SDABW TVSAK Special Processing Indicator SDABW
VBKD TRATY VBKD MANDT TVTY Packaging Material Types MANDT
VBKD TRATY VBKD TRATY TVTY Packaging Material Types TRATY
VBKD TRMTYP VBKD MANDT MARA General Material Data MANDT
VBKD TRMTYP VBKD TRMTYP MARA General Material Data MATNR
VBKD VBELN VBKD MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBKD VBELN VBKD VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
VBKD VSART VBKD VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
VBKD VSART VBKD MANDT T173 Routes: Mode of Transport for Each Shipping Type MANDT
VBKD WAKTION VBKD MANDT WAKH Promotion Header Data, IS-R MANDT
VBKD WAKTION VBKD WAKTION WAKH Promotion Header Data, IS-R AKTNR
VBKD WKWAE VBKD WKWAE TCURC Currency Codes WAERS
VBKD WKWAE VBKD MANDT TCURC Currency Codes MANDT
VBKD WMINR VBKD MANDT WWMI Product catalog MANDT
VBKD WMINR VBKD WMINR WWMI Product catalog WMINR
VBKD ZLSCH VBKD MANDT T042Z Payment Methods for Automatic Payment MANDT
VBKD ZLSCH RV45A BUKRSL T042Z Payment Methods for Automatic Payment LAND1
VBKD ZLSCH VBKD ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH