SAP ABAP Table SHP_VL10_ITEM (Substructure for List Display for Documents Due for Shipment)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VL (Package) WS-SHP: General Processing for Shipping

Basic Data

Table Category	INTTAB	Structure
Structure	SHP_VL10_ITEM	Table Relationship Diagram
Short Description	Substructure for List Display for Documents Due for Shipment

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	SELKZ	☐	XFELD	XFELD	CHAR	1	0	Checkbox
2	EXPAND	☐	XFELD	XFELD	CHAR	1	0	Checkbox
3	LINE_COLOR	☐			CHAR	3	0
4	AMPEL	☐	SHP_VL10_AMPEL1	AMPEL_IK	NUMC	1	0	Signal for urgent and overdue documents
5	POSTAB_TABIX	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
6	MASTER_TABIX	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
7	SLAVE0_TABIX	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
8	SORT1	☐	SHP_VL10_SORT1	SHP_VL10_SORT1	CHAR	1	0	First sort criterion for the VL10 list
9	ENQUE_VORG	☐	SHP_VL10_ENQUE_VORG	XFELD	CHAR	1	0	Delivery item's predecessor is blocked
10	ENQUE_NACH	☐	XFELD	XFELD	CHAR	1	0	Checkbox
11	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
12	SPLIT_RULE	☐	SHP_VL10_SPLIT_RULE	SHP_VL10_SPLIT_RULE	CHAR	4	0	Rule for creating one delivery item per schedule line
13	.INCLUDE	☐				0	0	Delivery Due Index
14	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
15	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
16	LEDAT	☐	LEDAT	DATUM	DATS	8	0	Delivery Creation Date
17	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
18	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
19	SPDNR	☐	SPDNR	LIFNR	CHAR	10	0	Carrier	LFA1
20	WADAT	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
21	KUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
22	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
23	LIFSP	☐	LIFSP_VG	LIFSP	CHAR	2	0	Delivery block for header or schedule line	TVLS
24	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
25	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
26	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
27	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
28	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
29	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
30	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
31	BRGEW	☐	BRGEW_VG	MENG15	QUAN	15	3	Open gross weight of all schedule lines for this key
32	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
33	VOLUM	☐	VOLUM_VG	MENG15	QUAN	15	3	Open volume of all schedule lines for this key
34	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
35	BEARZ	☐	BEARZ_VG	DEC3_2	DEC	5	2	Processing time in days
36	ADRNR_AG	☐	ADRNR_AG	ADRNR	CHAR	10	0	Address number of the sold-to party	*
37	ADRNR_WE	☐	ADRNR_WE	ADRNR	CHAR	10	0	Address number of the ship-to party	*
38	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
39	KZAZU	☐	KZAZU_INV	XFELD	CHAR	1	0	Inverse Cumulated Indicator: Order Combination
40	VGTYP	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
41	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
42	VBELV	☐	VBELV	VBELN	CHAR	10	0	Originating document	*
43	POSNV	☐	POSNV	POSNR	NUMC	6	0	Originating item	*
44	ETENR	☐	ETENR	ETENR	NUMC	4	0	Schedule line	*
45	ETART	☐	EDI_ETTYP	ETART	CHAR	1	0	Schedule line type EDI	*
46	ABART	☐	ABART	ABART	CHAR	1	0	Release type
47	POSNN	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
48	WMENG	☐	WMENG	MENG13	QUAN	13	3	Order quantity in sales units
49	BMENG	☐	BMENG	MENG13	QUAN	13	3	Confirmed quantity
50	OLFMNG	☐	OLFMNG	MENG13	QUAN	13	3	Open quantity to be delivered (in sales unit)
51	VSMNG	☐	VSMNG	MENG13	QUAN	13	3	Delivered quantity in sales units
52	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
53	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
54	LFIMG	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
55	LEINS	☐	SHP_VL10_LEINS	MEINS	UNIT	3	0	Sales unit of the delivery item	*
56	EDATU	☐	EDATU	DATUM	DATS	8	0	Schedule line date
57	PRGRS	☐	PRGRS	PRGRS	CHAR	1	0	Date type (day, week, month, interval)
58	ETDAT	☐	ETDAT	ETDAT	CHAR	10	0	Schedule line date
59	PRGBZ	☐	PRGBZ	PRGBZ	CHAR	1	0	External date type	*
60	WBSTA	☐	WBSTA	STATV	CHAR	1	0	Goods movement status
61	KOSTA	☐	KOSTA	STATV	CHAR	1	0	Picking Status/Putaway Status
62	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
63	NAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
64	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
65	KDMAT	☐	KDMAT	IDNEX	CHAR	35	0	Material belonging to the customer
66	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
67	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
68	LABST	☐	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock
69	ME001	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
70	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
71	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	*
72	ABHOV	☐	ABHOZ	UZEIT	TIMS	6	0	Pick up time
73	EZEIT	☐	EZEIT_VBEP	UZEIT	TIMS	6	0	Arrival time
74	ETTYP	☐	ETTYP	ETTYP	CHAR	2	0	Item Cat. in Schedule Line	*
75	KUMNG	☐	SHP_VL10_KUMNG	MENG13	QUAN	13	3	Cumulated open delivery quantity of all schedule lines
76	KUMNG_NO_ROUND	☐	SHP_VL10_KUMNG_NO_ROUND	MENG13	QUAN	13	3	Cumulated open delivery quantity (not rounded)
77	ABLFZ	☐	ABLFZ	ABLFZ	QUAN	13	3	Rounding quantity for delivery
78	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
79	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
80	PLART	☐	PLART	PLART	CHAR	1	0	Planning type	*
81	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
82	AESKD	☐	AESKD	AESKD	CHAR	17	0	Customer Engineering Change Status
83	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
84	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
85	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
86	KZFME	☐	KZFME	KZFME	CHAR	1	0	ID: Leading unit of measure for completing a transaction
87	DATUM	☐	DATUM	DATUM	DATS	8	0	Date
88	UZEIT	☐	UZEIT	UZEIT	TIMS	6	0	Time
89	DATVW	☐	DATVW	DATVW	CHAR	1	0	Usage of a date for scheduling the delivery
90	NORND_LP	☐	NORND_LP	SELKZ	CHAR	1	0	No rounding acc. to rounding qty in sched. agreement
91	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
92	WAKTION	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
93	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	*
94	AULWE	☐	AULWE	AULWE	CHAR	10	0	Route Schedule	*
95	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
96	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
97	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
98	MBUHR	☐	MBUHR	TIME_PLANT	TIMS	6	0	Material Staging Time (Local, Relating to a Plant)
99	TDDAT	☐	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
100	TDUHR	☐	TDUHR	TIME_SHIPP	TIMS	6	0	Transp. Planning Time (Local, Relating to a Shipping Point)
101	LDDAT	☐	LDDAT	DATUM	DATS	8	0	Loading Date
102	LDUHR	☐	LDUHR	TIME_SHIPP	TIMS	6	0	Loading Time (Local Time Relating to a Shipping Point)
103	WAUHR	☐	WAUHR	TIME_PLANT	TIMS	6	0	Time of Goods Issue (Local, Relating to a Plant)
104	LFDAT	☐	LFDAT	DATUM	DATS	8	0	Delivery date
105	LFUHR	☐	LFUHR	LFUHR	TIMS	6	0	Time of delivery
106	BTGEW	☐	GSGEW	MENG15	QUAN	15	3	Total Weight
107	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
108	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
109	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
110	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
111	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	*
112	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	*
113	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
114	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
115	KODAT	☐	KODAT	DATUM	DATS	8	0	Picking Date
116	LFART	☐	LFART	LFART	CHAR	4	0	Delivery Type	*
117	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	*
118	WADAT_IST	☐	WADAT_IST	DATUM	DATS	8	0	Actual Goods Movement Date
119	ADDEL	☐	SHP_VL10_ADDEL	XFELD	CHAR	1	0	Additional, Individually Selected Delivery
120	VGSYS	☐	VGLOGSYS	LOGSYS	CHAR	10	0	Logical System in the Preceding Document	*
121	BESTA	☐	BESTA	STATV	CHAR	1	0	Confirmation status of the document item
122	ICON_OBJECT	☐	LESHP_ICON_OBJECT	LESHP_ICON_OBJECT	CHAR	20	0	Graphical Display of an Object from Delivery Processing
123	LOGSYS_N	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
124	BEDAE	☐	BEDAE	BEDAE	CHAR	4	0	Requirements type	*
125	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	*
126	GRKOR	☐	GRKOR	GRKOR	NUMC	3	0	Delivery group (items are delivered together)
127	SPE_REL_TMSTMP	☐	/SPE/DE_RELEASE_TMSTMP	TZNTSTMPS	DEC	15	0	Release Time Stamp
128	SPE_ATP_TMSTMP	☐	/SPE/DE_ATP_TIMESTAMP	TZNTSTMPS	DEC	15	0	ATP Time Stamp
129	SPE_GEOROUTE	☐	/SPE/DE_ROUTE_ID	CHAR10	CHAR	10	0	Description of a Geographical Route
130	SPE_GTS_REL	☐	/SPE/DE_LEG_GTS_CODE	CHAR2	CHAR	2	0	Goods Traffic Type
131	SPE_GTS_RT_CDE	☐	/SPE/DE_ROUTE_GTS_CODE	CHAR10	CHAR	10	0	Route Code for SAP Global Trade Services
132	SPE_CURRENCY	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
133	SPE_LE_SCENARIO	☐	/SPE/LE_SCENARIO	/SPE/LE_SCENARIO	CHAR	1	0	Scenario Logistic Execution
134	.INCLU--AP	☐				0	0	Relocation: Display VL10
135	.INCLUDE	☐				0	0	Relocation: Display VL10
136	RELOC_DESC	☐	/ISDFPS/RELOC_DESC	CHAR40_LOW	CHAR	40	0	Relocation Description
137	RELOC_SEQ_DESC	☐	/ISDFPS/RELOC_SEQ_DESC	CHAR40_LOW	CHAR	40	0	Relocation Step

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SHP_VL10_ITEM	AUART	TVAK	AUART	REF	1	CN
2	SHP_VL10_ITEM	GEWEI	T006	MSEHI	REF	C	CN
3	SHP_VL10_ITEM	KUNNR	KNA1	KUNNR	REF	1	CN
4	SHP_VL10_ITEM	KUNWE	KNA1	KUNNR	KEY	1	CN
5	SHP_VL10_ITEM	LIFSP	TVLS	LIFSP	KEY	1	CN
6	SHP_VL10_ITEM	LPRIO	TPRIO	LPRIO	KEY	1	CN
7	SHP_VL10_ITEM	MANDT	T000	MANDT	KEY	1	CN
8	SHP_VL10_ITEM	ROUTE	TVRO	ROUTE	KEY	1	CN
9	SHP_VL10_ITEM	SPART	TSPA	SPART	REF	1	CN
10	SHP_VL10_ITEM	SPDNR	LFA1	LIFNR	KEY	1	CN
11	SHP_VL10_ITEM	VBELN	VBUK	VBELN	KEY	1	CN
12	SHP_VL10_ITEM	VKBUR	TVBUR	VKBUR	REF	C	CN
13	SHP_VL10_ITEM	VKGRP	TVKGR	VKGRP	REF	C	CN
14	SHP_VL10_ITEM	VKORG	TVKO	VKORG	REF	1	CN
15	SHP_VL10_ITEM	VOLEH	T006	MSEHI	REF	C	CN
16	SHP_VL10_ITEM	VSTEL	TVST	VSTEL	KEY	1	CN
17	SHP_VL10_ITEM	VTWEG	TVTW	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in