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.

KPI	Analytical Model
Stock Balances	4MA_P2FINV_MaterialStock
Freght KPI Report (ERP-1795)	xxxxxxxxxx
Freight Cost Report (ERP-1792)	xxxxxxxxxx
Carrier Performance (ERP-1782)	xxxxxxxxxx
Freight Cost Allocation (ERP-2359)	4MA_P2FTMS_FrtCstAlloc

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:

Req No	Requirement	Description	Source Tables	Analytical Model	Notes
0	Current Bonded Stock Position	Current stock quantity and value by Plant/SLOC/Material/Batch/StockType, filtered to bonded SLOCs and/or Plants	2VR_S4HARM_GoodsMovementDocumentDEX	4MA_P2FINV_MaterialStock (reuse)	Already built - filter to bonded SLOC/Plant in SAC story. No new AM required. NonCumulative KF CurrentStock already defined. Reconciles to MB52.
1	Inward Movements	Procurement receipts (GR against PO), production FG receipts, intercompany inbound â€” bonded plants/SLOCs only	2VR_S4HARM_GoodsMovementDocumentDEX	4MA_P2FINV_MaterialStock (reuse)	Filter MvT: 101/501/531/561/101 interco. Plant/SLOC filter for bonded scope. PO reference available via PurchaseOrder field on GoodsMovementDocumentDEX.
2	Outward Movements - Export/Domestic Sales	GI against outbound delivery (MvT 601/641 etc.). Identifies export vs domestic via customer country or sales org.	2VR_S4HARM_GoodsMovementDocumentDEX JOIN 2VR_S4HARM_I_OutboundDelivery JOIN 2VR_S4HARM_I_Customer	4MA_P2FINV_MaterialStock (reuse) + new 3VR for delivery enrichment	Delivery join pattern already defined in 3VR_P2FINV_BatchDel â€” reuse join logic. Customer country drives Export vs Domestic split. Possible ITAR â€” flag for DAE review before cross-region exposure.
3	Bonded <-> Non-Bonded Transfers	STOs and material documents transferring stock between bonded and non-bonded SLOCs/Plants. Must show STO reference, sending/receiving plant+SLOC.	2VR_S4HARM_GoodsMovementDocumentDEX	4MA_P2FINV_MaterialStock (reuse)	MvT 301/303/311/315/641 (STO). Both legs (issue+receive) present in MSEG. ReceivingPlant/StorageLocation/IssuingStorageLocation available on GoodsMovementDocumentDEX. No new source required.
4	Manufacturing Consumption	GI of bonded RM to Production Order (MvT 261). Shows Production Order number, component material, quantity consumed.	2VR_S4HARM_GoodsMovementDocumentDEX	4MA_P2FINV_MaterialStock (reuse)	ProductionOrder field available on GoodsMovementDocumentDEX. No BOM traversal required (confirmed in tech review). Filter MvT 261 + bonded SLOC/Plant.
5	Production FG Receipt - Bonded	GR of finished goods to bonded SLOC from Production Order (MvT 101 against order). Batch-level.	2VR_S4HARM_GoodsMovementDocumentDEX	4MA_P2FINV_MaterialStock (reuse)	MvT 101 with OrderID populated. Batch available. Distinguish from PO receipt (Req 1) by OrderID vs PurchaseOrder population.
6	Vendor Returns	Return deliveries to vendor (MvT 122) from bonded stock.	2VR_S4HARM_GoodsMovementDocumentDEX	4MA_P2FINV_MaterialStock (reuse)	MvT 122. PurchaseOrder/PurchaseOrderItem reference available. Bonded SLOC/Plant filter.
7	Duty-Triggering Movements	Movements associated with customs clearance requests' specific MvTs TBD with Saravanan/GTS team. Count of materials requested for clearance.	2VR_S4HARM_GoodsMovementDocumentDEX	4MA_P2FINV_MaterialStock (reuse)	MvT list to be confirmed (GTS/CMS specific). May require Z-table for clearance reference if not on MSEG. If GTS integration exists, assess /SAPSLL/ table availability in DSP
8	Batch-Level Traceability	Batch identification on all movements above. No recursive chain traversal â€” flat filter on MATNR/WERKS/CHARG.	2VR_S4HARM_GoodsMovementDocumentDEX JOIN 2VD_S4HARM_I_Batch	4MA_P2FINV_MaterialStock (reuse)	2VD_S4HARM_I_Batch to be created (already planned for ERP-410) -> reuse. No TF required in contrast with ERP-410 recursive BOM requirements. Batch filter is user selection, not chain expansion. Join with 2VR_BatchWUL to add batch numbers.
9	Scrap	Scrapping of bonded stock where applicable (MvT 551).	2VR_S4HARM_GoodsMovementDocumentDEX	4MA_P2FINV_MaterialStock (reuse)	MvT 551. Scope TBC 'where applicable' per functional requirements. Bonded SLOC/Plant filter.

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

