Objective

The objective is to have Raw Material Costs in a Manufacturing query. This query will be used with Qlik Sense Dashboards.

Raw Material Forecast prices are confirmed by Business in a dedicated Workbook.

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.

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:

TECHNO - BI TEAM > Raw Material Forecast > image2022-3-17_12-52-43.png

Data Flow 2:

TECHNO - BI TEAM > Raw Material Forecast > image2022-7-26_15-26-34.png

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.

Source Layer

As showed in the data flow 2 above the data source is the Main Calculation View CV_FMCO_RAW_MAT:

TECHNO - BI TEAM > Raw Material Forecast > image2022-3-17_12-56-38.png

The Main Calculation View above is composed by CV_FMCO_CS_RAW_MAT and CV_FMCO_SP_RAW_MAT:

CV_FMCO_CS_RAW_MAT

TECHNO - BI TEAM > Raw Material Forecast > image2022-3-17_14-25-9.png

The Calculation View CV_FMCO_CS_RAW_MAT is composed by:

TECHNO - BI TEAM > Raw Material Forecast > image2022-3-17_15-57-39.png

TECHNO - BI TEAM > Raw Material Forecast > image2022-3-17_15-59-27.png

TECHNO - BI TEAM > Raw Material Forecast > image2022-3-17_16-0-23.png

CV_FMCO_SP_RAW_MAT

TECHNO - BI TEAM > Raw Material Forecast > image2022-3-17_14-26-11.png

The Calculation View CV_FMCO_SP_RAW_MAT is composed by:

TECHNO - BI TEAM > Raw Material Forecast > image2022-3-17_15-57-39.png

TECHNO - BI TEAM > Raw Material Forecast > image2022-3-17_15-59-27.png

TECHNO - BI TEAM > Raw Material Forecast > image2022-3-17_16-2-47.png

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:

TECHNO - BI TEAM > Raw Material Forecast > image2022-3-17_16-12-22.png

Loading frequency

Daily

Business Layer

Data Loading:

Infoproviders ABCOPC01, ABCOPC02 and ABCOPC08:

TECHNO - BI TEAM > Raw Material Forecast > image2022-3-17_16-16-3.png

Loading frequency

Daily

Reporting

Two queries are available in the Workbook : the Query Overall and the Query Detail.

The first one allows to modify the value of the Forecasted Price and automatically filters the second one to a more detailed view.

The Query Detail is the detailed view of the Raw Material per month with a Forecast quantity for a minimum of one year. All documents (Purchase Order, Contract, and Inventory) are available for each month as well as the forecast price calculated for the forecast quantity.
The Query Overall is the global view of the Raw Material aggregated by month without the detail by documents. The Forecast price is calculated from the detail and aggregated by month and Raw Material. The Quantity Assigned for each document is available in columns.

Reporting Layer

Aggregation Level

ALCOPC01

TECHNO - BI TEAM > Raw Material Forecast > image2022-7-26_17-50-38.png

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

TECHNO - BI TEAM > Raw Material Forecast > image2022-7-26_15-50-10.png

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

TECHNO - BI TEAM > Raw Material Forecast > image2022-7-26_15-51-34.png

Key figures

TECHNO - BI TEAM > Raw Material Forecast > image2022-7-26_15-52-1.png

Characteristics

TECHNO - BI TEAM > Raw Material Forecast > image2022-7-26_15-52-14.png

Cells

N/A

Conditions

N/A

Exceptions

N/A

Virtual Layer

Composite Providers

CPCOPC01

TECHNO - BI TEAM > Raw Material Forecast > image2022-3-17_16-19-35.png