Follow us on LinkedIn for your next SAP project

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 Possible values
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
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
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
RRREL
Revenue recognition category
RR_RELTYP
CHAR
1 0
ACDATV
Proposed start date for accrual period
RR_ACDATV
CHAR
1 0
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
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
REVEVTYP
Revenue Event Type (Customizing)
RR_REVEVTYP_CUST
CHAR
1 0
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
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
SEPON
SEPA-Relevance
SD_SEPA_FLAG
CHAR
1 0
MNDVG
SEPA-Relevance
SD_SEPA_FLAG
CHAR
1 0

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 AKWAE TCURC
Currency Codes
WAERS
VBKD AKWAE VBKD MANDT TCURC
Currency Codes
MANDT
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 BZIRK T171
Customers: Sales Districts
BZIRK
VBKD BZIRK VBKD MANDT T171
Customers: Sales Districts
MANDT
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 FPLNR FPLA
Billing Plan
FPLNR
VBKD FPLNR VBKD MANDT FPLA
Billing Plan
MANDT
VBKD INCO1 VBKD MANDT TINC
Customers: Incoterms
MANDT
VBKD INCO1 VBKD INCO1 TINC
Customers: Incoterms
INCO1
VBKD J_1ADTYP VBKD MANDT J_1ADTYP
Distribution Types for Gross Income Tax
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_1AFITP 'D' J_1AFITP
Tax Types
KOART
VBKD J_1AFITP VBKD J_1AFITP J_1AFITP
Tax Types
J_1AFITP
VBKD J_1AFITP VBKD MANDT J_1AFITP
Tax Types
MANDT
VBKD J_1AGICD VBKD MANDT J_1AGICD
Activity codes for gross income tax declaration
MANDT
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_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 J_1AREGIO T005S
Taxes: Region (Province) Key
BLAND
VBKD J_1AREGIO VBKD MANDT T005S
Taxes: Region (Province) Key
MANDT
VBKD J_1AREGIO T001 LAND1 T005S
Taxes: Region (Province) Key
LAND1
VBKD J_1ARFZ VBKD MANDT J_1ARFZ
Definition of reasons for zero VAT
MANDT
VBKD J_1ARFZ VBKD J_1ARFZ J_1ARFZ
Definition of reasons for zero VAT
J_1ARFZ
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 KDKG1 TVKGG
Customer Condition Groups (Customer Master)
KDKGR
VBKD KDKG1 VBKD MANDT TVKGG
Customer Condition Groups (Customer Master)
MANDT
VBKD KDKG2 VBKD MANDT TVKGG
Customer Condition Groups (Customer Master)
MANDT
VBKD KDKG2 VBKD KDKG2 TVKGG
Customer Condition Groups (Customer Master)
KDKGR
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 MANDT TVKGG
Customer Condition Groups (Customer Master)
MANDT
VBKD KDKG5 VBKD KDKG5 TVKGG
Customer Condition Groups (Customer Master)
KDKGR
VBKD KONDA VBKD MANDT T188
Conditions: Groups for Customer Classifications
MANDT
VBKD KONDA VBKD KONDA T188
Conditions: Groups for Customer Classifications
KONDA
VBKD KTGRD VBKD KTGRD TVKT
Customers: Account Assignment Groups
KTGRD
VBKD KTGRD VBKD MANDT TVKT
Customers: Account Assignment Groups
MANDT
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 OIPFLIC TPAR
Business Partner: Functions
PARVW
VBKD OIPFLIC VBKD MANDT TPAR
Business Partner: Functions
MANDT
VBKD PERFK VBKD PERFK TFACD
Factory calendar definition
IDENT
VBKD PERRL VBKD PERRL TFACD
Factory calendar definition
IDENT
VBKD PLTYP VBKD PLTYP T189
Conditions: Price List Categories
PLTYP
VBKD PLTYP VBKD MANDT T189
Conditions: Price List Categories
MANDT
VBKD POSNR VBKD MANDT VBUP
Sales Document: Item Status
MANDT
VBKD POSNR VBKD VBELN VBUP
Sales Document: Item Status
VBELN
VBKD POSNR VBKD POSNR VBUP
Sales Document: Item Status
POSNR
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 VBELN VBUK
Sales Document: Header Status and Administrative Data
VBELN
VBKD VBELN VBKD MANDT VBUK
Sales Document: Header Status and Administrative Data
MANDT
VBKD VSART VBKD MANDT T173
Routes: Mode of Transport for Each Shipping Type
MANDT
VBKD VSART VBKD VSART T173
Routes: Mode of Transport for Each Shipping Type
VSART
VBKD WAKTION VBKD WAKTION WAKH
Promotion Header Data, IS-R
AKTNR
VBKD WAKTION VBKD MANDT WAKH
Promotion Header Data, IS-R
MANDT
VBKD WKWAE VBKD MANDT TCURC
Currency Codes
MANDT
VBKD WKWAE VBKD WKWAE TCURC
Currency Codes
WAERS
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