Req No	Requirement	Description	Internal Table	Source Tables	Analytical Model	Notes
0	Batch Chain - Primary Report	The main report results screen showing the full resolved batch genealogy chain for the selected material/plant/batch and direction	GT_WORKLIST	CHVW / MCH1 / MARA / MAKT / T001W	4MA_P2FINV_BatchTrace	Entry point for all branching. Driven by TF_WPP_BatchTrace recursive traversal of CHVW. All 8 branch requirements filter against this result set
1	Material Movements	Reports all material movements for all materials/batches on the report results	GT_MSEG	MSEG / MKPF	4MA_P2FINC_MaterialStock	Filtered by MATNR/WERKS/CHARG from batch chain. Movement types 101/102/531/532. MENGE calculated via SHKZG +/-
2	Stocks	Reports all current stock of all materials/batches on the report results	GT_MCHB	Derived from MSEG via GoodsMovementDocumentDEX aggregation	4MA_P2FINC_MaterialStock	No separate MCHB extraction required - derived from GT_MSEG aggregated by MATNR/WERKS/CHARG per P2F DDFS pattern
3	NCN	Reports all NCN quality notifications for all the materials/batches on the report results	GT_NCN	New Z-table - pending CL_IT_NCN analysis	4MA_P2FINV_QualityCompliance	Blocked pending CL_IT_NCN analysis. Join on MATNR/WERKS/CHARG from batch chain assumed.
4	Specs	Shows all entries in the multi spec table for all materials/batches on the report results	GT_SPECS	Unknown - pending parent class ZWPP_MDE_HCE analysis	4MA_P2FINV_QualityCompliance	Blocked pending ZWPP_MDE_HCE. Shares AM with NCN and FG_CHARS assumed.
5	Finished Goods Characteristics	Reports characteristic values for all materials/batches on the report results	GT_CHAR	AUSP / CABN / CAWN via 3VR_CharcValue (already exists in DSP)	4MA_P2FINV_QualityCompliance	3VR_CharcValue already built - join to batch chain on ObjectInternalID = MATNR. Filter to relevant class type
6	~~PCD~~	~~Reports PCD document numbers for all materials/batches on the report results~~	~~GT_PCD~~	~~MAST / STAS / STPO / DRAT~~	~~4MA_P2FINV_PCDDocuments~~	J~~oin on MATNR/WERKS only - no CHARG. PCD is at material level not batch level. DOKAR = KPR AND DKTXT LIKE PCD%~~
7	Deliveries	Reports all outbound deliveries for all selected materials/batches including the first specification on the sales order	GT_DEL	LIKP / LIPS / KNA1 (via ZWPP_GET_MDE_DEL RFC)	4MA_P2FINV_Deliveries	Two-hop join: MSEG VBELN_IM to delivery then validated against batch chain. Includes first spec from VGBEL/VGPOS - spec logic in parent class ZWPP_MDE_HCE
8	Delivery Specs	Reports all outbound deliveries for all selected materials/batches and all specifications on the sales order	GT_DEL_SPEC	LIKP / LIPS / KNA1 plus all spec entries via create_spec_table	4MA_P2FINV_DeliverySpecs	Derived from GT_DEL via create_spec_table - returns full spec table per delivery item not just first entry. Spec logic blocked pending ZWPP_MDE_HCE availability

Tolling Dashboad

Req No	Requirement	Description	Source Tables	Analytical Model	Notes
0	Current Tolling Stock Position	Current stock quantity and value by Toller/Plant/SLOC/Material/Batch/StockType. Special stock type O (stock at vendor/toller) identified via InventoryStockType on GoodsMovementDocumentDEX.	2VR_S4HARM_GoodsMovementDocumentDEX JOIN 2VR_S4HARM_I_BatchWhereUsedLevel (CHVW)	4MA_P2FINV_MaterialStock (reuse)	Already built. InventoryStockType = O filters to subcontracting/tolling stock. NonCumulative KF CurrentStock and CurrentStockValue available. Batch dimension via CHVW join (per ERP-601 pattern). Excludes intercompany tolling (?).
1	Toller (Business Partner) Dimension	Resolve toller identity per stock position and movement. Toller = Supplier on subcontracting PO item (item category L).	2VR_S4HARM_C_PurchaseOrderItem or 2VR_S4HARM_C_PurOrdScheduleLine JOIN 2VR_S4HARM_GoodsMovementDocumentDEX ON PurchaseOrder/PurchaseOrderItem	4MA_P2FINV_MaterialStock (reuse)	Both 2VR_S4HARM_C_PurchaseOrderItem and 2VR_S4HARM_C_PurOrdScheduleLine already in harmonisation layer, No new extractor required. Filter PurchasingDocumentItemCategory = 'L' or '3'. Supplier field resolves toller identity.
2	Subcontracting Purchase Orders	Subcontracting PO header and item data â€” PO number, item, material, supplier (toller), plant, quantity, delivery dates.	2VR_S4HARM_C_PurchaseOrderItem or 2VR_S4HARM_C_PurOrdScheduleLine	4MA_P2FINV_MaterialStock (reuse)	Filter PurchasingDocumentItemCategory = 'L' or '3' Schedule line view preferred if delivery date granularity required. PO reference links to GR movements (MvT 101) and outbound deliveries.
3	Outbound Deliveries to Tollers	Outbound deliveries of components to tollers' delivery number, item, material, batch, plant, SLOC, quantity, goods issue date.	2VR_S4HARM_I_OutboundDelivery	4MA_P2FINV_MaterialStock (reuse)	2VR_S4HARM_I_OutboundDelivery already exists (used in 3VR_P2FINV_BatchDel). Join to subcontracting PO via ReferenceSDDocument or PurchaseOrder on delivery item. Reuse join pattern from 3VR_P2FINV_BatchDel.
4	Goods Receipts from Tollers	GR of finished/semi-finished goods from toller (MvT 101 against subcontracting PO). Material, batch, quantity, plant, SLOC, posting date, PO reference.	2VR_S4HARM_GoodsMovementDocumentDEX	4MA_P2FINV_MaterialStock (reuse)	MvT 101 with PurchaseOrder populated and PurchasingDocumentItemCategory = L. Links back to subcontracting PO (Req 2). Batch available on movement line.
5	Component Issue to Toller	GI of components to toller (MvT 541 - transfer to subcontracting stock). Material, batch, quantity, plant, SLOC, posting date, PO reference.	2VR_S4HARM_GoodsMovementDocumentDEX	4MA_P2FINV_MaterialStock (reuse)	MvT 541. InventoryStockType changes to O on issue. Links to subcontracting PO. Component batch traceability available via Batch field on movement.
6	Component Return from Toller	Return of unused components from toller (MvT 542). Material, batch, quantity, plant, posting date.	2VR_S4HARM_GoodsMovementDocumentDEX	4MA_P2FINV_MaterialStock (reuse)	MvT 542. Reversal of MvT 541. Batch and PO reference available.
7	Batch Master Data and Shelf Life	Batch attributes for toller-produced batches -> ExternalBatch, VendorBatch, SLED/BBD, batch status, material.	2VD_S4HARM_I_Batch (planned for ERP-410)	4MA_P2FINV_MaterialStock (reuse)	2VD_S4HARM_I_Batch to be created under ERP-410 delivery dependency. Shelf life (SLED) available on I_Batch standard CDS view. Reuse once available.
8	Batch Movement History	Full movement history per batch produced by toller -> all MvTs, quantities, dates, document references. Navigation from batch to documents.	2VR_S4HARM_GoodsMovementDocumentDEX JOIN 2VR_S4HARM_I_BatchWhereUsedLevel	4MA_P2FINV_MaterialStock (reuse)	CHVW join provides batch linkage across movements. No recursive traversal required flat filter on Material/Plant/Batch. Consistent with ERP-601 batch pattern.
9	Inventory Aging Indicators	Aging exposure for stock held at tollers -> time since component issue (MvT 541) without corresponding GR (MvT 101). Calculated measure in SAC.	2VR_S4HARM_GoodsMovementDocumentDEX	4MA_P2FINV_MaterialStock (reuse)	Aging exposure for stock held at tollers -> time since component issue (MvT 541) without corresponding GR (MvT 101). Calculated measure in SAC.

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.

