SAP ABAP Table ROIJLOCMAT (OIL-TSW: Structure for int. table OIJLOCMAT_TAB)

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

Table Category	INTTAB	Structure
Structure	ROIJLOCMAT	Table Relationship Diagram
Short Description	OIL-TSW: Structure for int. table OIJLOCMAT_TAB

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	.INCLUDE	☐				0	0	OIL-TSW: Location Rundown/Planning material table
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
4	PMATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	LOCNAME	☐	OIJ_LOCNAM	OIJ_LOCNAM	CHAR	60	0	Location name (used by system owner)
6	PMATNAME	☐	MAKTX	TEXT40	CHAR	40	0	Material description
7	PWERK	☐	OIJ_PWERK	WERKS	CHAR	4	0	Plant for location Stock Projection and Replenishment Planng	T001W
8	CHARG	☐	OIJ_CHARG	CHARG	CHAR	10	0	Batch / Valuation type	MCHB
9	.INCLUDE	☐				0	0	Rundown header material structure
10	RDUOM	☐	OIJ_RDUOM	MEINS	UNIT	3	0	Stock Projection unit of measure (UoM)	T006
11	RDCONV	☐	OIJ_RDCONV	NUMC5	NUMC	5	0	OIL-TSW: Stock Projection conversion factor
12	PERIOD	☐	OIJ_PERIOD	ANZTA	NUMC	3	0	OIL-TSW: Rolling period
13	PAST	☐	OIJ_PAST	ANZTA	NUMC	3	0	OIL-TSW: Number of days in the past
14	TOLPCT	☐	OIJ_BUTOL	DEC3_1	DEC	4	1	Quantity tolerance under (%)
15	TOLABS	☐	OIJ_TOLABS	MENG13	QUAN	13	3	Absolute tolerance qty under
16	PASTDATA	☐	OIJ_SFPAST	ANZTA	NUMC	3	0	OIL-TSW: No. of days in past for safety stock calculation
17	PHY_INV_FLG	☐	OIJ_FLG	XFELD	CHAR	1	0	OIL-TSW: Flag indicating physical inventory input
18	PHY_INV	☐	OIJ_PHY_INV	MENG13V	QUAN	13	3	OIL-TSW: Phy inventory at loc.(from external source)
19	PHY_DATE	☐	OIJ_PHY_DATE	DATUM	DATS	8	0	OIL-TSW: Date for last physical inventory update
20	FCPAST	☐	OIJ_FCPAST	ANZTA	NUMC	3	0	OIL-TSW: History horizon for automated rack issue forecast
21	FCOFFSET	☐	OIJ_FCOFFSET	ANZTA	NUMC	3	0	OIL-TSW: Number of offset days in forecast calculation
22	FCTYPE	☐	OIJ_FCTYPE	OIJ_FCTYPE	CHAR	4	0	OIL-TSW: Rack issue forecast type
23	PHYTMS	☐	OIJ_PHYTMS	TSTAMP	NUMC	14	0	Timestamp for previous physical inventory update
24	SRCTYPE	☐	OIJ_SRCTYPE	OIJ_SRCTYPE	CHAR	1	0	OIL-TSW: Physical inventory type / source	OIJSRCTYPE
25	FCHORIZ	☐	OIJ_FCHORIZ	OIJ_FCHORIZ	NUMC	3	0	Oil-TSW: Rack issue / Throughput forecast history horizon
26	RVP	☐	OIJ_RVP	DEC2_1	DEC	3	1	RVP value
27	.INCLUDE	☐				0	0	Planning data sub-structure
28	PLTYP	☐	OIJ_PLTYP	OIJ_PLTYP	CHAR	3	0	OIL-TSW: Planning type
29	CALFLG	☐	OIJ_CALFLG	OIJ_CALFLG	CHAR	1	0	OIL-TSW: Calendar use indicator
30	PLCAL	☐	OIJ_PLCAL	OIJ_PLCAL	CHAR	3	0	Planning calendar	*
31	COVER	☐	OIJ_COVER	OIJ_PERIOD	QUAN	3	0	OIL-TSW: Safety stock coverage period (in plan period UoM)
32	PLHOZ	☐	OIJ_PLHOZ	OIJ_PERIOD	QUAN	3	0	OIL-TSW: Planning horizon
33	DATUOM	☐	OIJ_DATUOM	MEINS	UNIT	3	0	OIL-TSW: Planning period UoM	T006
34	PTSYST	☐	OIJ_PTSYST	OIJ_TSYST	CHAR	10	0	OIL-TSW: Planning transport system	OIJTS
35	PLUOM	☐	OIJ_PLUOM	MEINS	UNIT	3	0	OIL-TSW: Planning UoM	T006
36	CYCLE	☐	OIJ_CYCPER	OIJ_PERIOD	QUAN	3	0	OIL-TSW: Planning cycle period
37	CYCUOM	☐	OIJ_CYCUOM	MEINS	UNIT	3	0	OIL-TSW: Cycle period UoM	T006
38	MAXLOT	☐	OIJ_MAXLOT	MENG13	QUAN	13	3	OIL-TSW: Planning maximum batch (lot) size
39	MINLOT	☐	OIJ_MINLOT	MENG13	QUAN	13	3	OIL-TSW: Planning minimum batch (lot) size
40	INCLOT	☐	OIJ_INCLOT	MENG13	QUAN	13	3	OIL-TSW: Planning incremental batch (lot) size - rounding
41	INVUOM	☐	OIJ_INVUOM	MEINS	UNIT	3	0	OIL-TSW: Planning inventory UoM	T006
42	MAXINV	☐	OIJ_MAXINV	MENG13V	QUAN	13	3	OIL-TSW: Planning maximum inventory level
43	TARGET	☐	OIJ_TGTINV	MENG13V	QUAN	13	3	OIL-TSW: Planning target inventory level
44	REORDER	☐	OIJ_REORD	MENG13V	QUAN	13	3	OIL-TSW: Planning reorder point inventory level
45	SAFETY	☐	OIJ_SFTINV	MENG13V	QUAN	13	3	OIl-TSW: Planning safety inventory level
46	UNPUMP	☐	OIJ_UNPUMP	MENG13V	QUAN	13	3	OIL-TSW: Unpumpable (blocked) inventory
47	MININV	☐	OIJ_MININV	MENG13V	QUAN	13	3	OIL-TSW: Planning minimum inventory level
48	STSYST	☐	OIJ_STSYST	OIJ_TSYST	CHAR	10	0	OIL-TSW: Planning source transport system	OIJTS
49	SLOCID	☐	OIJ_SLOCID	OIJ_LOCID	CHAR	10	0	OIL-TSW: Planning source location ID	OIJLOC
50	SPART	☐	OIJ_SPART	OIJ_PARTNR	CHAR	10	0	OIl-TSW: Planning source partner (supplier)
51	SPOBJ	☐	OIJ_SPOBJ	CHAR2	CHAR	2	0	OIL-TSW: Planning source partner object type (vend/plant)
52	OFFPER	☐	OIJ_OFFPER	OIJ_PERIOD	QUAN	3	0	OIL-TSW: Planning source offset period
53	OFFUOM	☐	OIJ_OFFUOM	MEINS	UNIT	3	0	OIL-TSW: Planning source offset period UoM	T006
54	RADIONOSRC	☐	OIJ_RADNSC	XFELD	CHAR	1	0	OIL-TSW: Radio button - no planning source
55	RADIOTSSRC	☐	OIJ_RADTS	XFELD	CHAR	1	0	OIL-TSW: Radio button for TS sourcing
56	RADIOLOCSC	☐	OIJ_RADLOC	XFELD	CHAR	1	0	OIL-TSW: Radio button for TSW location sourcing
57	PLANAMPEL	☐	OIJ_PAMPEL	TEXT80	CHAR	80	0	OIL-TSW: Traffic light indicating presence of plan details
58	PLANFLAG	☐	OIJ_PLFLAG	XFELD	CHAR	1	0	OIL-TSW: Planning run flag (X = plan run done since RD)
59	SCFLAG	☐	OIJ_SCFLAG	XFELD	CHAR	1	0	OIL_TSW : Source object planning run flag
60	SERVICE	☐	OIJ_SRVC	DEC3	DEC	3	0	OIL-TSW: Safety stock service level
61	COVPROF	☐	OIJ_COVPRF	OIJ_COVPRF	CHAR	3	0	OIL-TSW: Safety stock coverage profile	OIJCOV
62	CALPROF	☐	OIJ_CALPRF	OIJ_CALPRF	CHAR	3	0	OIL-TSW: Safety stock calendar usage profile	OIJSCAL
63	FACTORY	☐	OIJ_FACTRY	WFCID	CHAR	2	0	OIL-TSW: Factory calendar ID	TFACD
64	SFTTYPE	☐	OIJ_SFTTYP	OIJ_SFTTYP	CHAR	3	0	OIL-TSW: Safety stock calculation type	OIJSFTYP
65	HISTHOZ	☐	OIJ_HISTHZ	ANZTA	NUMC	3	0	OIL-TSW: Safety stock history horizon
66	TSERVICE	☐	OIJ_TSRVC	DEC3	DEC	3	0	OIL-TSW: Target stock service level
67	TCOVPROF	☐	OIJ_TCOVPRF	OIJ_TCOVPRF	CHAR	3	0	OIL-TSW: Target stock coverage profile
68	TCALPROF	☐	OIJ_TCALPRF	OIJ_TCALPRF	CHAR	3	0	OIL-TSW: Target stock calendar usage profile
69	TFACTORY	☐	OIJ_TFACTRY	WFCID	CHAR	2	0	OIL-TSW: Factory calendar ID for Target stock calculation	*
70	TGTTYPE	☐	OIJ_TGTTYP	OIJ_TGTTYP	CHAR	3	0	OIL-TSW: Target stock calculation type	OIJTGTYP
71	THISTHOZ	☐	OIJ_THISTHZ	ANZTA	NUMC	3	0	OIL-TSW: Target stock history horizon
72	FCCAL	☐	OIJ_FCCAL	WFCID	CHAR	2	0	OIL-TSW: Stock Projection rack forecast calendar	TFACD
73	FCPRF	☐	OIJ_FCPRF	OIJ_FCPRF	CHAR	3	0	OIL-TSW: Stock Projection rack forecast profile	OIJFCPRF
74	TANKUPD	☐	OIJ_TANKUPD	XFELD	CHAR	1	0	Flag to indicate update by tank interface file
75	SFTLVL	☐	OIJ_SFTLVL	MENG13V	QUAN	13	3	Preferred Safety Level
76	HRLVL	☐	OIJ_HRLVL	MENG13V	QUAN	13	3	Preferred Headroom Level
77	SFTTDIND	☐	OIJ_SFTTDIND	XFELD	CHAR	1	0	Calculate time-dependent safety stock
78	TGTTDIND	☐	OIJ_TGTTDIND	XFELD	CHAR	1	0	Calculate time-dependent target stock
79	PPTYP	☐	OIJ_PPTYP	OIJ_PPTYP	CHAR	4	0	Production planning type
80	BALANCE	☐	OIJ_BALANCE	XFELD	CHAR	1	0	Indicator to supress balance quantities in Stock Projection
81	.INCLUDE	☐				0	0	OIL-TSW: Structure for production version handling
82	PVFLAG	☐	OIJ_PVFLAG	XFELD	CHAR	1	0	OIL-TSW: Flag indicating that PV use is active
83	VERID	☐	OIJ_VERID	VERID	CHAR	4	0	OIL-TSW: Version ID currently assigned	MKAL
84	TODAT	☐	OIJ_TDATE	DATUM	DATS	8	0	OIL-TSW: To date of active PV
85	FROMDAT	☐	OIJ_FDATE	DATUM	DATS	8	0	OIL-TSW: From date of active PV
86	BOMALT	☐	OIJ_BOMALT	ALTNR	CHAR	2	0	OIL-TSW: Alternative BOM
87	BOMUSE	☐	OIJ_BOMUSE	STLAN	CHAR	1	0	OIL-TSW: BOM use indicator	T416
88	BOMMAT	☐	OIJ_BOMMAT	MATNR	CHAR	18	0	OIL-TSW: BOM material assigned	MARA
89	.INCLUDE	☐				0	0	OIL-TSW: Standard status field set (TSW)
90	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
91	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
92	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
93	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
94	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
95	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
96	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
97	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
98	TCONS	☐	OIJ_TCONS	XFELD	CHAR	1	0	Indicator for location/material time dependent data
99	.INCLUDE	☐				0	0	TSW Scheduling Defaults
100	AUTOCONFIRM	☐	OIJ_AUTOCONF	XFELD	CHAR	1	0	Automatic confirmation Flag
101	.INCLUDE	☐				0	0	IS-Oil/TSW: Substructure for consumption mode data
102	VRMOD	☐	VRMOD	VRMOD	CHAR	1	0	Consumption mode
103	VINT1	☐	VINT1	VRINT	NUMC	3	0	Consumption period: backward
104	VINT2	☐	VINT2	VRINT	NUMC	3	0	Consumption period: forward
105	DEFSITYP	☐	OIJ_DEFSITYP	OIJ_SITYP	CHAR	2	0	Default schedule type	TOIJ_EL_SITYPES
106	DEFDOCIND	☐	OIJ_DOCIND	OIJ_DOCIND	CHAR	1	0	Reference document indicator (PSX)
107	.INCLUDE	☐				0	0	Location Balancing sub-structure in OIJLOCMAT
108	LBUOM	☐	OIJ_LBUOM	MEINS	UNIT	3	0	Location Balancing UOM	*
109	SELECTFLAG	☐	FLAG	FLAG	CHAR	1	0	General Flag
110	UPDATEFLAG	☐	TRTYP	TRTYP	CHAR	1	0	Transaction type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIJLOCMAT	BOMMAT	MARA	MATNR	KEY	1	CN
2	ROIJLOCMAT	BOMUSE	T416	STLAN	KEY	1	CN
3	ROIJLOCMAT	CALPROF	OIJSCAL	CALPROF	KEY	1	CN
4	ROIJLOCMAT	CHARG	MCHB	CHARG
5	ROIJLOCMAT	COVPROF	OIJCOV	COVPROF	KEY	1	CN
6	ROIJLOCMAT	CYCUOM	T006	MSEHI	KEY	1	CN
7	ROIJLOCMAT	DATUOM	T006	MSEHI	KEY	1	CN
8	ROIJLOCMAT	DEFSITYP	TOIJ_EL_SITYPES	SITYP
9	ROIJLOCMAT	FACTORY	TFACD	IDENT		1	CN
10	ROIJLOCMAT	FCCAL	TFACD	IDENT		1	CN
11	ROIJLOCMAT	FCPRF	OIJFCPRF	FCPRF
12	ROIJLOCMAT	INVUOM	T006	MSEHI	KEY	1	CN
13	ROIJLOCMAT	LOCID	OIJLOC	LOCID	KEY	1	CN
14	ROIJLOCMAT	MANDT	T000	MANDT	KEY	1	CN
15	ROIJLOCMAT	OFFUOM	T006	MSEHI	KEY	1	CN
16	ROIJLOCMAT	PLUOM	T006	MSEHI	KEY	1	CN
17	ROIJLOCMAT	PMATNR	MARA	MATNR	KEY	1	CN
18	ROIJLOCMAT	PTSYST	OIJTS	TSYST	KEY	1	CN
19	ROIJLOCMAT	PWERK	T001W	WERKS	KEY	1	CN
20	ROIJLOCMAT	RDUOM	T006	MSEHI	KEY	1	CN
21	ROIJLOCMAT	SFTTYPE	OIJSFTYP	SFTTYPE	KEY	1	CN
22	ROIJLOCMAT	SLOCID	OIJLOC	LOCID	KEY	1	CN
23	ROIJLOCMAT	SRCTYPE	OIJSRCTYPE	SRCTYPE	KEY	1	CN
24	ROIJLOCMAT	STSYST	OIJTS	TSYST	KEY	1	CN
25	ROIJLOCMAT	TGTTYPE	OIJTGTYP	TGTTYPE
26	ROIJLOCMAT	VERID	MKAL	VERID	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in