OIJ_PLAN_PRF

3WP Planning Profile | #masterdata | Component: Trader's and Scheduler's Workbench
Column Name Description
MANDT FK Client
PROFILE_ID Planning profile ID
Column Name Description
Column Name Description
📏 General unit of measure (G_UNIT):
T_REMCAP_QUAN Remaining Capacity in Quantity
Column Name Description
G_DATE_F General Period Start Date
G_DATE_T General Period End Date
G_TIME_F General Period Start Time
G_TIME_T General Period End Time
D_DATE_F Demand Period Start Date
D_DATE_T Demand Period End Date
D_TIME_F Demand Period Start Time
D_TIME_T Demand Period End Time
S_DATE_F Supply Period Start Date
S_DATE_T Supply Period End Date
S_TIME_F Supply Period Start Time
S_TIME_T Supply Period End Time
T_DATE_F Transport Period Start Date
T_DATE_T Transport Period End Date
T_TIME_F Transport Period Start Time
T_TIME_T Transport Period End Time
DS_DATE_F Distribution Schedule Period Start Date
DS_DATE_T Distribution Schedule Period End Date
DS_TIME_F Distribution Schedule Period Start Time
DS_TIME_T Distribution Schedule Period End Time
ERDAT Date on which the record was created
ERTIM Time of creation
AEDAT Last Changed On
AETIM Time of day the record was changed
Column Name Description
D_CHECKBOX Select no Demand Items Show values
S_CHECKBOX Select no Supply Avails Show values
T_CHECKBOX Select no Transportation Avails Show values
DS_CHECKBOX Select no Distribution Schedule Items Show values
G_BOM_CHECKBOX BOM Explosion Show values
G_PS_CHECKBOX Pegging to Stock Show values
FIELD_STATE Transaction type Show values
SHOW_DMD Display/Hide Demand Items Section Show values
SHOW_SUP Display/Hide Supply Avails Section Show values
SHOW_TRANS Display/Hide Transport Avails Section Show values
SHOW_DS Display/Hide Distribution Schedule Section Show values
SHOW_DS_PEG Display/Hide Pegging Section Show values
SHOW_FOOTER_CON Display/Hide Footer Container Show values
SHOW_TREE_CON Display/Hide Tree Container Show values
SHOW_DMD_TREE Display/Hide Demand Tree Show values
SHOW_SUP_TREE Display/Hide Supply Tree Show values
SHOW_TRANS_TREE Display/Hide Transport Avails Tree Show values
SHOW_DS_TREE Display/Hide Distribution Schedule Tree Show values
SHOW_TITLE Display/Hide Title for ALV Grids Show values
SHOW_CONSUMED Display/Hide Consumed Lines in ALV Grids Show values
SHOW_DS_DETAIL Display/Hide Detailed Distribution Schedule Lines Show values
NEW_SEL New selection flag Show values
SHOW_PUBL Display/Hide Published Lines in Distribution Schedule Show values
Column Name Description Domain name
PROFILE_TXT Planning Profile Description CHAR30
G_MAXSEL Maximum Number of Selected Entries SYST_LONG
G_OFFSET General Period Offset OIJ_OFFSET
G_DURATION General Period Duration (in hours:minutes) TSTRDURAN
D_OFFSET Demand Period Offset OIJ_OFFSET
D_DURATION Demand Period Duration (in hours:minutes) TSTRDURAN
S_OFFSET Supply Period Offset OIJ_OFFSET
S_DURATION Supply Period Duration (in hours:minutes) TSTRDURAN
T_OFFSET Transport Period Offset OIJ_OFFSET
T_DURATION Transport Period Duration (in hours:minutes) TSTRDURAN
T_MINAV Minimum availability period [day] ANZTA
T_VHRL Nomination relevance period [day] ANZTA
T_REMCAP_PERC Remaining capacity in percentage DEC3_1
DS_OFFSET Distribution Schedule Period Offset OIJ_OFFSET
DS_DURATION Distribution Schedule Period Duration (in hours:minutes) TSTRDURAN
DMD_SIZE Demand section size (width) INT4
SUP_SIZE Supply section size (width) INT4
TRANS_SIZE Transport section size (width) INT4
DS_SIZE Distribution Schedule section size (height) INT4
TOP_SIZE Top section size (height) INT4
DS_PEG_SIZE DS Pegging section size (height) INT4
FOOTER_SIZE Footer section (height) INT4
TREE_SIZE Tree section size (width) INT4
DMD_TREE_SIZE Demand Tree section size (height) INT4
SUP_TREE_SIZE Supply Tree section size (height) INT4
TRANS_TREE_SIZE Transport Tree section size (height) INT4
DS_TREE_SIZE Distribution Schedule Tree section size (height) INT4
TRANS_COLOR ALV Color code for highlighted transport avails CHAR4
ASGCTX_FCODE Context menu function code SYCHAR70
UNASGCTX_FCODE Context menu function code SYCHAR70
PUBLCTX_FCODE Context menu function code SYCHAR70
PEGCTX_FCODE Context menu function code SYCHAR70
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Client OIJ_PLAN_PRF.MANDT == T000.MANDT
Other Relations Join Conditions
Name of Selection Variant
  • ?
  • Name of Selection Variant
  • ?
  • ?
  • OIJ_PLAN_PRF.MANDT == VARID.MANDT
  • OIJ_PLAN_PRF.[column in domain "VARI_REPRT"] == VARID.REPORT
  • OIJ_PLAN_PRF.SEL_VARIANT == VARID.VARIANT
  • OIJ_PLAN_PRF.[column in domain "SYCHAR01"] == VARID.FLAG2
  • OIJ_PLAN_PRF.[column in domain "SYCHAR01"] == VARID.FLAG1