Effort Estimate and Object Count

S/4 Custom CDS	1 - Medium	1 * 5	1 Custom CDS View Z_I_BatchWhereUsedLevel on CHVW for single-level batch where-used extraction into DSP inbound layer. ERP-410
S/4 Custom CDS	1 - Medium	1 * 5	1 Custom CDS View Z_I_NCN for NCN Z-table extraction. Effort unknown - blocked pending CL_IT_NCN class analysis.ERP-410
S/4 Custom CDS (VDM)	1` - Medium	1 * 5	Custom CDS view for PCD documents. Join of legacy tables MAST/STPO/DRAT. New cds view will join I_MaterialBOMLink (MAST),I_BillOfMaterialItem (STPO & STAS), I_DocumentInfoRecord (DRAT) ERP-410
S/4 CDS	1 - Small	1 * 10	Custom extractor and wrapper for i_maintenanceplanbasic ERP-1098
			Extract cds views, all require wrappers. I_ClfnCharcDesc I_ClfnObjectCharcValue I_ClfnInternalIdObjectMapping I_ClfnClass I_ClfnCharcDesc I_ClfnClassCharcBasic ERP - 1422

Source System Extractors

`

Extractor Name	Description	Build Jira Ref For Extension Information
Z_I_TranspRoot (XE_TransRoot)
Z_I_TranspChargesRoot (XE_TransChRoot)
Z_I_TranspChargesItem (XE_TransChitem)
Z_I_TranspChargesItemElement (XE_TransChItemE)
Z_I_TranspExecData (XE_TransExec)
Z_I_TranspRootNode (XE_TransRootN)
Z_I_TranspRootNode (XE_TransRootN)
Z_I_BatchWhereUsedLevel (XE_BatchWUL)	Single-level CHVW extraction. One row per parent-child batch pair. No recursion here — handled in 3VR_P2FINV_TF_BatchTrace.
Z_I_NCN (XE_NCN)	NCN Z-table extraction. BLOCKED — source table and fields TBD. Pending CL_IT_NCN analysis.
Plqaceholder (XE_Specs)	BLOCKED — Pending analysis for class ZWPP_MDE_HCE.

VDM

Z_I_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?

Jira

Requirement

Description

ERP-410

PCD - Reports PCD document numbers for all materials/batches on the report results.

Custom CDS view for PCD documents. Join of legacy tables MAST/STPO/DRAT.

New cds view will join I_MaterialBOMLink (MAST),I_BillOfMaterialItem (STPO & STAS), I_DocumentInfoRecord (DRAT)

This requirement cannot be delivered by DSP as it is potential ITAR restricted data., will be presented in SAC.

Sample Code:

@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 Z_I_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

Extension of the cds views SCTMS_D required to include the expected extensions mentioned in ERP-1792 'Manual updated charges vs Freight Agreement calculated amount'

TMS KPI to source mapping

Jira

KPI

2VR_TransRoot

2VR_TrItemDex

2VR_TransChRoot

2VR_TransChitem

2VR_TransChItemE

2VR_TransExec

2VR_TransRootN

2VR_FreightAgreement

2VR_InvoiceDisp

2VR_FrtDsputCase

2VR_Outbound

2VR_CustSettlmt

2VR_GL_Acc_Line

Notes

Z_I_TranspRoot
/SCMTMS/D_TORROT

Z_I_TranspRootItem
/SCMTMS/D_TORITE

Z_I_TranspChargesRoot
/SCMTMS/D_TCHRGR

Z_I_TranspChargesItem
/SCMTMS/D_TCHRGI

Z_I_TranspChargesItemElement
/SCMTMS/D_TCHRGE

Z_I_TranspExecData
/SCMTMS/D_TOREXE

Z_I_TranspRootNode
/SCMTMS/D_SF_ROT

Z_I_FreightAgreement
/SCMTMS/D_FAGROT

Z_I_InvoiceDisp
/SCMTMS/D_INDSRT

XE_FrtDsputCase
C_FrtDsputCaseAnlytsDEX

I_OutboundDelivery
LIKP/LIPS

C_CustSettlmtDEX
WBRK/WBRP

I_GLAccountLineItemRAW
ACDOCA

ERP-1795

Freight Unit Compliance Score

X

FUs with planning status at time of PGI. Delivery goods movement date as base.

ERP-1795

FSD Timing Compliance Score

X

FSD CREATED_ON vs ActualDeparture (PlannedDeparture as fallback).

ERP-1795

Freight Agreement Usage Score

X

FAGRMNTID044 presence on charge items; MANUALLY_CHANGED on charge elements.

ERP-1795

Overall Compliance Score

Weighted average of the three scores above.

ERP-1792

Manual Charges vs FA Calculated

X

CALC_AMOUNT vs AMOUNT where MANUALLY_CHANGED = X on charge elements.

ERP-1792

3rd Party Charges Overview

X

Charges assigned to 3rd party; filtered by charge type on element.

ERP-1792

Freight Agreement Utilisation

X

All freight orders linked to a freight agreement including costs.

ERP-1792

Freight Charge Breakdown

X

Breakdown by charge type carrier posting/doc status timeline.

ERP-1782

Confirmed Pick-up vs Actual

X

Earliest pick-up event vs confirmed pickup date on freight order.

ERP-1782

Confirmed ETA vs Actual Arrival

X

Earliest arrival event vs confirmed ETA on freight order.

ERP-1782

Proof of Delivery Rate

X

POD event reported (PROCESSING_STATUS = Confirmed) as % of total FOs.

ERP-1782

Event Reporting Rate

X

Critical event compliance per defined rules; split Outbound / Inbound.

ERP-2359

Freight Cost to Cost Account/Material Account

X

Amount posted to material/expense/P&L G/L accounts after settlement.

ERP-2359

Cost Allocation Breakdown

X

Breakdown by CompanyCode PurchOrg Plant Material SalesOrder/PO G/L.

ERP-1793

Document Relationships - Freight Unit No.

X (TOR_TYPE=FU)

REUSE. Filter TOR_TYPE = FU on /SCMTMS/D_TORROT. No new extractor needed.

ERP-1793

Document Relationships - Freight Order No.

X (TOR_TYPE=TO)

REUSE. Filter TOR_TYPE = TO on /SCMTMS/D_TORROT. Same extractor as FU.

