SAP ABAP Table ROIJPLAN (Planning data sub-structure)

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	ROIJPLAN	Table Relationship Diagram
Short Description	Planning data sub-structure

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	PLTYP	☐	OIJ_PLTYP	OIJ_PLTYP	CHAR	3	0	OIL-TSW: Planning type
2	CALFLG	☐	OIJ_CALFLG	OIJ_CALFLG	CHAR	1	0	OIL-TSW: Calendar use indicator
3	PLCAL	☐	OIJ_PLCAL	OIJ_PLCAL	CHAR	3	0	Planning calendar	*
4	COVER	☐	OIJ_COVER	OIJ_PERIOD	QUAN	3	0	OIL-TSW: Safety stock coverage period (in plan period UoM)
5	PLHOZ	☐	OIJ_PLHOZ	OIJ_PERIOD	QUAN	3	0	OIL-TSW: Planning horizon
6	DATUOM	☐	OIJ_DATUOM	MEINS	UNIT	3	0	OIL-TSW: Planning period UoM	*
7	PTSYST	☐	OIJ_PTSYST	OIJ_TSYST	CHAR	10	0	OIL-TSW: Planning transport system	*
8	PLUOM	☐	OIJ_PLUOM	MEINS	UNIT	3	0	OIL-TSW: Planning UoM	*
9	CYCLE	☐	OIJ_CYCPER	OIJ_PERIOD	QUAN	3	0	OIL-TSW: Planning cycle period
10	CYCUOM	☐	OIJ_CYCUOM	MEINS	UNIT	3	0	OIL-TSW: Cycle period UoM	*
11	MAXLOT	☐	OIJ_MAXLOT	MENG13	QUAN	13	3	OIL-TSW: Planning maximum batch (lot) size
12	MINLOT	☐	OIJ_MINLOT	MENG13	QUAN	13	3	OIL-TSW: Planning minimum batch (lot) size
13	INCLOT	☐	OIJ_INCLOT	MENG13	QUAN	13	3	OIL-TSW: Planning incremental batch (lot) size - rounding
14	INVUOM	☐	OIJ_INVUOM	MEINS	UNIT	3	0	OIL-TSW: Planning inventory UoM	*
15	MAXINV	☐	OIJ_MAXINV	MENG13V	QUAN	13	3	OIL-TSW: Planning maximum inventory level
16	TARGET	☐	OIJ_TGTINV	MENG13V	QUAN	13	3	OIL-TSW: Planning target inventory level
17	REORDER	☐	OIJ_REORD	MENG13V	QUAN	13	3	OIL-TSW: Planning reorder point inventory level
18	SAFETY	☐	OIJ_SFTINV	MENG13V	QUAN	13	3	OIl-TSW: Planning safety inventory level
19	UNPUMP	☐	OIJ_UNPUMP	MENG13V	QUAN	13	3	OIL-TSW: Unpumpable (blocked) inventory
20	MININV	☐	OIJ_MININV	MENG13V	QUAN	13	3	OIL-TSW: Planning minimum inventory level
21	STSYST	☐	OIJ_STSYST	OIJ_TSYST	CHAR	10	0	OIL-TSW: Planning source transport system	*
22	SLOCID	☐	OIJ_SLOCID	OIJ_LOCID	CHAR	10	0	OIL-TSW: Planning source location ID	*
23	SPART	☐	OIJ_SPART	OIJ_PARTNR	CHAR	10	0	OIl-TSW: Planning source partner (supplier)
24	SPOBJ	☐	OIJ_SPOBJ	CHAR2	CHAR	2	0	OIL-TSW: Planning source partner object type (vend/plant)
25	OFFPER	☐	OIJ_OFFPER	OIJ_PERIOD	QUAN	3	0	OIL-TSW: Planning source offset period
26	OFFUOM	☐	OIJ_OFFUOM	MEINS	UNIT	3	0	OIL-TSW: Planning source offset period UoM	*
27	RADIONOSRC	☐	OIJ_RADNSC	XFELD	CHAR	1	0	OIL-TSW: Radio button - no planning source
28	RADIOTSSRC	☐	OIJ_RADTS	XFELD	CHAR	1	0	OIL-TSW: Radio button for TS sourcing
29	RADIOLOCSC	☐	OIJ_RADLOC	XFELD	CHAR	1	0	OIL-TSW: Radio button for TSW location sourcing
30	PLANAMPEL	☐	OIJ_PAMPEL	TEXT80	CHAR	80	0	OIL-TSW: Traffic light indicating presence of plan details
31	PLANFLAG	☐	OIJ_PLFLAG	XFELD	CHAR	1	0	OIL-TSW: Planning run flag (X = plan run done since RD)
32	SCFLAG	☐	OIJ_SCFLAG	XFELD	CHAR	1	0	OIL_TSW : Source object planning run flag
33	SERVICE	☐	OIJ_SRVC	DEC3	DEC	3	0	OIL-TSW: Safety stock service level
34	COVPROF	☐	OIJ_COVPRF	OIJ_COVPRF	CHAR	3	0	OIL-TSW: Safety stock coverage profile	*
35	CALPROF	☐	OIJ_CALPRF	OIJ_CALPRF	CHAR	3	0	OIL-TSW: Safety stock calendar usage profile	*
36	FACTORY	☐	OIJ_FACTRY	WFCID	CHAR	2	0	OIL-TSW: Factory calendar ID	*
37	SFTTYPE	☐	OIJ_SFTTYP	OIJ_SFTTYP	CHAR	3	0	OIL-TSW: Safety stock calculation type	*
38	HISTHOZ	☐	OIJ_HISTHZ	ANZTA	NUMC	3	0	OIL-TSW: Safety stock history horizon
39	TSERVICE	☐	OIJ_TSRVC	DEC3	DEC	3	0	OIL-TSW: Target stock service level
40	TCOVPROF	☐	OIJ_TCOVPRF	OIJ_TCOVPRF	CHAR	3	0	OIL-TSW: Target stock coverage profile
41	TCALPROF	☐	OIJ_TCALPRF	OIJ_TCALPRF	CHAR	3	0	OIL-TSW: Target stock calendar usage profile
42	TFACTORY	☐	OIJ_TFACTRY	WFCID	CHAR	2	0	OIL-TSW: Factory calendar ID for Target stock calculation	*
43	TGTTYPE	☐	OIJ_TGTTYP	OIJ_TGTTYP	CHAR	3	0	OIL-TSW: Target stock calculation type	OIJTGTYP
44	THISTHOZ	☐	OIJ_THISTHZ	ANZTA	NUMC	3	0	OIL-TSW: Target stock history horizon
45	FCCAL	☐	OIJ_FCCAL	WFCID	CHAR	2	0	OIL-TSW: Stock Projection rack forecast calendar	TFACD
46	FCPRF	☐	OIJ_FCPRF	OIJ_FCPRF	CHAR	3	0	OIL-TSW: Stock Projection rack forecast profile	OIJFCPRF
47	TANKUPD	☐	OIJ_TANKUPD	XFELD	CHAR	1	0	Flag to indicate update by tank interface file
48	SFTLVL	☐	OIJ_SFTLVL	MENG13V	QUAN	13	3	Preferred Safety Level
49	HRLVL	☐	OIJ_HRLVL	MENG13V	QUAN	13	3	Preferred Headroom Level
50	SFTTDIND	☐	OIJ_SFTTDIND	XFELD	CHAR	1	0	Calculate time-dependent safety stock
51	TGTTDIND	☐	OIJ_TGTTDIND	XFELD	CHAR	1	0	Calculate time-dependent target stock
52	PPTYP	☐	OIJ_PPTYP	OIJ_PPTYP	CHAR	4	0	Production planning type
53	BALANCE	☐	OIJ_BALANCE	XFELD	CHAR	1	0	Indicator to supress balance quantities in Stock Projection

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIJPLAN	FCCAL	TFACD	IDENT		1	CN
2	ROIJPLAN	FCPRF	OIJFCPRF	FCPRF
3	ROIJPLAN	TGTTYPE	OIJTGTYP	TGTTYPE

History

Last changed by/on	SAP	20050224
SAP Release Created in