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.
• Freight KPI scores (Freight Unit Compliance, FSD Timing, Freight Agreement Usage, Overall Compliance) tracked weekly and by business entity.
• Freight Cost analysis – breakdown of transportation charges by type, carrier, company code, purchasing organisation, plant, document and posting status.
• Carrier Performance – confirmed pick-up vs. actual, confirmed ETA vs. actual arrival, Proof-of-Delivery rate, and event-reporting rate.
• Freight Cost Allocation – breakdown of settled freight costs by company code, sales/purchase organisation, plant, order, material and G/L account.

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

Bonded Stock Reports:

Global Batch Track & Trace

The following table is a mapping of ERP-410's requirements, the Analytical Model used and then a mapping to the legacy code Internal Table(s) used

Tolling Dashboad

Physical Inventory

Physical inventory adjustments are processed in SAP as material documents with movement types 701/702 (inventory difference posting). These postings are captured in MSEG and will flow through the standard I_GoodsMovementDocument CDS view. No separate extraction path is required; physical inventory adjustments are included in the GoodsMovementDocumentDEX flow and will be unioned with the period opening balance to produce the closing balance.

Dataflow Diagram

Source System Extractors

`

VDM

/SYQ/WPP_PCDDocuments - WPP - PCD Document Links by Material/Plant

GAP: Report is cross instance, which means ROW and China data must be combined/. Cross plant BOMs? 

@AbapCatalog.sqlViewName: 'ZWPP_VPCD'
@AbapCatalog.compiler.compareFilter: true   --  push WHERE clause filter conditions down to the database level
@AbapCatalog.preserveKey: true              -- compiler to keep the key definition exactly as specified. Should this be false?
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'WPP - PCD Document Links by Material/Plant'

@Analytics.dataCategory: #DIMENSION         -- Master Data, no measures.
@Analytics.dataExtraction.enabled: true
@OData.publish: true   -- oData service needed to publish to SAC

@ObjectModel.usageType: {
  serviceQuality: #C,                      --  Customer/partner developed — stability not guaranteed by SAP
  sizeCategory:   #M,                      -- Medium — thousands to low millions of rows
  dataClass:      #MASTER_DATA             -- Slow changing reference data
}

define view /SYQ/WPP_PCDDocuments
  as select from I_MaterialBOMLink          as m               -- replaces MAST
    inner join   I_BillOfMaterialItem       as bi              -- replaces STPO + STAS
      on  m.BillOfMaterial          = bi.BillOfMaterial
      and m.BillOfMaterialVariant   = bi.BillOfMaterialVariant
    inner join   I_DocumentInfoRecord       as d               -- replaces DRAT
      on  bi.DocumentType           = d.DocumentType
      and bi.DocumentNumber         = d.DocumentNumber
      and bi.DocumentVersion        = d.DocumentVersion
      and bi.DocumentPart           = d.DocumentPart

Inbound Layer

Join conditions for TSM tables:

1TL_S4Hx_I_BATCHWHEREUSEDLIST

1FR_S4Hx_I_BATCHWHEREUSEDLIST

1TL_S4Hx_Specs

BLOCKED — source CDS view, tables and fields TBD. Pending ZWPP_MDE_HCE analysis.

1TL_S4Hx_I_FREIGHTAGREEMENT

Initial + delta load of Freight Agreement records from /SYQ/I_FREIGHTAGREEMENT (XE_FreightAgreement). Filled by 1FR_S4Hx_I_FREIGHTAGREEMENT.

TF  1FR_S4Hx_I_FREIGHTAGREEMENT

Source: /SYQ/FreightAgreement (XE_FreightAgreement)

Replication flow loading /SYQ/I_FREIGHTAGREEMENT into 1TL_S4Hx_I_FREIGHTAGREEMENT. No transformations.

1TL_S4Hx_I_INVOICEDISP

Initial + delta load of Carrier Invoice and Dispute records from /SYQ/I_INVOICEDISP (XE_InvoiceDisp). Filled by 1FR_S4Hx_I_InvoiceDisp.

1FR_S4Hx_I_NVOICEDISP

Source: /SYQ/InvoiceDisp (XE_InvoiceDisp)

Replication flow loading /SYQ/InvoiceDisp into 1TL_S4Hx_I_INVOICEDISP. No transformations.

1TL_S4Hx_I_OUTBOUND

Initial + delta load of Outbound Delivery header records from I_OUTBOUNDDELIVERY (XE_Outbound). Filled by 1FR_S4Hx_I_Outbound.

1FR_S4Hx_I_OUTBOUND

Source: I_OUTBOUNDDELIVERY (XE_Outbound)

Replication flow. No transformations.

1TL_S4Hx_I_OUTBOUNDITEM

Initial + delta load of Outbound Delivery item records from C_OUTBOUNDDELIVERYDEX (XE_OutboundItem). Filled by 1FR_S4Hx_I_OutboundItem.

1FR_S4Hx_I_OUTBOUNDITEM

Source: C_OUTBOUNDDELIVERYDEX (XE_OutboundItem)

Replication flow. No transformations.

Harmonisation Layer

2TL_S4HARM_GoodsMovementDocumentDEX

Type: TL (Table/Load)

Source: 1TL_S4Hx_I_GOODSMOVEMENTDOCUMENTDEX

Purpose: Delta load of Material Documents. Set keys. Filled by 2FT_S4HARM_I_GoodsMovementDocumentDEX.

Projection:

Add as Key: MaterialDocumentYear

Add as Key: MaterialDocument

Add as Key: MaterialDocumentItem

Keep keys MaterialDocumentKey1-6 for Delta Capture.

2FT_S4HARM_I_GoodsMovementDocumentDEX

Type: TF (Transformation Flow)

Source: 1TL_S4Hx_I_GOODSMOVEMENTDOCUMENTDEX

Purpose: Transformation flow for GoodsMovementDocumentDEX.

Projection:

Add as Key: MaterialDocumentYear

Add as Key: MaterialDocument

Add as Key: MaterialDocumentItem

2VR_S4HARM_GoodsMovementDocumentDEX

Type: VR (View)

Source: 2TL_S4HARM_GoodsMovementDocumentDEX

Purpose: View on harmonised goods movement data.

Projection:

Exclude: MaterialDocumentKey1

Exclude: MaterialDocumentKey2

Exclude: MaterialDocumentKey3

Exclude: MaterialDocumentKey4

Exclude: MaterialDocumentKey5

Exclude: MaterialDocumentKey6

Note: MaterialDocumentKey1-6 is a compound delta-capture key — discarded once DocNo, DocYr and DocItem are established as the key in the TL step.

2TL_S4HARM_C_TranspOrdItemAnlytsSDEX

Type: TL (Table/Load)

Source: 1TL_S4Hx_C_TRANSPORDITEMANALYSTDEX

Purpose: Delta load of Transportation Order Items. Filled by 2FT_S4HARM_C_TranspOrdItemAnlytsSDEX.

2FT_S4HARM_C_TranspOrdItemAnlytsSDEX

Type: TF (Transformation Flow)

Source: 1TL_S4HR_C_TRANSPORDITEMANALYSTDEX

Purpose: No transformations.

Notes: Filter documentation missing in source DDFS — to be confirmed.

2VR_S4HARM_C_TranspOrdItemAnlytsSDEX

Source: 2TL_S4HARM_C_TranspOrdItemAnlytsSDEX

View on harmonised transportation order item data.

Filter: TransportationOrder <> '' OR TransportationOrder IS NOT NULL.

Formula / Aggregation:

2TL_S4HARM_I_TranspOrdStageAnalytics

Type: TL (Table/Load)

Source: 1TL_S4Hx_I_TRANSPORDSTAGEANALYTICS

Purpose: Delta load of Transportation Order Stage records. Filled by 2FT_S4HARM_I_TranspOrdStageAnalytics.

2FT_S4HARM_I_TranspOrdStageAnalytics

Type: TF (Transformation Flow)

Source: 1TL_S4Hx_I_TRANSPORDSTAGEANALYTICS

Purpose: No transformations.

2VR_S4HARM_I_TranspOrdStageAnalytics

Source: 2TL_S4HARM_I_TranspOrdStageAnalytics

View on stage analytics with distance and duration aggregation.

Filter: TranspOrdStageDestStopCategory = 'L'.

Projection: Exclude all except: TransportationOrderUUID, TranspOrdStageDistance, TranspOrdStageDistanceUnit, TranspOrdStageNetDuration.

Formula / Aggregation:

2TL_S4HARM_I_TranspChargesRoot (2TL_TransChRoot)

Type: TL (Table/Load)

Source: 1TL_S4Hx_I_TranspChargesRoot (1TL_TransChRoot)

Purpose: Delta load of Freight Order Charge Root records (/SCMTMS/D_TCHRGR). Filled by 2FT_S4HARM_I_TranspChargesRoot.

2FT_S4HARM_I_TranspChargesRoot

Type: TF (Transformation Flow)

Source: 1TL_S4Hx_I_TranspChargesRoot (1TL_TransChRoot)

Purpose: No transformations.

2VR_S4HARM_I_TranspChargesRoot (2VR_TransChRoot)

Source: 2TL_S4HARM_I_TranspChargesRoot

View on Freight Order Charge Root records.

Filter: CALC_STATUS <> ''.

Formula / Aggregation:

2TL_S4HARM_I_TranspChargesItem (2TL_TransChitem)

Type: TL (Table/Load)

Source: 1TL_S4Hx_I_TranspChargesItem (1TL_TransChitem)

Purpose: Delta load of Freight Order Charge Item records (/SCMTMS/D_TCHRGI). Filled by 2FT_S4HARM_I_TranspChargesItem.

2FT_S4HARM_I_TranspChargesItem

Type: TF (Transformation Flow)

Source: 1TL_S4Hx_I_TranspChargesItem (1TL_TransChitem)

Purpose: No transformations.

2VR_S4HARM_I_TranspChargesItem (2VR_TransChitem)

Source: 2TL_S4HARM_I_TranspChargesItem

View on Freight Order Charge Item records.

Filter: HOST_KEY IS NOT NULL.

Formula / Aggregation:

2TL_S4HARM_I_TranspChargesItemElement (2TL_TransChItemE)

Type: TL (Table/Load)

Source: 1TL_S4Hx_I_TranspChargesItemElement (1TL_TransChItemE)

Purpose: Delta load of Freight Order Charge Element records (/SCMTMS/D_TCHRGE). Filled by 2FT_S4HARM_I_TranspChargesItemElement.

2FT_S4HARM_I_TranspChargesItemElement

Type: TF (Transformation Flow)

Source: 1TL_S4Hx_I_TranspChargesItemElement (1TL_TransChItemE)

Purpose: No transformations.

2VR_S4HARM_I_TranspChargesItemElement (2VR_TransChItemE)

Source: 2TL_S4HARM_I_TranspChargesItemElement

View on Freight Order Charge Element records.

Filter: ROOT_KEY IS NOT NULL AND INVOICING <> ''.

Formula / Aggregation:

2TL_S4HARM_I_TranspExecData (2TL_TransExec)

Type: TL (Table/Load)

Source: 1TL_S4Hx_I_TranspExecData (1TL_TransExec)

Purpose: Delta load of Transportation Order Execution events (/SCMTMS/D_TOREXE). Provides event codes, actual dates/times, and discrepancy indicators for carrier performance KPIs (ERP-1782). Filled by 2FT_S4HARM_I_TranspExecData.

2FT_S4HARM_I_TranspExecData

Type: TF (Transformation Flow)

Source: 1TL_S4Hx_I_TranspExecData (1TL_TransExec)

Purpose: No transformations.

2VR_S4HARM_I_TranspExecData (2VR_TransExec)

Source: 2TL_S4HARM_I_TranspExecData

View on Transportation Order Execution event data.

Filter: EVENT_REVOKED <> 'X' AND EVENT_STATUS <> ''.

Note: Event code mappings (pick-up, arrival, POD) must be configured as input parameters or a reference table in DSP — client-specific customising values in /SCMTMS/D_TOREXE.

Formula / Aggregation:

2TL_S4HARM_I_TranspRootNode (2TL_TransRootN)

Type: TL (Table/Load)

Source: 1TL_S4Hx_I_TranspRootNode (1TL_TransRootN)

Purpose: Delta load of Freight Settlement Documents (/SCMTMS/D_SF_ROT). Used for FSD Timing Compliance KPI (ERP-1795) and settlement header joins (ERP-2359). Filled by 2FT_S4HARM_I_TranspRootNode.

2FT_S4HARM_I_TranspRootNode

Type: TF (Transformation Flow)

Source: 1TL_S4Hx_I_TranspRootNode (1TL_TransRootN)

Purpose: No transformations.

2VR_S4HARM_I_TranspRootNode (2VR_TransRootN)

Source: 2TL_S4HARM_I_TranspRootNode

View on Freight Settlement Document header records.

Filter: SFIR_TYPE <> '' AND LIFECYCLE <> 'X'.

Formula / Aggregation:

2TL_S4HARM_C_CustSettlmtDEX (2TL_CustSettlmt)

Type: TL (Table/Load)

Source: 1TL_S4Hx_C_CustSettlmtDEX (1TL_CustSettlmt)

Purpose: Delta load of Customer/Freight Settlement documents (C_CustSettlmtDEX — WBRP/WBRK). Settlement item data for Freight Cost Allocation (ERP-2359). Filled by 2FT_S4HARM_C_CustSettlmtDEX.

2FT_S4HARM_C_CustSettlmtDEX

Type: TF (Transformation Flow)

Source: 1TL_S4Hx_C_CustSettlmtDEX (1TL_CustSettlmt)

Purpose: No transformations.

2VR_S4HARM_C_CustSettlmtDEX (2VR_CustSettlmt)

Type: VR (View)

Source: 2TL_S4HARM_C_CustSettlmtDEX

Purpose: View on Customer/Freight Settlement document items.

Filter: CustSettlmt IS NOT NULL

Projection:

Include: CustSettlmt

Include: CustSettlmtItem

Include: CompanyCode

Include: SettlementFiscalYear

Include: ControllingArea

Include: CostCenter

Include: BusinessArea

Include: PurchasingOrganization

Include: Plant

Include: Material

Include: CndnContrType

Include: ActualSettlmtDate

Include: CreationDate

Include: CreatedByUser

2FT_S4HARM_I_BatchWhereUsedLevel

Type: TF (Transformation Flow)

Source: 1TL_S4Hx_I_BatchWhereUsedLevel

Purpose: Transformation flow for batch where-used level data.

Projection:

Add as Key: Material

Add as Key: Plant

Add as Key: Batch

Add as Key: ParentMaterial

Add as Key: ParentPlant

Add as Key: ParentBatch

2TL_S4HARM_I_BatchWhereUsedLevel

Type: TL (Table/Load)

Source: 2FT_S4HARM_I_BatchWhereUsedLevel

Purpose: Load of single-level CHVW batch where-used records. Filled by 2FT_S4HARM_I_BatchWhereUsedLevel.

2VR_S4HARM_I_BatchWhereUsedLevel

Type: VR (View)

Source: 2TL_S4HARM_I_BatchWhereUsedLevel

Purpose: View on single-level batch where-used records.

Filter: Batch IS NOT NULL AND ParentBatch IS NOT NULL

Projection:

Include: Material

Include: Plant

Include: Batch

Include: ParentMaterial

Include: ParentPlant

Include: ParentBatch

2TL_S4HARM_I_NCN

Type: TL (Table/Load)

Source: /SYQ/NCN

Purpose: BLOCKED — pending CL_IT_NCN analysis. Source Z-table and fields TBD.

Notes: BLOCKED

BLOCKED — TBD

2VR_S4HARM_I_NCN

Type: VR (View)

Source: 2TL_S4HARM_I_NCN

Purpose: BLOCKED — pending CL_IT_NCN analysis. Filter, formula and projection TBD.

Notes: BLOCKED

BLOCKED — TBD

2TL_S4HARM_I_InvoiceDisp

Source: 1TL_S4Hx_I_InvoiceDisp

Delta load of Carrier Invoice and Dispute records (/SCMTMS/D_INDSRT). Filled by 2FT_S4HARM_I_InvoiceDisp.

2FT_S4HARM_I_InvoiceDisp

Source: 1TL_S4Hx_I_InvoiceDisp

No transformations.

2VR_S4HARM_I_InvoiceDisp (2VR_InvoiceDisp)

Source: 2TL_S4HARM_I_InvoiceDisp

View on Carrier Invoice and Dispute records. CARRIER_INVOICE_KEY is already present on 2VR_TransRootN and serves as the join key from the settlement document side. Used by ERP-1793 Document Relationships report.

Filter: HOST_KEY IS NOT NULL.

Projection: Include: HOST_KEY, REF_KEY, CARRIER_INVOICE_KEY, INVOICE_ID, INVOICE_DATE, CARRIER_ID, STATUS, CREATED_ON.

Formula / Aggregation:

2TL_S4HARM_I_Outbound

Source: 1TL_S4Hx_I_Outbound

Delta load of Outbound Delivery header records (I_OutboundDelivery / LIKP). Filled by 2FT_S4HARM_I_Outbound.

2FT_S4HARM_I_Outbound

Source: 1TL_S4Hx_I_Outbound

No transformations.

2VR_S4HARM_I_Outbound (2VR_Outbound)

Source: 2TL_S4HARM_I_Outbound

View on harmonised Outbound Delivery header data. Provides PGI date (ActualGoodsMovementDate) for Freight Unit Compliance planning-status determination (ERP-1795) and outbound/inbound split for Event Reporting Rate (ERP-1782).

Filter: OutboundDelivery IS NOT NULL AND ActualGoodsMovementDate IS NOT NULL.

Projection: Include: OutboundDelivery, ShippingPoint, ShipToParty, SoldToParty, ActualGoodsMovementDate, OverallSDProcessStatus, DeliveryDate, TransportationPlanningStatus, GoodsMovementStatus.

Formula / Aggregation:

TL  2TL_S4HARM_I_OutboundItem

Source: 1TL_S4Hx_I_OutboundItem

Delta load of Outbound Delivery item records (C_OutboundDeliveryDEX / LIPS). Filled by 2FT_S4HARM_I_OutboundItem.

TF  2FT_S4HARM_I_OutboundItem

Source: 1TL_S4Hx_I_OutboundItem

No transformations.

VR  2VR_S4HARM_I_OutboundItem (2VR_OutboundItem)

Source: 2TL_S4HARM_I_OutboundItem

View on harmonised Outbound Delivery item data. Carries TransportationOrderItemUUID enabling the join from delivery item to TORROT for Freight Unit Compliance. Also feeds 3VR_TrItemDex (already documented).

Filter: OutboundDelivery IS NOT NULL.

Projection: Include: OutboundDelivery, OutboundDeliveryItem, Material, Plant, StorageLocation, Batch, ActualDeliveredQuantity, DeliveryQuantityUnit, ReferenceSDDocument, ReferenceSDDocumentItem, TransportationOrderItem, PickingStatus, GoodsMovementStatus.

Formula / Aggregation:

Propagation Layer

3VR_P2FINC_MaterialStock

Type: VR (View)

Source: 2VR_S4HARM_I_GLAccountLineItemRAW  UNION  2VR_S4HARM_I_GoodsMovementDocumentDEX

Purpose: Combined source view feeding the material stock flow. Union of GL adjustment postings and goods movement documents.

Filter: GLAccountLineItemRAW: ReferenceDocumentType = 'PRCHG' AND ControllingBusTransacType = '' AND SourceLedger = '0L' AND Product != '' GoodsMovementDocumentDEX: Material != '' AND InventoryStockType != ''

Formula / Aggregation:

Union: Accept default union mappings

3VF_P2FINV_MaterialStock

Type: VF (Formula/Fact View)

Source: 3VR_P2FINC_MaterialStock

Purpose: Fact view on material stock. Applies RecordType calculation for Non-Cumulative Key Figures.

Formula / Aggregation:

RecordType (Integer):

  CASE WHEN PostingDate < '20251231' THEN 2

       WHEN PostingDate = '20251231' THEN 1

       ELSE 0 END

Note: Dates must be parameterised via input table.

3VR_P2FTMS_TransportationOrderSql (3VR_TranOrdSql)

Type: VR — SQL Table Function

Supports: ERP-1795, ERP-1792, ERP-1782

Source: 2VR_S4HARM_C_TranspOrdItemAnlytsDEX + 2VR_TransChRoot + 2VR_TransChitem + 2VR_TransChItemE + 2VR_TransExec (via join)

Purpose: SQL-level aggregation and pre-join of Transportation Order items with Charges Root, Item, Element data and Execution events. Filters and projects fields required downstream.

3VR_P2FTMS_TransportationOrder (3VR_TranOrd)

Type: VR (View)

Supports: ERP-1795, ERP-1792, ERP-1782

Source: 3VR_P2FTMS_TransportationOrderSql  LEFT JOIN  2VR_S4HARM_C_TranspOrdStageAnalytics  ON TransportationOrderUUID

Purpose: Core transportation order view used by all TMS analytical models.

Filter: TransportationOrder <> '' AND TranspOrdLifeCycleStatus NOT IN ('X', 'Z')

Projection:

Include: TransportationOrder, TransportationOrderUUID, TransportationOrderType, TransportationMode

Include: CarrierUUID, ShipperUUID, ConsigneeUUID, FreightAgreement

Include: PlannedDepartureDateTime, ActualDepartureDateTime, PlannedArrivalDateTime, ActualArrivalDateTime

Include: TranspOrdLifeCycleStatus, TranspOrdPlanningStatus, ShippingCondition

Include: TransportationOrderItemUUID, Product / ShipFromParty / ShipToParty

Include (from stage): NetDurationInHours, NumberOfStages, TranspOrdStageDistance / DistanceUnit

Charge fields: FAGRMNTID044, HOST_KEY, CALC_AMOUNT, AMOUNT, INVOICED_AMT, ANALYTICRELEV, CCOD, MANUALLY_CHANGED

Execution fields: EVENT_CODE, ACTUAL_DATE, DISCREPANCY, DISCR_TYPE, PROCESSING_STATUS

3VF_P2FTMS_TransportationOrder (3VF_TranOrd)

Type: VF (Formula/Fact View)

Supports: ERP-1795, ERP-1792, ERP-1782

Source: 3VR_P2FTMS_TransportationOrder

Purpose: Formula / Calculation view. Applies final field-level derivations and unit conversions before exposure to analytical model.

3VR_P2FTMS_FrtCstAlloc (3VR_FrtCstAlloc)

Type: VR (View)

Supports: ERP-2359

Source: 2VR_S4HARM_I_TranspRootNode  JOIN  2VR_S4HARM_C_CustSettlmtDEX  JOIN  2VR_S4HARM_I_GLAccountLineItemRAW

Purpose: Pre-join view for Freight Cost Allocation report (ERP-2359). Links FSD, settlement document, and G/L line items.

Filter: ReferenceDocumentContext = 'WB' AND S.CustSettlmt IS NOT NULL AND N.LIFECYCLE <> 'X'

Projection:

From CustSettlmt: CustSettlmt, CustSettlmtItem, CompanyCode, SettlementFiscalYear, PurchasingOrganization, Plant, Material, CndnContrType, ActualSettlmtDate

From GL Account Line Item: GLAccount, DebitCreditCode, AmountInCompanyCodeCurrency, CompanyCodeCurrency, AmountInTransactionCurrency, TransactionCurrency, CostCenter, ControllingArea, ProfitCenter, BusinessArea, SalesOrder / PurchaseOrder

From TranspRootNode: SFIR_ID, CREATED_ON, TSP_ID, PURCH_COMPANY_CODE, PURCH_ORG_ID, LIFECYCLE, BLOCK, BLOCK_REASON

Joins:

G.CompanyCode = S.CompanyCode

AND G.FiscalYear = S.SettlementFiscalYear

AND G.ReferenceDocument = S.CustSettlmt

AND G.ReferenceDocumentItem = S.CustSettlmtItem

AND G.ReferenceDocumentContext = 'WB'

AND N.REF_KEY = S.SettlmtRefDoc

3VF_P2FTMS_FrtCstAlloc (3VF_FrtCstAlloc)

Type: VF (Formula/Fact View)

Supports: ERP-2359

Source: 3VR_P2FTMS_FrtCstAlloc

Purpose: Formula / Calculation view. Applies final derivations (e.g. account type classification: Cost vs. Material) before exposure to analytical model.

3VR_P2FINV_TF_BatchChain

Type: TF (SQLScript Table Function)

Supports: ERP-410

Source: 2VR_S4HARM_I_BatchWhereUsedLevel (read at runtime — not persisted)

Purpose: SQLScript Table Function. Called dynamically at runtime by SAC. Recursive CHVW traversal for a single batch input. DSP equivalent of ZWPP_HCE GET_BATCHES WHILE loop. Output feeds 3VR_P2FINV_BatchTrace and 3VR_P2FINV_QC.

Projection:

Input Parameters: IV_Material NVARCHAR(18), IV_Plant NVARCHAR(4), IV_Batch NVARCHAR(10), IV_DIRECTION NVARCHAR(1)  [B = Bottom Up / T = Top Down]

Output columns: Material, Plant, Batch, ParentMaterial, ParentPlant, ParentBatch, Level (0 = seed batch)

Formula / Aggregation:

Already-processed batches excluded via NOT EXISTS check.

Loops until no new batches returned.

Direction B: joins on Material/Plant/Batch to find ParentMaterial/ParentPlant/ParentBatch.

Direction T: reverses join direction.

3VR_P2FINV_BatchTrace

Type: VR (View)

Supports: ERP-410 Req 0

Source: 3VR_P2FINV_TF_BatchChain

Purpose: Primary result set for the batch traceability report. Enriches TF output with master data and classification. Filter anchor for all branch AMs.

Joins:

LEFT JOIN 2VD_S4HARM_I_Batch ON Material=Material AND Batch=Batch  →  adds ExternalBatch

LEFT JOIN 2VD_S4HARM_Material ON Material=Material  →  adds MaterialDescription, BaseUnit

LEFT JOIN 2VD_S4HARM_Plant ON Plant=Plant  →  adds PlantName

LEFT JOIN 3VR_P2FINV_CharcValue ON Material=ObjectInternalID  →  adds characteristic values (filter to relevant class type)

3VF_P2FINV_BatchTrace

Type: VF (Formula/Fact View)

Supports: ERP-410 Req 0

Source: 3VR_P2FINV_BatchTrace

Purpose: Formula only — makes the view a fact. No joins.

Formula / Aggregation:

ChainDirection: CASE WHEN Level = 0 THEN 'Seed' WHEN ParentMaterial = Material THEN 'Same Material' ELSE 'Cross Material' END

IsFinishedGood: CASE WHEN Level = 0 THEN 'X' ELSE '' END

3VR_P2FINV_BatchDel

Type: VR (View)

Supports: ERP-410 Req 7

Source: 2VR_S4HARM_GoodsMovementDocumentDEX  +  2VR_S4HARM_I_OutboundDelivery  +  2VR_S4HARM_I_Customer

Purpose: Resolves outbound deliveries for batches in the chain. Equivalent of GET_DEL in ZWPP_HCE.

Filter: Join 1 filter: ReferenceSDDocument IS NOT NULL AND PurchaseOrder IS NULL AND Material/Plant/Batch IN (SAC batch chain context)

Projection:

OutboundDelivery / OutboundDeliveryItem

ReferenceSDDocument / ReferenceSDDocumentItem / ReferenceSDDocumentCategory (TBD)

PurchaseOrder / PurchaseOrderItem

SoldToParty / Country (TBD) / CustomerName (TBD) / CityName (TBD)

Material / Batch / Plant

ActualGoodsmovementDate

ActualDeliveryQuantity / DeliveryQuantityUnit

SalesGroup / SalesOffice

Joins:

Join 1: GoodsMovementDocumentDEX INNER JOIN OutboundDelivery ON ReferenceSDDocument = OutboundDelivery

Join 2: Result of Join 1 INNER JOIN Customer ON SoldToParty = KUNNR

3VF_P2FINV_BatchDel

Type: VF (Formula/Fact View)

Supports: ERP-410 Req 7

Source: 3VR_P2FINV_BatchDel

Purpose: Final derivations on delivery data before AM exposure.

3VR_P2FINV_BatchDelSpec

Type: VR (View)

Supports: ERP-410 Req 8

Source: 3VR_P2FINV_BatchDel

Purpose: All spec entries per delivery item. Contrast with BatchDel which carries first spec only.

Notes: BLOCKED — create_spec_table / init_specs / get_spec all in ZWPP_MDE_HCE. Source tables and join keys TBD.

BLOCKED — TBD

3VF_P2FINV_BatchDelSpec

Type: VF (Formula/Fact View)

Supports: ERP-410 Req 8

Source: 3VR_P2FINV_BatchDelSpec

Purpose: BLOCKED — dependent on 3VR_P2FINV_BatchDelSpec.

BLOCKED — TBD

3VR_P2FINV_QC

Type: VR (View)

Supports: ERP-410 Req 3 (NCN) / Req 4 (Specs) / Req 5 (FG Characteristics)

Source: 3VR_P2FINV_TF_BatchChain (shared with BatchTrace)

Purpose: NCN records, specifications and FG characteristics for all batches in the chain.

Joins:

INNER JOIN 3VR_CharcValue ON ObjectInternalID = MATNR (filter to relevant class type)  →  STATUS: Available

INNER JOIN 2VR_S4HARM_I_NCN ON MATNR/WERKS/CHARG  →  STATUS: BLOCKED pending CL_IT_NCN

INNER JOIN TBD (Specifications)  →  STATUS: BLOCKED pending ZWPP_MDE_HCE

Notes: Partial BLOCKED — NCN and Specs TBD. CharcValue join is available.

3VF_P2FINV_QC

Type: VF (Formula/Fact View)

Supports: ERP-410 Req 3, 4, 5

Source: 3VR_P2FINV_QC

Purpose: Final derivations on quality and compliance data.

Notes: Partial BLOCKED — NCN and Specs TBD.

3VR_P2FTMS_DocRelationship

Source: 2VR_S4HARM_C_TranspOrdItemAnlytsSDEX JOIN 2VR_S4HARM_I_TranspRoot JOIN 2VR_S4HARM_I_TranspRootNode JOIN 2VR_S4HARM_I_FreightAgreement JOIN 2VR_S4HARM_I_InvoiceDisp JOIN 2VR_S4HARM_C_PurchaseOrderItem JOIN 2VR_S4HARM_C_SupplierInvoiceItem

Pre-join propagation view for the Document Relationships report (ERP-1793). Resolves all freight document references back to the originating source document (Sales Order / PO / Delivery).

Filter: BASE_BTD_ID IS NOT NULL.

Joins: TORITE.BASE_BTD_ID -> TORROT (FU/FO/BK via TOR_TYPE) -> SF_ROT (FSD via REF_KEY; Cost Dist via SFIR_TYPE) -> FAGROT (FA via FAG_KEY) -> INDSRT (Carrier Invoice/Dispute via CARRIER_INVOICE_KEY) -> EKKO/EKPO (Freight PO, item category L) -> RBKP (Invoice Receipt via PO reference).

Note: Memory consumption risk flagged (13/Apr/26) — UUID-based joins and relationship fan-out may require scope reduction during Detailed Design. Single instance only. Real-time not required.

3VF_P2FTMS_DocRelationship

Source: 3VR_P2FTMS_DocRelationship

Formula / Calculation view. Applies final derivations before exposure to analytical model. ERP-1793.

3VR_P2FTMS_Outbound (3VR_Outbound)

Source: 2VR_S4HARM_I_Outbound (header) INNER JOIN 2VR_S4HARM_I_OutboundItem (item) JOIN 2VR_S4HARM_C_TranspOrdItemAnlytsSDEX ON TransportationOrderItemUUID

Propagation view joining outbound delivery header and item data with the transportation order item. Provides the delivery-to-freight-unit linkage required for Freight Unit Compliance Score (ERP-1795) and the outbound leg for Event Reporting Rate (ERP-1782).

Filter: TransportationOrderItem IS NOT NULL.

Projection: Include: OutboundDelivery, OutboundDeliveryItem, TransportationOrderItem, TransportationOrder, ShipToParty, SoldToParty, Material, Plant, Batch, ActualGoodsMovementDate, ActualDeliveredQuantity, DeliveryQuantityUnit, TransportationPlanningStatus, GoodsMovementStatus, OverallSDProcessStatus.

Joins: INNER JOIN on OutboundDelivery = OutboundDelivery (header to item). LEFT JOIN to 2VR_S4HARM_C_TranspOrdItemAnlytsSDEX ON TransportationOrderItemUUID to resolve Freight Unit / Freight Order reference.

3VF_P2FTMS_Outbound (3VF_Outbound)

Source: 3VR_P2FTMS_Outbound

Formula / Calculation view. Applies final derivations before exposure to 4MA_P2FTMS_Outbound.

3VR_P2FTMS_TrpAnlytcs

Source: 2VR_S4HARM_I_TranspRoot JOIN

2VR_S4HARM_C_TranspOrdItemAnlytsSDEX JOIN

2VR_S4HARM_I_TranspChargesRoot JOIN

2VR_S4HARM_I_TranspChargesItem JOIN

2VR_S4HARM_I_TranspChargesItemElement JOIN

2VR_S4HARM_I_TranspExecData JOIN

2VR_S4HARM_I_TranspRootNode JOIN

2VR_S4HARM_I_FreightAgreement JOIN

2VR_S4HARM_I_TranspOrdStageAnalytics

SQL(?)-level aggregation and join of all TMS operational data.

Central propagation view for 4MA_P2FTMS_TrpAnlytcs.

Brings together freight order core data, charge detail, execution events, settlement documents, freight agreements, and stage distance/duration into a single queryable structure.

Filter: TransportationOrder <> '' AND TranspOrdLifeCycleStatus NOT IN ('X', 'Z').

Joins: TransRoot (header) JOIN TransRootItm (item) ON DB_KEY = PARENT_KEY.

JOIN ChargesRoot ON HOST_KEY = DB_KEY (freight order).

JOIN ChargesItem ON DB_KEY = PARENT_KEY (charges root).

JOIN ChargesItemElement ON ROOT_KEY = charges root key.

JOIN TransExec ON TORITMUID = freight order item.

JOIN TransRootNode ON REF_KEY = freight order DB_KEY.

JOIN FreightAgreement ON FAG_KEY = freight order FAG_KEY.

LEFT JOIN StageAnalytics ON TransportationOrderUUID.

Note: Stage data (distance, duration) aggregated at freight order level before join. Charge amounts summed per charge root. Execution events filtered to non-revoked, non-empty status.

3VF_P2FTMS_TrpAnlytcs

Source: 3VR_P2FTMS_TrpAnlytcs

Formula / Calculation view. Applies final field derivations and unit conversions before exposure to 4MA_P2FTMS_TrpAnlytcs.

3VR_P2FTMS_DocRelationship

Source: 2VR_S4HARM_C_TranspOrdItemAnlytsSDEX JOIN

2VR_S4HARM_I_TranspRoot JOIN

2VR_S4HARM_I_TranspRootNode JOIN

2VR_S4HARM_I_FreightAgreement JOIN

2VR_S4HARM_I_InvoiceDisp JOIN

2VR_S4HARM_C_PurchaseOrderItem JOIN

2VR_S4HARM_C_SupplierInvoiceItem

Pre-join view for the Document Relationships report (ERP-1793). Resolves all freight document references back to the originating source document (Sales Order / PO / Delivery).

Filter: BASE_BTD_ID IS NOT NULL.

Joins: TORITE.BASE_BTD_ID -> TORROT (FU/FO/BK via TOR_TYPE) -> SF_ROT (FSD via REF_KEY; Cost Dist via SFIR_TYPE) -> FAGROT (FA via FAG_KEY) -> INDSRT (Carrier Invoice/Dispute via CARRIER_INVOICE_KEY) -> EKKO/EKPO (Freight PO, item category L) -> RBKP (Invoice Receipt via PO reference).

Note: Memory consumption risk (13/Apr/26) — UUID-based joins and relationship fan-out may require scope reduction during Detailed Design.

Single instance only.

Real-time not required.

3VF_P2FTMS_DocRelationship

Source: 3VR_P2FTMS_DocRelationship

Formula / Calculation view. Applies final derivations before exposure to 4MA_P2FTMS_DocRelationship. ERP-1793.

Reporting Layer

4MA_P2FINV_DowntimeFact

Supports:

Includes technical details for:

Calculated Measures (Post Aggregation Calculations / exception aggregation etc)

4MA_P2FTMS_TransportationOrder (4MA_TranOrd) — updated

Source: 3VF_P2FTMS_TransportationOrder (3VF_TranOrd)

Supports ERP-1795, ERP-1792, and ERP-1782. This single analytical model serves all three TMS KPI reports via 3VF_TranOrd (freight charge pre-aggregation view).

Freight KPI Report (ERP-1795) — Intended KPI measures (draft):

Freight Cost Report (ERP-1792) — Intended measures (draft):

Carrier Performance Report (ERP-1782) — Intended measures (draft):

Shared analytical model with ERP-1795 and ERP-1792.

Note: Event code mappings (pick-up, arrival, POD) must be configured as input parameters or a reference table in DSP — client-specific values in /SCMTMS/D_TOREXE.

Carrier Performance Report (ERP-1782) — Intended measures (draft):

Shared analytical model with ERP-1795 and ERP-1792.

Note: Event code mappings (pick-up, arrival, POD) must be configured as input parameters or a reference table in DSP — client-specific values in /SCMTMS/D_TOREXE.

4MA_P2FTMS_Outbound (4MA_Outbound)

Source: 3VF_P2FTMS_Outbound (3VF_Outbound)

Supports Freight Unit Compliance dimension analysis (ERP-1795) and outbound event reporting (ERP-1782). Provides outbound delivery data linked to freight units, enabling planning-status-at-PGI calculations in SAC.

4MA_P2FTMS_TrpAnlytcs (4MA_TrpAnlytcs)

Source: 3VF_P2FTMS_TrpAnlytcs (3VF_TrpAnlytcs)

Broader transportation analytics model. Combines freight order core data, charge totals, execution events, stage distance/duration, settlement documents, and freight agreements into a single analytical model. Distinct from 4MA_TranOrd which serves the freight charge pre-aggregation path — TrpAnlytcs serves operational transportation reporting including carrier performance, route analytics, and freight cost overview.

4MA_P2FTMS_DocRelationship

Source: 3VF_P2FTMS_DocRelationship

Supports ERP-1793 — Document Relationships Report. Holistic view of all shipment documents related to a source Sales Order, Purchase Order, or Delivery. Single SAC list report, Tier 1 object.

Input parameters: Date range, Created By, Created On.

Measures: Document count per relationship type (SUM).

Note: Memory consumption risk due to UUID-based joins — scope may be reduced during Detailed Design. Single instance only.

4MA_P2FTMS_FrtCstAlloc  (4MA_FrtCstAlloc)

Source: 3VF_P2FTMS_FrtCstAlloc  (3VF_FrtCstAlloc)

• Supports: ERP-2359 – Freight Cost Allocation Report.

Calculated Measures:

Dimensions:

• Company Code, Purchasing Organisation, Sales Organisation (where populated)
• Plant, Material, Sales Order / Purchase Order
• G/L Account, Cost Center, Controlling Area, Business Area
• Period (ActualSettlmtDate)

Out of Scope:

Breakdown by charge type or carrier – refer to Freight Cost Report (ERP-1792) for that analysis.

4MA_P2FINV_BatchTrace

Input Parameters:

Dimensions:

Material / Plant / Batch / Vendor Batch / Material Description / Plant Name / Parent Material / Parent Plant / Parent Batch / Chain Level / Chain Direction

Measures:

Batch count by level.

4MA_P2FINV_QC

Dimensions:

Material / Plant / Batch / Class / Characteristic / Characteristic Value / NCN Number / NCN Status

Measures:

NCN Count (SUM)

Partially BLOCKED — NCN and Specs TBD. 

4MA_P2FINV_BatchDel

Dimensions:

OutboundDelivery / OutboundDeliveryItem / SoldToParty / Material / Plant / Batch / ReferenceSDDocument / ReferenceSDDocumentItem / ActualGoodsmovementDate / SalesGroup / SalesOffice / PurchaseOrder / PurchaseOrderItem / ActualDeliveryQuantity / DeliveryQuantityUnit

Measures:

Delivery Quantity (SUM)

BLOCKED — pending ZWPP_MDE_HCE analysis.

4MA_P2FINV_BatchDelSpec

Dimensions:

Delivery / Item / Customer / Material / Plant / Batch / Specification / Specification Value

Measures: TBD

BLOCKED — pending ZWPP_MDE_HCE analysis.

Restricted Measures

tbd

Currency Conversions

tbd

Variables

Data access controls

Outbound Layer

Appendix

Effort Estimate and Object Count

TMS KPI to source mapping