ERP-1793

Document Relationships - Freight Booking No.

X (TOR_TYPE=BK)

REUSE. Filter TOR_TYPE = BK on /SCMTMS/D_TORROT. All three TOR types covered by single existing extraction path.

ERP-1793

Document Relationships - Link Source Doc to Freight Doc (SO/PO/Delivery)

X

X (NEW)

NEW. /SCMTMS/D_TORITE. BASE_BTD_ID and BASE_BTD_TCO carry back-reference to originating Sales Order/PO/Delivery. New Z_I_TranspRootItem (XE_TrItemDex) + 1TL + 2TL + 2VR required.

ERP-1793

Document Relationships - Freight Agreement No.

X

X (NEW)

NEW. /SCMTMS/D_FAGROT. Join to TORROT via FAG_KEY already on TORROT. New Z_I_FreightAgreement (XE_FreightAgreement) + 1TL + 2TL + 2VR required. Standard CDS availability to confirm in ADT.

ERP-1793

Document Relationships - Freight Settlement Doc No.

X

REUSE. SFIR_ID is settlement document number. REF_KEY links to TORROT. Already fully extracted and used by ERP-1795 and ERP-2359.

ERP-1793

Document Relationships - Cost Distribution Document No.

X

REUSE. Same SF_ROT table as settlement doc. Distinguish via SFIR_TYPE filter in propagation view. No new extractor needed.

ERP-1793

Document Relationships - Carrier Invoice No.

X

X (NEW)

NEW. /SCMTMS/D_INDSRT. CARRIER_INVOICE_KEY already on 2VR_TransRootN as join key. New Z_I_InvoiceDisp (XE_InvoiceDisp) + 1TL + 2TL + 2VR required.

ERP-1793

Document Relationships - Dispute Document No.

X

REUSE. C_FrtDsputCaseAnlytsDEX full extraction track already in DDFS (XE_FrtDsputCase -> 1TL -> 2TL -> 2VR -> 3VR_P2FTMS_FrtDsputCase -> 4MA_P2FTMS_FrtDsputCase). No new objects required.

ERP-1793

Document Relationships - Document Relationship Chain (propagation)

X

NEW propagation view 3VR_P2FTMS_DocRelationship. Chain: Source Doc (TORITE.BASE_BTD_ID) -> TORROT (FU/FO/BK) -> SF_ROT (FSD/Cost Dist) -> FAGROT (FA via FAG_KEY) -> INDSRT (Carrier Invoice/Dispute via CARRIER_INVOICE_KEY).

Source View / Extractor	Key Relationships
Freight Order /SCMTMS/D_TORROT (XE_TransRoot = Z_I_TranspRoot)	DB_KEY = TOR_ID
Freight Order /SCMTMS/D_TORITE	NEW
Charges Root /SCMTMS/D_TCHRGR (XE_TransChRoot = Z_I_TranspChargesRoot)	DB_KEY = HOST_KEY (DB_KEY freight order)
Charges Item /SCMTMS/D_TCHRGI (XE_TransChitem = Z_I_TranspChargesItem)	DB_KEY = PARENT_KEY (DB_KEY charges root)
Charges Elem /SCMTMS/D_TCHRGE (XE_TransChItemE = Z_I_TranspChargesItemElement)	DB_KEY = ROOT_KEY (charges root) or PARENT_KEY (charges item)
Execution Events /SCMTMS/D_TOREXE (XE_TransExec = Z_I_TranspExecData)	Linked via TORITMUID to freight order item
Freight Settl. Doc /SCMTMS/D_SF_ROT (XE_TransRootN = Z_I_TranspRootNode)	SFIR_ID; linked to freight order via REF_KEY
Customer Settlement (XE_CustSettlmt = C_CustSettlmtDEX)	WBRP/WBRK; joined to GL via CompanyCode + FiscalYear + ReferenceDocument

1TL_S4Hx_I_BatchWhereUsedLevel

Purpose	Initial + delta load of single-level CHVW batch where-used records via Z_I_BatchWhereUsedLevel.
Filled by	1TF_S4Hx_I_BatchWhereUsedLevel

1TF_S4Hx_I_BatchWhereUsedLevel

Source	Z_I_BatchWhereUsedLevel (XE_BatchWUL)
Purpose	Transformation flow loading Z_I_BatchWhereUsedLevel into 1TL_S4Hx_I_BatchWhereUsedLevel. No transformations.

1TL_S4Hx_Specs

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

Harmonisation Layer

