You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

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


Extractor NameBuild 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

Filter:

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


Formula:

FieldFormula
TransportationOrderItemUUIDBINTOHEX(TransportationOrderItemUUID)
TransportationOrderUUIDBINTOHEX(TransportationOrderUUID)
TranspOrdItemParentItemUUIDBINTOHEX(TranspOrdItemParentItemUUID)
SourceStopUUID:BINTOHEX(SourceStopUUID)
DestinationStopUUIDBINTOHEX(DestinationStopUUID)
CarrierUUIDBINTOHEX(CarrierUUID)
ShipperUUIDBINTOHEX(ShipperUUID
ConsigneeUUIDBINTOHEX(ConsigneeUUID)
TranspOrdNetDurationto_double(TranspOrdNetDuration)
TranspOrdItemShipperUUI

BINTOHEX(TranspOrdItemShipperUUID)

ProductUUIDBINTOHEX(ProductUUID)
NetDurationInHoursto_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

Filter:

 TranspOrdStageDestStopCategory = 'L'


Projection: Exclude ALL, except: 


Projection Details

Include Column: TransportationOrderUUID

Include Column: TranspOrdStageDistance

Include Column: TranspOrdStageDistanceUnit

Include Column: TranspOrdStageNetDuration


Formula:

FieldFormula
TransportationOrderStageUUIDBINTOHEX(TransportationOrderStageUUID)
TransportationOrderUUIDBINTOHEX(TransportationOrderUUID)
TranspOrdStageSrceStopUUIDBINTOHEX(TranspOrdStageSrceStopUUID)
TranspOrdStageDestStopUUIDBINTOHEX(TranspOrdStageDestStopUUID)
CarrierUUIDBINTOHEX(CarrierUUID)
NumberOfStages1


Aggregation

FieldAggregation
NumberOfStagesSUM
TranspOrdStageDistanceSUM
TranspOrdStageNetDurationSUM


Propagation Layer

3VR_P2FINC_MaterialStock

Source: 2VR_S2HARM_GoodsMovementDocumentDEX & xxxxxxxx

Filters:

FlowFilter Values
2VR_S4HARM_I_GLAccountLineItemRAW

"ReferenceDocumentType" = 'PRCHG' AND
"ControllingBusTransacType" = '' AND
"SourceLedger" = '0L' AND
"Product" != ''

2VR_S4HARM_I_GoodsMovementDocumentDEXMaterial" != '' 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:

NameDescriptionData TypeExpressionNotes
RecordTypeUsed for Non-Cumulative Key Figures to track inventory balance over time.Integercase 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 DescriptionSAP Table-Field Name / processComments / Calculation / Formula / Restriction dimensions and valuesAggregation of dataExample SAP field data
CurrentStockMatlStkChangeQtyInBaseUnit

Non-Cumulative

Record Type Field: RecordType

TimeDimension: PostingDate

Earliest Reporting Start Date: TBD

LatestReportingEndDate: TBD

Set Unbooked Values to 0: X

LAST1,000



Restricted Measures

tbd

Currency Conversions

tbd

Variables





































Data access controls











Outbound Layer

  • No labels