Objective
Add a "Make or Buy" step 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 provided 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.
Role Code | Role Description | Explanation |
|---|---|---|
| ZR_RCS_CA_M78 | Forward Looking ICM - Raw Material | Role Menu |
| ZBI_RCS_CO_A06 | Forward Looking ICM - Raw Material | Authorization objects |
Authorization variables
List of authorization variables mandatory for the application.
Authorization variables | Object |
|---|---|
| V_CPFCTR1_2_0006 | CPFCTR1_2 |
| V_C_PLANT_0012 | C_PLANT |
| V_C_AUTHMA_0001 | C_PLANT__C_AUTHMA |
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) :
- Load full content of Planning ADSO to Buffer ADSO
- Load Critical Raw Mat 'I' and 'E' to Buffer ADSO
- Delete full content of Planning ADSO
- Load full content of Buffer ADSO to Planning ADSO
- Update “Usage factors” and “Mixing ratio” in Planning ADSO from workbook
Dependencies with other applications
There is a dependency with :
InfoObjects: C_FLRMAT, C_GLBFILT.
Propagation Layer
N/A
Business Layer
Data Loading:
Infoproviders
Loading frequency
Daily
Reporting
One query is available in the Workbook :
Reporting Layer
Aggregation Level
ALCOPC
Reporting (BW Query)
Description | FL - Raw Mat - |
|---|---|
| Technical Name | BW_QRY_ALCOPCxx_0001 |
Application | COPC |
Info-provider | CPCOPC |
Usage type | |
Expected users |
Global properties
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
| CALMONT2 | 0CALMONTH | Interval | Yes | Calendar Year/Month |
| V_C_PLANT_0012 | C_PLANT | Authorization with Input | No | Plant |
| V_CPFCTR1_2_0006 | CPFCTR1_2 | Authorization with Input | No | Global business Unit |
| V_C_MATNR2_0001 | C_MATNR2 | Select Option | No | Raw Material |
| V_FLRMATF_0001 | C_FLRMATF | Single Value | No | Critical Raw Material Only ('X') |
| V_C_BNAME_0001 | C_BNAME | Select Option | No | Buyer Name |
| V_C_AUTHMA_0001 | C_PLANT__C_AUTHMA | Authorization | No | Authorization Scope |
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