Objective

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

TECHNO - BI TEAM > Logistics - Freight and Duties > image2022-3-10_16-6-4.png

Source Layer

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

Description	FL ICM Freight and duties (core query)
Technical Name	BW_QRY_MVCOPA01_0010
Application	COPC
Info-provider	MVCOPA01
Usage type	Data Source
Expected users

Global properties

TECHNO - BI TEAM > Logistics - Freight and Duties > image2022-3-10_11-59-1.png

Variables

Definitions

Variable Name	Info-object	Selection Type	Required	Description/Explanation

Variable Sequence

N/A

Filters

TECHNO - BI TEAM > Logistics - Freight and Duties > image2022-3-10_12-0-9.png

Key figures

TECHNO - BI TEAM > Logistics - Freight and Duties > image2022-3-10_12-3-28.png

TECHNO - BI TEAM > Logistics - Freight and Duties > image2022-3-10_16-21-32.png

TECHNO - BI TEAM > Logistics - Freight and Duties > image2022-3-10_16-24-42.png

TECHNO - BI TEAM > Logistics - Freight and Duties > image2022-3-10_16-25-48.png

Characteristics

TECHNO - BI TEAM > Logistics - Freight and Duties > image2022-3-10_12-6-29.png

TECHNO - BI TEAM > Logistics - Freight and Duties > image2022-3-10_12-7-32.png

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

TECHNO - BI TEAM > Logistics - Freight and Duties > image2022-3-10_16-31-25.png

Loading frequency

Daily

Virtual Layer

Calculation Views

CV_FMCO_LOG_FREIGHT

TECHNO - BI TEAM > Logistics - Freight and Duties > image2022-3-10_12-27-6.png

CV_FMCO_LOG_DUTIES

TECHNO - BI TEAM > Logistics - Freight and Duties > image2022-3-10_12-26-5.png

CV_FMCO_LOG_FREIGHT_DUTIES

TECHNO - BI TEAM > Logistics - Freight and Duties > image2022-3-10_12-28-3.png

Composite Providers

CPCOPC09

TECHNO - BI TEAM > Logistics - Freight and Duties > image2022-3-10_16-32-53.png

Reporting (BW Query for Qlik)

Description	FL - Logistic Cost
Technical Name	QV_BW_QRY_CPCOPC09_0001
Application	COPC
Info-provider	CPCOPC09
Usage type	Qlik Source
Expected users