SAP ABAP View V_OIJRDSEL3 (OIL-TSW: View for selecting Location and Material Rundown)

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_OIJRDSEL3
Short Description	OIL-TSW: View for selecting Location and Material Rundown
Root table	OIJTSLOC	OIL-TSW: transport system/location assignment table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	OIJTSLOC	OIJTSLOC
2	OIJLOC
3	OIJLOCMAT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	OIJLOC	MANDT	JL	EQ				0	0
2	OIJTSLOC	MANDT	JR	EQ			AND	0	0
3	OIJLOC	LOCID	JL	EQ				0	0
4	OIJTSLOC	LOCID	JR	EQ			AND	0	0
5	OIJLOC	MANDT	JL	EQ				0	0
6	OIJLOCMAT	MANDT	JR	EQ			AND	0	0
7	OIJLOC	LOCID	JL	EQ				0	0
8	OIJLOCMAT	LOCID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	OIJTSLOC	MANDT		☐	MANDT	☐	Client
2	LOCID	OIJTSLOC	LOCID		☐	OIJ_LOCID	☐	Location ID
3	PMATNR	OIJLOCMAT	PMATNR		☐	MATNR	☐	Material Number
4	ODINDO	OIJTSLOC	ODINDO		☐	OIJ_ODINDO	☐	OIL-TSW: Location is origin flag
5	ODINDD	OIJTSLOC	ODINDD		☐	OIJ_ODINDD	☐	OIL-TSW: Location destination flag
6	PWERK	OIJLOCMAT	PWERK		☐	OIJ_PWERK	☐	Plant for location Stock Projection and Replenishment Planng
7	CHARG	OIJLOCMAT	CHARG		☐	OIJ_CHARG	☐	Batch / Valuation type
8	RDUOM	OIJLOCMAT	RDUOM		☐	OIJ_RDUOM	☐	Stock Projection unit of measure (UoM)
9	RDCONV	OIJLOCMAT	RDCONV		☐	OIJ_RDCONV	☐	OIL-TSW: Stock Projection conversion factor
10	PERIOD	OIJLOCMAT	PERIOD		☐	OIJ_PERIOD	☐	OIL-TSW: Rolling period
11	PAST	OIJLOCMAT	PAST		☐	OIJ_PAST	☐	OIL-TSW: Number of days in the past
12	TOLPCT	OIJLOCMAT	TOLPCT		☐	OIJ_BUTOL	☐	Quantity tolerance under (%)
13	TOLABS	OIJLOCMAT	TOLABS		☐	OIJ_TOLABS	☐	Absolute tolerance qty under
14	PHY_INV_FLG	OIJLOCMAT	PHY_INV_FLG		☐	OIJ_FLG	☐	OIL-TSW: Flag indicating physical inventory input
15	PHY_INV	OIJLOCMAT	PHY_INV		☐	OIJ_PHY_INV	☐	OIL-TSW: Phy inventory at loc.(from external source)
16	PHY_DATE	OIJLOCMAT	PHY_DATE		☐	OIJ_PHY_DATE	☐	OIL-TSW: Date for last physical inventory update
17	FCPAST	OIJLOCMAT	FCPAST		☐	OIJ_FCPAST	☐	OIL-TSW: History horizon for automated rack issue forecast
18	FCOFFSET	OIJLOCMAT	FCOFFSET		☐	OIJ_FCOFFSET	☐	OIL-TSW: Number of offset days in forecast calculation
19	FCTYPE	OIJLOCMAT	FCTYPE		☐	OIJ_FCTYPE	☐	OIL-TSW: Rack issue forecast type
20	PHYTMS	OIJLOCMAT	PHYTMS		☐	OIJ_PHYTMS	☐	Timestamp for previous physical inventory update
21	SRCTYPE	OIJLOCMAT	SRCTYPE		☐	OIJ_SRCTYPE	☐	OIL-TSW: Physical inventory type / source
22	FCHORIZ	OIJLOCMAT	FCHORIZ		☐	OIJ_FCHORIZ	☐	Oil-TSW: Rack issue / Throughput forecast history horizon
23	RVP	OIJLOCMAT	RVP		☐	OIJ_RVP	☐	RVP value
24	PLTYP	OIJLOCMAT	PLTYP		☐	OIJ_PLTYP	☐	OIL-TSW: Planning type
25	CALFLG	OIJLOCMAT	CALFLG		☐	OIJ_CALFLG	☐	OIL-TSW: Calendar use indicator
26	PLCAL	OIJLOCMAT	PLCAL		☐	OIJ_PLCAL	☐	Planning calendar
27	MAXLOT	OIJLOCMAT	MAXLOT		☐	OIJ_MAXLOT	☐	OIL-TSW: Planning maximum batch (lot) size
28	MINLOT	OIJLOCMAT	MINLOT		☐	OIJ_MINLOT	☐	OIL-TSW: Planning minimum batch (lot) size
29	INCLOT	OIJLOCMAT	INCLOT		☐	OIJ_INCLOT	☐	OIL-TSW: Planning incremental batch (lot) size - rounding
30	MAXINV	OIJLOCMAT	MAXINV		☐	OIJ_MAXINV	☐	OIL-TSW: Planning maximum inventory level
31	TARGET	OIJLOCMAT	TARGET		☐	OIJ_TGTINV	☐	OIL-TSW: Planning target inventory level
32	REORDER	OIJLOCMAT	REORDER		☐	OIJ_REORD	☐	OIL-TSW: Planning reorder point inventory level
33	SAFETY	OIJLOCMAT	SAFETY		☐	OIJ_SFTINV	☐	OIl-TSW: Planning safety inventory level
34	UNPUMP	OIJLOCMAT	UNPUMP		☐	OIJ_UNPUMP	☐	OIL-TSW: Unpumpable (blocked) inventory
35	MININV	OIJLOCMAT	MININV		☐	OIJ_MININV	☐	OIL-TSW: Planning minimum inventory level
36	STSYST	OIJLOCMAT	STSYST		☐	OIJ_STSYST	☐	OIL-TSW: Planning source transport system
37	OFFPER	OIJLOCMAT	OFFPER		☐	OIJ_OFFPER	☐	OIL-TSW: Planning source offset period
38	OFFUOM	OIJLOCMAT	OFFUOM		☐	OIJ_OFFUOM	☐	OIL-TSW: Planning source offset period UoM
39	FCCAL	OIJLOCMAT	FCCAL		☐	OIJ_FCCAL	☐	OIL-TSW: Stock Projection rack forecast calendar
40	FCPRF	OIJLOCMAT	FCPRF		☐	OIJ_FCPRF	☐	OIL-TSW: Stock Projection rack forecast profile
41	TANKUPD	OIJLOCMAT	TANKUPD		☐	OIJ_TANKUPD	☐	Flag to indicate update by tank interface file
42	SFTLVL	OIJLOCMAT	SFTLVL		☐	OIJ_SFTLVL	☐	Preferred Safety Level
43	HRLVL	OIJLOCMAT	HRLVL		☐	OIJ_HRLVL	☐	Preferred Headroom Level
44	PPTYP	OIJLOCMAT	PPTYP		☐	OIJ_PPTYP	☐	Production planning type
45	BALANCE	OIJLOCMAT	BALANCE		☐	OIJ_BALANCE	☐	Indicator to supress balance quantities in Stock Projection
46	RDACT	OIJLOC	RDACT		☐	OIJ_RDACT	☐	Stock Projection activation indicator
47	TSYST	OIJTSLOC	TSYST		☐	OIJ_TSYST	☐	Transport system

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