SAP ABAP Table LIEFERUNGEN (Deliveries for Picking Waves for ALV / VL35)

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	LIEFERUNGEN	Table Relationship Diagram
Short Description	Deliveries for Picking Waves for ALV / VL35

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	SAMMG	☐	KWELVPLUS	KWELVPLUS	CHAR	10	0	Picking wave number
2	SHIPNO	☐	SHIPNO	TKNUM	CHAR	10	0	Shipment number	*
3	.INCLUDE	☐				0	0	W&S: Picking Waves
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	SSOUR	☐	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
6	VRSIO	☐	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
7	SPMON	☐	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
8	SPTAG	☐	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
9	SPWOC	☐	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
10	SPBUP	☐	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
11	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
12	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
13	PLGTYP	☐	MCL_PLGTYP	LGTYP	CHAR	3	0	Planned picking storage type	T301
14	PKOBER	☐	MCL_PKOBER	KOBER	CHAR	3	0	Planned picking area	T30A
15	METYP	☐	METYP	MEITY	CHAR	1	0	Unit-of-measure load category according to workload criteria	TMET
16	VHART	☐	MCL_VHARTL	TRATY	CHAR	4	0	Packaging Material Type Rough Workload Estimate	TVTY
17	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
18	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
19	GEWEH	☐	MCL_GEWEH	MEINS	UNIT	3	0	Weight unit: Rough Workload Estimate and picking waves	T006
20	VOLEH	☐	MCL_VOLEH	MEINS	UNIT	3	0	Volume unit: Rough Workload Estimate and picking waves	T006
21	METYP_E	☐	MCL_METYPE	DEC15_3	DEC	15	3	Quantity for unit-of-measure load category +
22	METYP_R	☐	MCL_METYPR	DEC15_3	DEC	15	3	Quantity for UoM handling group
23	METYP_D	☐	MCL_METYPD	DEC15_3	DEC	15	3	Quantity for unit-of-measure load category
24	MEGEW_E	☐	MCL_MEGEWE	MENG8	QUAN	15	3	Weight for quantity +
25	MEGEW_R	☐	MCL_MEGEWR	MENG8	QUAN	15	3	Weight for quantity -
26	MEGEW_D	☐	MCL_MEGEWD	MENG8	QUAN	15	3	Weight for quantity
27	MEVOL_E	☐	MCL_MEVOLE	MENG8	QUAN	15	3	Volume for quantity +
28	MEVOL_R	☐	MCL_MEVOLR	MENG8	QUAN	15	3	Volume for quantity -
29	MEVOL_D	☐	MCL_MEVOLD	MENG8	QUAN	15	3	Volume for quantity
30	BZEIT_E	☐	MCL_BZEITE	DEC17_5	DEC	17	5	Processing time+ for quantity in hours
31	BZEIT_R	☐	MCL_BZEITR	DEC17_5	DEC	17	5	Processing time- for quantity in hours
32	BZEIT_D	☐	MCL_BZEITD	DEC17_5	DEC	17	5	Processing time for quantity in hours
33	VHART_E	☐	MCL_VHARTE	DEC15_3	DEC	15	3	Packaging Materials for Packaging Material Type +
34	VHART_R	☐	MCL_VHARTR	DEC15_3	DEC	15	3	Packaging Materials for Packaging Material Type
35	VHART_D	☐	MCL_VHARTD	DEC15_3	DEC	15	3	Packaging Materials for Packaging Material Type
36	ANZBP_E	☐	MCL_ANZBPE	MCZAEHLINT	INT4	10	0	Number of document items/schedule lines +
37	ANZBP_R	☐	MCL_ANZBPR	MCZAEHLINT	INT4	10	0	Number of document items/schedule lines -
38	ANZBP_D	☐	MCL_ANZBPD	MCZAEHLINT	INT4	10	0	Number of document items/schedule lines
39	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
40	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
41	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
42	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
43	AULWE	☐	AULWE	AULWE	CHAR	10	0	Route Schedule	VALW
44	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
45	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
46	LFART	☐	LFART	LFART	CHAR	4	0	Delivery Type	TVLK
47	PSPDNR	☐	SPDNR	LIFNR	CHAR	10	0	Carrier	LFA1
48	PKUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
49	PKUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
50	VGLZT	☐	MCL_VGLZT	UZEIT	TIMS	6	0	Comparison time for forming waves
51	COULEUR	☐	COULEUR	COULEUR	CHAR	3	0	Color for VL35 / ALV
52	CHBOX_SPEZ	☐	CHBOX_SPEZ	XFELD	CHAR	1	0	Delivery selected for saving
53	ICON_SPEZ	☐	ICON_34	ICON_34	CHAR	34	0	Temporary delivery status for picking waves with quick info
54	EINSCHUB	☐	EINSCHUB	EINSCHUB	CHAR	1	0	Insert for ALV/VL35
55	SORT_FELD	☐	CUSTSORT	CUSTSORT	NUMC	4	0	Sort field for deliveries for forming picking waves
56	SHP_ODD	☐			CHAR	1	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LIEFERUNGEN	AULWE	VALW	AULWE	REF	1	CN
2	LIEFERUNGEN	GEWEH	T006	MSEHI	KEY	1	C
3	LIEFERUNGEN	LFART	TVLK	LFART
4	LIEFERUNGEN	LGNUM	T300	LGNUM
5	LIEFERUNGEN	LPRIO	TPRIO	LPRIO
6	LIEFERUNGEN	MANDT	T000	MANDT
7	LIEFERUNGEN	METYP	TMET	METYP	KEY	1	CN
8	LIEFERUNGEN	PKOBER	T30A	KOBER
9	LIEFERUNGEN	PKUNAG	KNA1	KUNNR
10	LIEFERUNGEN	PKUNWE	KNA1	KUNNR
11	LIEFERUNGEN	PLGTYP	T301	LGTYP
12	LIEFERUNGEN	PSPDNR	LFA1	LIFNR
13	LIEFERUNGEN	ROUTE	TVRO	ROUTE
14	LIEFERUNGEN	VBELN	VBUK	VBELN
15	LIEFERUNGEN	VHART	TVTY	TRATY
16	LIEFERUNGEN	VKORG	TVKO	VKORG
17	LIEFERUNGEN	VOLEH	T006	MSEHI	KEY	1	C
18	LIEFERUNGEN	VSBED	TVSB	VSBED
19	LIEFERUNGEN	VSTEL	TVST	VSTEL

History

Last changed by/on	SAP	20050411
SAP Release Created in