SAP ABAP Table OIJLOCMAT (OIL-TSW: Location Rundown/Planning material table)

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	TRANSP	Transparent table
Transparent table	OIJLOCMAT	Table Relationship Diagram
Short Description	OIL-TSW: Location Rundown/Planning material table

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20050224
SAP Release Created in