OIJ_PLAN_PRF SAP table for - 3WP Planning Profile

Table of Contents

Here we would like to draw your attention to OIJ_PLAN_PRF table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIJ_PLAN_PRF is a SAP standard transp table used for storing 3WP Planning Profile related data in SAP. It comes under the package OIJ.

SAP OIJ_PLAN_PRF table

Table OIJ_PLAN_PRF technical data

Table	OIJ_PLAN_PRF
Data storing	3WP Planning Profile
Module	IS-OIL
Sub Module	IS-OIL-DS-TSW
SAP Package	OIJ
Delivery Class	A – Application table (master and transaction data)
Component	IS-OIL
Table Category	TRANSP

SAP OIJ_PLAN_PRF Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIJ_PLAN_PRF table.

MANDT : Client
Its a key field. Its data type is CLNT (Character with length 3) with field length 3

PROFILE_ID : Planning profile ID
Its a key field. Its data type is CHAR (Character String) with field length 22

PROFILE_TXT : Planning Profile Description
Its data type is CHAR (Character String) with field length 30

D_CHECKBOX : Select no Demand Items
Its data type is CHAR (Character String) with field length 1

S_CHECKBOX : Select no Supply Avails
Its data type is CHAR (Character String) with field length 1

T_CHECKBOX : Select no Transportation Avails
Its data type is CHAR (Character String) with field length 1

DS_CHECKBOX : Select no Distribution Schedule Items
Its data type is CHAR (Character String) with field length 1

G_BOM_CHECKBOX : BOM Explosion
Its data type is CHAR (Character String) with field length 1

G_PS_CHECKBOX : Pegging to Stock
Its data type is CHAR (Character String) with field length 1

G_MAXSEL : Maximum Number of Selected Entries
Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10

G_UNIT : General unit of measure
Its data type is UNIT (Unit key for a Quantity field) with field length 3

G_TIME_UNIT : Scheduled UoM Time
Its data type is UNIT (Unit key for a Quantity field) with field length 3

.INCLUDE : General Period

G_DATE_F : General Period Start Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

G_DATE_T : General Period End Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

G_TIME_F : General Period Start Time
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

G_TIME_T : General Period End Time
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

G_OFFSET : General Period Offset
Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3

G_DURATION : General Period Duration (in hours:minutes)
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11

.INCLUDE : Demand Period

D_DATE_F : Demand Period Start Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

D_DATE_T : Demand Period End Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

D_TIME_F : Demand Period Start Time
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

D_TIME_T : Demand Period End Time
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

D_OFFSET : Demand Period Offset
Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3

D_DURATION : Demand Period Duration (in hours:minutes)
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11

.INCLUDE : Supply Period

S_DATE_F : Supply Period Start Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

S_DATE_T : Supply Period End Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

S_TIME_F : Supply Period Start Time
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

S_TIME_T : Supply Period End Time
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

S_OFFSET : Supply Period Offset
Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3

S_DURATION : Supply Period Duration (in hours:minutes)
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11

.INCLUDE : Transport Period

T_DATE_F : Transport Period Start Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

T_DATE_T : Transport Period End Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

T_TIME_F : Transport Period Start Time
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

T_TIME_T : Transport Period End Time
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

T_OFFSET : Transport Period Offset
Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3

T_DURATION : Transport Period Duration (in hours:minutes)
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11

T_MINAV : Minimum availability period [day]
Its data type is NUMC (Character String with Digits Only) with field length 3

T_VHRL : Nomination relevance period [day]
Its data type is NUMC (Character String with Digits Only) with field length 3

T_REMCAP_QUAN : Remaining Capacity in Quantity
Its data type is QUAN (Quantity field) with field length 13

T_REMCAP_PERC : Remaining capacity in percentage
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4

.INCLUDE : Distribution Schedule Period

DS_DATE_F : Distribution Schedule Period Start Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DS_DATE_T : Distribution Schedule Period End Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DS_TIME_F : Distribution Schedule Period Start Time
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

DS_TIME_T : Distribution Schedule Period End Time
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

DS_OFFSET : Distribution Schedule Period Offset
Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3

DS_DURATION : Distribution Schedule Period Duration (in hours:minutes)
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11

SEL_VARIANT : Name of Selection Variant
Its data type is CHAR (Character String) with field length 14

.INCLUDE : Structure for 3WP screen control

FIELD_STATE : Transaction type
Its data type is CHAR (Character String) with field length 1

SHOW_DMD : Display/Hide Demand Items Section
Its data type is CHAR (Character String) with field length 1

SHOW_SUP : Display/Hide Supply Avails Section
Its data type is CHAR (Character String) with field length 1

SHOW_TRANS : Display/Hide Transport Avails Section
Its data type is CHAR (Character String) with field length 1

SHOW_DS : Display/Hide Distribution Schedule Section
Its data type is CHAR (Character String) with field length 1

SHOW_DS_PEG : Display/Hide Pegging Section
Its data type is CHAR (Character String) with field length 1

DMD_SIZE : Demand section size (width)
Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10

SUP_SIZE : Supply section size (width)
Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10

TRANS_SIZE : Transport section size (width)
Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10

DS_SIZE : Distribution Schedule section size (height)
Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10

TOP_SIZE : Top section size (height)
Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10

DS_PEG_SIZE : DS Pegging section size (height)
Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10

SHOW_FOOTER_CON : Display/Hide Footer Container
Its data type is CHAR (Character String) with field length 1

FOOTER_SIZE : Footer section (height)
Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10

SHOW_TREE_CON : Display/Hide Tree Container
Its data type is CHAR (Character String) with field length 1

TREE_SIZE : Tree section size (width)
Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10

SHOW_DMD_TREE : Display/Hide Demand Tree
Its data type is CHAR (Character String) with field length 1

