SAP ABAP View V_OI0BW_OIGSPA (View for BW Extractor OI0BW_TD_OIGSPA)

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

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	OIGS	SHNUMBER	JL	EQ				0	0
2	OIGSPA	VBELN	JR	EQ			AND	0	0
3	OIGS	CLIENT	JL	EQ				0	0
4	OIGSPA	MANDT	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	POSNR	OIGSPA	POSNR		☐	POSNR	☐	Item number of the SD document
4	PARVW	OIGSPA	PARVW		☐	PARVW	☐	Partner Role
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	FRKRL	OIGS	FRKRL		☐	FRKRL_KOP	☐	Proposal freight costs relevance, Shipment header
10	FRKRL_STR	OIGS	FRKRL_STR		☐	FRKRL_STR	☐	Proposal freight costs relevance, shipment leg
11	FRKRL_UMP	OIGS	FRKRL_UMP		☐	FRKRL_UMP	☐	Proposal for shipment costs relevance - Load transfer point
12	FRKRL_GRP	OIGS	FRKRL_GRP		☐	FRKRL_GRP	☐	Proposal for freight costs relevance, Border cross.pt
13	FRKRL_VEH	OIGS	FRKRL_VEH		☐	OIG_FRKRLV	☐	TD - shipment cost relevance for vehicles
14	SCLDTYPE	OIGS	SCLDTYPE		☐	OIG_STYPE	☐	TD-F -Shipment costing based on loaded or disch. quantitites
15	TPLST	OIGS	TPLST		☐	TPLST	☐	Transportation planning point
16	CRE_NAME	OIGS	CRE_NAME		☐	ERNAM	☐	Name of Person who Created the Object
17	CRE_DATE	OIGS	CRE_DATE		☐	ERDAT	☐	Date on which the record was created
18	CRE_TIME	OIGS	CRE_TIME		☐	ERZET	☐	Entry time
19	CHA_NAME	OIGS	CHA_NAME		☐	AENAM	☐	Name of Person Who Changed Object
20	CHA_DATE	OIGS	CHA_DATE		☐	AEDAT	☐	Last Changed On
21	CHA_TIME	OIGS	CHA_TIME		☐	AEZET	☐	Time last change was made
22	OIG_SSTSF	OIGS	OIG_SSTSF		☐	OIG_SSTSF	☐	TD Shipment Status (Functional)
23	LOAD_STDTA	OIGS	LOAD_STDTA		☐	OIG_LDSTDA	☐	Date for start of loading
24	LOAD_STTMA	OIGS	LOAD_STTMA		☐	OIG_LDSTTA	☐	Actual time for start of loading
25	LOAD_EDDTA	OIGS	LOAD_EDDTA		☐	OIG_LDEDDA	☐	Actual date for end of loading
26	LOAD_EDTMA	OIGS	LOAD_EDTMA		☐	OIG_LDEDTA	☐	Actual time for end of loading
27	DEL_STDTA	OIGS	DEL_STDTA		☐	OIG_DESTDA	☐	Actual date for start of delivery confirmation
28	DEL_STTMA	OIGS	DEL_STTMA		☐	OIG_DESTTA	☐	Actual time for start of delivery confirmation
29	DEL_EDDTA	OIGS	DEL_EDDTA		☐	OIG_DEEDDA	☐	Actual date for end of delivery confirm
30	DEL_EDTMA	OIGS	DEL_EDTMA		☐	OIG_DEEDTA	☐	Actual time for end of delivery confirmation
31	FBGST	OIGS	FBGST		☐	FBGST	☐	Overall status of calculation of shipment costs for shipment
32	ARGST	OIGS	ARGST		☐	ARGST	☐	Total status of shipment costs settlement for shipment
33	LIFNR	OIGSPA	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
34	PERNR	OIGSPA	PERNR		☐	PERNR_D	☐	Personnel Number
35	PARNR	OIGSPA	PARNR		☐	PARNR	☐	Number of contact person
36	ADRNR	OIGSPA	ADRNR		☐	ADRNR	☐	Address

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