The new wiki link for this data flow is here:
Technical Documentation - Procurement - SPRINT report
Please update the new doc there and no longer here.
| Table of Contents |
|---|
General presentation
Objective of the application
This report / application is to track the Contract price change information by change date. This information is gathered using the change document details. There is no report in ECC which can give this information.
...
Purchasing Data and P-t-P Interface Manager : Sylvie Severini (Brussels)
Usage information
D&A and buyers are the key users of this report
History
Business requested a BW report that can provide a structure similar to the above mentioned reports in PF1 and WP1 and that is able to provide the price changes per material Base Unit of Measure and also per last condition record unit of measure considering changes done not only to the condition records but the Price Unit information and its quantity conversions.
Requestor: Rui Cabrita
Roles & Access
Roles and access
List of application role + menu role and explanation if we have several applications role with specials rules.
...
| Authorization object | Explanation |
|---|---|
| Plant (C_PLANT) | ZR_*_CA_P02 ZR_7866_CA_P02 => Plant 7866 - Chalampé (ex 7027) - (Cie ZFR9) ZR_TOUT_CA_P02 => All Plants "Solvay" |
Dataflow overview
The key logic was built in extractor. The extraction logic was built in such a way that the relevant field's (that affect the price changes) old value and new value should be captured in the extraction.
...
Reporting documentation drive folder:
https://drive.google.com/drive/folders/1TCUoZDVUBcP1eC6og52brDN2fScOrAVd1OG6Qn8xEbrO-GKGPWyrPkQ1BtHkS6I1L
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
All the KPI calculations are explained in this section
...
Convert the K_IRBUNP to vendor currency using FM "Convert_To_Foreign_Currency"
Dependencies with other applications
This is an independent data model and do not dependent on any applications
Data loadings
Info providers and objects loaded
Process Chain: PC_SPRINT_CONT1
...
Loads to this info providers are added at end of the process chain PC_SPRINT_CONT1
Loading frequency
Daily loads (except week end) using pseudo delta with current day - 4 days logic
Average performance
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | 2 Mins |
| ~ Average nb of rows loaded per load | 100 - 200 |
| ~ Total nb of rows loaded (if full) | |
| ~ Average Runtime for 10k lines |
Record Keeping
Data loaded from 2018 - till date
Reporting
Queries End User Documentation
Main queries
The core Query:
BW_QRY_CPPURCNT1_0001 - SPRINT - PUR : Contract Price Analysis (Core Query)
...
Variance greater than 200
Selection Screen:
Report Output:
Exception:
