Describe in a few words the content of application + link with functional or technical specifications (google links) done with during the project or linked with PPMO
The application owner is Ana Silva
The reporting coordinator is Charlotte Rollier.
How many users? Which user category ? Is there critical period ? Which geographical perimeter? Describe in one sentence: around 50 users, worldwide or 200 users / European Site
This application was created in 2017 under CAMS project.
| Role Code | Role Description | Explanation |
|---|---|---|
| ZR_RCS_CA_M61 | CDG - CICC Customer Discounts by GBU | Role menu |
| ZBI_RCS_CDG_A01 | Application role for CDG Customer Discount (CICC) : | Application Role:
|
Link to the BW Catalog of role
https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I
Dataflow overview
The solution consists in a multicube based on 2 infosets on FIAR factoring DSO and CICC FIGL DSO.
For information concerning FIAR factoring DSO, please refers to BW RTR - ITC (Invoice to Cash FIAR) (WBP) wiki, part FIAR Factoring data flow.
Infoset joins (all inner joins):
DBFIGL20 → DBFIAR15/16:
DBFIAR15/16 → C_COMPCDE:
DBFIAR15/16 → C_WWE01AF:
DBFIGL20 DSO is used to retrieve discounts entries: identified by GL account 6531000000, for companies 0231 and 4044 (filtered in the query).
GBU and other informations (include discounts amounts and percentages, which could help to split the total discount by GBU) on the customer invoices are retrieved in DSO DBFIAR15 (RCS) and DBFIAR16 (Solvay). The customer entries corresponding to the discounts are the ones cleared by the documents selected in DBFIGL20 and have a posting key 01 or 11(filtered in the query).
The company code (c_compcde) MD is added to the multiprovider but excluded from the reporting, only for authorization purpose: it enables to restrict authorization by PRS company code as the field generated by the infosets references c_compprs which is not "authorization relevant" (only c_compcde__c_compprs is authorization relevant).
This application is dependant with
No loading, only virtual providers were created for this application
NA
Reporting is available throught a query in the role "CDG - CICC Customer Discounts by GBU" ZR_RCS_CA_M61
BW_QRY_MVFICD01_0001 PI1 Discount report by GBU (Core Query):
Discounts posting are displayed next to the corresponding customer invoices.
There is no rule to calculate the discount amounts from the customer entry when it is not filled. So potentially, the total discount amount could be only partially split by GBU.
No complex functionalities
No broadcast
Give the list and explanation on the known, not-solved, bugs.
List recurring procedures
Detail planned major evolution if already known. Example: complete decommissioning of application is planned in 2017 / Extension to solvay perimeter planned in 2nd semester of 2016