SAP ABAP View V_OIJRDSEL (OIL-TSW: SPW master data 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_OIJRDSEL
Short Description	OIL-TSW: SPW master data 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	OIJLOCMAT
5	OIJLOC

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	OIJLOCMAT	MANDT	JR	EQ			AND	0	0
3	OIJTSLOC	LOCID	JL	EQ				0	0
4	OIJLOCMAT	LOCID	JR	EQ			AND	0	0
5	OIJTSMAT	PMATNR	JL	EQ				0	0
6	OIJLOCMAT	PMATNR	JR	EQ			AND	0	0
7	OIJTS	MANDT	JL	EQ				0	0
8	OIJTSLOC	MANDT	JR	EQ			AND	0	0
9	OIJTS	TSYST	JL	EQ				0	0
10	OIJTSLOC	TSYST	JR	EQ			AND	0	0
11	OIJTS	MANDT	JL	EQ				0	0
12	OIJTSMAT	MANDT	JR	EQ			AND	0	0
13	OIJTS	TSYST	JL	EQ				0	0
14	OIJTSMAT	TSYST	JR	EQ			AND	0	0
15	OIJLOC	MANDT	JL	EQ				0	0
16	OIJTSLOC	MANDT	JR	EQ			AND	0	0
17	OIJLOC	LOCID	JL	EQ				0	0
18	OIJTSLOC	LOCID	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	ODINDO_T	OIJTSLOC	ODINDO		☐	OIJ_ODINDO	☐	OIL-TSW: Location is origin flag
6	ODINDD_T	OIJTSLOC	ODINDD		☐	OIJ_ODINDD	☐	OIL-TSW: Location destination flag
7	TRDUOM	OIJTSMAT	RDUOM		☐	OIJ_RDUOM	☐	Stock Projection unit of measure (UoM)
8	TRDCONV	OIJTSMAT	RDCONV		☐	OIJ_RDCONV	☐	OIL-TSW: Stock Projection conversion factor
9	TPERIOD	OIJTSMAT	PERIOD		☐	OIJ_PERIOD	☐	OIL-TSW: Rolling period
10	TPAST	OIJTSMAT	PAST		☐	OIJ_PAST	☐	OIL-TSW: Number of days in the past
11	TTOLPCT	OIJTSMAT	TOLPCT		☐	OIJ_BUTOL	☐	Quantity tolerance under (%)
12	TTOLABS	OIJTSMAT	TOLABS		☐	OIJ_TOLABS	☐	Absolute tolerance qty under
13	TPLTYP	OIJTSMAT	PLTYP		☐	OIJ_PLTYP	☐	OIL-TSW: Planning type
14	TCALFLG	OIJTSMAT	CALFLG		☐	OIJ_CALFLG	☐	OIL-TSW: Calendar use indicator
15	TPLCAL	OIJTSMAT	PLCAL		☐	OIJ_PLCAL	☐	Planning calendar
16	TOFFPER	OIJTSMAT	OFFPER		☐	OIJ_OFFPER	☐	OIL-TSW: Planning source offset period
17	TOFFUOM	OIJTSMAT	OFFUOM		☐	OIJ_OFFUOM	☐	OIL-TSW: Planning source offset period UoM
18	TMAXLOT	OIJTSMAT	MAXLOT		☐	OIJ_MAXLOT	☐	OIL-TSW: Planning maximum batch (lot) size
19	TMINLOT	OIJTSMAT	MINLOT		☐	OIJ_MINLOT	☐	OIL-TSW: Planning minimum batch (lot) size
20	TINCLOT	OIJTSMAT	INCLOT		☐	OIJ_INCLOT	☐	OIL-TSW: Planning incremental batch (lot) size - rounding
21	TMAXINV	OIJTSMAT	MAXINV		☐	OIJ_MAXINV	☐	OIL-TSW: Planning maximum inventory level
22	TTARGET	OIJTSMAT	TARGET		☐	OIJ_TGTINV	☐	OIL-TSW: Planning target inventory level
23	TREORDER	OIJTSMAT	REORDER		☐	OIJ_REORD	☐	OIL-TSW: Planning reorder point inventory level
24	TMININV	OIJTSMAT	MININV		☐	OIJ_MININV	☐	OIL-TSW: Planning minimum inventory level
25	LOCWERK	OIJLOCMAT	PWERK		☐	OIJ_PWERK	☐	Plant for location Stock Projection and Replenishment Planng
26	TSLOCID	OIJTSMAT	SLOCID		☐	OIJ_SLOCID	☐	OIL-TSW: Planning source location ID
27	TSAFETY	OIJTSMAT	SAFETY		☐	OIJ_SFTINV	☐	OIl-TSW: Planning safety inventory level
28	TUNPUMP	OIJTSMAT	UNPUMP		☐	OIJ_UNPUMP	☐	OIL-TSW: Unpumpable (blocked) inventory
29	RDUOM	OIJLOCMAT	RDUOM		☐	OIJ_RDUOM	☐	Stock Projection unit of measure (UoM)
30	RDCONV	OIJLOCMAT	RDCONV		☐	OIJ_RDCONV	☐	OIL-TSW: Stock Projection conversion factor
31	PERIOD	OIJLOCMAT	PERIOD		☐	OIJ_PERIOD	☐	OIL-TSW: Rolling period
32	PAST	OIJLOCMAT	PAST		☐	OIJ_PAST	☐	OIL-TSW: Number of days in the past
33	TOLPCT	OIJLOCMAT	TOLPCT		☐	OIJ_BUTOL	☐	Quantity tolerance under (%)
34	TOLABS	OIJLOCMAT	TOLABS		☐	OIJ_TOLABS	☐	Absolute tolerance qty under
35	PLTYP	OIJLOCMAT	PLTYP		☐	OIJ_PLTYP	☐	OIL-TSW: Planning type
36	CALFLG	OIJLOCMAT	CALFLG		☐	OIJ_CALFLG	☐	OIL-TSW: Calendar use indicator
37	PLCAL	OIJLOCMAT	PLCAL		☐	OIJ_PLCAL	☐	Planning calendar
38	OFFPER	OIJLOCMAT	OFFPER		☐	OIJ_OFFPER	☐	OIL-TSW: Planning source offset period
39	OFFUOM	OIJLOCMAT	OFFUOM		☐	OIJ_OFFUOM	☐	OIL-TSW: Planning source offset period UoM
40	MAXLOT	OIJLOCMAT	MAXLOT		☐	OIJ_MAXLOT	☐	OIL-TSW: Planning maximum batch (lot) size
41	MINLOT	OIJLOCMAT	MINLOT		☐	OIJ_MINLOT	☐	OIL-TSW: Planning minimum batch (lot) size
42	INCLOT	OIJLOCMAT	INCLOT		☐	OIJ_INCLOT	☐	OIL-TSW: Planning incremental batch (lot) size - rounding
43	MAXINV	OIJLOCMAT	MAXINV		☐	OIJ_MAXINV	☐	OIL-TSW: Planning maximum inventory level
44	TARGET	OIJLOCMAT	TARGET		☐	OIJ_TGTINV	☐	OIL-TSW: Planning target inventory level
45	REORDER	OIJLOCMAT	REORDER		☐	OIJ_REORD	☐	OIL-TSW: Planning reorder point inventory level
46	MININV	OIJLOCMAT	MININV		☐	OIJ_MININV	☐	OIL-TSW: Planning minimum inventory level
47	STSYST	OIJLOCMAT	STSYST		☐	OIJ_STSYST	☐	OIL-TSW: Planning source transport system
48	SAFETY	OIJLOCMAT	SAFETY		☐	OIJ_SFTINV	☐	OIl-TSW: Planning safety inventory level
49	UNPUMP	OIJLOCMAT	UNPUMP		☐	OIJ_UNPUMP	☐	OIL-TSW: Unpumpable (blocked) inventory
50	CHARG	OIJLOCMAT	CHARG		☐	OIJ_CHARG	☐	Batch / Valuation type
51	PHY_INV	OIJLOCMAT	PHY_INV		☐	OIJ_PHY_INV	☐	OIL-TSW: Phy inventory at loc.(from external source)
52	PHY_DATE	OIJLOCMAT	PHY_DATE		☐	OIJ_PHY_DATE	☐	OIL-TSW: Date for last physical inventory update
53	PHY_INV_FLG	OIJLOCMAT	PHY_INV_FLG		☐	OIJ_FLG	☐	OIL-TSW: Flag indicating physical inventory input
54	FCCAL	OIJLOCMAT	FCCAL		☐	OIJ_FCCAL	☐	OIL-TSW: Stock Projection rack forecast calendar
55	FCPRF	OIJLOCMAT	FCPRF		☐	OIJ_FCPRF	☐	OIL-TSW: Stock Projection rack forecast profile
56	FCTYPE	OIJLOCMAT	FCTYPE		☐	OIJ_FCTYPE	☐	OIL-TSW: Rack issue forecast type
57	FCPAST	OIJLOCMAT	FCPAST		☐	OIJ_FCPAST	☐	OIL-TSW: History horizon for automated rack issue forecast
58	FCOFFSET	OIJLOCMAT	FCOFFSET		☐	OIJ_FCOFFSET	☐	OIL-TSW: Number of offset days in forecast calculation
59	TANKUPD	OIJLOCMAT	TANKUPD		☐	OIJ_TANKUPD	☐	Flag to indicate update by tank interface file
60	PHYTMS	OIJLOCMAT	PHYTMS		☐	OIJ_PHYTMS	☐	Timestamp for previous physical inventory update
61	SRCTYPE	OIJLOCMAT	SRCTYPE		☐	OIJ_SRCTYPE	☐	OIL-TSW: Physical inventory type / source
62	FCHORIZ	OIJLOCMAT	FCHORIZ		☐	OIJ_FCHORIZ	☐	Oil-TSW: Rack issue / Throughput forecast history horizon
63	SFTLVL	OIJLOCMAT	SFTLVL		☐	OIJ_SFTLVL	☐	Preferred Safety Level
64	HRLVL	OIJLOCMAT	HRLVL		☐	OIJ_HRLVL	☐	Preferred Headroom Level
65	RVP	OIJLOCMAT	RVP		☐	OIJ_RVP	☐	RVP value
66	RDACT	OIJLOC	RDACT		☐	OIJ_RDACT	☐	Stock Projection activation indicator
67	BALANCE	OIJLOCMAT	BALANCE		☐	OIJ_BALANCE	☐	Indicator to supress balance quantities in Stock Projection
68	PPTYP	OIJLOCMAT	PPTYP		☐	OIJ_PPTYP	☐	Production planning type

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