The aims of the solution and the report is to be able to get the GBU assignment of discount postings that are monthly made in PI1 when related to invoices transferred from WP1 and PF1 to Solvay internal banks (0231/4044) in PI1 in the frame of CAMS processes.
The application owner is Ana Silva
The reporting coordinator is Charlotte Rollier.
CICC Accounting team, Controller of Treasury 0231,...
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
Authorization on company is based on the affiliate PRS company code which seems more appropriate than to restrict by the local company code and do not require to add new roles to Working Capital reporting users.
Dataflow overview
The solution consists on 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) /!\ Obsolete /!\ wiki, part FIAR Factoring data flow.
DBFIGL20 → DBFIAR15/16 (inner join = only discount posting linked to customer invoices are displayed):
DBFIAR15/16 → C_COMPCDE (inner join):
DBFIAR15/16 → C_WWE01AF (inner join):
DBFIGL20 DSO is used to retrieve discounts entries: identified by GL account 6531000000, for companies 0231 and 4044 (filtered in the query).
Customer invoices informations comes from the DSO DBFIAR15 (RCS) and DBFIAR16 (Solvay): entries cleared by the documents selected in DBFIGL20 and that have a posting key 01 or 11(filtered in the query).
The GBU is the attribute of the sub-activity (affiliate) in DSO DBFIAR15/16.
The company code (c_compcde) MD is added to the multiprovider (but excluded for 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 discounts could be only approximatively split by GBU (total of "discount amount (Cust. inv.)", which is assigned to a GBU, could be less than the "discount (posted)" or 0).
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