SAP ABAP View V_OIJRDSEL1 (OIL-TSW: View for selecting RD Locations without plants)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
     ⤷ OIJ (Package) TSW Traders and Schedulers Workbench

Basic Data

View Type	D	Database View
Database View	V_OIJRDSEL1
Short Description	OIL-TSW: View for selecting RD Locations without plants
Root table	OIJLOC	Location table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	OIJLOC	OIJLOC
2	OIFSPBL
3	OIFSPBLT
4	OIJTSLOC
5	OIJTS
6	OIJTSMAT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	OIFSPBLT	MANDT	JL	EQ				0	0
2	OIFSPBL	MANDT	JR	EQ			AND	0	0
3	OIFSPBLT	PBLTYP	JL	EQ				0	0
4	OIFSPBL	PBLTYP	JR	EQ			AND	0	0
5	OIJLOC	MANDT	JL	EQ				0	0
6	OIJTSLOC	MANDT	JR	EQ			AND	0	0
7	OIJLOC	LOCID	JL	EQ				0	0
8	OIJTSLOC	LOCID	JR	EQ			AND	0	0
9	OIJTS	MANDT	JL	EQ				0	0
10	OIJTSLOC	MANDT	JR	EQ			AND	0	0
11	OIJTS	TSYST	JL	EQ				0	0
12	OIJTSLOC	TSYST	JR	EQ			AND	0	0
13	OIJTS	MANDT	JL	EQ				0	0
14	OIJTSMAT	MANDT	JR	EQ			AND	0	0
15	OIJTS	TSYST	JL	EQ				0	0
16	OIJTSMAT	TSYST	JR	EQ			AND	0	0
17	OIFSPBL	MANDT	JL	EQ				0	0
18	OIJLOC	MANDT	JR	EQ			AND	0	0
19	OIFSPBL	PBLNR	JL	EQ				0	0
20	OIJLOC	LOCID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	OIJLOC	MANDT		☐	MANDT	☐	Client
2	LOCID	OIJLOC	LOCID		☐	OIJ_LOCID	☐	Location ID
3	TSYST	OIJTSLOC	TSYST		☐	OIJ_TSYST	☐	Transport system
4	PMATNR	OIJTSMAT	PMATNR		☐	MATNR	☐	Material Number
5	PLANIND	OIFSPBLT	PLANIND		☐	OIJ_PLANIN	☐	Planning location flag
6	REFIND	OIFSPBLT	REFIND		☐	OIJ_REFIND	☐	OIL-TSW: Refinery indicator
7	ODINDO	OIFSPBLT	ODINDO		☐	OIJ_ODINDO	☐	OIL-TSW: Location is origin flag
8	ODINDD	OIFSPBLT	ODINDD		☐	OIJ_ODINDD	☐	OIL-TSW: Location destination flag
9	BOOKTS	OIJTS	BOOKTS		☐	OIJ_BOOKTS	☐	Book TS indicator
10	TSSUOMV	OIJTS	TSSUOMV		☐	OIJ_TSUOMV	☐	TS standard volume UoM
11	TSSUOMM	OIJTS	TSSUOMM		☐	OIJ_TSUOMM	☐	TS standard weight UoM
12	RDUOM	OIJTSMAT	RDUOM		☐	OIJ_RDUOM	☐	Stock Projection unit of measure (UoM)
13	RDCONV	OIJTSMAT	RDCONV		☐	OIJ_RDCONV	☐	OIL-TSW: Stock Projection conversion factor
14	PERIOD	OIJTSMAT	PERIOD		☐	OIJ_PERIOD	☐	OIL-TSW: Rolling period
15	PAST	OIJTSMAT	PAST		☐	OIJ_PAST	☐	OIL-TSW: Number of days in the past
16	RDACT	OIJLOC	RDACT		☐	OIJ_RDACT	☐	Stock Projection activation indicator
17	RDTSACT	OIJTS	RDTSACT		☐	OIJ_RDACT	☐	Stock Projection activation indicator
18	TSWERK	OIJTS	WERK		☐	OIJ_WERK	☐	Transport system In-transit Plant
19	TSLGORT	OIJTS	LGORT		☐	OIJ_LGORT	☐	Transport system In-transit Storage Location

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