Type	Object Name	Source	Purpose	Filter	Projection	Formula / Aggregation	Notes
TL	2TL_S4HARM_GoodsMovementDocumentDEX	1TL_S4Hx_I_GOODSMOVEMENTDOCUMENTDEX	Delta load of Material Documents. Set keys. Filled by 2TF_S4HARM_I_GoodsMovementDocumentDEX.		Add as Key: MaterialDocumentYear Add as Key: MaterialDocument Add as Key: MaterialDocumentItem Keep keys MaterialDocumentKey1-6 for Delta Capture.
TF	2TF_S4HARM_I_GoodsMovementDocumentDEX	1TL_S4Hx_I_GOODSMOVEMENTDOCUMENTDEX	Transformation flow for GoodsMovementDocumentDEX.		Add as Key: MaterialDocumentYear Add as Key: MaterialDocument Add as Key: MaterialDocumentItem
VR	2VR_S4HARM_GoodsMovementDocumentDEX	2TL_S4HARM_GoodsMovementDocumentDEX	View on harmonised goods movement data.		Exclude: MaterialDocumentKey1 Exclude: MaterialDocumentKey2 Exclude: MaterialDocumentKey3 Exclude: MaterialDocumentKey4 Exclude: MaterialDocumentKey5 Exclude: MaterialDocumentKey6
TL	2TL_S4HARM_C_TranspOrdItemAnlytsSDEX	1TL_S4Hx_I_GOODSMOVEMENTDOCUMENTDEX	Delta load of Transportation Order Items. Filled by 2TF_S4HARM_C_TranspOrdItemAnlytsSDEX.
TF	2TF_S4HARM_C_TranspOrdItemAnlytsSDEX	1TL_S4HR_C_TranspOrdItemAnlytsSDEX	No transformations.
VR	2VR_S4HARM_C_TranspOrdItemAnlytsSDEX	2TL_S4HARM_C_TranspOrdItemAnlytsSDEX	View on harmonised transportation order item data.	TransportationOrder <> '' OR TransportationOrder IS NOT NULL		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) TranspOrdItemShipperUUID = BINTOHEX(TranspOrdItemShipperUUID) ProductUUID = BINTOHEX(ProductUUID) NetDurationInHours = to_decimal((to_integer(TranspOrdNetDuration/10000))+(to_integer((MOD(TranspOrdNetDuration,10000))/100)/60),5,2)
TF	2TF_S4HARM_I_TranspOrdStageAnalytics	1TL_S4Hx_I_TRANSPORDSTAGEANALYTICS	No transformations.
TL	2TL_S4HARM_I_TranspOrdStageAnalytics	1TL_S4Hx_I_TRANSPORDSTAGEANALYTICS	Delta load of Transportation Order Stage records. Filled by 2TF_S4HARM_I_TranspOrdStageAnalytics.
VR	2VR_S4HARM_I_TranspOrdStageAnalytics	2TL_S4HARM_I_TranspOrdStageAnalytics	View on stage analytics with distance and duration aggregation.	TranspOrdStageDestStopCategory = 'L'	Exclude ALL except: TransportationOrderUUID TranspOrdStageDistance TranspOrdStageDistanceUnit TranspOrdStageNetDuration	TransportationOrderStageUUID = BINTOHEX(TransportationOrderStageUUID) TransportationOrderUUID = BINTOHEX(TransportationOrderUUID) TranspOrdStageSrceStopUUID = BINTOHEX(TranspOrdStageSrceStopUUID) TranspOrdStageDestStopUUID = BINTOHEX(TranspOrdStageDestStopUUID) CarrierUUID = BINTOHEX(CarrierUUID) NumberOfStages = 1 Aggregation: NumberOfStages → SUM TranspOrdStageDistance → SUM TranspOrdStageNetDuration → SUM
TL	2TL_S4HARM_I_TranspChargesRoot (2TL_TransChRoot)	1TL_S4Hx_I_TranspChargesRoot (1TL_TransChRoot)	Delta load of Freight Order Charge Root records (/SCMTMS/D_TCHRGR). Filled by 2TF_S4HARM_I_TranspChargesRoot.
TF	2TF_S4HARM_I_TranspChargesRoot	1TL_S4Hx_I_TranspChargesRoot (1TL_TransChRoot)	No transformations.
VR	2VR_S4HARM_I_TranspChargesRoot (2VR_TransChRoot)	2TL_S4HARM_I_TranspChargesRoot	View on Freight Order Charge Root records.	CALC_STATUS <> ''		HOST_KEY = BINTOHEX(HOST_KEY) HOST_BO_KEY = BINTOHEX(HOST_BO_KEY) HOST_NODE_KEY = BINTOHEX(HOST_NODE_KEY)
TL	2TL_S4HARM_I_TranspChargesItem (2TL_TransChitem)	1TL_S4Hx_I_TranspChargesItem (1TL_TransChitem)	Delta load of Freight Order Charge Item records (/SCMTMS/D_TCHRGI). Filled by 2TF_S4HARM_I_TranspChargesItem.
TF	2TF_S4HARM_I_TranspChargesItem	1TL_S4Hx_I_TranspChargesItem (1TL_TransChitem)	No transformations.
VR	2VR_S4HARM_I_TranspChargesItem (2VR_TransChitem)	2TL_S4HARM_I_TranspChargesItem	View on Freight Order Charge Item records.	HOST_KEY IS NOT NULL		HOST_KEY = BINTOHEX(HOST_KEY) HOST_BO_KEY = BINTOHEX(HOST_BO_KEY) HOST_NODE_KEY = BINTOHEX(HOST_NODE_KEY) HOST_ROOT_KEY = BINTOHEX(HOST_ROOT_KEY) PARENT_KEY = BINTOHEX(PARENT_KEY) PARENT_ITEM_KEY = BINTOHEX(PARENT_ITEM_KEY) EXECUTING_DOC_KEY = BINTOHEX(EXECUTING_DOC_KEY) DESTLOC_UUID = BINTOHEX(DESTLOC_UUID) SOURCELOC_UUID = BINTOHEX(SOURCELOC_UUID) CONTEXT_KEY = BINTOHEX(CONTEXT_KEY) ORIG_OP_UUID = BINTOHEX(ORIG_OP_UUID) PARTY_UUID = BINTOHEX(PARTY_UUID) REF_KEY = BINTOHEX(REF_KEY) REF_ROOT_KEY = BINTOHEX(REF_ROOT_KEY) UUID020 = BINTOHEX(UUID020) UUID057 = BINTOHEX(UUID057)
TL	2TL_S4HARM_I_TranspChargesItemElement (2TL_TransChItemE)	1TL_S4Hx_I_TranspChargesItemElement (1TL_TransChItemE)	Delta load of Freight Order Charge Element records (/SCMTMS/D_TCHRGE). Filled by 2TF_S4HARM_I_TranspChargesItemElement.
TF	2TF_S4HARM_I_TranspChargesItemElement	1TL_S4Hx_I_TranspChargesItemElement (1TL_TransChItemE)	No transformations.
VR	2VR_S4HARM_I_TranspChargesItemElement (2VR_TransChItemE)	2TL_S4HARM_I_TranspChargesItemElement	View on Freight Order Charge Element records.	ROOT_KEY IS NOT NULL AND INVOICING <> ''		ROOT_KEY = BINTOHEX(ROOT_KEY) PARENT_KEY = BINTOHEX(PARENT_KEY) PARENT_TCE = BINTOHEX(PARENT_TCE) DESTLOC_UUID = BINTOHEX(DESTLOC_UUID) SOURCELOC_UUID = BINTOHEX(SOURCELOC_UUID) DIST_ELEM_KEY = BINTOHEX(DIST_ELEM_KEY) REF_ELEM_KEY = BINTOHEX(REF_ELEM_KEY) RATE_RECORD_KEY = BINTOHEX(RATE_RECORD_KEY) CALCBASELINE_KEY = BINTOHEX(CALCBASELINE_KEY) UUID026 = BINTOHEX(UUID026) SPLIT_PARENT_KEY = BINTOHEX(SPLIT_PARENT_KEY) TARGET_ITEM_KEY = BINTOHEX(TARGET_ITEM_KEY) SRV_NODE = BINTOHEX(SRV_NODE) UUID_INDEX_RATE = BINTOHEX(UUID_INDEX_RATE)
TL	2TL_S4HARM_I_TranspExecData (2TL_TransExec)	1TL_S4Hx_I_TranspExecData (1TL_TransExec)	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 2TF_S4HARM_I_TranspExecData.
TF	2TF_S4HARM_I_TranspExecData	1TL_S4Hx_I_TranspExecData (1TL_TransExec)	No transformations.
VR	2VR_S4HARM_I_TranspExecData (2VR_TransExec)	2TL_S4HARM_I_TranspExecData	View on Transportation Order Execution event data.	EVENT_REVOKED <> 'X' AND EVENT_STATUS <> ''		TORITMUID = BINTOHEX(TORITMUID) TORSTOPUUID = BINTOHEX(TORSTOPUUID) TORSTSUID = BINTOHEX(TORSTSUID) PARENT_KEY = BINTOHEX(PARENT_KEY) EXT_LOC_UUID = BINTOHEX(EXT_LOC_UUID) ORIG_EXEC_KEY = BINTOHEX(ORIG_EXEC_KEY) ORIG_NODE_KEY = BINTOHEX(ORIG_NODE_KEY) REF_EXEC_KEY = BINTOHEX(REF_EXEC_KEY) ACTUAL_DATE = to_date(to_varchar(ACTUAL_DATE,'YYYYMMDD'),'YYYY-MM-DD')
TL	2TL_S4HARM_I_TranspRootNode (2TL_TransRootN)	1TL_S4Hx_I_TranspRootNode (1TL_TransRootN)	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 2TF_S4HARM_I_TranspRootNode.
TF	2TF_S4HARM_I_TranspRootNode	1TL_S4Hx_I_TranspRootNode (1TL_TransRootN)	No transformations.
VR	2VR_S4HARM_I_TranspRootNode (2VR_TransRootN)	2TL_S4HARM_I_TranspRootNode	View on Freight Settlement Document header records.	SFIR_TYPE <> '' AND LIFECYCLE <> 'X'		TSP_UUID = BINTOHEX(TSP_UUID) REF_BO_KEY = BINTOHEX(REF_BO_KEY) REF_KEY = BINTOHEX(REF_KEY) BILL_FROM_PARTY = BINTOHEX(BILL_FROM_PARTY) PAYEE_ID = BINTOHEX(PAYEE_ID) CARRIER_INVOICE_KEY = BINTOHEX(CARRIER_INVOICE_KEY) CREATED_ON = to_date(to_varchar(CREATED_ON,'YYYYMMDD'),'YYYY-MM-DD') CREATION_DATE_EXT = to_date(to_varchar(CREATION_DATE_EXT,'YYYYMMDD'),'YYYY-MM-DD')
TL	2TL_S4HARM_C_CustSettlmtDEX (2TL_CustSettlmt)	1TL_S4Hx_C_CustSettlmtDEX (1TL_CustSettlmt)	Delta load of Customer/Freight Settlement documents (C_CustSettlmtDEX — WBRP/WBRK). Settlement item data for Freight Cost Allocation (ERP-2359). Filled by 2TF_S4HARM_C_CustSettlmtDEX.
TF	2TF_S4HARM_C_CustSettlmtDEX	1TL_S4Hx_C_CustSettlmtDEX (1TL_CustSettlmt)	No transformations.
VR	2VR_S4HARM_C_CustSettlmtDEX (2VR_CustSettlmt)	2TL_S4HARM_C_CustSettlmtDEX	View on Customer/Freight Settlement document items.	CustSettlmt IS NOT NULL	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
TF	2TF_S4HARM_I_BatchWhereUsedLevel	1TL_S4Hx_I_BatchWhereUsedLevel	Transformation flow for batch where-used level data.		Add as Key: Material Add as Key: Plant Add as Key: Batch Add as Key: ParentMaterial Add as Key: ParentPlant Add as Key: ParentBatch
TL	2TL_S4HARM_I_BatchWhereUsedLevel	2TF_S4HARM_I_BatchWhereUsedLevel	Load of single-level CHVW batch where-used records. Filled by 2TF_S4HARM_I_BatchWhereUsedLevel.
VR	2VR_S4HARM_I_BatchWhereUsedLevel	2TL_S4HARM_I_BatchWhereUsedLevel	View on single-level batch where-used records.	Batch IS NOT NULL AND ParentBatch IS NOT NULL	Include: Material Include: Plant Include: Batch Include: ParentMaterial Include: ParentPlant Include: ParentBatch
TL	2TL_S4HARM_I_NCN	Z_I_NCN	BLOCKED — pending CL_IT_NCN analysis. Source Z-table and fields TBD.				BLOCKED
VR	2VR_S4HARM_I_NCN	2TL_S4HARM_I_NCN	BLOCKED — pending CL_IT_NCN analysis. Filter, formula and projection TBD.				BLOCKED

