SAP ABAP View LIPSUP (Delivery Item Data and Status)

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

View Type	D	Database View
Database View	LIPSUP
Short Description	Delivery Item Data and Status
Root table	LIPS	SD document: Delivery: Item data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LIPS	LIPS
2	VBUP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	LIPS	MANDT	JL	EQ				0	0
2	VBUP	MANDT	JR	EQ			AND	0	0
3	LIPS	VBELN	JL	EQ				0	0
4	VBUP	VBELN	JR	EQ			AND	0	0
5	LIPS	POSNR	JL	EQ				0	0
6	VBUP	POSNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	LIPS	MANDT		☐	MANDT	☐	Client
2	VBELN	LIPS	VBELN		☐	VBELN_VL	☐	Delivery
3	POSNR	LIPS	POSNR		☐	POSNR_VL	☐	Delivery Item
4	PSTYV	LIPS	PSTYV		☐	PSTYV_VL	☐	Delivery item category
5	ERNAM	LIPS	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
6	ERZET	LIPS	ERZET		☐	ERZET	☐	Entry time
7	ERDAT	LIPS	ERDAT		☐	ERDAT	☐	Date on which the record was created
8	MATNR	LIPS	MATNR		☐	MATNR	☐	Material Number
9	WERKS	LIPS	WERKS		☐	WERKS_D	☐	Plant
10	LGORT	LIPS	LGORT		☐	LGORT_D	☐	Storage location
11	CHARG	LIPS	CHARG		☐	CHARG_D	☐	Batch Number
12	LFIMG	LIPS	LFIMG		☐	LFIMG	☐	Actual quantity delivered (in sales units)
13	MEINS	LIPS	MEINS		☐	MEINS	☐	Base Unit of Measure
14	VRKME	LIPS	VRKME		☐	VRKME	☐	Sales unit
15	NTGEW	LIPS	NTGEW		☐	NTGEW_15	☐	Net weight
16	BRGEW	LIPS	BRGEW		☐	BRGEW_15	☐	Gross weight
17	GEWEI	LIPS	GEWEI		☐	GEWEI	☐	Weight Unit
18	VOLUM	LIPS	VOLUM		☐	VOLUM_15	☐	Volume
19	VOLEH	LIPS	VOLEH		☐	VOLEH	☐	Volume unit
20	KZTLF	LIPS	KZTLF		☐	KZTLF	☐	Partial delivery at item level
21	UEBTO	LIPS	UEBTO		☐	UEBTO	☐	Overdelivery Tolerance Limit
22	UNTTO	LIPS	UNTTO		☐	UNTTO	☐	Underdelivery Tolerance Limit
23	CHSPL	LIPS	CHSPL		☐	CHSPL	☐	Batch split allowed
24	MBDAT	LIPS	MBDAT		☐	MBDAT	☐	Material Staging/Availability Date
25	LGMNG	LIPS	LGMNG		☐	LGMNG	☐	Actual quantity delivered in stockkeeping units
26	ARKTX	LIPS	ARKTX		☐	ARKTX	☐	Short text for sales order item
27	VBELV	LIPS	VBELV		☐	VBELV	☐	Originating document
28	POSNV	LIPS	POSNV		☐	POSNV	☐	Originating item
29	VGBEL	LIPS	VGBEL		☐	VGBEL	☐	Document number of the reference document
30	VGPOS	LIPS	VGPOS		☐	VGPOS	☐	Item number of the reference item
31	KOMKZ	LIPS	KOMKZ		☐	KOMKZ	☐	Indicator for picking control
32	LGNUM	LIPS	LGNUM		☐	LGNUM	☐	Warehouse Number / Warehouse Complex
33	LISPL	LIPS	LISPL		☐	LNSPL_LIPS	☐	Split to warehouse number required
34	BWTEX	LIPS	BWTEX		☐	BWTEX	☐	Indicator: Separate valuation
35	BWART	LIPS	BWART		☐	BWART	☐	Movement type (inventory management)
36	XCHPF	LIPS	XCHPF		☐	XCHPF	☐	Batch management requirement indicator
37	BWTAR	LIPS	BWTAR		☐	BWTAR_D	☐	Valuation type
38	MTVFP	LIPS	MTVFP		☐	MTVFP	☐	Checking Group for Availability Check
39	GRKOR	LIPS	GRKOR		☐	GRKOR	☐	Delivery group (items are delivered together)
40	ANTLF	LIPS	ANTLF		☐	ANTLF	☐	Maximum number of partial deliveries allowed per item
41	SOBKZ	LIPS	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
42	AEDAT	LIPS	AEDAT		☐	AEDAT	☐	Last Changed On
43	VPZUO	LIPS	VPZUO		☐	VPZUO	☐	Allocation Indicator
44	VGTYP	LIPS	VGTYP		☐	VBTYP	☐	SD document category
45	BEDAR_LF	LIPS	BEDAR_LF		☐	BEDAR	☐	Requirements class
46	KCMENG	LIPS	KCMENG		☐	KCMENG	☐	Cumulative batch quantity of all split items (in StckUnit)
47	KCBRGEW	LIPS	KCBRGEW		☐	KCBRGEW	☐	Cumulative gross weight of all batch split items
48	KCVOLUM	LIPS	KCVOLUM		☐	KCVOLUM	☐	Cumulative volume of all batch split items
49	UECHA	LIPS	UECHA		☐	UECHA	☐	Higher-Level Item of Batch Split Item
50	ANZSN	LIPS	ANZSN		☐	ANZSN	☐	Number of serial numbers
51	SERAIL	LIPS	SERAIL		☐	SERAIL	☐	Serial Number Profile
52	KCGEWEI	LIPS	KCGEWEI		☐	GEWEI	☐	Weight Unit
53	KCVOLEH	LIPS	KCVOLEH		☐	VOLEH	☐	Volume unit
54	SERNR	LIPS	SERNR		☐	SERNR	☐	BOM explosion number
55	ABART	LIPS	ABART		☐	ABART	☐	Release type
56	PROSA	LIPS	PROSA		☐	PROSA	☐	ID for material selection - active
57	UEPVW	LIPS	UEPVW		☐	UEPVW	☐	ID for higher-level item usage
58	KOQUI	LIPS	KOQUI		☐	KOQUI	☐	Picking is subject to confirmation
59	PSPNR	LIPS	PSPNR		☐	PS_INTNR	☐	Current number for project or project item
60	WBSTA	VBUP	WBSTA		☐	WBSTA	☐	Goods movement status
61	GBSTA	VBUP	GBSTA		☐	GBSTA	☐	Overall Processing Status of the SD Document Item
62	KOSTA	VBUP	KOSTA		☐	KOSTA	☐	Picking Status/Putaway Status
63	LVSTA	VBUP	LVSTA		☐	LVSTA	☐	Status of warehouse management activities
64	UVALL	VBUP	UVALL		☐	UVALL_UP	☐	General Incompletion Status of the Item
65	UVVLK	VBUP	UVVLK		☐	UVVLK_UP	☐	Incompletion Status of the Item with Regard to Delivery
66	UVFAK	VBUP	UVFAK		☐	UVFAK_UP	☐	Item incompletion status with respect to billing
67	FKIVP	VBUP	FKIVP		☐	FKIVP	☐	Intercompany billing status
68	PKSTA	VBUP	PKSTA		☐	PKSTA	☐	Packing status of item
69	KOQUA	VBUP	KOQUA		☐	KOQUA	☐	Confirmation status of picking/putaway
70	UVPIK	VBUP	UVPIK		☐	UVPIP_UP	☐	Incomplete status of item for picking/putaway
71	UVPAK	VBUP	UVPAK		☐	UVPAP_UP	☐	Incomplete status of item for packaging
72	UVWAK	VBUP	UVWAK		☐	UVWAP_UP	☐	Incomplete status of item regarding goods issue

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140121
SAP Release Created in