SAP ABAP Table VBAPR (Sales document item 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	VBAPR	Table Relationship Diagram
Short Description	Sales document item 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	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
5	PSPID	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
6	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
7	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
8	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
9	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
11	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
12	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
13	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
14	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
15	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
16	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	TVPT
17	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
18	LFREL	☐	LFREL_AP	XFELD	CHAR	1	0	Item is relevant for delivery
19	FKREL	☐	FKREL	FKREL	CHAR	1	0	Relevant for Billing
20	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	*
21	GRPOS	☐	GRPOS	GRPOS	NUMC	6	0	Item for which this item is an alternative
22	ZWERT	☐	DZWERT	WERT7	CURR	13	2	Target value for outline agreement in document currency
23	ZMENG	☐	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
24	ZIEME	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	T006
25	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
26	SMENG	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
27	ABSFZ	☐	ABSFZ	MENG13	QUAN	13	3	Allowed deviation in quantity (absolute)
28	POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
29	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
30	KBVER	☐	KBVER	PACK2	DEC	3	0	Allowed deviation in quantity (in percent)
31	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
32	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
33	NETWR	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
34	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
35	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
36	LSMENG	☐	LSMENG	MENG15	QUAN	15	3	Cumulative Target Delivery Qty (all dlv-relev.sched.lines)
37	KBMENG	☐	KBMENG	MENG15	QUAN	15	3	Cumulative confirmed quantity in sales unit
38	KLMENG	☐	KLMENG	MENG15	QUAN	15	3	Cumulative Confirmed Quantity in Base Unit of Measure
39	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
40	VBELV	☐	VBELV	VBELN	CHAR	10	0	Originating document	VBUK
41	POSNV	☐	POSNV	POSNR	NUMC	6	0	Originating item	VBUP
42	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
43	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP
44	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
45	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
46	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
47	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
48	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
49	STKEY	☐	STKEY	STKEY	CHAR	1	0	Origin of the bill of material
50	STDAT	☐	STDAT	DATUM	DATS	8	0	Date of Bill of Material
51	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
52	STPOS	☐	STPOS_VBAP	STPOS_VBAP	DEC	5	0	Bill of material item number VBAP not used
53	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
54	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
55	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
56	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
57	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
58	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
59	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
60	KMPMG	☐	KMPMG	MENGV13	QUAN	13	3	Component Quantity
61	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
62	VPMAT	☐	VPMAT	MATNR	CHAR	18	0	Planning material	MARA
63	VPWRK	☐	VPWRK	WERKS	CHAR	4	0	Planning plant	T001W
64	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
65	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
66	ABGRS	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
67	SPOSN	☐	SPOSN	SPOSN	CHAR	4	0	BOM Item Number
68	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	VBAPR	ABGRS	TKKAA	ABGSL	REF	C	CN
2	VBAPR	AUFNR	AUFK	AUFNR	REF	C	CN
3	VBAPR	CHARG	MCH1	CHARG	REF	C	CN
4	VBAPR	GSBER	TGSB	GSBER	REF	C	CN
5	VBAPR	KDAUF	VBUK	VBELN	KEY	1	C
6	VBAPR	KDPOS	VBUP	POSNR	KEY	1	CN
7	VBAPR	KMEIN	T006	MSEHI	REF	C	CN
8	VBAPR	KNTTP	T163K	KNTTP	REF	C	CN
9	VBAPR	LGORT	T001L	LGORT	REF	C	CN
10	VBAPR	LPRIO	TPRIO	LPRIO	REF	C	CN
11	VBAPR	MATKL	T023	MATKL	REF	C	CN
12	VBAPR	MATNR	MARA	MATNR	REF	C	CN
13	VBAPR	MATWA	MARA	MATNR	REF	C	CN
14	VBAPR	MEINS	T006	MSEHI	REF	C	CN
15	VBAPR	PMATN	MARA	MATNR	REF	C	CN
16	VBAPR	POSNV	VBUP	POSNR	REF	C	CN
17	VBAPR	PRCTR	CEPC	PRCTR	REF	C	CN
18	VBAPR	PSTYV	TVPT	PSTYV	REF	C	CN
19	VBAPR	ROUTE	TVRO	ROUTE	REF	C	CN
20	VBAPR	SERNR	SNUM	SERNR	REF	C	CN
21	VBAPR	SOBKZ	T148	SOBKZ	REF	C	CN
22	VBAPR	SPART	TSPA	SPART	REF	C	CN
23	VBAPR	VBELV	VBUK	VBELN	REF	C	CN
24	VBAPR	VGBEL	VBUK	VBELN	REF	C	CN
25	VBAPR	VGPOS	VBUP	POSNR	REF	C	CN
26	VBAPR	VPMAT	MARA	MATNR	REF	C	CN
27	VBAPR	VPWRK	T001W	WERKS	REF	C	CN
28	VBAPR	VRKME	T006	MSEHI	REF	C	CN
29	VBAPR	VSTEL	TVST	VSTEL	REF	C	CN
30	VBAPR	WAERK	TCURC	WAERS	REF	C	CN
31	VBAPR	WERKS	T001W	WERKS	REF	C	CN
32	VBAPR	ZIEME	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in