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.
Roles & Access
Roles and access
This application is separated from Working Capital application (required to be in a separate role menu)
| 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:
|
Authorization objects
Link to the BW Catalog of role
https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I
Same authorization as Working Capital application, except the WC account type, which is only "INVENTORY" for this application. Moreover, as we needed the cube Material Stock (CUB_IC001) for Logistic Inventory at Integrated Cost report, and this cube doesn't contain the PRS company code, then the perimeter role on 0company is also required.
Dataflow overview
Reporting documentation drive folder:
BW folder : https://drive.google.com/drive/folders/10E2KpooKYimueCVIYp_T22FgekLM269-
Dataflow :
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
The solution is a multiprovider between Material stock WP1 cube and IM Cost unit cube.
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