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
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

Data Flow 1: HANA Calculation Views

TECHNO - BI TEAM > Raw Material Forecast > image2022-12-19_16-27-13.png

Data Flow 2: BW Stack

TECHNO - BI TEAM > Raw Material Forecast > image2022-12-19_16-28-5.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 above, the BW data source is the Main Calculation View CV_FMCO_RAW_MAT:

TECHNO - BI TEAM > Raw Material Forecast > image2022-12-19_16-36-49.png

Calculation View Logic

Projection P_CS_RAW : Get Raw Material records for GBU NOVECARE (CS) from CV_FMCO_CS_RAW_MAT (see detail below).

Projection P_SP_RAW : Get Raw Material records for GBU SPECIALITY POLYMERE (SP) from CV_FMCO_SP_RAW_MAT (see detail below).

Currency Conversion in HANA

At Semantic level, both values below are converted using CAR3 exchange rate type.

This Exchange Rate Type has been updated from 'M' to 'CAR3' on October 2022.

CC_VALUE_EUR : Conversion of Document Currency (CC_VALUE_DOC) in EUR :

TECHNO - BI TEAM > Raw Material Forecast > image2022-10-12_16-58-36.png

CC_VALUE_COMP : Conversion of Document Currency (CC_VALUE_DOC) in Company Code Currency :

TECHNO - BI TEAM > Raw Material Forecast > image2022-10-12_17-2-56.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-12-13_15-47-59.png

Until 14th December 2022, the Projection P_INVENTORY was built on CV_FMCO_DYNASYS_PP to retrieve Inventory Price (INV).

From that date, the Projection P_INVENTORY is built on Master Data C_MATPNT3 to retrieve Material Standard Price instead.

For technical reason, the identification INV (Inventory) is kept to identify this source of data.

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

In this CV_FMCO_DYNASYS_PP used to retrieve Forecast (FOR) from DYNASYS, value is always in Euro (EUR).

The join with C_PLANT and C_COMPCODE to retrieve the Company Code currency must no be used in association with the value in EUR.

In the calling CV_FMCO_CS_RAW_MAT, a constant EUR is used for source Forecast (AG_PURCH) at the time of union (Union_1).

The Calculation View CV_FMCO_DYNASYS_PP is composed by:

TECHNO - BI TEAM > Raw Material Forecast > image2022-10-17_15-43-19.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, C_GLBFILT, C_MATPNT3.

Infoproviders: DB_PUHD1, DB_PUHD2, DB_PUSL1, DB_PUSL2, ABDPDY53 and AAMMIM02S.

Currency Conversion in BW

BW Raw Material data flows are using function module ‘CONVERT_TO_LOCAL_CURRENCY’ to convert currencies.

The exchange rate type used is read from Master Data C_GLBFILT (Global Filter) thanks to parameters below :

C_STREAM = ‘FMCO_COPC’

C_RULE = ‘EXCHGE_RT’

C_GLBFILT = ‘000’

C_SIGN = ‘I’

C_OPTION = ‘EQ’

C_LOW = ‘CAR3’

C_ACTIVE = ‘Y’

The Exchange Rate Type value was 'M' until October 2022.

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

ALCOPC13

TECHNO - BI TEAM > Raw Material Forecast > image2022-12-13_18-0-35.png

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

TECHNO - BI TEAM > Raw Material Forecast > image2022-12-13_17-54-19.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	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

TECHNO - BI TEAM > Raw Material Forecast > image2022-12-13_17-58-18.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-12-13_18-3-9.png

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

TECHNO - BI TEAM > Raw Material Forecast > image2022-7-26_15-38-41.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	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_0002	C_FLRMATF	Select Option	No	Critical Raw Material Only ('X' and 'B')
V_C_AUTHMA_0001	C_AUTHMA	Authorization	No	Authorization Scope