Objective
The objective is to have Raw Material Costs query. This query will be used with Qlik.
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 |
|---|---|---|
Authorization objects
List of authorization objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| C_AUTHMA | Authorization Scope |
Dataflow overview
Data Flow 1:
Data Flow 2:
Source Layer
As showed in the data flow 2 above the data source is the Main Calculation View CV_FMCO_RAW_MAT:
The Main Calculation View above is composed by CV_FMCO_CS_RAW_MAT and CV_FMCO_SP_RAW_MAT:
CV_FMCO_CS_RAW_MAT
The Calculation View CV_FMCO_CS_RAW_MAT is composed by:
CV_FMCO_SP_RAW_MAT
The Calculation View CV_FMCO_SP_RAW_MAT is composed by:
Dependencies with other applications
There is a dependency from data flows:
InfoObjects: C_COMPCDE, C_PLANT, C_PO_ITM, C_SUBACT2, C_AGRITM and C_FLRMAT.
Infoproviders: DB_PUHD1, DB_PUHD2, DB_PUSL1, DB_PUSL2 and AAMMIM02S.
Propagation Layer
Data Loading:
Infoprovider APCOPC02:
Loading frequency
Daily
Business Layer
Data Loading:
Infoproviders ABCOPC01, ABCOPC02 and ABCOPC08:
Loading frequency
Daily
Reporting Layer
Aggregation Level
ALCOPC01
Reporting (BW Query)
Description | FL - Raw Mat - Query Input ready |
|---|---|
| Technical Name | BW_QRY_ALCPCOPC01_0001 |
Application | COPC |
Info-provider | CPCOPC01 |
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 | Select Option | No | Plant |
| V_CPFCTR1_2_0006 | CPFCTR1_2 | Select Option | 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 |
Variable Sequence
Filters
Key figures
Characteristics
Cells
N/A
Conditions
N/A
Exceptions
N/A
Virtual Layer
Composite Providers
CPCOPC01
Reporting (BW Query)
Description | FL ICM - Raw Material Forecast Detail |
|---|---|
| Technical Name | BW_QRY_CPCOPC01_001 |
Application | COPC |
Info-provider | CPCOPC01 |
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 | Select Option | No | Plant |
| V_CPFCTR1_2_0006 | CPFCTR1_2 | Select Option | No | Global business Unit |
| V_C_MATNR2_0001 | C_MATNR2 | Select Option | No | Raw Material |
| V_FLRMATF_0002 | C_FLRMATF | Select Option | No | Critical Raw Material Only ('X' and 'B') |
| V_C_AUTHMA_0001 | C_AUTHMA | Authorization | No | Authorization Scope |
Variable Sequence
Filters
Key figures
Characteristics
Cells
N/A
Conditions
N/A
Exceptions
N/A