Objective

Provide "Make or Buy" information in the SpP Raw Material process to deliver a Manufacturing adjusted cost.

This information is provided by Finance or Controlling and based on several calculations on their side, and therefore not available in SAP.

The indicators "Usage factor" and "Mixing ratio" must be manually populated by the Business at BOM Component / Plant level.

A calculation will be applied on each finished products concerned by these BOM Components.

Overall design

Concerned raw materials are identified in the ZCRIT transaction in PF1 with the critical flag “I” for internal and “E” for external.

A dedicated workbook allows users to fill “Usage factors” and “Mixing ratio” for those relevant Raw Materials.

A data flow push these Raw Materials information to the Manufacturing query, computing the “Adjusted Mixing Ratio” to apply to the Raw Material cost.

Roles & Access

Roles and access

List of application role + menu role  and explanation if we have several applications role with specials rules.

Authorization variables

List of authorization variables mandatory for the application.

Dataflow overview

BW Logic

The Critical Raw Material Master Data C_FLRMAT is used to identify the “Make or Buy” Products.

This Master Data is already used to retrieve Raw Material information like Critical flag, Buyer name, Buyer currency, Buyer unit, Classification.

The source of this information is located in PF1 system for SpP, where the table ZFI_ICM_CRITIC is populated by Business through transaction ZCRIT.

The field “Critical flag” (C_FLRMATF) is used to identify “Make or Buy” Products.

Available values for the field are :

“ “  : Not critical

“X” : Critical

“B” : Critical No BOM

“I”  : Critical Internal

“E” : Critical External

The BW data flow logic is based on an intermediate buffer ADSO, allowing the save of the previously input value from Business, and the update from the latest data coming from the Critical Raw Material Master Data C_FLRMAT.

The chronology is the following (see red bullets in above graphic) :

1. Load full content of Planning ADSO to Buffer ADSO
2. Load Critical Raw Mat 'I' and 'E' to Buffer ADSO
3. Delete full content of Planning ADSO
4. Load full content of Buffer ADSO to Planning ADSO
5. Update “Usage factors” and “Mixing ratio” in Planning ADSO from workbook

The Planning ADSO is then source of the Manufacturing data flow, applying the “Adjusted Mixing Ratio” to the finished products price concerned by these Components.

Therefore, the Raw Material Forecast price must have been confirmed and sent to Manufacturing before the "Make or Buy" process (Raw Material Forecast#Objective).

Dependencies with other applications

There is a dependency with : 

InfoObjects : C_FLRMAT, C_GLBFILT (Global Filters).

InfoProviders : ABCOPC01 (Raw Material Forecast).

Propagation Layer

N/A

Business Layer

InfoProvider : ABCOPC17    FL - Raw Mat Make or Buy

ADSO in write optimized mode, with all characteristics in key to allow planning functionalities.

The structure of the Planning ADSO is : 

• Source system (0LOGSYS)
• Material (C_MATNR2)
• Plant (C_PLANT)
• Quarter (0CALQUARTER)
• GBU (CPFCTR1_2)
• Flag critical raw material (C_FLRMATF)
• Usage Factor (K_USGFACT)
• Mixing ratio (K_MIXRAT)
• Adjusted Mixing ratio (K_ADJRAT)

The 0CALMONTH dimension will be extrapolated from Quarter in the Manufacturing data flow, at the time of loading the Planning ADSO into the Manufacturing one.

Transformation ADSO ABCOPC18 -> ADSO ABCOPC17

InfoProvider : ABCOPC18    FL - Raw Mat Make or Buy - Buffer

ADSO in Activation + Change Log mode, with GBU and Critical flag not in key to allow value change from Master Data.

The structure of the Buffer ADSO is : 

• Source system (0LOGSYS)
• Material (C_MATNR2)
• Plant (C_PLANT)
• Quarter (0CALQUARTER)
• GBU (CPFCTR1_2)
• Flag critical raw material (C_FLRMATF)
• Usage Factor (K_USGFACT)
• Mixing ratio (K_MIXRAT)
• Adjusted Mixing ratio (K_ADJRAT)

Transformation ADSO ABCOPC17 -> ADSO ABCOPC18

A 1:1 copy of all records from Planning ADSO.

The Critical Raw Mat flag is cleared, and saved into an additional field SAVE_FLRMATF.

When a new load is done from the Critical Raw Material Master Data, the flag is populated with the refreshed value, and the "Adjusted Mixing Ratio" is computed with the relevant rule if the new flag is different from the saved one.

Transformation TRSF: C_FLRMAT -> ABCOPC18

Extraction of the updated Critical Raw Materials from source system PF1 ('I' and 'E').

A 1:1 mapping is done for all matching characteristics, except 0CALQUARTER which is determined by a formula.

The 3 key figures are not populated from the Master Data, but only by the loading from Planning ADSO.

4 different rule groups are created, each one with the same mappings, except the Quarter formula sliding by 1 quarter to cover the 4 coming quarters.

Quarter formulas :

Standard Group : DATE_QUARTER( SYST-DATUM )

Month + 2 Group : DATE_QUARTER( ADD_TO_DATE( CONCATENATE( DATE_MONTH( Current Date ), 15 ), 90 ) )

Month + 3 Group : DATE_QUARTER( ADD_TO_DATE( CONCATENATE( DATE_MONTH( Current Date ), 15 ), 180 ) )

Month + 4 Group : DATE_QUARTER( ADD_TO_DATE( CONCATENATE( DATE_MONTH( Current Date ), 15 ), 270 ) )

Loading frequency

Daily

Reporting

One query is available in the Workbook : 

Reporting Layer

Aggregation Level

ALCOPC

Reporting (BW Query)

Global properties

Variables

Definitions

Variable Sequence

Filters

Key figures

Characteristics

Cells

N/A

Conditions

N/A

Exceptions

N/A

Virtual Layer

Composite Providers

CPCOPC

Process Chains

PC_COPC_14    

PC_COPC_14     

Loading of