You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

General presentation

Objective of the application

The goal of this application is to display the CICC customer discounts by GBU (from corresponding customer invoices).


The application owner is Ana Silva
The reporting coordinator is Charlotte Rollier.

Usage information

CICC Accounting team, Controller of Treasury 0231,...

History

This application was created in 2017 under CAMS project.

Roles & Access

Roles and access

 

Role CodeRole DescriptionExplanation
ZR_RCS_CA_M61CDG - CICC Customer Discounts by GBURole menu
ZBI_RCS_CDG_A01Application role for CDG Customer Discount (CICC) :

Application Role:

  • End User rights
  • gives access to infoproviders of Infoarea "IA_FMCO_FICD*"
  • BI Analysis Authorization "ZBI_CDG" ("*" for authorization objects not relevant for the application)
   

Authorization objects

Link to the BW Catalog of role

https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I

 

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) wiki, part FIAR Factoring data flow.

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Infoset joins:

DBFIGL20 → DBFIAR15/16 (inner join = only discount posting linked to customer invoices are displayed):

  • dbfiar15/16-lgsyslg = dbfigl20-logsys
  • dbfiar15/16-c_compclg = dbfigl20-c_compcde
  • dbfiar15/16-clear_date = dbfigl20-pstng_date
  • dbfiar15/16-clr_doc_no = dbfigl20-ac_doc_no

DBFIAR15/16 → C_COMPCDE (inner join):

  • c_compcde-logsys = dbfiar15/16-lgsyslg
  • c_compcde-c_compcde = dbfiar15/16-c_compclg

DBFIAR15/16 → C_WWE01AF (inner join):

  • c_wwe01af-c_wwe01af = 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 on the customer invoices are retrieved in DSO DBFIAR15 (RCS) and DBFIAR16 (Solvay). The customer entries corresponding to the discounts are the ones

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).

Dependencies with other applications

This application is dependant with

  • BW RTR - ITC (Invoice to Cash FIAR) (AR Factoring DSO) 

Data loadings

No loading, only virtual providers were created for this application

Record Keeping

NA

Reporting

Queries End User Documentation

Reporting is available throught a query in the role "CDG - CICC Customer Discounts by GBU" ZR_RCS_CA_M61

 

Main queries

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).

Main functionalities

No complex functionalities

Broadcast

No broadcast

Maintenance

Known bugs

Recurring procedure

Planned Evolution

 

  • No labels