SAP ABAP Table V_OIJRDSEL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_OIJRDSEL	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_OIJRDSEL	CHARG	MCHB	CHARG
2	V_OIJRDSEL	FCCAL	TFACD	IDENT		1	CN
3	V_OIJRDSEL	FCPRF	OIJFCPRF	FCPRF
4	V_OIJRDSEL	LOCID	OIJLOC	LOCID	KEY	1	CN
5	V_OIJRDSEL	LOCWERK	T001W	WERKS	REF	1	CN
6	V_OIJRDSEL	MANDT	T000	MANDT	KEY	1	CN
7	V_OIJRDSEL	OFFUOM	T006	MSEHI	REF	1	CN
8	V_OIJRDSEL	PMATNR	MARA	MATNR	KEY	1	CN
9	V_OIJRDSEL	RDUOM	T006	MSEHI	REF	1	CN
10	V_OIJRDSEL	SRCTYPE	OIJSRCTYPE	SRCTYPE	KEY	1	CN
11	V_OIJRDSEL	STSYST	OIJTS	TSYST	REF	1	CN
12	V_OIJRDSEL	TOFFUOM	T006	MSEHI	REF	1	CN
13	V_OIJRDSEL	TRDUOM	T006	MSEHI	REF	1	CN
14	V_OIJRDSEL	TSLOCID	OIJLOC	LOCID	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in