SAP ABAP View V_OIJPLSEL (OIL-TSW: SPW planning location view)

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_OIJPLSEL
Short Description	OIL-TSW: SPW planning location view
Root table	OIJTS	Transport system (IS-Oil TSW standard/core object )

Table

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

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	OIJTS	MANDT		☐	MANDT	☐	Client
2	TSYST	OIJTS	TSYST		☐	OIJ_TSYST	☐	Transport system
3	LOCID	OIJTSLOC	LOCID		☐	OIJ_LOCID	☐	Location ID
4	PMATNR	OIJTSMAT	PMATNR		☐	MATNR	☐	Material Number
5	LOCTYP	OIFSPBL	PBLTYP		☐	OIF_PBLTYP	☐	Business Location Type (IS-Oil MRN)
6	VKTRA	OIJTS	VKTRA		☐	VKTRA	☐	Mode of transport
7	TSSUOMV	OIJTS	TSSUOMV		☐	OIJ_TSUOMV	☐	TS standard volume UoM
8	TSSUOMM	OIJTS	TSSUOMM		☐	OIJ_TSUOMM	☐	TS standard weight UoM
9	CYCPERD	OIJTS	CYCPERD		☐	OIJ_CYCDUR	☐	TS cycle duration
10	CYCPUOM	OIJTS	CYCPUOM		☐	OIJ_CYDUOM	☐	TS cycle duration UoM
11	TSWERK	OIJTS	WERK		☐	OIJ_WERK	☐	Transport system In-transit Plant
12	TSLGORT	OIJTS	LGORT		☐	OIJ_LGORT	☐	Transport system In-transit Storage Location
13	RDUOM	OIJTSMAT	RDUOM		☐	OIJ_RDUOM	☐	Stock Projection unit of measure (UoM)
14	RDCONV	OIJTSMAT	RDCONV		☐	OIJ_RDCONV	☐	OIL-TSW: Stock Projection conversion factor
15	PERIOD	OIJTSMAT	PERIOD		☐	OIJ_PERIOD	☐	OIL-TSW: Rolling period
16	PAST	OIJTSMAT	PAST		☐	OIJ_PAST	☐	OIL-TSW: Number of days in the past
17	TTOLPCT	OIJTSMAT	TOLPCT		☐	OIJ_BUTOL	☐	Quantity tolerance under (%)
18	TTOLABS	OIJTSMAT	TOLABS		☐	OIJ_TOLABS	☐	Absolute tolerance qty under
19	TMAXLOT	OIJTSMAT	MAXLOT		☐	OIJ_MAXLOT	☐	OIL-TSW: Planning maximum batch (lot) size
20	TMINLOT	OIJTSMAT	MINLOT		☐	OIJ_MINLOT	☐	OIL-TSW: Planning minimum batch (lot) size
21	TINCLOT	OIJTSMAT	INCLOT		☐	OIJ_INCLOT	☐	OIL-TSW: Planning incremental batch (lot) size - rounding
22	TMAXINV	OIJTSMAT	MAXINV		☐	OIJ_MAXINV	☐	OIL-TSW: Planning maximum inventory level
23	TTARGET	OIJTSMAT	TARGET		☐	OIJ_TGTINV	☐	OIL-TSW: Planning target inventory level
24	TREORDER	OIJTSMAT	REORDER		☐	OIJ_REORD	☐	OIL-TSW: Planning reorder point inventory level
25	TMININV	OIJTSMAT	MININV		☐	OIJ_MININV	☐	OIL-TSW: Planning minimum inventory level
26	PLANIND	OIFSPBLT	PLANIND		☐	OIJ_PLANIN	☐	Planning location flag
27	REFIND	OIFSPBLT	REFIND		☐	OIJ_REFIND	☐	OIL-TSW: Refinery indicator
28	ODINDO	OIFSPBLT	ODINDO		☐	OIJ_ODINDO	☐	OIL-TSW: Location is origin flag
29	ODINDD	OIFSPBLT	ODINDD		☐	OIJ_ODINDD	☐	OIL-TSW: Location destination flag
30	ODINDO_T	OIJTSLOC	ODINDO		☐	OIJ_ODINDO	☐	OIL-TSW: Location is origin flag
31	ODINDD_T	OIJTSLOC	ODINDD		☐	OIJ_ODINDD	☐	OIL-TSW: Location destination flag
32	PLANLOC	OIJPLANLOC	PLANLOC		☐	OIJ_PLANLO	☐	OIL-TSW: Planning location
33	RDACT	OIJLOC	RDACT		☐	OIJ_RDACT	☐	Stock Projection activation indicator

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