The new wiki link for this data flow is here:
Please update the doc there and no longer here.
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.
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 2018, requested by Technology Solution.
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:
|
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.
Reporting documentation drive folder:
BW folder : https://drive.google.com/drive/folders/1Nw3InLh-hRv_q-vPihCkPxcBLuFu0t-F
Dataflow :
The solution is a multiprovider between Material stock WP1 cube and IM Cost unit cube.
Query end user documentation should be created in the public "Customer Support Wiki" space under the corresponding BW application page : BW - Application. Technical query query documentation, if necessary should be added as a sub-page of this documentation using the BW Technical Query Documentation template.
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.
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.
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