SAP ABAP Table VBKD (Sales Document: Business Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VA (Package) Application development R/3 Sales

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VBKD	Table Relationship Diagram
Short Description	Sales Document: Business Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
3	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
4	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
5	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
6	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
7	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
8	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
9	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
10	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
11	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
12	PERRL	☐	PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)	TFACD
13	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
14	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
15	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
16	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
17	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
18	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
19	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
20	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
21	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
22	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
23	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
24	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
25	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
26	STCUR	☐	STCUR	KURRF	DEC	9	5	Exchange rate for statistics
27	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
28	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
29	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	FPLA
30	WAKTION	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
31	ABSSC	☐	ABSSCHE_CM	ABSSCHE_CM	CHAR	6	0	Payment Guarantee Procedure	T691M
32	LCNUM	☐	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number	AKKP
33	J_1AFITP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITP
34	J_1ARFZ	☐	J_1ARFZVAT	J_1ARFZVAT	CHAR	1	0	Reason for zero VAT	J_1ARFZ
35	J_1AREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
36	J_1AGICD	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	J_1AGICD
37	J_1ADTYP	☐	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax	J_1ADTYP
38	J_1ATXREL	☐	J_1ATXREL_	J_1ATXREL	CHAR	10	0	Tax relevant classification	J_1ATXREL
39	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
40	EMPST	☐	EMPST	TEXT25	CHAR	25	0	Receiving point
41	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
42	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
43	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
44	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
45	BSTKD_E	☐	BSTKD_E	BSTKD	CHAR	35	0	Ship-to Party's Purchase Order Number
46	BSTDK_E	☐	BSTDK_E	DATUM	DATS	8	0	Ship-to party's PO date
47	BSARK_E	☐	BSARK_E	BSARK	CHAR	4	0	Ship-to party purchase order type	T176
48	IHREZ_E	☐	IHREZ_E	TEXT12	CHAR	12	0	Ship-to party character
49	POSEX_E	☐	POSEX_E	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
50	KURSK_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
51	KURRF_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
52	KDKG1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	TVKGG
53	KDKG2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	TVKGG
54	KDKG3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	TVKGG
55	KDKG4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	TVKGG
56	KDKG5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	TVKGG
57	WKWAE	☐	WKWAE	WAERS	CUKY	5	0	Value contract currency	TCURC
58	WKKUR	☐	WKKUR	KURRF	DEC	9	5	Exchange rate in value contract currency
59	AKWAE	☐	AKWAE	WAERS	CUKY	5	0	Currency key for letter-of-credit procg in foreign trade	TCURC
60	AKKUR	☐	AKKUR	KURRF	DEC	9	5	Exchange rate for letter-of-credit procg in foreign trade
61	AKPRZ	☐	AKPRZ	PRZ32	DEC	5	2	Depreciation percentage for financial document processing
62	J_1AINDXP	☐	J_1AINDXP	J_1AINDXP	CHAR	5	0	Inflation Index	J_1AINFT20
63	J_1AIDATEP	☐	J_1AIDATES	J_1AUDATEP	DATS	8	0	Indexing base date
64	BSTKD_M	☐	BSTKD_M	CHAR35	CHAR	35	0	Customer PO number as matchcode field
65	DELCO	☐	DELCO	DELCO	CHAR	3	0	Agreed delivery time	TVDC
66	FFPRF	☐	AD01PROFNR	AD01PROFNR	CHAR	8	0	Dynamic Item Processor Profile	AD01C_PROF
67	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
68	FAKTF	☐	FAKTF	FAKTF	CHAR	2	0	Billing Form
69	RRREL	☐	RR_RELTYP	RR_RELTYP	CHAR	1	0	Revenue recognition category
70	ACDATV	☐	RR_ACDATV	RR_ACDATV	CHAR	1	0	Proposed start date for accrual period
71	VSART	☐	VSARTTR	VERSART	CHAR	2	0	Shipping type	T173
72	TRATY	☐	TRATY	TRATY	CHAR	4	0	Means-of-Transport Type	TVTY
73	TRMTYP	☐	TRMTYP	MATNR	CHAR	18	0	Means of Transportation	MARA
74	SDABW	☐	SDABW	SDABW	CHAR	4	0	Special Processing Indicator	TVSAK
75	WMINR	☐	WMINR	WMINR	CHAR	10	0	Product catalog number	WWMI
76	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
77	PODKZ	☐	PODKZ	XFELD	CHAR	1	0	Relevant for POD processing
78	CAMPAIGN	☐	CGPL_GUID16_R3	SYSUUID	RAW	16	0	Generic project planning: GUID from external R/3 system
79	VKONT	☐	CORR_VKONT_KK	CORR_VKONT_KK	CHAR	12	0	Contract Account Number
80	DPBP_REF_FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	*
81	DPBP_REF_FPLTR	☐	FPLTR	FPLTR	NUMC	6	0	Item for billing plan/invoice plan/payment cards	*
82	REVSP	☐	RR_REVSP	RR_REVSP	CHAR	1	0	Revenue Distribution Type
83	REVEVTYP	☐	RR_REVEVTYP_CUST	RR_REVEVTYP_CUST	CHAR	1	0	Revenue Event Type (Customizing)
84	VTREF	☐	CORR_VTREF_KK	CORR_VTREF_KK	CHAR	20	0	Reference Specifications from Contract
85	.INCLU--AP	☐				0	0	Period of Performance
86	PEROP_BEG	☐	FM_PEROP_SD_LOW	DATUM	DATS	8	0	Period of Performance Start Date
87	PEROP_END	☐	FM_PEROP_SD_HIGH	DATUM	DATS	8	0	Period of Performance End Date
88	.INCLU--AP	☐				0	0	Sales forms extension
89	STCODE	☐	J_1ISTCODE	J_1ISTCODE	CHAR	3	0	LST CST applicability code	*
90	FORMC1	☐	J_1IFORTYP	J_1IFORTYP	CHAR	3	0	Form Type	*
91	FORMC2	☐	J_1IFORTYP	J_1IFORTYP	CHAR	3	0	Form Type	*
92	STEUC	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	*
93	.INCLU--AP	☐				0	0	Complaint Management
94	COMPREAS	☐	CMP_COMPREAS_COPY	CMP_COMPREAS_COPY	CHAR	4	0	Abbreviation for Complaints Reason
95	.INCLU--AP	☐				0	0	VBRK_SEPA
96	.INCLUDE	☐				0	0	SEPA SD Struktur
97	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
98	PAY_TYPE	☐	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
99	SEPON	☐	SD_SEPA_FLAG	SD_SEPA_FLAG	CHAR	1	0	SEPA-Relevance
100	MNDVG	☐	SD_SEPA_FLAG	SD_SEPA_FLAG	CHAR	1	0	SEPA-Relevance

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VBKD	ABSSC	T691M	ABSSC	REF	C	CN
2	VBKD	ABTNR	TSAB	ABTNR	REF	1	CN
3	VBKD	AKWAE	TCURC	WAERS	REF	1	CN
4	VBKD	BEMOT	TBMOT	BEMOT	REF	1	CN
5	VBKD	BSARK	T176	BSARK	REF	C	CN
6	VBKD	BSARK_E	T176	BSARK		C	CN
7	VBKD	BZIRK	T171	BZIRK	REF	C	CN
8	VBKD	DELCO	TVDC	DELCO	KEY	1	CN
9	VBKD	FFPRF	AD01C_PROF	PROFNR		1	CN
10	VBKD	FKBER	TFKB	FKBER
11	VBKD	FPLNR	FPLA	FPLNR	REF	C	CN
12	VBKD	INCO1	TINC	INCO1	REF	C	CN
13	VBKD	J_1ADTYP	J_1ADTYP	J_1ADTYP		1	CN
14	VBKD	J_1AFITP	J_1AFITP	J_1AFITP		1	CN
15	VBKD	J_1AGICD	J_1AGICD	J_1AGICD		1	CN
16	VBKD	J_1AINDXP	J_1AINFT20	J_1AINDX	KEY	1	CN
17	VBKD	J_1AREGIO	T005S	BLAND		1	CN
18	VBKD	J_1ARFZ	J_1ARFZ	J_1ARFZ		1	CN
19	VBKD	J_1ATXREL	J_1ATXREL	J_1ATXREL		1	CN
20	VBKD	KDGRP	T151	KDGRP	REF	C	CN
21	VBKD	KDKG1	TVKGG	KDKGR		C	CN
22	VBKD	KDKG2	TVKGG	KDKGR		C	CN
23	VBKD	KDKG3	TVKGG	KDKGR		C	CN
24	VBKD	KDKG4	TVKGG	KDKGR		C	CN
25	VBKD	KDKG5	TVKGG	KDKGR		C	CN
26	VBKD	KONDA	T188	KONDA	REF	C	CN
27	VBKD	KTGRD	TVKT	KTGRD	REF	C	CN
28	VBKD	LCNUM	AKKP	LCNUM		C	CN
29	VBKD	MANDT	T000	MANDT	KEY	1	CN
30	VBKD	MANSP	T040S	MANSP	REF	C	CN
31	VBKD	MSCHL	T040	MSCHL	REF	C	CN
32	VBKD	PERFK	TFACD	IDENT	REF	C	CN
33	VBKD	PERRL	TFACD	IDENT	REF	C	CN
34	VBKD	PLTYP	T189	PLTYP	REF	C	CN
35	VBKD	POSNR	VBUP	POSNR	KEY	1	CN
36	VBKD	SDABW	TVSAK	SDABW	KEY	1	CN
37	VBKD	TRATY	TVTY	TRATY	KEY	1	CN
38	VBKD	TRMTYP	MARA	MATNR	KEY	1	CN
39	VBKD	VBELN	VBUK	VBELN	KEY	1	CN
40	VBKD	VSART	T173	VSART	KEY	1	CN
41	VBKD	WAKTION	WAKH	AKTNR	REF	1	CN
42	VBKD	WKWAE	TCURC	WAERS		1	CN
43	VBKD	WMINR	WWMI	WMINR	REF	1	CN
44	VBKD	ZLSCH	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in