Propagation Layer

Type	Object Name	Source	Purpose	Filter	Projection	Formula / Aggregation / Joins	Notes
VR	3VR_P2FINC_MaterialStock	2VR_S4HARM_I_GLAccountLineItemRAW 2VR_S4HARM_I_GoodsMovementDocumentDEX	Combined source view feeding the material stock flow. Union of GL adjustment postings and goods movement documents.	GLAccountLineItemRAW: ReferenceDocumentType = 'PRCHG' AND ControllingBusTransacType = '' AND SourceLedger = '0L' AND Product != '' GoodsMovementDocumentDEX: Material != '' AND InventoryStockType != ''	GLAccountLineItemRAW: Only for join GoodsMovementDocumentDEX: Only for join	Union: Accept default union mappings
VF	3VF_P2FINV_MaterialStock	3VR_P2FINC_MaterialStock	Fact view on material stock. Applies RecordType calculation for Non-Cumulative Key Figures.			RecordType (Integer): CASE WHEN PostingDate < '20251231' THEN 2 WHEN PostingDate = '20251231' THEN 1 ELSE 0 END Note: Dates must be parameterised via input table.
VR (SQL)	3VR_P2FTMS_TransportationOrderSql (3VR_TranOrdSql)	2VR_S4HARM_C_TranspOrdItemAnlytsDEX + 2VR_TransChRoot + 2VR_TransChitem + 2VR_TransChItemE + 2VR_TransExec (via join)	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.
VR	3VR_P2FTMS_TransportationOrder (3VR_TranOrd)	3VR_P2FTMS_TransportationOrderSql LEFT JOIN 2VR_S4HARM_C_TranspOrdStageAnalytics ON TransportationOrderUUID	Core transportation order view used by all TMS analytical models.	TransportationOrder <> '' AND TranspOrdLifeCycleStatus NOT IN ('X', 'Z')	Include: TransportationOrder Include: TransportationOrderUUID Include: TransportationOrderType Include: TransportationMode Include: CarrierUUID Include: ShipperUUID Include: ConsigneeUUID Include: FreightAgreement Include: PlannedDepartureDateTime Include: ActualDepartureDateTime Include: PlannedArrivalDateTime Include: ActualArrivalDateTime Include: TranspOrdLifeCycleStatus Include: TranspOrdPlanningStatus Include: ShippingCondition Include: TransportationOrderItemUUID Include: Product / ShipFromParty / ShipToParty Include: NetDurationInHours (stage) Include: NumberOfStages (stage) Include: 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
VF	3VF_P2FTMS_TransportationOrder (3VF_TranOrd)	3VR_P2FTMS_TransportationOrder	Formula / Calculation view. Applies final field-level derivations and unit conversions before exposure to analytical model.
VR	3VR_P2FTMS_FrtCstAlloc (3VR_FrtCstAlloc)	2VR_S4HARM_I_TranspRootNode JOIN 2VR_S4HARM_C_CustSettlmtDEX JOIN 2VR_S4HARM_I_GLAccountLineItemRAW	Pre-join view for Freight Cost Allocation report (ERP-2359). Links FSD, settlement document, and G/L line items.	ReferenceDocumentContext = 'WB' AND S.CustSettlmt IS NOT NULL AND N.LIFECYCLE <> 'X'	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	Join condition (ERP-2359): 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	ERP-2359
VF	3VF_P2FTMS_FrtCstAlloc (3VF_FrtCstAlloc)	3VR_P2FTMS_FrtCstAlloc	Formula / Calculation view. Applies final derivations (e.g. account type classification: Cost vs. Material) before exposure to analytical model.				ERP-2359
TF (SQLScript)	3VR_P2FINV_TF_BatchChain	2VR_S4HARM_I_BatchWhereUsedLevel (read at runtime)	SQLScript Table Function. Called dynamically at runtime by SAC — not persisted. 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. 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: Material, Plant, Batch, ParentMaterial, ParentPlant, ParentBatch, Level (0=seed batch)	Already-processed batches excluded via NOT EXISTS. Loops until no new batches returned.		Direction B: joins on Material/Plant/Batch to find ParentMaterial/ParentPlant/ParentBatch. Direction T: reverses join direction.	ERP-410
VR	3VR_P2FINV_BatchTrace	3VR_P2FINV_TF_BatchChain	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)	ERP-410
VF	3VF_P2FINV_BatchTrace	3VR_P2FINV_BatchTrace	Formula only — makes the view a fact. No joins.			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	ERP-410
VR	3VR_P2FINV_BatchDel	2VR_S4HARM_GoodsMovementDocumentDEX + 2VR_S4HARM_I_OutboundDelivery + 2VR_S4HARM_I_Customer	Resolves outbound deliveries for batches in the chain. Equivalent of GET_DEL in ZWPP_HCE.	Join 1 filter: ReferenceSDDocument IS NOT NULL AND PurchaseOrder IS NULL AND Material/Plant/Batch IN (SAC batch chain context)	OutboundDelivery / OutboundDeliveryItem ReferenceSDDocument / ReferenceSDDocumentItem / ReferenceSDDocumentCategory (TBD) PurchaseOrder / PurchaseOrderItem SoldToParty / Country (TBD) / CustomerName (TBD) / CityName (TBD) Material / Batch Plant ActualGoodsmovementDate ActualDeliveryQuantity / DeliveryQuantityUnit SalesGroup / SalesOffice	Join 1: GoodsMovementDocumentDEX INNER JOIN OutboundDelivery ON ReferenceSDDocument = OutboundDelivery Join 2: Result of Join 1 INNER JOIN Customer ON SoldToParty = KUNNR	ERP-410
VF	3VF_P2FINV_BatchDel	3VR_P2FINV_BatchDel	Final derivations on delivery data before AM exposure.				ERP-410
VR	3VR_P2FINV_BatchDelSpec	3VR_P2FINV_BatchDel	All spec entries per delivery item. Contrast with BatchDel which carries first spec only. BLOCKED — create_spec_table / init_specs / get_spec all in ZWPP_MDE_HCE. Source tables and join keys TBD.				BLOCKED
VF	3VF_P2FINV_BatchDelSpec	3VR_P2FINV_BatchDelSpec	BLOCKED — dependent on 3VR_P2FINV_BatchDelSpec.				BLOCKED
VR	3VR_P2FINV_QC	3VR_P2FINV_TF_BatchChain (shared with BatchTrace)	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	Partial BLOCKED
VF	3VF_P2FINV_QC	3VR_P2FINV_QC	Final derivations on quality and compliance data.				Partial BLOCKED — NCN and Specs TBD

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

