/!\ Obsolete /!\

Access latest documentation in the below SPP Make or Buy part.

The logic is the same, but BW objects changed (ABCOPC17 and ABCOPC18 → ABCOPC20 and ABCOPC21) with a different granularity.

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

The ADSO is loaded with Make or Buy products only (Critical flag “I” or “E”), from Buffer ADSO ABCOPC18, in which the Planning ADSO was previously saved, and enhanced with a loading from MD Critical Raw Material.

A 1:1 mapping is done for all matching characteristics, except key figure K_ADJRAT which is computed from the 2 other key figures, according to Critical flag change (I or E).

Planning ADSO records are deleted and reloaded from buffer ADSO daily.

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

Data is displayed in a Workbook built on a single query with Planning functionalities.

The query is built on an Aggregation Level, based on a Composite Provider encapsulating the Planning ADSO.

Reporting Layer

Aggregation Level

ALCOPC15   FL - Raw Mat Make or Buy

The Aggregation Level is encapsulating the Composite Provider, with the exact same output structure.

All characteristics and key figures of the ADSO are selected to guarantee the Planning functionalities in the query/workbook.

Planning Function

PF_ALCOPC15_0001   FLICM - SPP Raw Mat Make or Buy compute

The Planning Function is called from the workbook when saving data.

Key Figure “Adjusted Mixing Ratio” is computed according to the Critical Raw Mat flag ('I' or 'E')

Virtual Layer

Composite Providers

CPCOPC13   FL - Raw Mat Make or Buy

The Composite Provider is encapsulating the Planning ADSO, with the exact same output structure.

The navigational attribute C_PLANT__C_AUTHMA is added to handle authorizations on Scope in the query.

Reporting

BW Query

Global properties

Variables

Definitions

Variable Sequence

Filters

Key figures

Characteristics

Cells

N/A

Conditions

N/A

Exceptions

N/A

BW Workbook

Prompt

Layout

Macro VBA

Process Chains

PC_COPC_14    COPC: TD - D - RMAT Make or Buy Panning (Monthly)

Scheduled daily