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.

It is required to setup

1. Global filter to stop important master that can change the structure
2. Schedule yearly PC on the unfreeze date

1. Global filter to setup

1.1 SFREEZE

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. Normally, it will be mid of Dec to mid of Jan

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 .    

1.2. SFREEZE1 

In 2022, Financial team (Charlotte R) request to have another freeze that start to freeze only from 1 Jan until end of yearly freeze.  Then, we create a new global filter to freeze these master data and move master data to this freeze accordingly to the requirement

Master data: C_GLBFILT Global Filter

Stream = Global

RULE = SFREEZE1

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

SFreeze1 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 =  'SFREEZE1'
  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 . 

2. 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