SAP ABAP Table VSVBKD_CN (Version: Sales document - commercial data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ CNVS (Package) R/3 Application development: Version Management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VSVBKD_CN	Table Relationship Diagram
Short Description	Version: Sales document - commercial 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	*
2	.INCLUDE	☑				0	0	Version: PS version, version-related key fields
3	VSNMR	☑	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
4	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
5	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
6	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	*
7	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
8	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	*
9	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	*
10	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
11	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
12	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
13	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	*
14	PERRL	☐	PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)	*
15	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
16	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
17	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
18	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
19	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
20	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	*
21	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	*
22	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
23	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
24	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
25	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
26	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
27	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
28	STCUR	☐	STCUR	KURRF	DEC	9	5	Exchange rate for statistics
29	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	*
30	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
31	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	*
32	WAKTION	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
33	ABSSC	☐	ABSSCHE_CM	ABSSCHE_CM	CHAR	6	0	Payment Guarantee Procedure
34	LCNUM	☐	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number	*
35	J_1AFITP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	*
36	J_1ARFZ	☐	J_1ARFZVAT	J_1ARFZVAT	CHAR	1	0	Reason for zero VAT	*
37	J_1AREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
38	J_1AGICD	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	*
39	J_1ADTYP	☐	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax	*
40	J_1ATXREL	☐	J_1ATXREL_	J_1ATXREL	CHAR	10	0	Tax relevant classification	*
41	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	*
42	EMPST	☐	EMPST	TEXT25	CHAR	25	0	Receiving point
43	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
44	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
45	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	*
46	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
47	BSTKD_E	☐	BSTKD_E	BSTKD	CHAR	35	0	Ship-to Party's Purchase Order Number
48	BSTDK_E	☐	BSTDK_E	DATUM	DATS	8	0	Ship-to party's PO date
49	BSARK_E	☐	BSARK_E	BSARK	CHAR	4	0	Ship-to party purchase order type	*
50	IHREZ_E	☐	IHREZ_E	TEXT12	CHAR	12	0	Ship-to party character
51	POSEX_E	☐	POSEX_E	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
52	KURSK_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
53	KURRF_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
54	KDKG1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	*
55	KDKG2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	*
56	KDKG3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	*
57	KDKG4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	*
58	KDKG5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	*
59	WKWAE	☐	WKWAE	WAERS	CUKY	5	0	Value contract currency	*
60	WKKUR	☐	WKKUR	KURRF	DEC	9	5	Exchange rate in value contract currency
61	AKWAE	☐	AKWAE	WAERS	CUKY	5	0	Currency key for letter-of-credit procg in foreign trade	*
62	AKKUR	☐	AKKUR	KURRF	DEC	9	5	Exchange rate for letter-of-credit procg in foreign trade
63	AKPRZ	☐	AKPRZ	PRZ32	DEC	5	2	Depreciation percentage for financial document processing
64	J_1AINDXP	☐	J_1AINDXP	J_1AINDXP	CHAR	5	0	Inflation Index	*
65	J_1AIDATEP	☐	J_1AIDATES	J_1AUDATEP	DATS	8	0	Indexing base date
66	BSTKD_M	☐	BSTKD_M	CHAR35	CHAR	35	0	Customer PO number as matchcode field
67	DELCO	☐	DELCO	DELCO	CHAR	3	0	Agreed delivery time
68	FFPRF	☐	AD01PROFNR	AD01PROFNR	CHAR	8	0	Dynamic Item Processor Profile	*
69	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	*
70	FAKTF	☐	FAKTF	FAKTF	CHAR	2	0	Billing Form
71	RRREL	☐	RR_RELTYP	RR_RELTYP	CHAR	1	0	Revenue recognition category
72	ACDATV	☐	RR_ACDATV	RR_ACDATV	CHAR	1	0	Proposed start date for accrual period
73	VSART	☐	VSARTTR	VERSART	CHAR	2	0	Shipping type	T173
74	TRATY	☐	TRATY	TRATY	CHAR	4	0	Means-of-Transport Type	TVTY
75	TRMTYP	☐	TRMTYP	MATNR	CHAR	18	0	Means of Transportation	MARA
76	SDABW	☐	SDABW	SDABW	CHAR	4	0	Special Processing Indicator	TVSAK
77	WMINR	☐	WMINR	WMINR	CHAR	10	0	Product catalog number	WWMI
78	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
79	PODKZ	☐	PODKZ	XFELD	CHAR	1	0	Relevant for POD processing
80	CAMPAIGN	☐	CGPL_GUID16_R3	SYSUUID	RAW	16	0	Generic project planning: GUID from external R/3 system
81	VKONT	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
82	.INCLU--AP	☐				0	0	APPEND in Version Table for APPEND J_1IVBKD in VBKD
83	STCODE	☐	J_1ISTCODE	J_1ISTCODE	CHAR	3	0	LST CST applicability code	*
84	FORMC1	☐	J_1IFORTYP	J_1IFORTYP	CHAR	3	0	Form Type	*
85	FORMC2	☐	J_1IFORTYP	J_1IFORTYP	CHAR	3	0	Form Type	*
86	STEUC	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VSVBKD_CN	FKBER	TFKB	FKBER
2	VSVBKD_CN	SDABW	TVSAK	SDABW	KEY	1	CN
3	VSVBKD_CN	TRATY	TVTY	TRATY	KEY	1	CN
4	VSVBKD_CN	TRMTYP	MARA	MATNR	KEY	1	CN
5	VSVBKD_CN	VSART	T173	VSART	KEY	1	CN
6	VSVBKD_CN	WMINR	WWMI	WMINR	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in