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.
Technical 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
From HANA Datasource with all Purchase documents identified for Raw Material Forecast, data is handled in several BW layers to deliver a detailed view of Forecast in one hand, and an overall view in another hand.
The global logic
Dependencies with other applications
There is a dependency from data flows:
InfoObjects:
Infoproviders:
Propagation Layer
Data Loading from Datasource DTS_FMCO_CO_PC_CV_FI_FL_FRAWMA built on CV_FMCO_CS_RAW_MAT.
Target Infoprovider APCOPC02
Transformation Logic
If a monthly forecast price is unconfirmed by Business, it is extrapolated from the first previous confirmed price at the time of pushing this Forecast into Manufacturing data flow.
This process takes place in the Transformation ABCOPC01 on itself.
Loading frequency
Daily
Business Layer
Data Loading:
Infoproviders ABCOPC01, ABCOPC02 and ABCOPC08:
Loading frequency
Daily
Reporting
One query is available in the Workbook :
Reporting Layer
Aggregation Level
ALCOPC
Reporting (BW Query)
Description | FL - Raw Mat - Query Input ready |
|---|---|
| Technical Name | BW_QRY_ALCOPC13_0001 |
Application | COPC |
Info-provider | CPCOPC11 |
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