SAP ABAP View V_EWM_LIPSPOD (View: Join LIPS Keys and Proof of Delivery)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ LVS (Package) Application development Warehouse Management (WM)

Basic Data

View Type	D	Database View
Database View	V_EWM_LIPSPOD
Short Description	View: Join LIPS Keys and Proof of Delivery
Root table	LIPS	SD document: Delivery: Item data

Table

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

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	TVPOD	MANDT	JR	EQ			AND	0	0
3	LIPS	HANDLE	JL	EQ				0	0
4	TVPOD	HANDLE_LIPS	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	HANDLE_LIPS	LIPS	HANDLE		☐	TSEGGUID_LIPS	☐	Worldwide unique key for LIPS-VBELN & LIPS_POSNR
5	GRUND	TVPOD	GRUND		☐	REACD	☐	Reason for variance in POD
6	LFIMG_DIFF	TVPOD	LFIMG_DIFF		☐	LFIMG_DIFF	☐	Deviation in quantity actually delivered in sales unit
7	VRKME	LIPS	VRKME		☐	VRKME	☐	Sales unit
8	LGMNG_DIFF	TVPOD	LGMNG_DIFF		☐	LGMNG_DIFF	☐	Difference in actual delivery quantity in stockkeeping unit
9	MEINS	LIPS	MEINS		☐	MEINS	☐	Base Unit of Measure
10	PODAT	TVPOD	PODAT		☐	PODAT	☐	Date (proof of delivery)
11	POTIM	TVPOD	POTIM		☐	POTIM	☐	Confirmation time
12	CALCU	TVPOD	CALCU		☐	CALCU	☐	Quantity calculation for POD

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	606