SAP ABAP Table OIJ_PLAN_PRF (3WP Planning Profile)

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	OIJ_PLAN_PRF	Table Relationship Diagram
Short Description	3WP Planning Profile

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	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	T000
2	PROFILE_ID	OIJ_PROFILE_ID	OIJ_PROFILE_ID	CHAR	22	0	Planning profile ID
3	PROFILE_TXT	OIJ_PROFILE_TXT	CHAR30	CHAR	30	0	Planning Profile Description
4	D_CHECKBOX	OIJ_XFLAG_DMD	XFELD	CHAR	1	0	Select no Demand Items
5	S_CHECKBOX	OIJ_XFLAG_SUP	XFELD	CHAR	1	0	Select no Supply Avails
6	T_CHECKBOX	OIJ_XFLAG_TRANS	XFELD	CHAR	1	0	Select no Transportation Avails
7	DS_CHECKBOX	OIJ_XFLAG_DS	XFELD	CHAR	1	0	Select no Distribution Schedule Items
8	G_BOM_CHECKBOX	OIJ_XFLAG_BOM	XFELD	CHAR	1	0	BOM Explosion
9	G_PS_CHECKBOX	OIJ_XFLAG_PS	XFELD	CHAR	1	0	Pegging to Stock
10	G_MAXSEL	TBMAXSEL	SYST_LONG	INT4	10	0	Maximum Number of Selected Entries
11	G_UNIT	OIJ_UNIT	MEINS	UNIT	3	0	General unit of measure	*
12	G_TIME_UNIT	OIJ_UNITI_T	MEINS	UNIT	3	0	Scheduled UoM Time	*
13	.INCLUDE				0	0	General Period
14	G_DATE_F	OIJ_DATE_F_GEN	DATS	DATS	8	0	General Period Start Date
15	G_DATE_T	OIJ_DATE_T_GEN	DATS	DATS	8	0	General Period End Date
16	G_TIME_F	OIJ_TIME_F_GEN	TIME	TIMS	6	0	General Period Start Time
17	G_TIME_T	OIJ_TIME_T_GEN	TIME	TIMS	6	0	General Period End Time
18	G_OFFSET	OIJ_OFFSET_GEN	OIJ_OFFSET	INT1	3	0	General Period Offset
19	G_DURATION	OIJ_OFFSET_DUR_GEN	TSTRDURAN	DEC	11	0	General Period Duration (in hours:minutes)
20	.INCLUDE				0	0	Demand Period
21	D_DATE_F	OIJ_DATE_F_DMD	DATS	DATS	8	0	Demand Period Start Date
22	D_DATE_T	OIJ_DATE_T_DMD	DATS	DATS	8	0	Demand Period End Date
23	D_TIME_F	OIJ_TIME_F_DMD	TIME	TIMS	6	0	Demand Period Start Time
24	D_TIME_T	OIJ_TIME_T_DMD	TIME	TIMS	6	0	Demand Period End Time
25	D_OFFSET	OIJ_OFFSET_DMD	OIJ_OFFSET	INT1	3	0	Demand Period Offset
26	D_DURATION	OIJ_OFFSET_DUR_DMD	TSTRDURAN	DEC	11	0	Demand Period Duration (in hours:minutes)
27	.INCLUDE				0	0	Supply Period
28	S_DATE_F	OIJ_DATE_F_SUP	DATS	DATS	8	0	Supply Period Start Date
29	S_DATE_T	OIJ_DATE_T_SUP	DATS	DATS	8	0	Supply Period End Date
30	S_TIME_F	OIJ_TIME_F_SUP	TIME	TIMS	6	0	Supply Period Start Time
31	S_TIME_T	OIJ_TIME_T_SUP	TIME	TIMS	6	0	Supply Period End Time
32	S_OFFSET	OIJ_OFFSET_SUP	OIJ_OFFSET	INT1	3	0	Supply Period Offset
33	S_DURATION	OIJ_OFFSET_DUR_SUP	TSTRDURAN	DEC	11	0	Supply Period Duration (in hours:minutes)
34	.INCLUDE				0	0	Transport Period
35	T_DATE_F	OIJ_DATE_F_TRANS	DATS	DATS	8	0	Transport Period Start Date
36	T_DATE_T	OIJ_DATE_T_TRANS	DATS	DATS	8	0	Transport Period End Date
37	T_TIME_F	OIJ_TIME_F_TRANS	TIME	TIMS	6	0	Transport Period Start Time
38	T_TIME_T	OIJ_TIME_T_TRANS	TIME	TIMS	6	0	Transport Period End Time
39	T_OFFSET	OIJ_OFFSET_TRANS	OIJ_OFFSET	INT1	3	0	Transport Period Offset
40	T_DURATION	OIJ_OFFSET_DUR_TRANS	TSTRDURAN	DEC	11	0	Transport Period Duration (in hours:minutes)
41	T_MINAV	OIJ_PERIOD_MINAV	ANZTA	NUMC	3	0	Minimum availability period [day]
42	T_VHRL	OIJ_PERIOD_VHRL	ANZTA	NUMC	3	0	Nomination relevance period [day]
43	T_REMCAP_QUAN	OIJ_REMCAP_QUAN	MENG13	QUAN	13	3	Remaining Capacity in Quantity
44	T_REMCAP_PERC	OIJ_REMCAP_PERC	DEC3_1	DEC	4	1	Remaining capacity in percentage
45	.INCLUDE				0	0	Distribution Schedule Period
46	DS_DATE_F	OIJ_DATE_F_DS	DATS	DATS	8	0	Distribution Schedule Period Start Date
47	DS_DATE_T	OIJ_DATE_T_DS	DATS	DATS	8	0	Distribution Schedule Period End Date
48	DS_TIME_F	OIJ_TIME_F_DS	TIME	TIMS	6	0	Distribution Schedule Period Start Time
49	DS_TIME_T	OIJ_TIME_T_DS	TIME	TIMS	6	0	Distribution Schedule Period End Time
50	DS_OFFSET	OIJ_OFFSET_DS	OIJ_OFFSET	INT1	3	0	Distribution Schedule Period Offset
51	DS_DURATION	OIJ_OFFSET_DUR_DS	TSTRDURAN	DEC	11	0	Distribution Schedule Period Duration (in hours:minutes)
52	SEL_VARIANT	OIJ_SEL_VARIANT	VARIANT	CHAR	14	0	Name of Selection Variant	VARID
53	.INCLUDE				0	0	Structure for 3WP screen control
54	FIELD_STATE	TRTYP	TRTYP	CHAR	1	0	Transaction type
55	SHOW_DMD	OIJ_SHOW_DMD	XFELD	CHAR	1	0	Display/Hide Demand Items Section
56	SHOW_SUP	OIJ_SHOW_SUP	XFELD	CHAR	1	0	Display/Hide Supply Avails Section
57	SHOW_TRANS	OIJ_SHOW_TRANS	XFELD	CHAR	1	0	Display/Hide Transport Avails Section
58	SHOW_DS	OIJ_SHOW_DS	XFELD	CHAR	1	0	Display/Hide Distribution Schedule Section
59	SHOW_DS_PEG	OIJ_SHOW_PEG	XFELD	CHAR	1	0	Display/Hide Pegging Section
60	DMD_SIZE	OIJ_DMD_SIZE	INT4	INT4	10	0	Demand section size (width)
61	SUP_SIZE	OIJ_SUP_SIZE	INT4	INT4	10	0	Supply section size (width)
62	TRANS_SIZE	OIJ_TRANS_SIZE	INT4	INT4	10	0	Transport section size (width)
63	DS_SIZE	OIJ_DS_SIZE	INT4	INT4	10	0	Distribution Schedule section size (height)
64	TOP_SIZE	OIJ_TOP_SIZE	INT4	INT4	10	0	Top section size (height)
65	DS_PEG_SIZE	OIJ_PEG_SIZE	INT4	INT4	10	0	DS Pegging section size (height)
66	SHOW_FOOTER_CON	OIJ_SHOW_FOOTER_CON	XFELD	CHAR	1	0	Display/Hide Footer Container
67	FOOTER_SIZE	OIJ_FOOTER_SIZE	INT4	INT4	10	0	Footer section (height)
68	SHOW_TREE_CON	OIJ_SHOW_TREE_CON	XFELD	CHAR	1	0	Display/Hide Tree Container
69	TREE_SIZE	OIJ_TREE_SIZE	INT4	INT4	10	0	Tree section size (width)
70	SHOW_DMD_TREE	OIJ_SHOW_DMD_TR	XFELD	CHAR	1	0	Display/Hide Demand Tree
71	SHOW_SUP_TREE	OIJ_SHOW_SUP_TR	XFELD	CHAR	1	0	Display/Hide Supply Tree
72	SHOW_TRANS_TREE	OIJ_SHOW_TRANS_TR	XFELD	CHAR	1	0	Display/Hide Transport Avails Tree
73	SHOW_DS_TREE	OIJ_SHOW_DS_TR	XFELD	CHAR	1	0	Display/Hide Distribution Schedule Tree
74	DMD_TREE_SIZE	OIJ_DMD_TR_SIZE	INT4	INT4	10	0	Demand Tree section size (height)
75	SUP_TREE_SIZE	OIJ_SUP_TR_SIZE	INT4	INT4	10	0	Supply Tree section size (height)
76	TRANS_TREE_SIZE	OIJ_TRANS_TR_SIZE	INT4	INT4	10	0	Transport Tree section size (height)
77	DS_TREE_SIZE	OIJ_DS_TR_SIZE	INT4	INT4	10	0	Distribution Schedule Tree section size (height)
78	SHOW_TITLE	OIJ_SHOW_ALV_TITLE	XFELD	CHAR	1	0	Display/Hide Title for ALV Grids
79	SHOW_CONSUMED	OIJ_SHOW_CONS	XFELD	CHAR	1	0	Display/Hide Consumed Lines in ALV Grids
80	SHOW_DS_DETAIL	OIJ_SHOW_DS_DETAIL	XFELD	CHAR	1	0	Display/Hide Detailed Distribution Schedule Lines
81	TRANS_COLOR	OIJ_TRANS_COLOR	CHAR4	CHAR	4	0	ALV Color code for highlighted transport avails
82	ASGCTX_FCODE	OIJ_CTX_FCODE	SYCHAR70	CHAR	70	0	Context menu function code
83	NEW_SEL	OIJ_NEW_SEL	XFELD	CHAR	1	0	New selection flag
84	UNASGCTX_FCODE	OIJ_CTX_FCODE	SYCHAR70	CHAR	70	0	Context menu function code
85	PUBLCTX_FCODE	OIJ_CTX_FCODE	SYCHAR70	CHAR	70	0	Context menu function code
86	PEGCTX_FCODE	OIJ_CTX_FCODE	SYCHAR70	CHAR	70	0	Context menu function code
87	SHOW_PUBL	OIJ_SHOW_PUBL	XFELD	CHAR	1	0	Display/Hide Published Lines in Distribution Schedule
88	.INCLUDE				0	0	Date, time and name of creation and change in txn-data
89	ERDAT	ERDAT	DATUM	DATS	8	0	Date on which the record was created
90	ERTIM	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	AETIM	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