SAP ABAP View V_OIGSDOCS (TD View (Del.& Sh.Not.) for Document Selection Report)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIG (Package) TD Transport and Distribution

Basic Data

View Type	D	Database View
Database View	V_OIGSDOCS
Short Description	TD View (Del.& Sh.Not.) for Document Selection Report
Root table	LIKP	SD Document: Delivery Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LIKP	LIKP
2	VBUK
3	LIPS

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	LIKP	MANDT		☐	MANDT	☐	Client
2	VBELN	LIKP	VBELN		☐	VBELN_VL	☐	Delivery
3	POSNR	LIPS	POSNR		☐	POSNR_VL	☐	Delivery Item
4	ERNAM	LIKP	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
5	ERZET	LIKP	ERZET		☐	ERZET	☐	Entry time
6	ERDAT	LIKP	ERDAT		☐	ERDAT	☐	Date on which the record was created
7	BZIRK	LIKP	BZIRK		☐	BZIRK	☐	Sales district
8	VSTEL	LIKP	VSTEL		☐	VSTEL	☐	Shipping Point/Receiving Point
9	VKORG	LIKP	VKORG		☐	VKORG	☐	Sales Organization
10	LFART	LIKP	LFART		☐	LFART	☐	Delivery Type
11	AUTLF	LIKP	AUTLF		☐	AUTLF	☐	Complete delivery defined for each sales order?
12	KZAZU	LIKP	KZAZU		☐	KZAZU_D	☐	Order combination indicator
13	WADAT	LIKP	WADAT		☐	WADAK	☐	Planned goods movement date
14	LDDAT	LIKP	LDDAT		☐	LDDAT	☐	Loading Date
15	TDDAT	LIKP	TDDAT		☐	TDDAT_D	☐	Transportation Planning Date
16	LFDAT	LIKP	LFDAT		☐	LFDAT_V	☐	Delivery Date
17	KODAT	LIKP	KODAT		☐	KODAT	☐	Picking Date
18	ABLAD	LIKP	ABLAD		☐	ABLAD	☐	Unloading Point
19	INCO1	LIKP	INCO1		☐	INCO1	☐	Incoterms (part 1)
20	INCO2	LIKP	INCO2		☐	INCO2	☐	Incoterms (part 2)
21	EXPKZ	LIKP	EXPKZ		☐	EXPKZ	☐	Export indicator
22	ROUTE	LIKP	ROUTE		☐	ROUTE	☐	Route
23	FAKSK	LIKP	FAKSK		☐	FAKSK	☐	Billing block in SD document
24	LIFSK	LIKP	LIFSK		☐	LIFSK	☐	Delivery block (document header)
25	VBTYP	LIKP	VBTYP		☐	VBTYP	☐	SD document category
26	KNFAK	LIKP	KNFAK		☐	KNFAK	☐	Customer factory calendar
27	TPQUA	LIKP	TPQUA		☐	TPQUA	☐	not currently in use
28	TPGRP	LIKP	TPGRP		☐	TPGRP	☐	not currently in use
29	LPRIO	LIKP	LPRIO		☐	LPRIO	☐	Delivery priority
30	VSBED	LIKP	VSBED		☐	VSBED	☐	Shipping conditions
31	KUNNR	LIKP	KUNNR		☐	KUNWE	☐	Ship-to party
32	KUNAG	LIKP	KUNAG		☐	KUNAG	☐	Sold-to party
33	KDGRP	LIKP	KDGRP		☐	KDGRP	☐	Customer group
34	STZKL	LIKP	STZKL		☐	STZKL	☐	Not Currently in Use
35	STZZU	LIKP	STZZU		☐	STZZU	☐	not currently in use
36	BTGEW	LIKP	BTGEW		☐	GSGEW	☐	Total Weight
37	NTGEW	LIKP	NTGEW		☐	NTGEW_15	☐	Net weight
38	GEWEI	LIKP	GEWEI		☐	GEWEI	☐	Weight Unit
39	VOLUM	LIKP	VOLUM		☐	VOLUM_15	☐	Volume
40	VOLEH	LIKP	VOLEH		☐	VOLEH	☐	Volume unit
41	ANZPK	LIKP	ANZPK		☐	ANZPK	☐	Total number of packages in delivery
42	BEROT	LIKP	BEROT		☐	BEROT	☐	Picked items location
43	LFUHR	LIKP	LFUHR		☐	LFUHR	☐	Time of delivery
44	GRULG	LIKP	GRULG		☐	GRULG	☐	Weight group for delivery (To group)
45	LSTEL	LIKP	LSTEL		☐	LSTEL	☐	Loading Point
46	TRAGR	LIKP	TRAGR		☐	TRAGR	☐	Transportation Group
47	FKARV	LIKP	FKARV		☐	FKARV	☐	Proposed billing type for a delivery-related billing doc.
48	FKDAT	LIKP	FKDAT		☐	FKDAT	☐	Billing date for billing index and printout
49	PERFK	LIKP	PERFK		☐	PERFK	☐	Invoice dates (calendar identification)
50	ROUTA	LIKP	ROUTA		☐	ROUTE	☐	Route
51	STAFO	LIKP	STAFO		☐	STAFO	☐	Update group for statistics update
52	KALSM	LIKP	KALSM		☐	KALSM_D	☐	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
53	KNUMV	LIKP	KNUMV		☐	KNUMV	☐	Number of the document condition
54	WAERK	LIKP	WAERK		☐	WAERK	☐	SD document currency
55	VKBUR	LIKP	VKBUR		☐	VKBUR	☐	Sales office
56	VBEAK	LIKP	VBEAK		☐	VBEAK	☐	Shipping processing time for the entire document
57	ZUKRL	LIKP	ZUKRL		☐	DZUKRL	☐	Combination criteria for delivery
58	VERUR	LIKP	VERUR		☐	VERUR_VL	☐	Distribution delivery
59	COMMN	LIKP	COMMN		☐	COMMN	☐	Communication number for Q-API interface
60	STWAE	LIKP	STWAE		☐	STWAE	☐	Statistics currency
61	STCUR	LIKP	STCUR		☐	STCUR	☐	Exchange rate for statistics
62	EXNUM	LIKP	EXNUM		☐	EXNUM	☐	Number of foreign trade data in MM and SD documents
63	AEDAT	LIKP	AEDAT		☐	AEDAT	☐	Last Changed On
64	LGNUM	LIKP	LGNUM		☐	LGNUM	☐	Warehouse Number / Warehouse Complex
65	VKOIV	LIKP	VKOIV		☐	VKOIV	☐	Sales organization for intercompany billing
66	VTWIV	LIKP	VTWIV		☐	VTWIV	☐	Distribution channel for intercompany billing
67	SPAIV	LIKP	SPAIV		☐	SPAIV	☐	Division for intercompany billing
68	FKAIV	LIKP	FKAIV		☐	FKAIV	☐	Billing type for intercompany billing
69	PIOIV	LIKP	PIOIV		☐	PIOIV	☐	Date for intercompany billing
70	FKDIV	LIKP	FKDIV		☐	FKDIV	☐	Billing date for intercompany billing
71	KUNIV	LIKP	KUNIV		☐	KUNIV	☐	Customer number for intercompany billing
72	KKBER	LIKP	KKBER		☐	KKBER	☐	Credit control area
73	KNKLI	LIKP	KNKLI		☐	KNKLI	☐	Customer's account number with credit limit reference
74	GRUPP	LIKP	GRUPP		☐	GRUPP_CM	☐	Customer credit group
75	SBGRP	LIKP	SBGRP		☐	SBGRP_CM	☐	Credit Representative Group for Credit Management
76	CTLPC	LIKP	CTLPC		☐	CTLPC_CM	☐	Credit management: Risk category
77	CMWAE	LIKP	CMWAE		☐	WAERS_CM	☐	Currency key of credit control area
78	AMTBL	LIKP	AMTBL		☐	AMTBL_CM	☐	Released credit value of the document
79	BOLNR	LIKP	BOLNR		☐	BOLNR	☐	Bill of lading
80	LIFNR	LIKP	LIFNR		☐	ELIFN	☐	Vendor's account number
81	TRATY	LIKP	TRATY		☐	TRATY	☐	Means-of-Transport Type
82	TRAID	LIKP	TRAID		☐	TRAID	☐	Means-of-transport ID
83	CMFRE	LIKP	CMFRE		☐	CMFRE	☐	Release date of the document determined by credit management
84	CMNGV	LIKP	CMNGV		☐	CMNGV	☐	Next date
85	XABLN	LIKP	XABLN		☐	XABLN	☐	Goods receipt/issue slip number
86	WADAT_IST	LIKP	WADAT_IST		☐	WADAT_IST	☐	Actual Goods Movement Date
87	TRSPG	LIKP	TRSPG		☐	TRSPG	☐	Shipment Blocking Reason
88	TPSID	LIKP	TPSID		☐	TPSID	☐	ID for external transport system
89	LIFEX	LIKP	LIFEX		☐	LIFEX	☐	External Identification of Delivery Note
90	TERNR	LIKP	TERNR		☐	AUFNR	☐	Order Number
91	KALSM_CH	LIKP	KALSM_CH		☐	KALSMA_CH	☐	Search procedure for batch determination
92	KLIEF	LIKP	KLIEF		☐	KLIEF	☐	Correction delivery
93	KALSP	LIKP	KALSP		☐	KALSP	☐	Shipping: Pricing procedure
94	KNUMP	LIKP	KNUMP		☐	KNUMP	☐	Number of document condition - pricing
95	AULWE	LIKP	AULWE		☐	AULWE	☐	Route Schedule
96	WERKS	LIKP	WERKS		☐	EMPFW	☐	Receiving plant for deliveries
97	KOQUK	VBUK	KOQUK		☐	KOQUK	☐	Status of pick confirmation
98	WBSTK	VBUK	WBSTK		☐	WBSTK	☐	Total goods movement status
99	PKSTK	VBUK	PKSTK		☐	PKSTK	☐	Overall packing status of all items
100	TRSTA	VBUK	TRSTA		☐	TRSTA	☐	Transportation planning status
101	IMEINS	LIPS	MEINS		☐	MEINS	☐	Base Unit of Measure
102	ICHARG	LIPS	CHARG		☐	CHARG_D	☐	Batch Number
103	IMATNR	LIPS	MATNR		☐	MATNR	☐	Material Number
104	IVBELV	LIPS	VBELV		☐	VBELV	☐	Originating document
105	IBWTAR	LIPS	BWTAR		☐	BWTAR_D	☐	Valuation type
106	IWERKS	LIPS	WERKS		☐	WERKS_D	☐	Plant
107	ILGMNG	LIPS	LGMNG		☐	LGMNG	☐	Actual quantity delivered in stockkeeping units
108	ILFIMG	LIPS	LFIMG		☐	LFIMG	☐	Actual quantity delivered (in sales units)
109	IVRKME	LIPS	VRKME		☐	VRKME	☐	Sales unit
110	ILGORT	LIPS	LGORT		☐	LGORT_D	☐	Storage location
111	IBRGEW	LIPS	BRGEW		☐	BRGEW_15	☐	Gross weight
112	INTGEW	LIPS	NTGEW		☐	NTGEW_15	☐	Net weight
113	ILADGR	LIPS	LADGR		☐	LADGR	☐	Loading Group
114	ITRAGR	LIPS	TRAGR		☐	TRAGR	☐	Transportation Group
115	IGEWEI	LIPS	GEWEI		☐	GEWEI	☐	Weight Unit
116	IVOLUM	LIPS	VOLUM		☐	VOLUM_15	☐	Volume
117	IVOLEH	LIPS	VOLEH		☐	VOLEH	☐	Volume unit
118	IVGBEL	LIPS	VGBEL		☐	VGBEL	☐	Document number of the reference document
119	IVGPOS	LIPS	VGPOS		☐	VGPOS	☐	Item number of the reference item
120	IVGTYP	LIPS	VGTYP		☐	VBTYP	☐	SD document category

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