SAP ABAP Table VBAPI (PSIS - Individual Overviews: SD Document Items)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-IS-REP-LOG (Application Component) Logistics
     ⤷ PSIS_SINGLE (Package) PS Logistic Overview: Single Overview'

Basic Data

Table Category	INTTAB	Structure
Structure	VBAPI	Table Relationship Diagram
Short Description	PSIS - Individual Overviews: SD Document Items

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VBAPI	ABGRS	TKKAA	ABGSL	REF	C	CN
2	VBAPI	AUFNR	AUFK	AUFNR	REF	C	CN
3	VBAPI	CHARG	MCH1	CHARG	REF	C	CN
4	VBAPI	GSBER	TGSB	GSBER	REF	C	CN
5	VBAPI	KDAUF	VBUK	VBELN	KEY	1	C
6	VBAPI	KDPOS	VBUP	POSNR	KEY	1	CN
7	VBAPI	KMEIN	T006	MSEHI	REF	C	CN
8	VBAPI	KNTTP	T163K	KNTTP	REF	C	CN
9	VBAPI	LGORT	T001L	LGORT	REF	C	CN
10	VBAPI	LPRIO	TPRIO	LPRIO	REF	C	CN
11	VBAPI	MATKL	T023	MATKL	REF	C	CN
12	VBAPI	MATNR	MARA	MATNR	REF	C	CN
13	VBAPI	MATWA	MARA	MATNR	REF	C	CN
14	VBAPI	MEINS	T006	MSEHI	REF	C	CN
15	VBAPI	PMATN	MARA	MATNR	REF	C	CN
16	VBAPI	POSNV	VBUP	POSNR	REF	C	CN
17	VBAPI	PRCTR	CEPC	PRCTR	REF	C	CN
18	VBAPI	PSTYV	TVPT	PSTYV	REF	C	CN
19	VBAPI	ROUTE	TVRO	ROUTE	REF	C	CN
20	VBAPI	SERNR	SNUM	SERNR	REF	C	CN
21	VBAPI	SOBKZ	T148	SOBKZ	REF	C	CN
22	VBAPI	SPART	TSPA	SPART	REF	C	CN
23	VBAPI	VBELV	VBUK	VBELN	REF	C	CN
24	VBAPI	VGBEL	VBUK	VBELN	REF	C	CN
25	VBAPI	VGPOS	VBUP	POSNR	REF	C	CN
26	VBAPI	VPMAT	MARA	MATNR	REF	C	CN
27	VBAPI	VPWRK	T001W	WERKS	REF	C	CN
28	VBAPI	VRKME	T006	MSEHI	REF	C	CN
29	VBAPI	VSTEL	TVST	VSTEL	REF	C	CN
30	VBAPI	WAERK	TCURC	WAERS	REF	C	CN
31	VBAPI	WERKS	T001W	WERKS	REF	C	CN
32	VBAPI	ZIEME	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in	470