SAP ABAP View V_OI0BW_OIGSV (View for BW Extractor OI0BW_TD_OIGSV)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS (Application Component) Downstream
     ⤷ OI0_BW (Package) Oil/BW Business Information Warehouse (extractors,..)

Basic Data

View Type	D	Database View
Database View	V_OI0BW_OIGSV
Short Description	View for BW Extractor OI0BW_TD_OIGSV
Root table	OIGS	TD Shipment Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	OIGS	OIGS
2	OIGSV

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	OIGS	CLIENT	JL	EQ				0	0
2	OIGSV	CLIENT	JR	EQ			AND	0	0
3	OIGS	SHNUMBER	JL	EQ				0	0
4	OIGSV	SHNUMBER	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	OIGS	CLIENT		☐	MANDT	☐	Client
2	SHNUMBER	OIGS	SHNUMBER		☐	OIG_SHNUM	☐	TD shipment number
3	VEH_NR	OIGSV	VEH_NR		☐	OIG_VEHNR	☐	Vehicle Sequence Number in Shipment
4	SHTYPE	OIGS	SHTYPE		☐	OIG_TDSTYP	☐	TD shipment type
5	XBLNR	OIGS	XBLNR		☐	XBLNR1	☐	Reference Document Number
6	VEH_MODE	OIGS	VEH_MODE		☐	OIG_VMOT	☐	TD vehicle mode of transport
7	FKART	OIGS	FKART		☐	FKART_T	☐	Shipment cost type
8	FRKRL_VEH	OIGS	FRKRL_VEH		☐	OIG_FRKRLV	☐	TD - shipment cost relevance for vehicles
9	SCLDTYPE	OIGS	SCLDTYPE		☐	OIG_STYPE	☐	TD-F -Shipment costing based on loaded or disch. quantitites
10	TPLST	OIGS	TPLST		☐	TPLST	☐	Transportation planning point
11	CRE_NAME	OIGS	CRE_NAME		☐	ERNAM	☐	Name of Person who Created the Object
12	CRE_DATE	OIGS	CRE_DATE		☐	ERDAT	☐	Date on which the record was created
13	CRE_TIME	OIGS	CRE_TIME		☐	ERZET	☐	Entry time
14	CHA_NAME	OIGS	CHA_NAME		☐	AENAM	☐	Name of Person Who Changed Object
15	CHA_DATE	OIGS	CHA_DATE		☐	AEDAT	☐	Last Changed On
16	CHA_TIME	OIGS	CHA_TIME		☐	AEZET	☐	Time last change was made
17	OIG_SSTSF	OIGS	OIG_SSTSF		☐	OIG_SSTSF	☐	TD Shipment Status (Functional)
18	LOAD_STDTA	OIGS	LOAD_STDTA		☐	OIG_LDSTDA	☐	Date for start of loading
19	LOAD_STTMA	OIGS	LOAD_STTMA		☐	OIG_LDSTTA	☐	Actual time for start of loading
20	LOAD_EDDTA	OIGS	LOAD_EDDTA		☐	OIG_LDEDDA	☐	Actual date for end of loading
21	LOAD_EDTMA	OIGS	LOAD_EDTMA		☐	OIG_LDEDTA	☐	Actual time for end of loading
22	DEL_STDTA	OIGS	DEL_STDTA		☐	OIG_DESTDA	☐	Actual date for start of delivery confirmation
23	DEL_STTMA	OIGS	DEL_STTMA		☐	OIG_DESTTA	☐	Actual time for start of delivery confirmation
24	DEL_EDDTA	OIGS	DEL_EDDTA		☐	OIG_DEEDDA	☐	Actual date for end of delivery confirm
25	DEL_EDTMA	OIGS	DEL_EDTMA		☐	OIG_DEEDTA	☐	Actual time for end of delivery confirmation
26	FBGST	OIGS	FBGST		☐	FBGST	☐	Overall status of calculation of shipment costs for shipment
27	ARGST	OIGS	ARGST		☐	ARGST	☐	Total status of shipment costs settlement for shipment
28	VEHICLE	OIGSV	VEHICLE		☐	OIG_VHLNMR	☐	TD Vehicle Number
29	COMP_GROUP	OIGSV	COMP_GROUP		☐	OIG_VEHCUSTGRP	☐	TD Vehicle Customer group
30	VEH_TYPE	OIGSV	VEH_TYPE		☐	OIG_VHLTYP	☐	TD vehicle type
31	VEH_ID	OIGSV	VEH_ID		☐	OIG_VEHID	☐	TD vehicle identifier
32	CARRIER	OIGSV	CARRIER		☐	OIG_LIFNR	☐	TD carrier (vendor account number)
33	VEH_NRTUS	OIGSV	VEH_NRTUS		☐	OIG_NMRTU	☐	Number of transport units on vehicle (TD)
34	EQUIP_NR_V	OIGSV	EQUIP_NR		☐	EQUNR	☐	Equipment Number
35	ROUTE	OIGSV	ROUTE		☐	OIG_ROUTEV	☐	TD-F vehicle route
36	LDDATE	OIGSV	LDDATE		☐	OIG_LDDATE	☐	Loading Date
37	LDTIME	OIGSV	LDTIME		☐	OIG_LDTIME	☐	Loading time
38	SHIFT	OIGSV	SHIFT		☐	OIG_SHIFT	☐	TD driver shift
39	TRIP	OIGSV	TRIP		☐	OIG_TRIP	☐	Trip Number
40	RTDATE	OIGSV	RTDATE		☐	OIG_RTDATE	☐	Date of return
41	RTTIME	OIGSV	RTTIME		☐	OIG_RTTIME	☐	Time of return
42	DDCDAT	OIGSV	DDCDAT		☐	OIG_DDCDAT	☐	Document date in delivery confirmation
43	PSTDAT	OIGSV	PSTDAT		☐	OIG_PSTDAT	☐	Posting date in delivery confirmation
44	FBGST_V	OIGSV	FBGST		☐	OIG_VFBGST	☐	Overall status of shipment costing vehicle level
45	ARGST_V	OIGSV	ARGST		☐	OIG_VARGST	☐	Overall status of shipment cost settlement vehicle level

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	20110901
SAP Release Created in