Document Links

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

SyWay Project > ERP-1041: DDFS - P2F - Plan to Fulfill > image-2026-3-3_9-43-3.png

Extractor Name	Build Jira Ref For Extension Information

Inbound Layer

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

Harmonisation Layer

2TL_S2HARM_GoodsMovementDocumentDEX

Purpose:

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

2TF_S4HARM_I_GoodsMovementDocumentDEX

Source: 1TL_S4Hx_I_GOODSMOVEMENTDOCUMENTDEX

Projection:

Project Details
Add as Key: MaterialDocumentYear
Add as Key: MaterialDocument
Add as Key: MaterialDocumentItem

Note, keep keys MaterialDocumentKey1 - 6 for Delta Capture.

2VR_S2HARM_GoodsMovementDocumentDEX

Projection:

Projection Details
Exclude Column: MaterialDocumentKey1
Exclude Column: MaterialDocumentKey2
Exclude Column: MaterialDocumentKey3
Exclude Column: MaterialDocumentKey4
Exclude Column: MaterialDocumentKey5
Exclude Column: MaterialDocumentKey6

2TL_S4HARM_C_TranspOrdItemAnlytsSDEX

Source: 1TL_S4Hx_I_GOODSMOVEMENTDOCUMENTDEX

Purpose:

Delta load of Transportation Order Items
Filled by Transformation Flow 2TF_S4HARM_C_TranspOrdItemAnlytsSDEX

2TF_S4HARM_C_TranspOrdItemAnlytsSDEX

Source: 1TL_S4HR_C_TranspOrdItemAnlytsSDEX

No transformations

2VR_S4HARM_C_TranspOrdItemAnlytsSDEX

SyWay Project > ERP-1041: DDFS - P2F - Plan to Fulfill > image-2026-2-10_12-14-32.png

Filter:

(TransportationOrder <> '' OR TransportationOrder IS NOT NULL)

Formula:

Field	Formula
TransportationOrderItemUUID	BINTOHEX(TransportationOrderItemUUID)
TransportationOrderUUID	BINTOHEX(TransportationOrderUUID)
TranspOrdItemParentItemUUID	BINTOHEX(TranspOrdItemParentItemUUID)
SourceStopUUID:	BINTOHEX(SourceStopUUID)
DestinationStopUUID	BINTOHEX(DestinationStopUUID)
CarrierUUID	BINTOHEX(CarrierUUID)
ShipperUUID	BINTOHEX(ShipperUUID
ConsigneeUUID	BINTOHEX(ConsigneeUUID)
TranspOrdNetDuration	to_double(TranspOrdNetDuration)
TranspOrdItemShipperUUI	BINTOHEX(TranspOrdItemShipperUUID)
ProductUUID	BINTOHEX(ProductUUID)
NetDurationInHours	to_decimal((to_integer("TranspOrdNetDuration" / 10000)) + (to_integer((MOD("TranspOrdNetDuration", 10000)) / 100) / 60 ),5,2)

2TF_S4HARM_I_TranspOrdStageAnalytics

Source: 1TL_S4Hx_I_TRANSPORDSTAGEANALYTICS

No transformations

2TL_S4HARM_I_TranspOrdStageAnalytics

Purpose:

Delta load of Transportation Order Items
Filled by Transformation Flow 2TF_S4HARM_I_TranspOrdStageAnalytics

2VR_S4HARM_I_TranspOrdStageAnalytics

SyWay Project > ERP-1041: DDFS - P2F - Plan to Fulfill > image-2026-2-10_14-38-53.png

Filter:

TranspOrdStageDestStopCategory = 'L'

Projection: Exclude ALL, except:

Projection Details
Include Column: TransportationOrderUUID
Include Column: TranspOrdStageDistance
Include Column: TranspOrdStageDistanceUnit
Include Column: TranspOrdStageNetDuration

Formula:

Field	Formula
TransportationOrderStageUUID	BINTOHEX(TransportationOrderStageUUID)
TransportationOrderUUID	BINTOHEX(TransportationOrderUUID)
TranspOrdStageSrceStopUUID	BINTOHEX(TranspOrdStageSrceStopUUID)
TranspOrdStageDestStopUUID	BINTOHEX(TranspOrdStageDestStopUUID)
CarrierUUID	BINTOHEX(CarrierUUID)
NumberOfStages	1

Aggregation

Field	Aggregation
NumberOfStages	SUM
TranspOrdStageDistance	SUM
TranspOrdStageNetDuration	SUM

Propagation Layer

3VR_P2FINC_MaterialStock

Source: 2VR_S2HARM_GoodsMovementDocumentDEX & xxxxxxxx

SyWay Project > ERP-1041: DDFS - P2F - Plan to Fulfill > image-2026-2-9_15-37-1.png

Filters:

Flow	Filter Values
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

SyWay Project > ERP-1041: DDFS - P2F - Plan to Fulfill > image-2026-2-9_15-44-54.png

Calculation:

Name	Description	Data Type	Expression	Notes
RecordType	Used for Non-Cumulative Key Figures to track inventory balance over time.	Integer	case when 'PostingDate' < '20251231' then 2 when 'PostingDate' = '20251231' then 1 else 0 end	The dates must be parameterised to set the marker based on an input table.

3VR_P2FTMS_TransportationOrder

Reporting Layer

4MA_P2FINV_DowntimeFact

Supports:

Includes technical details for:

Calculated Measures (Post Aggregation Calculations / exception aggregation etc)

Report Field Description

SAP Table-Field Name / process

Comments / Calculation / Formula / Restriction dimensions and values

Aggregation of data

Example SAP field data

CurrentStock

MatlStkChangeQtyInBaseUnit

Non-Cumulative

Record Type Field: RecordType

TimeDimension: PostingDate

Earliest Reporting Start Date: TBD

LatestReportingEndDate: TBD

Set Unbooked Values to 0: X

LAST

1,000

Restricted Measures

tbd

Currency Conversions

tbd

Variables

Document Links

Introduction

Stock Balances

EWM Managed Plants:

Physical Inventory

Source System Extractors

Inbound Layer

Harmonisation Layer

2TL_S2HARM_GoodsMovementDocumentDEX

2TF_S4HARM_I_GoodsMovementDocumentDEX

2VR_S2HARM_GoodsMovementDocumentDEX

2TL_S4HARM_C_TranspOrdItemAnlytsSDEX

2TF_S4HARM_C_TranspOrdItemAnlytsSDEX

2VR_S4HARM_C_TranspOrdItemAnlytsSDEX

2TF_S4HARM_I_TranspOrdStageAnalytics

2TL_S4HARM_I_TranspOrdStageAnalytics

2VR_S4HARM_I_TranspOrdStageAnalytics

Propagation Layer

3VR_P2FINC_MaterialStock

Union:

3VF_P2FINV_MaterialStock

3VR_P2FTMS_TransportationOrder

Reporting Layer

4MA_P2FINV_DowntimeFact

Calculated Measures (Post Aggregation Calculations / exception aggregation etc)

Restricted Measures

Currency Conversions

Variables

Data access controls

Outbound Layer