SAP ABAP Table VBAKR (Sales document structure for project reporting)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-IS (Application Component) Information System
     ⤷ CNIS (Package) Application development R/3 PS information system

Basic Data

Table Category	INTTAB	Structure
Structure	VBAKR	Table Relationship Diagram
Short Description	Sales document structure for project reporting

Delivery and Maintenance

Pool/cluster
Delivery Class
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	ARNUMMER	☐	ADMI_RUN_D	ADMI_RUN	CHAR	6	0	Archiving Session Number
2	VSGRUPPE	☐	VSGRUPPE	TEXT20	CHAR	20	0	Group for a project version
3	VSNUMMER	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
4	PSPID	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
5	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
6	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
7	AUFNR	☐	AUF_NETNR	AUFNR	CHAR	12	0	Order/Network number	AUFK
8	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
9	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
10	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
11	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
12	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
13	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
14	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
15	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
16	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
17	GSKST	☐	GSKST	GSBER	CHAR	4	0	Business area from cost center	TGSB
18	GUEBG	☐	GUEBG	DATUM	DATS	8	0	Valid-from date (outline agreements, product proposals)
19	GUEEN	☐	GUEEN	DATUM	DATS	8	0	Valid-to date (outline agreements, product proposals)
20	VBKLA	☐	VBKLA	CHAR9	CHAR	9	0	unused (sales doocument class)
21	VBKLT	☐	VBKLT	VBKLT	CHAR	1	0	SD document indicator
22	KTEXT	☐	KTEXT_V	TEXT40	CHAR	40	0	Search term for product proposal
23	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
24	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
25	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
26	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
27	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
28	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
29	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
30	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
31	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
32	BUKRS_VF	☐	BUKRS_VF	BUKRS	CHAR	4	0	Company code to be billed	T001
33	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
34	VBELN_GRP	☐	VBELN_GRP	VBELN	CHAR	10	0	Group Master Contract	VBUK
35	STATXT	☐	STATUSTEXT_2	CHAR80	CHAR	80	0	Edited status text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VBAKR	AUART	TVAK	AUART	REF	1	CN
2	VBAKR	AUFNR	AUFK	AUFNR	REF	1	CN
3	VBAKR	AUGRU	TVAU	AUGRU	REF	C	CN
4	VBAKR	BSARK	T176	BSARK	REF	C	CN
5	VBAKR	BUKRS_VF	T001	BUKRS	REF	C	CN
6	VBAKR	GSBER	TGSB	GSBER	REF	C	CN
7	VBAKR	GSKST	TGSB	GSBER	REF	C	CN
8	VBAKR	KDAUF	VBUK	VBELN	KEY	1	C
9	VBAKR	KOKRS	TKA01	KOKRS	REF	C	CN
10	VBAKR	KOSTL	CSKS	KOSTL	REF	C	CN
11	VBAKR	KUNNR	KNA1	KUNNR	REF	C	CN
12	VBAKR	QMNUM	QMEL	QMNUM	REF	C	CN
13	VBAKR	SPART	TVTA	SPART	REF	C	CN
14	VBAKR	VBELN_GRP	VBUK	VBELN	REF	C	CN
15	VBAKR	VKBUR	TVKBZ	VKBUR	REF	C	CN
16	VBAKR	VKGRP	TVBVK	VKGRP	REF	C	CN
17	VBAKR	VKORG	TVKO	VKORG	REF	1	CN
18	VBAKR	VTWEG	TVKOV	VTWEG	REF	C	CN
19	VBAKR	WAERK	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in