Access Management 

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

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

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.

Reporting

Queries End User Documentation

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.

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.

Data Quality Control

Data come from SAP system. To compare data between BW and sources systems, check propagation layers.

Operational Documentation

Procedures

<Describe the recurring procedures needed to operate the application (eg. start/pause/terminate/restart the app processes, data preparation, data ingestion, ETL, data visualization, data export, other manual activities)>

Scheduling

<Describe the scheduling in place for the application (eg. existing jobs, trigger time/event based, dependencies)>

Monitoring

<Describe the monitoring checks to confirm the application is performing well (eg. check the overall status, check performance metrics like runtime/data volume/memory/disk/CPU, maintain and react to alerts/notifications)>

Error Handling

<Describe how to handle errors (eg. error codes, description and respective resolution, alert users)>

Known Bugs

<List the existing bugs, its criticity, workarounds and resolution plan.>

Roadmap