CurrentStockValue

InventoryValuationAmtInCoCodeCrcy

Non-Cumulative – same parameters as CurrentStock

SUM

4MA_P2FTMS_TransportationOrder (4MA_TranOrd)

Source: 3VF_P2FTMS_TransportationOrder (3VF_TranOrd)

Supports: Transportation order and freight charge analysis.
This model provides the base analytical structure from which the Freight KPI Report (ERP-1795), Freight Cost Report (ERP-1792) and Carrier Performance Report (ERP-1782) SAC stories will be built.

Calculated Measures:

Detailed calculated measure specifications for 4MA_P2FTMS_TransportationOrder are pending story design for ERP-1795, ERP-1792, and ERP-1782.

xxxxxxxxxxxxxx – Freight KPI Report (ERP-1795)

Intended KPI measures (draft – subject to model naming decision):

Measure	Logic / Source
FreightUnitComplianceScore	Ratio of Freight Units planned prior to PGI. Source: 2VR_S4HARM_I_OutboundDelivery + 2VR_S4HARM_I_TranspRoot. Hierarchy: Syensqo → Country → CompanyCode → Plant.
FSDTimingComplianceScore	Ratio of FSDs where CREATED_ON <= ActualDepartureDateTime (PlannedDeparture as fallback). Source: 2VR_S4HARM_I_TranspRootNode.
FreightAgreementUsageScore	Ratio of FSD items where FAGRMNTID044 IS NOT NULL. Manual updates counted: MANUALLY_CHANGED = 'X' on charges element. Excludes non-FA charge types (configurable list).
OverallComplianceScore	Weighted average of the three scores. Weighting factors TBD per project requirements.

xxxxxxxxxxxxx– Freight Cost Report (ERP-1792)