SHOW_SUP_TREE : Display/Hide Supply Tree
Its data type is CHAR (Character String) with field length 1

SHOW_TRANS_TREE : Display/Hide Transport Avails Tree
Its data type is CHAR (Character String) with field length 1

SHOW_DS_TREE : Display/Hide Distribution Schedule Tree
Its data type is CHAR (Character String) with field length 1

DMD_TREE_SIZE : Demand Tree section size (height)
Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10

SUP_TREE_SIZE : Supply Tree section size (height)
Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10

TRANS_TREE_SIZE : Transport Tree section size (height)
Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10

DS_TREE_SIZE : Distribution Schedule Tree section size (height)
Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10

SHOW_TITLE : Display/Hide Title for ALV Grids
Its data type is CHAR (Character String) with field length 1

SHOW_CONSUMED : Display/Hide Consumed Lines in ALV Grids
Its data type is CHAR (Character String) with field length 1

SHOW_DS_DETAIL : Display/Hide Detailed Distribution Schedule Lines
Its data type is CHAR (Character String) with field length 1

TRANS_COLOR : ALV Color code for highlighted transport avails
Its data type is CHAR (Character String) with field length 4

ASGCTX_FCODE : Context menu function code
Its data type is CHAR (Character String) with field length 70

NEW_SEL : New selection flag
Its data type is CHAR (Character String) with field length 1

UNASGCTX_FCODE : Context menu function code
Its data type is CHAR (Character String) with field length 70

PUBLCTX_FCODE : Context menu function code
Its data type is CHAR (Character String) with field length 70

PEGCTX_FCODE : Context menu function code
Its data type is CHAR (Character String) with field length 70

SHOW_PUBL : Display/Hide Published Lines in Distribution Schedule
Its data type is CHAR (Character String) with field length 1

.INCLUDE : Date, time and name of creation and change in txn-data

ERDAT : Date on which the record was created
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

ERTIM : Time of creation
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

ERNAM : Name of Person who Created the Object
Its data type is CHAR (Character String) with field length 12

AEDAT : Last Changed On
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

AETIM : Time of day the record was changed
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

AENAM : Name of Person Who Changed Object
Its data type is CHAR (Character String) with field length 12

OIJ_PLAN_PRF related tables

OIJ_LMTIMECON : OILTSW: Time dependent constraints by location & material
OIJPEG : TSW: Pegging of scheduled movements
B453 : Shpm.type/Carrier/Inspector/Shipper/TranSys/TrspPlanPt
OIJ_SP_FLTVALT : Stock projection filter values for BADI – text table
OIJ_NOMEV_CHK_A : Assignment of nomination item check routines to val.grp.
TOIJ_NOM_FIELD : Stores fields for different nomination views
OIJRDTYP : OIL-TSW : Partner Roles differentiation Types
OIJ_CONS_TYPET : TSW Texts for Time-Dependent Constraint Types
OIJTHPUTFCEST : OIL-TSW: Rack issue / Throughput estimate pop-up
OIJ_EL_TKT_I_O1 : Appendix: TSW Ticket item – Conversion Parameters
TOIJ_DET_DATE : Rules for pricing date determination
OIJ_NOM_CHK_GT : Nomination validation groups
OIJTSLOC : OIL-TSW: transport system/location assignment table
TOIJ_NOMV_CAPTCT : Customized screen sequence for tabstrip captions
OIJPLSEQ : OIL-TSW: Planning Functionality : Supply Chain Definitions
OIJEV : TD-Vehicle ~ Berth Master Data Events
TOIJNOM_EV02 : Nomination event profiles
TOIJ_PEG_CHK_R : Nomination item check routines
B445 : OIL-TSW: Carrier
OIJPLANLOC : OIL TSW: Multiple planning Locations

OIJ_PLAN_PRF related transaction codes under SAP package OIJ

O4TK : TSW archiving – Nomination
O4NSN : Display Nomination
S_SO7_65001272 : IMG activity: SIMG_OIJ_TSW_043
O4TM : OIL-TSW: Safety stock calc. engine
S_SO7_65001269 : IMG activity: SIMG_OIJ_TSW_040
O4TW : OIL-TSW Create Location
O4NM : Maintain Nomination
S_SOG_81000112 : IMG activity: SIMG_OIJ_TSW_1114
O4TSCD : Display Transport System Changes
S_SOG_81000090 : IMG activity: SIMG_OIJ_TSW_105
O5TB : Maintain output det procedure – NOM
S_SOG_81000087 : IMG activity: SIMG_OIJ_TSW_102
S_SO7_65001271 : IMG activity: SIMG_OIJ_TSW_042
S_SO7_65001315 : IMG activity: SIMG_OIJ_TSW_058
O4LB_OI : Loc Bal opening inventory calc
O4TI : TSW archiving – Tickets
O4TY : OIL-TSW Display Location
O4TL : TSW Delete Transport System
S_SO5_65000244 : IMG activity: SIMG_TSW_0022
O4TB_CT : Change What-if type

OIJ_PLAN_PRF SAP table for – 3WP Planning Profile

Table OIJ_PLAN_PRF technical data

SAP OIJ_PLAN_PRF Table Fields

OIJ_PLAN_PRF related tables

OIJ_PLAN_PRF related transaction codes under SAP package OIJ

Related References

About SAP

Most Popular

SAP Analytics & Administration

Useful References

OIJ_PLAN_PRF SAP table for – 3WP Planning Profile

Table OIJ_PLAN_PRF technical data

SAP OIJ_PLAN_PRF Table Fields

OIJ_PLAN_PRF related tables

OIJ_PLAN_PRF related transaction codes under SAP package OIJ

Related References

Related Tutorials

About SAP

Most Popular

SAP Analytics & Administration

Useful References