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

Foreign Keys

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

History

Last changed by/on	SAP	20050224
SAP Release Created in