SAP ABAP View V_OI0BW_OIGSVD (View for BW Extractor OI0BW_TD_OIGSVD)

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_OIGSVD
Short Description	View for BW Extractor OI0BW_TD_OIGSVD
Root table	OIGS	TD Shipment Header

Table

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

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	CLIENT	JL	EQ				0	0
4	OIGSVD	CLIENT	JR	EQ			AND	0	0
5	OIGSV	CLIENT	JL	EQ				0	0
6	OIGSVD	CLIENT	JR	EQ			AND	0	0
7	OIGS	SHNUMBER	JL	EQ				0	0
8	OIGSV	SHNUMBER	JR	EQ			AND	0	0
9	OIGS	SHNUMBER	JL	EQ				0	0
10	OIGSVD	SHNUMBER	JR	EQ			AND	0	0
11	OIGSV	SHNUMBER	JL	EQ				0	0
12	OIGSVD	SHNUMBER	JR	EQ			AND	0	0
13	OIGSV	VEH_NR	JL	EQ				0	0
14	OIGSVD	VEH_NR	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	DRIVERCODE	OIGSVD	DRIVERCODE		☐	OIG_DRVNMR	☐	TD driver number
5	SHTYPE	OIGS	SHTYPE		☐	OIG_TDSTYP	☐	TD shipment type
6	XBLNR	OIGS	XBLNR		☐	XBLNR1	☐	Reference Document Number
7	VEH_MODE	OIGS	VEH_MODE		☐	OIG_VMOT	☐	TD vehicle mode of transport
8	FKART	OIGS	FKART		☐	FKART_T	☐	Shipment cost type
9	TPLST	OIGS	TPLST		☐	TPLST	☐	Transportation planning point
10	CRE_NAME	OIGS	CRE_NAME		☐	ERNAM	☐	Name of Person who Created the Object
11	CRE_DATE	OIGS	CRE_DATE		☐	ERDAT	☐	Date on which the record was created
12	CRE_TIME	OIGS	CRE_TIME		☐	ERZET	☐	Entry time
13	CHA_NAME	OIGS	CHA_NAME		☐	AENAM	☐	Name of Person Who Changed Object
14	CHA_DATE	OIGS	CHA_DATE		☐	AEDAT	☐	Last Changed On
15	CHA_TIME	OIGS	CHA_TIME		☐	AEZET	☐	Time last change was made
16	OIG_SSTSF	OIGS	OIG_SSTSF		☐	OIG_SSTSF	☐	TD Shipment Status (Functional)
17	LOAD_STDTA	OIGS	LOAD_STDTA		☐	OIG_LDSTDA	☐	Date for start of loading
18	LOAD_STTMA	OIGS	LOAD_STTMA		☐	OIG_LDSTTA	☐	Actual time for start of loading
19	LOAD_EDDTA	OIGS	LOAD_EDDTA		☐	OIG_LDEDDA	☐	Actual date for end of loading
20	LOAD_EDTMA	OIGS	LOAD_EDTMA		☐	OIG_LDEDTA	☐	Actual time for end of loading
21	DEL_STDTA	OIGS	DEL_STDTA		☐	OIG_DESTDA	☐	Actual date for start of delivery confirmation
22	DEL_STTMA	OIGS	DEL_STTMA		☐	OIG_DESTTA	☐	Actual time for start of delivery confirmation
23	DEL_EDDTA	OIGS	DEL_EDDTA		☐	OIG_DEEDDA	☐	Actual date for end of delivery confirm
24	DEL_EDTMA	OIGS	DEL_EDTMA		☐	OIG_DEEDTA	☐	Actual time for end of delivery confirmation
25	FBGST	OIGS	FBGST		☐	FBGST	☐	Overall status of calculation of shipment costs for shipment
26	ARGST	OIGS	ARGST		☐	ARGST	☐	Total status of shipment costs settlement for shipment
27	VEHICLE	OIGSV	VEHICLE		☐	OIG_VHLNMR	☐	TD Vehicle Number

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