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...).

Physical Inventory

Need some words here.

Source System Extractors

Inbound Layer

No inbound field adjustments are applied. Standard technical fields are retained as delivered

Harmonisation Layer

2TL_S2HARM_GoodsMovementDocumentDEX

Source: 1TL_S4Hx_I_GOODSMOVEMENTDOCUMENTDEX

Purpose:

• Delta load of Material Documents
• Set keys
• Filled by Transformation Flow 2TF_S4HARM_I_GoodsMovementDocumentDEX

2TF_S4HARM_I_GoodsMovementDocumentDEX

Projection:

• Add as Key: MaterialDocumentYear

• Add as Key: MaterialDocument

• Add as Key: MaterialDocumentItem

Note, keep keys MaterialDocumentKey1 - 6 for Delta Capture.

2VR_S2HARM_GoodsMovementDocumentDEX

Projection:

• Exclude Column: MaterialDocumentKey1
• Exclude Column: MaterialDocumentKey2
• Exclude Column: MaterialDocumentKey3
• Exclude Column: MaterialDocumentKey4
• Exclude Column: MaterialDocumentKey5
• Exclude Column: MaterialDocumentKey6

Propagation Layer

3VR_P2FINC_MaterialStock

Source: 2VR_S2HARM_GoodsMovementDocumentDEX & xxxxxxxx

Filters:

• 2VR_S4HARM_I_GLAccountLineItemRAW
  • "ReferenceDocumentType" = 'PRCHG' AND
    "ControllingBusTransacType" = '' AND
    "SourceLedger" = '0L' AND
    "Product" != ''
• 2VR_S4HARM_I_GoodsMovementDocumentDEX
  • "Material" != '' AND
    "InventoryStockType" != ''

Projection:

• 2VR_S4HARM_I_GLAccountLineItemRAW
  • Only for join
• 2VR_S4HARM_I_GoodsMovementDocumentDEX
  • Only for join

Union:

Accept default union mappings

3VF_P2FINV_MaterialStock

Source: 3VR_P2FINC_MaterialStock

Calculation:

RecordType

used for Non-Cumulative Key Figures to track inventory balance over time.

Data Type: Integer

Expression: case when 'PostingDate' < '20251231' then 2 
     when 'PostingDate' = '20251231' then 1
     else 0 end

Note: The dates must be parameterised to set the marker based on an input table.

Projection: TBD

Reporting Layer

4MA_P2FINV_DowntimeFact

Supports:

Includes technical details for:

Calculated Measures (Post Aggregation Calculations / exception aggregation etc)

Restricted Measures

tbd

Currency Conversions

tbd

Variables

Data access controls

Outbound Layer