General presentation
Objective of the application
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 |
|---|---|---|
| ZBI_RCS_SCRE_A01 | SCRE - Transport/Packaging Analysis | Access role |
| ZR_RCS_CA_M76 | Transport & Packaging Analysis | Menu role |
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| C_COMPCDE__C_AUTHMA | |
CPFCTR1_2 | |
Dataflow overview
Reporting documentation drive folder:
Exemple of dataflow overview :
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Dependencies with other applications
Screen packaging uses many providers as source of data (used in calculations view):
ABMMIM02R
ABMMIM02S
DBMMIC01
DBMMIC02
DBFIGL03
DBFIGL06
DBFIGL13
DBFIGL14
DB_PUSL1
DB_PUSL2
DB_PUHD1
DB_PUHD2
ODSFIGL3
DPFIGL02
ABCOPP02
ABCOPP01
Data loadings
Info providers and objects loaded
Only one provider is loaded, the ADSO ABSCPK01 "Controlling - Screen Packaging" with data from composite provider CPSCPK01 "Controlling - Screen Packaging".
The composites providers CPSCPK02 and CPSCPK03 use calculations views.
Composite provider CPSCPK01 use calculation view and also ADSO ABSCPK01 (to improve the performance of queries)..
Loading frequency
ADSO ABSCPK01 is loaded during the working day with process chain PC_CT_TR_02 - "COSTA - Transactionnal Data 02 (Screen Pckg)".
The process chains starts at 6:30 am and waits the end of process chain PC_FREQUENTLY_LOAD_MAIN ' "01 Frequently Load PC Main" to load adso ABSCPPK01.
Average performance
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | |
| ~ Average nb of rows loaded per load | 1300000 |
| ~ Total nb of rows loaded (if full) | 1300000 |
| ~ Average Runtime for 50k lines | 15s |
Record Keeping
Reporting
Queries End User Documentation
Core queries:
BW_QRY_CPSCPK01_0001 - SCREEN - Pack. Inventory analysis - Detailed (Core Query)
BW_QRY_CPSCPK01_0002 - SCREEN - Pack. Inventory analysis - Aggregated (Core Query)
BW_QRY_CPSCPK02_0001 - SCRE - Pack. Purchasing analysis (Core Query)
BW_QRY_CPSCPK03_0001 - SCRE - Pack. Manuf. Consumption analysis (Core Query)
Qlikview queries:
QV_BW_QRY_CPSCPK01_0001 - SCRE - Pack. Inventory for QV / Stock (Core Query)
QV_BW_QRY_CPSCPK01_0002 - SCRE - Pack. Inventory for QV / Var. (Core Query)
QV_BW_QRY_CPSCPK02_0001 - SCRE - Purch. Pack. data for QV (Core Query)
QV_BW_QRY_CPSCPK03_0001 - SCRE - Pack. Consu. interface to QV (Core Query)