Access Management
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_M64 | IMWC - Inventory at Integrated Cost | Role menu |
| ZBI_RCS_FI_A36 | IMWC – Inventory at Integrated Cost - End User role | Application Role:
|
List of authorization objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| 0COMP_CODE__C_AUTHMA | ZR_*_CA_P00 |
| CPFCTR1_2 | ZR_*_CA_P05 |
| 0COMP_CODE | ZR_*_CA_P01 |
Link to the BW Catalog of role
https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I
Dataflow overview
Reporting documentation drive folder:
BW folder : https://drive.google.com/drive/folders/10E2KpooKYimueCVIYp_T22FgekLM269-
Dataflow :
General presentation
Objective of the application
The aim of this application is to provide logistic inventories valuated with Integrated Margin cost unit (IMc)
The general idea is to have a report similar to "Inventory aging report “ (BW_QRY_MPR_IC001_0001) but has quantities valuated at IM unit cost.
The application owner is Rosario Sevilla
The reporting coordinator is Charlotte Rollier.
Usage information
History
This application was created in 2018, requested by Technology Solution.
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
The solution is a multiprovider between Material stock WP1 cube and IM Cost unit cube.
Material stock - CUB_IC001: not complex rules in DSO associated.
IM - Unit Costs - CRCOPA24:
- ODS_PCP4 transformations explanations here: IM - Transformations rules
- ODS_PCP9
- TRSF: ODSO ODS_PCP4 -> ODSO ODS_PCP9
- Start routine: define logsys with module function Z_WBW_SOURCE_SYSTEM for RCS landscape. + load in internal table master data c_plant (fields logsys, plant, c_authma, c_compcde).
- Field routine: Define logsys.
- End routine: Read internal table plant to define C_AUTHMA, C_COMPCDE and COMP_CODE.
- TRSF: ODSO ODS_PCP4 -> ODSO ODS_PCP9
Reporting
Queries End User Documentation
Main queries
BW_QRY_MVFIWC05_0001: Inventory report at integrated costs (Core Query)
Conversion of currrency is using the conversion type CTK_ZRH2EM (Exchange rate ZRH2 with time ref = End of month )Conversion of unit is done using the conversion type QCT_CMATNR (using T006 if available otherwise C_MATNR).
=> as the conversion is base don c_matnr and no c_matnr2, the conversion DSO is not the same: UOMC_MAT instead of UOMCMAT2 => VKG and VTN conversions are not generated as it is in DSO UOMCMAT2.
Main functionalities
No exception aggregation is used to valuate the quantities, so it is important to keep the characteristics Plant and Material in the queries in order to be able to valuate the stock
Constant Selection on infoprovider "CRCOPA24" is set on IM cost unit key figures in order to ignore selections on characteristics that are not in the IM cost unit infoprovider.
Broadcast
No Broadcast