General presentation
Objective of the application
Functional Specification Document:
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 |
|---|---|---|
| ZR_RCS_CA_M69 | MS - Model S | Role for queries and workbook |
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| C_COMPCDE__C_AUTHMA | Query authorization object |
| CPFCTR1_2 | Query authorization object |
| C_COMPCDE__C_MNGAREA | Query authorization object |
| C_COMPPRS | Query authorization object |
Dataflow overview
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Main steps:
- Extract quantity total stock from ADSO ABMMIC01 in ADSO APCOMS01 with help of query BW_QRY_ABMMIC01_0001.
The principal thing to know here it's about the way to extract the data.
The goal is to extract and stock in APCOMS01 "Quantity Total Stock" 0TOTALSTCK from ABMMIC01. Info object 0TOTALSTCK is not physically stored in invenotry DSO. The only way to extract the key figure is to use a query as datasource (BW_QRY_ABMMIC01_0001).
In query BW_QRY_ABMMIC01_0001 we used a variable "V_CALMONTH11" based on class ZCL_BIU001_V_0CALMONTH_0031.
The class determine the month to load from current date and more or less x month(s). To know the number of months to add or removre from current date, the class read master data global filter (C_GLBFILT) on stream "STOCK_LOG":
Normally, by default the month to load in ADSO APCOMS01 is current month - 1. To load other month it's necessary to change fields "low" and / or "hight" in master data.
- Use calculation views to consolidate the different data sources.
See details here. - Load ADSO ABCOMS01 and calculate key figuress for Model S.
Dependencies with other applications
Mains data sources:
Logistic data: ADSO ABMMIC01 - "Material stock".
Transit data: DBFIGL13 - "IM from FIGL: Line Items for G/L Acct (S) - Rhodia Level 2".
Integrated Margin data: ODS_PCP4 - "CCR: Integrated margin".
Data loadings
Info providers and objects loaded
| Process Chain - Technical Name | Process Chain - Description | Starter | Comment |
|---|---|---|---|
| PC_CO_MS_0006 | MS: TD - M - Model S - Global | Event: Z_EVT_PC_CO_MS_0006 triggered in process chain PC_INT_MARGIN | |
| PC_CO_MS_0003 | MS: TD - M - Model S Propagation APCOMS01 | External start only (via API or metachain) | Sub Chain of PC_CO_MS_0006. Load ADSO APCOMS01 with query BW_QRY_ABMMIC01_0001 in source. |
| PC_CO_MS_0004 | MS: TD - M - Model S Propagation - APCOMS04 | External start only (via API or metachain) | Sub Chain of PC_CO_MS_0006 |
| PC_CO_MS_0005 | MS: TD - M - Model S Businesss | External start only (via API or metachain) | Sub Chain of PC_CO_MS_0006 |
| PC_CO_MS_0001 | MS: TD - D - Shift of Months: Models S (Propagation Layer) | External start only (via API or metachain) |
Loading frequency
The loading is done after the process chain PC_INT_MARGIN - "Integrated Margin 2" normally once a month in the 3th workday.
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
BW_QRY_ABMMIC01_0001 - BW - Material Stock for extract model S (Core Query)
BW_QRY_CPCOMS01_0001 - Stock margin elimination report (Core Query)
BW_QRY_CPCOMS01_0002 - Stock Margin Elimination report 2 (Core Query)
Main functionalities
Broadcast
Maintenance
Known bugs
Recurring procedure
Planned Evolution
- Replace query BW_QRY_ABMMIC01_0001 with new one based on composite provider CPMMIC02 and find a way to improve the loading time.