Document Links
ERP-1041 - Getting issue details... STATUS
Introduction
This Data Flow Specification (DFS) defines the end-to-end data flow required to meet the following requirements:
- Total stock balances (value and quantity) by Posting Date for every Material/Plant/Storage Location/Stock Type.
Stock Balances
The objective of the Stock Balances Analytical Model is to provide a comprehensive view of Material/Plant/Storage Location/Stock Type values and quantities at a given date, which reconciles to MB52.
Quantities and values are obtained from a combination of Goods Movement (MM) documents and Fi adjustment postings.
Snapshots of monthly and weekly inventories will be created and partitioned (how so it makes sense?)
A persisted/portioned flow, containing aggregated data will also be created. This aggregated view will carry the stock balances for a month by Material/Plant/Storage Location/Stock Type. The current month stock movements will be union-ed to it to get to the current month ending balance.
EWM Managed Plants:
No differentiation in the handling of EWM managed plants are required. EWM handles the process, but each movement is reflected as a GoodsMovementDocument in table MSEG. This allows for a single process to calculate Closing Inventory.
The standard CDS views for physical stock and plant stock for EWM managed plants will be extracted and made available for reporting (if required for cross instance reporting...).
Source System Extractors
| Extractor Name | Build Jira Ref For Extension Information |
|---|---|
Inbound Layer
Harmonisation Layer
2TL_S2HARM_GoodsMovementDocumentDEX
Source: 1TL_S4Hx_I_GOODSMOVEMENTDOCUMENTDEX
Purpose:
- Harmonise maintenance order technical object data for reuse across A2DAMM.
- Standardise Equipment and Functional Location identifiers.
- Preserve scheduled basic start and end timestamps for planned downtime calculations.
Propagation Layer
3VR_P2FXXXX_XXXXXXXXXXX
Source:
Calculation:
Projection:
Union:
Reporting Layer
4MA_P2FINV_DowntimeFact
Supports:
Includes technical details for:
Calculated Measures (Post Aggregation Calculations / exception aggregation etc)
Restricted Measures
tbd
Currency Conversions
tbd