OIJ_PLAN_PRF - 3WP Planning Profile

3WP Planning Profile information is stored in SAP table OIJ_PLAN_PRF.
It is part of development package OIJ in software component IS-OIL-DS-TSW. This development package consists of objects that can be grouped under "TSW Traders and Schedulers Workbench".

Fields for table OIJ_PLAN_PRF

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
PROFILE_ID	Planning profile ID	X	OIJ_PROFILE_ID	CHAR	44
PROFILE_TXT	Planning Profile Description		OIJ_PROFILE_TXT	CHAR	60
D_CHECKBOX	Select no Demand Items		OIJ_XFLAG_DMD	CHAR	2
S_CHECKBOX	Select no Supply Avails		OIJ_XFLAG_SUP	CHAR	2
T_CHECKBOX	Select no Transportation Avails		OIJ_XFLAG_TRANS	CHAR	2
DS_CHECKBOX	Select no Distribution Schedule Items		OIJ_XFLAG_DS	CHAR	2
G_BOM_CHECKBOX	BOM Explosion		OIJ_XFLAG_BOM	CHAR	2
G_PS_CHECKBOX	Pegging to Stock		OIJ_XFLAG_PS	CHAR	2
G_MAXSEL	Maximum Number of Selected Entries		TBMAXSEL	INT4	4
G_UNIT	General unit of measure		OIJ_UNIT	UNIT	6
G_TIME_UNIT	Scheduled UoM Time		OIJ_UNITI_T	UNIT	6
.INCLUDE				ROIJ_3WP_PERIOD_GEN	0
G_DATE_F	General Period Start Date		OIJ_DATE_F_GEN	DATS	16
G_DATE_T	General Period End Date		OIJ_DATE_T_GEN	DATS	16
G_TIME_F	General Period Start Time		OIJ_TIME_F_GEN	TIMS	12
G_TIME_T	General Period End Time		OIJ_TIME_T_GEN	TIMS	12
G_OFFSET	General Period Offset		OIJ_OFFSET_GEN	INT1	1
G_DURATION	General Period Duration (in hours:minutes)		OIJ_OFFSET_DUR_GEN	DEC	6
.INCLUDE				ROIJ_3WP_PERIOD_DMD	0
D_DATE_F	Demand Period Start Date		OIJ_DATE_F_DMD	DATS	16
D_DATE_T	Demand Period End Date		OIJ_DATE_T_DMD	DATS	16
D_TIME_F	Demand Period Start Time		OIJ_TIME_F_DMD	TIMS	12
D_TIME_T	Demand Period End Time		OIJ_TIME_T_DMD	TIMS	12
D_OFFSET	Demand Period Offset		OIJ_OFFSET_DMD	INT1	1
D_DURATION	Demand Period Duration (in hours:minutes)		OIJ_OFFSET_DUR_DMD	DEC	6
.INCLUDE				ROIJ_3WP_PERIOD_SUP	0
S_DATE_F	Supply Period Start Date		OIJ_DATE_F_SUP	DATS	16
S_DATE_T	Supply Period End Date		OIJ_DATE_T_SUP	DATS	16
S_TIME_F	Supply Period Start Time		OIJ_TIME_F_SUP	TIMS	12
S_TIME_T	Supply Period End Time		OIJ_TIME_T_SUP	TIMS	12
S_OFFSET	Supply Period Offset		OIJ_OFFSET_SUP	INT1	1
S_DURATION	Supply Period Duration (in hours:minutes)		OIJ_OFFSET_DUR_SUP	DEC	6
.INCLUDE				ROIJ_3WP_PERIOD_TRANS	0
T_DATE_F	Transport Period Start Date		OIJ_DATE_F_TRANS	DATS	16
T_DATE_T	Transport Period End Date		OIJ_DATE_T_TRANS	DATS	16
T_TIME_F	Transport Period Start Time		OIJ_TIME_F_TRANS	TIMS	12
T_TIME_T	Transport Period End Time		OIJ_TIME_T_TRANS	TIMS	12
T_OFFSET	Transport Period Offset		OIJ_OFFSET_TRANS	INT1	1
T_DURATION	Transport Period Duration (in hours:minutes)		OIJ_OFFSET_DUR_TRANS	DEC	6
T_MINAV	Minimum availability period [day]		OIJ_PERIOD_MINAV	NUMC	6
T_VHRL	Nomination relevance period [day]		OIJ_PERIOD_VHRL	NUMC	6
T_REMCAP_QUAN	Remaining Capacity in Quantity		OIJ_REMCAP_QUAN	QUAN	7
T_REMCAP_PERC	Remaining capacity in percentage		OIJ_REMCAP_PERC	DEC	3
.INCLUDE				ROIJ_3WP_PERIOD_DS	0
DS_DATE_F	Distribution Schedule Period Start Date		OIJ_DATE_F_DS	DATS	16
DS_DATE_T	Distribution Schedule Period End Date		OIJ_DATE_T_DS	DATS	16
DS_TIME_F	Distribution Schedule Period Start Time		OIJ_TIME_F_DS	TIMS	12
DS_TIME_T	Distribution Schedule Period End Time		OIJ_TIME_T_DS	TIMS	12
DS_OFFSET	Distribution Schedule Period Offset		OIJ_OFFSET_DS	INT1	1
DS_DURATION	Distribution Schedule Period Duration (in hours:minutes)		OIJ_OFFSET_DUR_DS	DEC	6
SEL_VARIANT	Name of Selection Variant		OIJ_SEL_VARIANT	CHAR	28	VARID
.INCLUDE				ROIJ_3WP_SCREEN_CTRL	0
FIELD_STATE	Transaction type		TRTYP	CHAR	2
SHOW_DMD	Display/Hide Demand Items Section		OIJ_SHOW_DMD	CHAR	2
SHOW_SUP	Display/Hide Supply Avails Section		OIJ_SHOW_SUP	CHAR	2
SHOW_TRANS	Display/Hide Transport Avails Section		OIJ_SHOW_TRANS	CHAR	2
SHOW_DS	Display/Hide Distribution Schedule Section		OIJ_SHOW_DS	CHAR	2
SHOW_DS_PEG	Display/Hide Pegging Section		OIJ_SHOW_PEG	CHAR	2
DMD_SIZE	Demand section size (width)		OIJ_DMD_SIZE	INT4	4
SUP_SIZE	Supply section size (width)		OIJ_SUP_SIZE	INT4	4
TRANS_SIZE	Transport section size (width)		OIJ_TRANS_SIZE	INT4	4
DS_SIZE	Distribution Schedule section size (height)		OIJ_DS_SIZE	INT4	4
TOP_SIZE	Top section size (height)		OIJ_TOP_SIZE	INT4	4
DS_PEG_SIZE	DS Pegging section size (height)		OIJ_PEG_SIZE	INT4	4
SHOW_FOOTER_CON	Display/Hide Footer Container		OIJ_SHOW_FOOTER_CON	CHAR	2
FOOTER_SIZE	Footer section (height)		OIJ_FOOTER_SIZE	INT4	4
SHOW_TREE_CON	Display/Hide Tree Container		OIJ_SHOW_TREE_CON	CHAR	2
TREE_SIZE	Tree section size (width)		OIJ_TREE_SIZE	INT4	4
SHOW_DMD_TREE	Display/Hide Demand Tree		OIJ_SHOW_DMD_TR	CHAR	2
SHOW_SUP_TREE	Display/Hide Supply Tree		OIJ_SHOW_SUP_TR	CHAR	2
SHOW_TRANS_TREE	Display/Hide Transport Avails Tree		OIJ_SHOW_TRANS_TR	CHAR	2
SHOW_DS_TREE	Display/Hide Distribution Schedule Tree		OIJ_SHOW_DS_TR	CHAR	2
DMD_TREE_SIZE	Demand Tree section size (height)		OIJ_DMD_TR_SIZE	INT4	4
SUP_TREE_SIZE	Supply Tree section size (height)		OIJ_SUP_TR_SIZE	INT4	4
TRANS_TREE_SIZE	Transport Tree section size (height)		OIJ_TRANS_TR_SIZE	INT4	4
DS_TREE_SIZE	Distribution Schedule Tree section size (height)		OIJ_DS_TR_SIZE	INT4	4
SHOW_TITLE	Display/Hide Title for ALV Grids		OIJ_SHOW_ALV_TITLE	CHAR	2
SHOW_CONSUMED	Display/Hide Consumed Lines in ALV Grids		OIJ_SHOW_CONS	CHAR	2
SHOW_DS_DETAIL	Display/Hide Detailed Distribution Schedule Lines		OIJ_SHOW_DS_DETAIL	CHAR	2
TRANS_COLOR	ALV Color code for highlighted transport avails		OIJ_TRANS_COLOR	CHAR	8
ASGCTX_FCODE	Context menu function code		OIJ_CTX_FCODE	CHAR	140
NEW_SEL	New selection flag		OIJ_NEW_SEL	CHAR	2
UNASGCTX_FCODE	Context menu function code		OIJ_CTX_FCODE	CHAR	140
PUBLCTX_FCODE	Context menu function code		OIJ_CTX_FCODE	CHAR	140
PEGCTX_FCODE	Context menu function code		OIJ_CTX_FCODE	CHAR	140
SHOW_PUBL	Display/Hide Published Lines in Distribution Schedule		OIJ_SHOW_PUBL	CHAR	2
.INCLUDE				OI0_ERDAT	0
ERDAT	Date on which the record was created		ERDAT	DATS	16
ERTIM	Time of creation		OI0_ERTIM	TIMS	12
ERNAM	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
AEDAT	Last Changed On		AEDAT	DATS	16
AETIM	Time of day the record was changed		OI0_AETIM	TIMS	12
AENAM	Name of Person Who Changed Object		AENAM	CHAR	24