OIJ_PLAN_PRF SAP (3WP Planning Profile) Table details
Dictionary Type: Table
Description: 3WP Planning Profile
Description: 3WP Planning Profile
Table field list including key, data, relationships and ABAP select examples
OIJ_PLAN_PRF is a standard SAP Table which is used to store 3WP Planning Profile data and is available within R/3 SAP systems depending on the version and release level.
The OIJ_PLAN_PRF table consists of various fields, each holding specific information or linking keys about 3WP Planning Profile data available in SAP. These include PROFILE_ID (Planning profile ID), PROFILE_TXT (Planning Profile Description), D_CHECKBOX (Select no Demand Items), S_CHECKBOX (Select no Supply Avails).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP OIJ_PLAN_PRF table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PROFILE_ID | Planning profile ID | OIJ_PROFILE_ID | CHAR | 22 | OIJ_PROFILE_ID | OIJ_3WP_PROFILE_ID | OIJ_PROFILE | ||
PROFILE_TXT | Planning Profile Description | OIJ_PROFILE_TXT | CHAR | 30 | CHAR30 | ||||
D_CHECKBOX | Select no Demand Items | OIJ_XFLAG_DMD | CHAR | 1 | XFELD | ||||
S_CHECKBOX | Select no Supply Avails | OIJ_XFLAG_SUP | CHAR | 1 | XFELD | ||||
T_CHECKBOX | Select no Transportation Avails | OIJ_XFLAG_TRANS | CHAR | 1 | XFELD | ||||
DS_CHECKBOX | Select no Distribution Schedule Items | OIJ_XFLAG_DS | CHAR | 1 | XFELD | ||||
G_BOM_CHECKBOX | BOM Explosion | OIJ_XFLAG_BOM | CHAR | 1 | XFELD | ||||
G_PS_CHECKBOX | Pegging to Stock | OIJ_XFLAG_PS | CHAR | 1 | XFELD | ||||
G_MAXSEL | Maximum Number of Selected Entries | TBMAXSEL | INT4 | 10 | SYST_LONG | ||||
G_UNIT | General unit of measure | OIJ_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
G_TIME_UNIT | Scheduled UoM Time | OIJ_UNITI_T | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
G_DATE_F | General Period Start Date | OIJ_DATE_F_GEN | DATS | 8 | DATS | ||||
G_DATE_T | General Period End Date | OIJ_DATE_T_GEN | DATS | 8 | DATS | ||||
G_TIME_F | General Period Start Time | OIJ_TIME_F_GEN | TIMS | 6 | TIME | ||||
G_TIME_T | General Period End Time | OIJ_TIME_T_GEN | TIMS | 6 | TIME | ||||
G_OFFSET | General Period Offset | OIJ_OFFSET_GEN | INT1 | 3 | OIJ_OFFSET | ||||
G_DURATION | General Period Duration (in hours:minutes) | OIJ_OFFSET_DUR_GEN | DEC | 11 | TSTRN | TSTRDURAN | |||
D_DATE_F | Demand Period Start Date | OIJ_DATE_F_DMD | DATS | 8 | DATS | ||||
D_DATE_T | Demand Period End Date | OIJ_DATE_T_DMD | DATS | 8 | DATS | ||||
D_TIME_F | Demand Period Start Time | OIJ_TIME_F_DMD | TIMS | 6 | TIME | ||||
D_TIME_T | Demand Period End Time | OIJ_TIME_T_DMD | TIMS | 6 | TIME | ||||
D_OFFSET | Demand Period Offset | OIJ_OFFSET_DMD | INT1 | 3 | OIJ_OFFSET | ||||
D_DURATION | Demand Period Duration (in hours:minutes) | OIJ_OFFSET_DUR_DMD | DEC | 11 | TSTRN | TSTRDURAN | |||
S_DATE_F | Supply Period Start Date | OIJ_DATE_F_SUP | DATS | 8 | DATS | ||||
S_DATE_T | Supply Period End Date | OIJ_DATE_T_SUP | DATS | 8 | DATS | ||||
S_TIME_F | Supply Period Start Time | OIJ_TIME_F_SUP | TIMS | 6 | TIME | ||||
S_TIME_T | Supply Period End Time | OIJ_TIME_T_SUP | TIMS | 6 | TIME | ||||
S_OFFSET | Supply Period Offset | OIJ_OFFSET_SUP | INT1 | 3 | OIJ_OFFSET | ||||
S_DURATION | Supply Period Duration (in hours:minutes) | OIJ_OFFSET_DUR_SUP | DEC | 11 | TSTRN | TSTRDURAN | |||
T_DATE_F | Transport Period Start Date | OIJ_DATE_F_TRANS | DATS | 8 | DATS | ||||
T_DATE_T | Transport Period End Date | OIJ_DATE_T_TRANS | DATS | 8 | DATS | ||||
T_TIME_F | Transport Period Start Time | OIJ_TIME_F_TRANS | TIMS | 6 | TIME | ||||
T_TIME_T | Transport Period End Time | OIJ_TIME_T_TRANS | TIMS | 6 | TIME | ||||
T_OFFSET | Transport Period Offset | OIJ_OFFSET_TRANS | INT1 | 3 | OIJ_OFFSET | ||||
T_DURATION | Transport Period Duration (in hours:minutes) | OIJ_OFFSET_DUR_TRANS | DEC | 11 | TSTRN | TSTRDURAN | |||
T_MINAV | Minimum availability period [day] | OIJ_PERIOD_MINAV | NUMC | 3 | ANZTA | ||||
T_VHRL | Nomination relevance period [day] | OIJ_PERIOD_VHRL | NUMC | 3 | ANZTA | ||||
T_REMCAP_QUAN | Remaining Capacity in Quantity | OIJ_REMCAP_QUAN | QUAN | 13(3) | MENG13 | ||||
T_REMCAP_PERC | Remaining capacity in percentage | OIJ_REMCAP_PERC | DEC | 4(1) | DEC3_1 | ||||
DS_DATE_F | Distribution Schedule Period Start Date | OIJ_DATE_F_DS | DATS | 8 | DATS | ||||
DS_DATE_T | Distribution Schedule Period End Date | OIJ_DATE_T_DS | DATS | 8 | DATS | ||||
DS_TIME_F | Distribution Schedule Period Start Time | OIJ_TIME_F_DS | TIMS | 6 | TIME | ||||
DS_TIME_T | Distribution Schedule Period End Time | OIJ_TIME_T_DS | TIMS | 6 | TIME | ||||
DS_OFFSET | Distribution Schedule Period Offset | OIJ_OFFSET_DS | INT1 | 3 | OIJ_OFFSET | ||||
DS_DURATION | Distribution Schedule Period Duration (in hours:minutes) | OIJ_OFFSET_DUR_DS | DEC | 11 | TSTRN | TSTRDURAN | |||
SEL_VARIANT | Name of Selection Variant | OIJ_SEL_VARIANT | CHAR | 14 | VARID | VARIANT | |||
FIELD_STATE | Transaction type | TRTYP | CHAR | 1 | TRTYP | ||||
SHOW_DMD | Display/Hide Demand Items Section | OIJ_SHOW_DMD | CHAR | 1 | XFELD | ||||
SHOW_SUP | Display/Hide Supply Avails Section | OIJ_SHOW_SUP | CHAR | 1 | XFELD | ||||
SHOW_TRANS | Display/Hide Transport Avails Section | OIJ_SHOW_TRANS | CHAR | 1 | XFELD | ||||
SHOW_DS | Display/Hide Distribution Schedule Section | OIJ_SHOW_DS | CHAR | 1 | XFELD | ||||
SHOW_DS_PEG | Display/Hide Pegging Section | OIJ_SHOW_PEG | CHAR | 1 | XFELD | ||||
DMD_SIZE | Demand section size (width) | OIJ_DMD_SIZE | INT4 | 10 | INT4 | ||||
SUP_SIZE | Supply section size (width) | OIJ_SUP_SIZE | INT4 | 10 | INT4 | ||||
TRANS_SIZE | Transport section size (width) | OIJ_TRANS_SIZE | INT4 | 10 | INT4 | ||||
DS_SIZE | Distribution Schedule section size (height) | OIJ_DS_SIZE | INT4 | 10 | INT4 | ||||
TOP_SIZE | Top section size (height) | OIJ_TOP_SIZE | INT4 | 10 | INT4 | ||||
DS_PEG_SIZE | DS Pegging section size (height) | OIJ_PEG_SIZE | INT4 | 10 | INT4 | ||||
SHOW_FOOTER_CON | Display/Hide Footer Container | OIJ_SHOW_FOOTER_CON | CHAR | 1 | XFELD | ||||
FOOTER_SIZE | Footer section (height) | OIJ_FOOTER_SIZE | INT4 | 10 | INT4 | ||||
SHOW_TREE_CON | Display/Hide Tree Container | OIJ_SHOW_TREE_CON | CHAR | 1 | XFELD | ||||
TREE_SIZE | Tree section size (width) | OIJ_TREE_SIZE | INT4 | 10 | INT4 | ||||
SHOW_DMD_TREE | Display/Hide Demand Tree | OIJ_SHOW_DMD_TR | CHAR | 1 | XFELD | ||||
SHOW_SUP_TREE | Display/Hide Supply Tree | OIJ_SHOW_SUP_TR | CHAR | 1 | XFELD | ||||
SHOW_TRANS_TREE | Display/Hide Transport Avails Tree | OIJ_SHOW_TRANS_TR | CHAR | 1 | XFELD | ||||
SHOW_DS_TREE | Display/Hide Distribution Schedule Tree | OIJ_SHOW_DS_TR | CHAR | 1 | XFELD | ||||
DMD_TREE_SIZE | Demand Tree section size (height) | OIJ_DMD_TR_SIZE | INT4 | 10 | INT4 | ||||
SUP_TREE_SIZE | Supply Tree section size (height) | OIJ_SUP_TR_SIZE | INT4 | 10 | INT4 | ||||
TRANS_TREE_SIZE | Transport Tree section size (height) | OIJ_TRANS_TR_SIZE | INT4 | 10 | INT4 | ||||
DS_TREE_SIZE | Distribution Schedule Tree section size (height) | OIJ_DS_TR_SIZE | INT4 | 10 | INT4 | ||||
SHOW_TITLE | Display/Hide Title for ALV Grids | OIJ_SHOW_ALV_TITLE | CHAR | 1 | XFELD | ||||
SHOW_CONSUMED | Display/Hide Consumed Lines in ALV Grids | OIJ_SHOW_CONS | CHAR | 1 | XFELD | ||||
SHOW_DS_DETAIL | Display/Hide Detailed Distribution Schedule Lines | OIJ_SHOW_DS_DETAIL | CHAR | 1 | XFELD | ||||
TRANS_COLOR | ALV Color code for highlighted transport avails | OIJ_TRANS_COLOR | CHAR | 4 | CHAR4 | ||||
ASGCTX_FCODE | Context menu function code | OIJ_CTX_FCODE | CHAR | 70 | SYCHAR70 | ||||
NEW_SEL | New selection flag | OIJ_NEW_SEL | CHAR | 1 | XFELD | ||||
UNASGCTX_FCODE | Context menu function code | OIJ_CTX_FCODE | CHAR | 70 | SYCHAR70 | ||||
PUBLCTX_FCODE | Context menu function code | OIJ_CTX_FCODE | CHAR | 70 | SYCHAR70 | ||||
PEGCTX_FCODE | Context menu function code | OIJ_CTX_FCODE | CHAR | 70 | SYCHAR70 | ||||
SHOW_PUBL | Display/Hide Published Lines in Distribution Schedule | OIJ_SHOW_PUBL | CHAR | 1 | XFELD | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERTIM | Time of creation | OI0_ERTIM | TIMS | 6 | UZEIT | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AETIM | Time of day the record was changed | OI0_AETIM | TIMS | 6 | UZEIT | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM |
Key field | Non-key field |
How do I retrieve data from SAP table OIJ_PLAN_PRF using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIJ_PLAN_PRF to SELECT all data from the tableDATA: WA_OIJ_PLAN_PRF TYPE OIJ_PLAN_PRF.
SELECT SINGLE *
FROM OIJ_PLAN_PRF
INTO CORRESPONDING FIELDS OF WA_OIJ_PLAN_PRF
WHERE...
How to access SAP table OIJ_PLAN_PRF
Within an ECC or HANA version of SAP you can also view further information about OIJ_PLAN_PRF and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects