The new wiki link for this data flow is here:
Please update the doc there and no longer here.
General presentation
Objective of the application
- Invalid results of Inspection results
- Inspection lots with completed status
Usage information
History
We have request on ticket ticket 4130261 and 4495655 to load invalid inspection lot value to BW as well since standard data source 2LIS_05_QE1 and 2LIS_05_QE2 provide only valid inspection lot.
This flow has been created for both Rhodia and Solvay to extract only Invalid inspection related data from WP1 and PF1 systems to BW. Data from both systems consolidated at composite provider creating based on ADSO.
The invalid and valid data will combine in QV Dashbaords only.
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_M14 | QM - Quality Management | This role gives access to the Query and Workbooks through role menus. |
| ZBI_RCS_QM_A02 | Quality Results Application - End User role | This role controls access to the application. |
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
Dataflow overview
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Invalid Inspection Results
Propagation layer-APQM02
This ADSO extracts data from the following two data sources from WP1 and PF1
DTS_BW_QM_ATTRIBUT(WP1_400) → APQM02
DTS_BW_QM_ATTRIBUT(PF1_020) → APQM02
Both the Data sources created based on Function Modules(ZFM_BW_QM_ATTRIBUT (PF1+WP1) and implemented the same business logic in both the systems.
Function module extracts Inspections lot with ' SATZSTATUS -5 (Record status completed) and ATTRIBUT type Invalid results Only .
Source for this function module is QASR,QALS,QAMV,QAPP and PLKO tables in SAP in order to find the required field
From source to PSA data load will be triggered based on created on and changed on date in two different Info packages. There is a code at Info package level to extract last four data.
Business Layer -ABQM05
ADSO APQM02 -> ADSO ABQM05
Direct mapping of fields from propagation DSO to Business layer DSO
Virtual layer - CPQM03
Composite provider created based business layer DSO -ABQM05
Dependencies with other applications
BEX Query-QV_BW_QRY_CPQM03_0001 using in QV applications
Data loadings
Info providers and objects loaded
Info packages and DTP's of this flow included in existing process chains of QM. New process chains are not created for this flow
Following two Info packages(Data extracts from PF1_020) included in Process chain -PC_QM_12
IP: DTS_BW_QM_ATTRIBUT - Solvay -Delta -Changed on(ZPAK_5MU145U5WGLD64Y8GUZJU81EY)
IP: DTS_BW_QM_ATTRIBUT - Solvay -Delta Created on(ZPAK_5MVOTM2E8YLU197KITBBSRW2Y)
Following two Info packages(Data extracts from WP1_400) included in Process chain -PC_QM_29
IP: DTS_BW_QM_ATTRIBUT - Rhodia -Delta -Changed on(ZPAK_5MVOT9WK868FJKEZA7LVVNX9M)
IP: DTS_BW_QM_ATTRIBUT - Rhodia -Delta -Created on(ZPAK_5MCNB4JN0SF5P7DX3IXN8O1T6)
Propagation and Business layer DTP's are included in Process chain-PC_QM_29
Loading frequency
Daily
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
QV_BW_QRY_CPQM03_0001 QVBW - QM : Inspection Invalid Result(Core query) - HANA
Main functionalities
We don't have request to see the invalid inspection lot on BW. Therefore, we have only query to send invalid inspection lot to QV