This Data Design and Flow Specification (DDFS) defines the end-to-end data flow required to deliver the A2D (Acquire to Decommission) analytics capability within the SyWay programme. It covers the full DSP layered architecture from S/4HANA source extraction through to SAP Analytics Cloud (SAC) analytical models.
This DDFS covers the following Jira requirements:
Both ERP-1104 (MRO Dashboard) and ERP-1156 (Cross-Instance Material Visibility) are listed under the A2D workstream but consume inventory objects already defined in the P2F DDFS (ERP-1041). These requirements are documented here for completeness but no new DSP objects are required in the A2D stream.
The table below provides a consolidated mapping of all in-scope ERPs, KPIs, CDS source views, and target analytical models.
ERP | KPI / Report | Type | Target AM (Code) | Primary Source CDS / View | Notes |
ERP-888 | Total Maintenance Cost | Strategic | 4MA_A2DAMM_MaintCost | I_MaintOrderActualCostDataCube | Capex/Opex determined by Z-field ZZ1_SYCAP_OPX_PSR on WBS master; budget at PPM item level (Category field). ARV required for asset viability KPI — G-01. |
ERP-888 | Planned vs Unplanned Cost | Tactical | 4MA_A2DAMM_MaintCost | I_MaintOrderActualCostDataCube | MaintenanceOrderType available directly on cost cube. Cost type split (Preventive/Corrective/Predictive/Emergency) identified from Order Type + Maintenance Activity Type. ABC Indicator on Equipment/FLOC master for asset criticality filter. |
ERP-888 | Asset Economical Viability | Tactical | 4MA_A2DAMM_MaintCost | 3VR_A2DAMM_AssetReplacementValue (placeholder) | ARV source not confirmed — G-01 . Age of Completion = (Today - StartUpDate) / (EndOfLife - StartupDate). Number of Breakdowns = COUNT(I_PMNotifMaintenanceData.MaintenanceNotification). |
ERP-888 | Work Order Cost & Efficiency | Tactical | 4MA_A2DAMM_MaintCost | I_MaintOrderActualCostDataCube | PARKED. No RESOURCEWORKCENTER on I_MAINTORDEROPERATION_DEX; other WorkCenter fields available. Planned costs displayed alongside actuals on the work order. WBS planned cost source not confirmed — BARROW-ext, ian To provide |2VR object for WBS Planned Costs |
ERP-1012 | Technical Availability % | Strategic | 4MA_A2DAMM_DowntimeFact | I_MaintOrderTechObjCube + I_PMNotifMaintenanceData | MaintenanceObjectIsDown = X identifies breakdown downtime. Planned Downtime = any order not flagged as breakdown is planned/preventative work. Total Operating Time assumption: 365 x 24 hours — G-03 . Note: Loss Driver KPIs (breakdown hours pareto, notification count pareto) combined into MTTR/Execution per Change Log R2/R3. |
ERP-1012 | Asset Downtime Planned vs Unplanned | Tactical | 4MA_A2DAMM_DowntimeFact | I_MaintOrderTechObjCube + I_PMNotifMaintenanceData | Down Time Type is not a native SAP field. Derived from Work Order Type / Breakdown Indicator from notification. TBD: Planned = scheduled order window; Unplanned = MaintObjectDowntimeDuration. |
ERP-1013 | Top 10 Bad Actors | Strategic | 4MA_A2DAMM_MaintCost | I_MaintOrderActualCostDataCube | Top 10 Equipment by Maintenance Cost (descending) for defined period and MaintenanceActivityType Pareto filter in SAC. 4MA_MaintCost ABCIndicator confirmed on I_MaintOrderActualCostDataCube. For PMNotif-based filters, join to 2VR_MOTech on MaintenanceNotification key required. |
ERP-1013 | Failure Reasons of Asset | Operational | 4MA_A2DAMM_PMNotif + 4MA_A2DAMM_MaintCost | I_PMNotifMaintenanceData + I_MaintOrderActualCostDataCube | Count Failure Reasons by frequency, segmented by MaintenanceActivityType. DamageCode, ObjectPartCode, CauseCode added to 2VR_PMNotif and 3VF_PMNotif. Failure count from 4MA_PMNotif; cost per failure reason from 4MA_MaintCost — Cost split by MaintenanceActivityType — confirmed available on I_MaintOrderActualCostDataCube directly. |
ERP-1013 | Reactive vs Proactive Maintenance | Operational | 4MA_A2DAMM_MaintCost | I_MaintOrderActualCostDataCube | Cost split by MaintenanceActivityType (Preventive/Corrective/Emergency). MaintenanceActivityType is available directly on I_MaintOrderActualCostDataCube — no join required. |
ERP-1013 | MTBF | Tactical | 4MA_A2DAMM_PMNotif | I_PMNotifMaintenanceData | MTBF = (Total Operating Time - Planned Downtime) / Count(Malfunction). Planned Downtime from ScheduledBasicEndDateTime-StartDateTime. Count(Malfunction) = COUNT where MaintenanceObjectIsDown=X (Same as ERP-1012 Tech Avail %) Total Operating Time not in SAP PM — G-03/G-16 . (Same assumption as Tech Avail% ?) ABCIndicator confirmed on I_MaintOrderTechObjCube; join to 2VR_MOTech on MaintenanceNotification key for PMNotif-based filter. |
ERP-1092 | % Work Order Planned | Strategic | 4MA_A2DAMM_MOTech + 4MA_A2DAMM_MaintOps | I_MaintOrderTechObjCube + I_MaintOrderOperation_DEX | Planned WO / Total WO (not completed, not breakdown). Proactive and Corrective (not break-in).
Source for order counts: I_MaintOrderTechObjCube. Planning at FieldGrp level. |
ERP-1092 | Backlog (Weeks) | Tactical | 4MA_A2DAMM_MaintOps | I_MaintOrderOperation_DEX | Total planned work in weeks of capacity. Based on Work Center of the notification. WC capacity not in CDS — G-06 . |
ERP-1092 | Planning Accuracy (%) | Tactical | 4MA_A2DAMM_MaintOps | I_MaintOrderOperation_DEX + I_MaintOrderActualCostDataCube | Planned hours vs Actual hours (OperationPlannedWork vs ConfirmationTotalQuantity). Planned Materials vs Actual Consumption from cost cube. No new DSP objects required. |
ERP-1092 | Average Planning Lead Time | Tactical | 4MA_A2DAMM_MOTech + 4MA_A2DAMM_PMNotif | I_PMNotifMaintenanceData + I_MaintOrderTechObjCube | Average days from Unplanned Corrective Notification creation to Work Order creation, segmented by MaintPriority. Join PMNotif to MOTech on MaintenanceNotification key (confirmed present on both views). WO CreationDate (ORDERCREATIONDATE) confirmed on I_MaintOrderTechObjCube. Lead time = MOTech.CreationDate - PMNotif.CreationDate. Derivable without new objects. |
ERP-1092 | % Repetitive Work without TL | Tactical | 4MA_A2DAMM_MOTech + 4MA_A2DAMM_PMNotif | I_MaintOrderTechObjCube + I_PMNotifMaintenanceData | Corrective work orders where TaskListGroup IS NULL, on same Equipment with same ObjectPartCode and DamageCode within defined period. Requires join of notification failure codes to order. DamageCode and ObjectPartCode already projected in 2VR_PMNotif — G-17 . |
ERP-1093 | Schedule Compliance (%) | Strategic | 4MA_A2DAMM_MaintOps | I_MaintOrderOperation_DEX | Work completed as per weekly schedule (snapshot). Average across weeks if period > 1 week. Frozen schedule flag required Explain snapshot requirement. — G-07 . The problem — to measure Schedule Compliance we need a snapshot of what was scheduled at the start of the week and then compare it to what was actually done by end of week. Without a snapshot, once an order is rescheduled the original committed date is overwritten. Standard SAP PM does not preserve that history. So the gap is: there is no standard CDS view or table in S/4HANA that stores the weekly schedule snapshot needed to calculate this KPI properly. It would require either a custom snapshot mechanism built in DSP, or an agreement with the business to use |
ERP-1093 | Schedule Attainment (%) | Tactical | 4MA_A2DAMM_MaintOps | I_MaintOrderOperation_DEX | Total Work Confirmation (ConfirmationTotalQuantity) vs Scheduled work for the week (OperationPlannedWork). Weekly grain required. Frozen schedule flag required Explain snapshot requirement. — G-07 . |
ERP-1093 | % Work Scheduled (vs Available Capacity) | Tactical | 4MA_A2DAMM_MaintOps | I_MaintOrderOperation_DEX | Scheduled hours / Work Center available capacity. Indicates scheduling effectiveness. WC capacity not in CDS — G-06 Also potentially: Frozen schedule flag required Explain snapshot requirement. — G-07 . |
ERP-1093 | % Break-In Work | Tactical | 4MA_A2DAMM_MaintOps | I_MaintOrderOperation_DEX | Break-In Work Confirmation / Total Work Confirmation. Break-in flag not native — G-08 . |
ERP-1093 | Frozen Schedule Adherence (%) | Tactical | 4MA_A2DAMM_MaintOps | I_MaintOrderOperation_DEX | % Work that is rescheduled. Requires identification of orders where planned date changed after freeze point — no native SAP field — G-07 . |
ERP-1096 | Technician Productivity | Strategic | 4MA_A2DAMM_MaintOps | I_MaintOrderOperation_DEX | Work Center hours booked on orders / Work Center total hours worked. I_MAINTORDEROPERATION_DEX does not give total available hours — hours confirmed used as denominator. I am not sure this is a gap anymore. The total WC hours worked could be all hours booked by the WC? WC capacity gap — G-06. |
ERP-1096 | MTTR | Tactical | 4MA_A2DAMM_PMNotif | I_PMNotifMaintenanceData | MTTR = Total Length of Downtime / No. of Breakdowns. SUM(MaintObjectDowntimeDuration) / COUNT where MaintenanceObjectIsDown=X. Aggregation by FuncLoc hierarchy not required — simplified approach. |
ERP-1096 | Overdue % | Tactical | 4MA_A2DAMM_MaintOps | I_MaintOrderTechObjCube | Order Level Overdue. Overdue Order = Final Confirmation Date - Final Due Date > 3 days. Source: I_MAINTORDERTECHOBJCUBE for order-level. 3-day tolerance. G-09 . |
|
|
|
|
|
|
ERP-1096 | Open Emergency Work / Open Time Confirmations / Open Regulatory Work | Operational | 4MA_A2DAMM_MaintOps + 4MA_A2DAMM_PMNotif | I_MaintOrderOperation_DEX + I_PMNotifMaintenanceData | Open emergency work orders, open time confirmations and open regulatory work. MaintPriority 0/1 for emergency. % Emergency Work = EmergencyNotificationCount / TotalNotificationCount — from 4MA_PMNotif. |
ERP-1098 | % Data Compliance | Strategic | 4MA_A2DAMM_MOTech | I_MaintOrderTechObjCube | % Data Compliance = Compliant Data Records / Total Data Records * 100. Objects under evaluation not yet confirmed by business. |
ERP-1098 | Active Preventive Maintenance Strategy | Tactical | 4MA_A2DAMM_MaintPlan | I_MaintenancePlan + I_MaintOrderTechObjCube | Collect each asset's active maintenance strategy. MaintPlanIsLockedAgainstCalls = false. Objects/assets under evaluation not yet confirmed. Join via MaintenancePlan key — G-11. |
ERP-1098 | Asset Information Report | Operational | 4MA_A2DAMM_MOTech | I_MaintOrderTechObjCube | Contains all information related to assets including characteristics. Equipment/FuncLoc master data attributes. |
ERP-1104 | Stock Value Trend | Tactical | 4MA_P2FINV_MaterialStock (P2F) | 2VR_S4HARM_GoodsMovementDocumentDEX (P2F) | Stock value over time by SLOC/Plant. Reuse 4MA_P2FINV_MaterialStock with MRO filter. |
ERP-1104 | Stock Outs | Tactical | 4MA_P2FINV_MaterialStock (P2F) | 2VR_S4HARM_GoodsMovementDocumentDEX (P2F) | # items where stock qty = 0 with open reservations. Derivable from 4MA_P2FINV_MaterialStock with MRO filter. |
ERP-1104 | Stock Over Max | Tactical | 4MA_P2FINV_MaterialStock (P2F) + MRP master | 2VR_S4HARM_GoodsMovementDocumentDEX + MM MRP data | % items above max stock level. Max stock level (MRP parameter) not in current P2F objects. Additional source required — G-18. |
ERP-1104 | Delivery Accuracy | Tactical | TBD | Purchasing / Delivery CDS (TBD) | Goods receipt vs PO delivery date comparison. Not covered by 4MA_P2FINV_MaterialStock. Requires purchasing/delivery CDS — G-17 . |
ERP-1104 | Cycle Count Accuracy | Tactical | TBD | Physical Inventory CDS (TBD) | Physical inventory count accuracy for MRO/spare parts managed by maintenance team. Not in P2F DDFS objects. May relate to ERP-436 — G-18 . |
ERP-1104 | Cycle Count Completion YTD | Tactical | TBD | Physical Inventory CDS (TBD) | YTD completion of physical inventory cycles. Same source gap as Cycle Count Accuracy — G-18 . |
ERP-1104 | Inventory Turnover Analysis | Operational | TBD | Material stock + consumption CDS (TBD) | Stock value turnover rate by material/SLOC over time. Source: combination of 4MA_P2FINV_MaterialStock (P2F) and goods movement/consumption data. Detailed source and model TBD — no standard extractor identified yet. |
ERP-1156 | Cross-Instance Material Visibility | Operational | 4MA_P2FINV_MaterialStock (P2F) | 2VR_S4HARM_GoodsMovementDocumentDEX (P2F) | SHARED WITH P2F. Cross-instance (ROW + China). DAE/ITAR review mandatory. |
