BW Master data Frozen period

Each end of year, the main BW master data (about the structure) which are not time-dependent need to be freeze = no more loading from ECC or flat file on these main master data.

And to avoid the impact of the new evolution scheduled for next year on the yearly closing a freeze is applied to block the loading to allow the yearly closing period with the same scope done for the year and not with inputs for next yeart, for some master data, the loading are freeze in the middle of December until end of January.

Global filter to setup

Process : Finance Data team (tania.faria@solvay.com from SU MAC Data, KM & Reporting)  have to inform BW team about the frozen period and BW team update one records of the global filter.

Master data : C_GLBFILT Global Filter

Stream =  Global

RULE = SFREEZE

Low = start date of the freeze in the format YYYYMMDD

High = end date of the freeze in the format YYYYMMDD

The process chain will have the enhance decision flow to have abap code to

SFreeze Active 

FORM EVALUATE CHANGING P_RETURN TYPE BOOL. "p_return = X then true else false

  DATA: LV_SFREEZE LIKE /BIC/PC_GLBFILT.

  SELECT SINGLE * FROM /BIC/PC_GLBFILT INTO LV_SFREEZE
  WHERE /BIC/C_STREAM = 'GLOBAL'
  AND /BIC/C_RULE = 'SFREEZE'
  AND /BIC/C_GLBFILT = '1'
  AND OBJVERS = 'A'
  AND /BIC/C_ACTIVE = 'Y'.

  IF SY-SUBRC = 0.
    IF ( SY-DATUM >= LV_SFREEZE-/BIC/C_LOW ) AND ( SY-DATUM <= LV_SFREEZE-/BIC/C_HIGH ).
      P_RETURN = 'X'.
    ENDIF.
  ENDIF.
ENDFORM.    

See below the audit done on master data :

Yearly Process Chain

Since we have issue of master data is not updated correct after unfreeze in 2020, we need to update material plants after C_CDSA, C_SUBACT2, 0G_CWWE01 are updated.  Therefore, we need to create a new PC_MD_02 to run yearly after FREQUENTLY_LOAD_MD is completed. 

However, we have loading conflict in 2022 after unlock. Therefore, the PC_MD_02 should run yearly around 18:00 CET on the date of unfreeze to avoid the loading conflict because this PC would take around 7.3 hours to complete

FREQUENTLY_LOAD_MD finish 14:00
PC_FIWC_02 finish 18:00