SAP VBKD Sales Document: Business Data Table

Overview

VBKD is a standard SAP S/4HANA table that stores Sales Document: Business Data data. There are total 102 fields in the VBKD table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VBKD belongs to Sales (SD-SLS) module and is located in the package Application development R/3 Sales (VA).

In addition, following links provide an overview of foreign key relationships, if any, that link VBKD to other SAP tables and standard CDS views available based on VBKD table in S/4HANA 2020.

Foreign Key Relations
VBKD CDS Views

Techincal Settings of VBKD

Below are technical details of the table VBKD

Buffering not allowed
No buffering
Storage type is Column Store

List of VBKD Fields

The following table gives you an overview of the fields available in VBKD

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

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VBKD

Table Name	Field	Cardinality	Check Table
VBKD	ABSSC	C: CN	T691M
VBKD	ABTNR	1: CN	TSAB
VBKD	AKWAE	1: CN	TCURC
VBKD	BEMOT	1: CN	TBMOT
VBKD	BSARK	C: CN	T176
VBKD	BSARK_E	C: CN	T176
VBKD	BZIRK	C: CN	T171
VBKD	DELCO	1: CN	TVDC
VBKD	FFPRF	1: CN	AD01C_PROF
VBKD	FKBER	:	TFKB
VBKD	FPLNR	C: CN	FPLA
VBKD	INCO1	C: CN	TINC
VBKD	INCOV	1: CN	TINCV
VBKD	J_1ADTYP	1: CN	J_1ADTYP
VBKD	J_1AFITP	1: CN	J_1AFITP
VBKD	J_1AGICD	1: CN	J_1AGICD
VBKD	J_1AINDXP	1: CN	J_1AINFT20
VBKD	J_1AREGIO	1: CN	T005S
VBKD	J_1ARFZ	1: CN	J_1ARFZ
VBKD	J_1ATXREL	1: CN	J_1ATXREL
VBKD	KDGRP	C: CN	T151
VBKD	KDKG1	C: CN	TVKGG
VBKD	KDKG2	C: CN	TVKGG
VBKD	KDKG3	C: CN	TVKGG
VBKD	KDKG4	C: CN	TVKGG
VBKD	KDKG5	C: CN	TVKGG
VBKD	KONDA	C: CN	T188
VBKD	KTGRD	C: CN	TVKT
VBKD	MANDT	1: CN	T000
VBKD	MANSP	C: CN	T040S
VBKD	MSCHL	C: CN	T040
VBKD	PACKNO	:	ESLH
VBKD	PERFK	C: CN	TFACD
VBKD	PERRL	C: CN	TFACD
VBKD	PLTYP	C: CN	T189
VBKD	SDABW	1: CN	TVSAK
VBKD	TRATY	1: CN	TVTY
VBKD	TRMTYP	1: CN	MARA
VBKD	VSART	1: CN	T173
VBKD	WAKTION	1: CN	WAKH
VBKD	WKWAE	1: CN	TCURC
VBKD	WMINR	1: CN	WWMI
VBKD	ZLSCH	C: CN	T042Z

SAP VBKD Sales Document: Business Data Table

Overview

Techincal Settings of VBKD

List of VBKD Fields

Foreign Key Relationships

Other References