General presentation
Objective of the application
The objective is to have some inventories queries. These queries will be used with Qlik.
Tool Leader + IT leader of the application:
Usage information
History
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 autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
Dataflow overview
Reporting documentation drive folder:
https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE
Exemple of dataflow overview :
Template Application name DataFlow
Functional and Technical rules on Workbench + Reporting
Update InfoProvider :
Infocube CRMMIC01 and multiprovider MVMMIC01 : add characteristics C_MOVETY, 0DCINDIC and C_PRODORD and key-fugures K_MOVEQTY and K_MOVEVAL
Infocube CRMMIC01, CRMMIC02 and multiprovider MVMMIC01, MVMMIC02 add navigation attributes
multiprovider MVFIWC01 : any modification
Multiprovider MVSDSO44 : add navigation attributes
Infocube CUB_IC001, CUB_IC002 and CUB_COPC1 and multiprovider MPR_IC001 : add navigation attributes
Infocube : add navigation attributes
Update DSO :
DSO DBMMIC07 : add characteristics C_MOVETY, 0DCINDIC and C_PRODORD and key-fugures K_MOVEQTY and K_MOVEVAL
Rules & Explanations
Dependencies with other applications
Data loadings
Info providers and objects loaded
Loading frequency
Average performance
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | |
| ~ Average nb of rows loaded per load | |
| ~ Total nb of rows loaded (if full) | |
| ~ Average Runtime for 10k lines |
Record Keeping
Reporting
Queries End User Documentation
Main queries
Master Data
QV_C_MATNR2_0001 QV - Material Master Data
A query on material (C_MATNR with LOGSYS) to have the atributes of material (example : C_PROD → Commercial Product / Material Group)
QV_C_MATPNT2_0001 QV - Material Plant Master Data
A query on material (C_MATPNT2 with LOGSYS and PLANT) to have the atributes of material/plant (example : CPFCTR1_2 → BFC Global Business Unit)
QV_C_MATPNT3_0001 QV - Material valuation class
A query on material (C_MATPNT3 with LOGSYS and PLANT) to have the atributes of material/plant (example : C_VALCLAS → Valuation class)
Solvay Data
QVSBS_BW_QRY_MPR_IC001_0003 BW - Stock Movement All Types (Core query) Qlik : a query on material/stock movement
Charactéristics : material informations with batch information
Key figures : Quantity Total Stock (Qty)
QVSBS_BW_QRY_MPR_IC001_0004 BW - Stock Movement All Types (Core query) Qlik
Charactéristics : material informations without batch information
Key figures : Quantity Total Stock (Qty), Good Receipt (Qty), Global Consumption (Qty), Global Sales (Qty), ValStockValue (Eur), Good Receipt (Eur), Global Consumption (Eur), Global Sales (Eur) and Counter
Rhodia data
QVSBS_BW_QRY_MVMMIC01_0001 BW - Inventory Management - Stock Movement (Core Query) : a query on material/stock movement
Charactéristics : material informations with batch information
Key figures : Quantity Total Stock (Qty)
QVSBS_BW_QRY_MVMMIC01_0002 BW - Inventory Management - Stock Movement (Core Query)
Charactéristics : material informations without batch information
Key figures : Quantity Total Stock (Qty), Good Receipt (Qty), Global Consumption (Qty), Global Sales (Qty), ValStockValue (Eur), Good Receipt (Eur), Global Consumption (Eur), Global Sales (Eur) and Counter
Rhodia / Solvay data
QVSBS_BW_QRY_MVSDSO44_0001 QV - Sales follow up -All
Charactéristics : sales informations
Key figures : Billed QTY and Total billing w/o taxes
QVSBS_BW_QRY_MVSDSO42_SD001 QV - Historical data: PO's invoices (core)
Charactéristics : sales informations
Key figures : Billed QTY and Total billing w/o taxes
QVSBS_BW_QRY_MVFIWC01_0001 BW - Working Capital Inventories (Core Query)
Main functionalities
Broadcast
Maintenance
Known bugs
Recurring procedure
Planned Evolution