Objective of the application

The objective is to have Freights and Duties 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

Dataflow overview

Source Layer

As showed in the data flow above the source data is a BW Query BW_QRY_MVCOPA01_0010 - FL ICM Freight and Duties.

Description	FL - Logistic Cost
Technical Name	QV_W_QRY_CPCOPC09_0001
Application	COPC
Info-provider	CPCOPC07
Usage type	Qlikview Source
Expected users

Global properties

xxxxxxx

Variables

Definitions

Variable Name	Info-object	Selection Type	Required
V_C_PLANT_C_AUTHMA_002	C_PLANT__C_AUTHMA	Authorization	Yes
ZINSPLOT	0INSP_LOT	SelectOption	No
V_C_MATNR2_0010	C_MATNR2	SelectOption	No
V_C_PLANT_37	C_PLANT	SelectOption	No
ENSTE_01	C_ENSTEHD	SelectOption	No
ZPLNNR	0PLNNR	SelectOption	No

Variable Sequence

Filters

Object	Filter Value	Explanation

TECHNO - BI TEAM > Logistics - Freight and Duties > image2021-7-26_11-36-50.png

Key figures

TECHNO - BI TEAM > Logistics - Freight and Duties > image2021-7-26_11-40-42.png

Characteristics

Location	Info-object Name	Info-object Text	Explanation (if needed)

Cells

N/A

Conditions

N/A

Exceptions

N/A

Dependencies with other applications

There is a dependency from MVCOPA01 data flow.

Data loadings

Info providers and objects loaded

Infoproviders:

APCOPC05

ABCOPC06

Loading frequency

Daily

Virtual Layer

Calculation Views

CV_FMCO_LOG_FREIGHT

xxxxxxxx

CV_FMCO_LOG_DUTIES

xxxxxxxx

CV_FMCO_LOG_FREIGHT_DUTIES

xxxxxxxx

Composite Providers

CPCOPC07

Reporting (BW Query for Qlikview)

Description	FL - Logistic Cost
Technical Name	QV_W_QRY_CPCOPC09_0001
Application	COPC
Info-provider	CPCOPC07
Usage type	Qlikview Source
Expected users

Global properties

xxxxxx

Variables

Definitions

Variable Name	Info-object	Selection Type	Required
V_C_PLANT_C_AUTHMA_002	C_PLANT__C_AUTHMA	Authorization	Yes
ZINSPLOT	0INSP_LOT	SelectOption	No
V_C_MATNR2_0010	C_MATNR2	SelectOption	No
V_C_PLANT_37	C_PLANT	SelectOption	No
ENSTE_01	C_ENSTEHD	SelectOption	No
ZPLNNR	0PLNNR	SelectOption	No

Variable Sequence

Filters

Object	Filter Value	Explanation

TECHNO - BI TEAM > Logistics - Freight and Duties > image2021-7-26_11-36-50.png

Key figures

TECHNO - BI TEAM > Logistics - Freight and Duties > image2021-7-26_11-40-42.png

Characteristics

Location	Info-object Name	Info-object Text	Explanation (if needed)

Cells

N/A

Conditions

N/A

Exceptions

N/A