SAP ABAP Table ROIJTSMAT (OIL-TSW: Structure for int. table OIJTSMAT_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	ROIJTSMAT	Table Relationship Diagram
Short Description	OIL-TSW: Structure for int. table OIJTSMAT_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: TS Rundown/Planning material table
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS
4	PMATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	TSNAM	☐	OIJ_TSNAM	OIJ_TSNAM	CHAR	60	0	OIL-TSW: Transport system name
6	PMATNAME	☐	MAKTX	TEXT40	CHAR	40	0	Material description
7	PWERK	☐	OIJ_WERK	WERKS	CHAR	4	0	Transport system In-transit Plant	T001W
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: Standard status field set (TSW)
81	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
82	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
83	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
84	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
85	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
86	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
87	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
88	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
89	.INCLUDE	☐				0	0	TSW Scheduling Defaults
90	AUTOCONFIRM	☐	OIJ_AUTOCONF	XFELD	CHAR	1	0	Automatic confirmation Flag
91	.INCLUDE	☐				0	0	IS-Oil/TSW: Substructure for consumption mode data
92	VRMOD	☐	VRMOD	VRMOD	CHAR	1	0	Consumption mode
93	VINT1	☐	VINT1	VRINT	NUMC	3	0	Consumption period: backward
94	VINT2	☐	VINT2	VRINT	NUMC	3	0	Consumption period: forward
95	DEFSITYP	☐	OIJ_DEFSITYP	OIJ_SITYP	CHAR	2	0	Default schedule type	TOIJ_EL_SITYPES
96	DEFDOCIND	☐	OIJ_DOCIND	OIJ_DOCIND	CHAR	1	0	Reference document indicator (PSX)
97	SELECTFLAG	☐	FLAG	FLAG	CHAR	1	0	General Flag
98	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	ROIJTSMAT	CALPROF	OIJSCAL	CALPROF	KEY	1	CN
2	ROIJTSMAT	COVPROF	OIJCOV	COVPROF	KEY	1	CN
3	ROIJTSMAT	CYCUOM	T006	MSEHI	KEY	1	CN
4	ROIJTSMAT	DATUOM	T006	MSEHI	KEY	1	CN
5	ROIJTSMAT	DEFSITYP	TOIJ_EL_SITYPES	SITYP
6	ROIJTSMAT	FACTORY	TFACD	IDENT	KEY	1	CN
7	ROIJTSMAT	FCCAL	TFACD	IDENT		1	CN
8	ROIJTSMAT	FCPRF	OIJFCPRF	FCPRF
9	ROIJTSMAT	INVUOM	T006	MSEHI	KEY	1	CN
10	ROIJTSMAT	MANDT	T000	MANDT	KEY	1	CN
11	ROIJTSMAT	OFFUOM	T006	MSEHI	KEY	1	CN
12	ROIJTSMAT	PLUOM	T006	MSEHI	KEY	1	CN
13	ROIJTSMAT	PMATNR	MARA	MATNR	KEY	1	CN
14	ROIJTSMAT	PTSYST	OIJTS	TSYST	KEY	1	CN
15	ROIJTSMAT	PWERK	T001W	WERKS	KEY	1	CN
16	ROIJTSMAT	RDUOM	T006	MSEHI	KEY	1	CN
17	ROIJTSMAT	SFTTYPE	OIJSFTYP	SFTTYPE	KEY	1	CN
18	ROIJTSMAT	SLOCID	OIJLOC	LOCID	KEY	1	CN
19	ROIJTSMAT	SRCTYPE	OIJSRCTYPE	SRCTYPE	KEY	1	CN
20	ROIJTSMAT	STSYST	OIJTS	TSYST	KEY	1	CN
21	ROIJTSMAT	TGTTYPE	OIJTGTYP	TGTTYPE
22	ROIJTSMAT	TSYST	OIJTS	TSYST	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in