Intended measures (draft):

Measure	Logic / Source
TotalChargeAmount	Sum of AMOUNT from Charges Element, restricted to INVOICING <> '' and ANALYTICRELEV = 'X'.
ManualChargeVariance	CALC_AMOUNT vs AMOUNT on elements where MANUALLY_CHANGED = 'X'. Supports ERP-1792 KPI: Manual Updated Charges vs FA Calculated Amount.
InvoicedAmount	INVOICED_AMT at Charges Root (total) and Element (detail) level.
WeightedAvgFreightRate	TotalChargeAmount / TotalWeight (CHRG_WEI_VAL). Post-aggregation in SAC.

[Not yet defined] – Carrier Performance Report (ERP-1782)

The analytical model for the Carrier Performance Report has not yet been assigned a name in the data flow diagram. This section is reserved once the model name is confirmed.

Intended measures (draft):

Measure	Logic / Source
PickupOnTimeRate	Earliest actual pick-up event (EVENT_CODE = pick-up) vs PlannedDepartureDateTime +/- threshold. Source: 2VR_S4HARM_I_TranspExecData.
ETAOnTimeRate	Earliest arrival event vs PlannedArrivalDateTime +/- threshold. Uses confirmed ETA from Transportation Order extension field.
ProofOfDeliveryRate	Ratio of FOs with POD event reported (EVENT_CODE = POD, PROCESSING_STATUS = Confirmed).
EventReportingRate	Compliance per defined event rules (ERP-1782). Separate rate for Outbound / Inbound FOs.

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

4MA_P2FTMS_FrtCstAlloc (4MA_FrtCstAlloc)

Source: 3VF_P2FTMS_FrtCstAlloc (3VF_FrtCstAlloc)

Supports: ERP-2359 – Freight Cost Allocation Report.

Calculated Measures:

Measure	Base Fields	Calculation / Logic	Aggregation
FreightCostToCostAccount	AmountInCompanyCodeCurrency	Sum of amounts where GLAccount is classified as an expense/cost account.	SUM
FreightCostToMaterialAccount	AmountInCompanyCodeCurrency	Sum of amounts where GLAccount is classified as a material/stock account.	SUM
CostVsMaterialSplit	FreightCostToCostAccount / TotalFreightCost	Ratio split between cost and material account postings. Expressed as %.	PERCENTAGE

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.

Batch Track and Trace

4MA_P2FINV_BatchTrace

Source	3VF_P2FINV_BatchTrace
Supports	ERP-410 Req 0 — Primary batch chain report. Entry point for all 7 branch AMs.

Input Parameters:

Parameter	Description
IV_Material	Material
IV_Plant	Plant
IV_Batch	Batch
IV_DIRECTION	B = Bottom Up / T = Top Down

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

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

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

Source	3VF_P2FINV_BatchDel
Supports	ERP-410 Req 7 — Deliveries incl. first spec on sales order.

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

Source	3VF_P2FINV_BatchDelSpec
Supports	ERP-410 Req 8 — All specs per delivery item.

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

May 08, 2026	Actor	Type	Activity	Version
Revision in progress	OOSTHUIZEN-ext, Lambertus	Edit	updated the page at 10:24 am
May 07, 2026
	OOSTHUIZEN-ext, Lambertus	State	changed state to Revision in progress at 11:02 am	v158
Approved	OOSTHUIZEN-ext, Lambertus	Edit	updated the page at 11:02 am
Apr 30, 2026
	WENNINGER-ext, Sascha	State	changed state to Approved at 8:58 am	v157
Lead Approval	WENNINGER-ext, Sascha	State	gave POD Lead Review approval at 8:58 am

Workflow history

Space shortcuts

Page tree

Document Links

Introduction

Stock Balances

EWM Managed Plants:

Bonded Stock Reports:

Global Batch Track & Trace

Tolling Dashboad

Physical Inventory

Effort Estimate and Object Count

Source System Extractors

VDM

Z_I_WPP_PCDDocuments - WPP - PCD Document Links by Material/Plant

Inbound Layer

1TL_S4Hx_I_BatchWhereUsedLevel

1TF_S4Hx_I_BatchWhereUsedLevel

1TL_S4Hx_Specs

Harmonisation Layer

Propagation Layer

Reporting Layer

4MA_P2FINV_DowntimeFact

Calculated Measures (Post Aggregation Calculations / exception aggregation etc)

4MA_P2FTMS_TransportationOrder (4MA_TranOrd)

xxxxxxxxxxxxxx – Freight KPI Report (ERP-1795)

xxxxxxxxxxxxx– Freight Cost Report (ERP-1792)

[Not yet defined] – Carrier Performance Report (ERP-1782)

4MA_P2FTMS_FrtCstAlloc (4MA_FrtCstAlloc)

Batch Track and Trace

4MA_P2FINV_BatchTrace

4MA_P2FINV_QC

4MA_P2FINV_BatchDel

4MA_P2FINV_BatchDelSpec

Restricted Measures

Currency Conversions

Variables

Data access controls

Outbound Layer

Workflow history

Space shortcuts

Page tree

ERP-1041: DDFS - P2F

Document Links

Introduction

Stock Balances

EWM Managed Plants:

Bonded Stock Reports:

Global Batch Track & Trace

Tolling Dashboad

Physical Inventory

Effort Estimate and Object Count

Source System Extractors

VDM

Z_I_WPP_PCDDocuments - WPP - PCD Document Links by Material/Plant

Inbound Layer

1TL_S4Hx_I_BatchWhereUsedLevel

1TF_S4Hx_I_BatchWhereUsedLevel

1TL_S4Hx_Specs

Harmonisation Layer

Propagation Layer

Reporting Layer

4MA_P2FINV_DowntimeFact

Calculated Measures (Post Aggregation Calculations / exception aggregation etc)

4MA_P2FTMS_TransportationOrder (4MA_TranOrd)

xxxxxxxxxxxxxx – Freight KPI Report (ERP-1795)

xxxxxxxxxxxxx– Freight Cost Report (ERP-1792)

[Not yet defined] – Carrier Performance Report (ERP-1782)

4MA_P2FTMS_FrtCstAlloc (4MA_FrtCstAlloc)

Batch Track and Trace

4MA_P2FINV_BatchTrace

4MA_P2FINV_QC

4MA_P2FINV_BatchDel

4MA_P2FINV_BatchDelSpec

Restricted Measures

Currency Conversions

Variables

Data access controls

Outbound Layer