Document Links
ERP-1043 - Getting issue details... STATUS
Introduction
1. Introduction
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:
- ERP-888 – Maintenance and Asset Management Cost Dashboard (PARKED)
- ERP-1012 – Asset Availability Dashboard (Planned vs Unplanned Downtime)
- ERP-1013 – Reliability Engineering Dashboard (MTBF, Top 10 Bad Actors)
- ERP-1092 – Maintenance Planning Dashboard
- ERP-1093 – Maintenance Scheduling Dashboard
- ERP-1096 – Maintenance Execution Dashboard (MTTR, Overdue%, Technician Productivity)
- ERP-1098 – Asset Information Dashboard (Preventive Maintenance Strategy, Data Compliance)
- ERP-1104 – MRO Dashboard (CROSS-REFERENCE to P2F DDFS — no new A2D objects)
- ERP-1156 – Cross-Instance Material Visibility – MRO Spares (CROSS-REFERENCE to P2F DDFS — DAE/ITAR review mandatory)
1.1 Scope Note: ERP-1104 and ERP-1156
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.
2. Requirements, KPIs and Analytical Model Mapping
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-1013 | Reactive vs Proactive Maintenance | Operational | 4MA_A2DAMM_MaintCost | I_MaintOrderActualCostDataCube | Cost split by MaintenanceActivityType (Preventive/Corrective/Emergency). I_MaintOrderActualCostDataCube does not carry MaintenanceActivityType directly — join to 3VR_MOTech required in 3VF_MaintCosts — G-17. |
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. Total Operating Time not in SAP PM — G-03/G-16. ABC Indicator filter — G-15. |
ERP-1092 | Planning Compliance | Strategic | 4MA_A2DAMM_MaintOps | I_MaintOrderTechObjCube | Planned WO / Total WO (not completed, not breakdown). Proactive and Corrective (not break-in) order types. MaintenanceActivityType filter. Source for counts: I_MaintOrderTechObjCube. |
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 | % Task List Usage | Tactical | 4MA_A2DAMM_MOTech | I_MaintOrderTechObjCube | TaskListGroup IS NOT NULL on order. Repetitive work without task list also tracked. |
ERP-1092 | Planned vs Actual Man-Hours | Tactical | 4MA_A2DAMM_MaintOps | I_MaintOrderOperation_DEX | OperationPlannedWork vs ConfirmationTotalQuantity. Planning is at FieldGrp level. |
ERP-1092 | % Emergency Work | Tactical | 4MA_A2DAMM_PMNotif | I_PMNotifMaintenanceData | MaintPriority IN (0,1) / total notifications. |
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 on MaintenanceNotification reference field. Order creation date field to be confirmed on I_MaintOrderTechObjCube — G-18. |
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-19. |
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 — G-07. |
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. |
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. |
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. 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 | % Rework | Tactical | 4MA_A2DAMM_MaintOps | I_MaintOrderOperation_DEX | Reactive maintenance orders in Repair activity type vs technically completed orders within defined timeframe on same equipment. Drilldown by maintenance order. G-10. |
ERP-1096 | Open Emergency / Regulatory Work | Operational | 4MA_A2DAMM_MaintOps | I_MaintOrderOperation_DEX | Open emergency work orders, open time confirmations and open regulatory work. MaintPriority 0/1 for emergency. |
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-19. |
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-20. |
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-20. |
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. |
3. Data Flow Diagram
4. Source System Extractors
The following source extractors feed the A2D data flow. All S/4HANA extractors are wrapped custom CDS views (Z_I_...) or standard VDM wrappers deployed in the SSAL_S4Hx space. The APM extractor is a placeholder pending APM integration definition.
Code | System | Extractor / CDS View | Key Base Tables | Supports ERPs | Notes |
XE_PMNotif | S4H | Z_I_PMNotifMaintenanceData | QMEL / QMIH / ILOA | ERP-1012, ERP-1013, ERP-1092, ERP-1096 | Existing custom Z-extractor. |
XE_MOTech | S4H | I_MaintOrderTechObjCube | IFLOT, ILOA, AUFK, AFKO, AFIH, CRHD, EQUZ, EQUI + others | ERP-1012, ERP-1013, ERP-1092, ERP-1093, ERP-1096, ERP-1098 | Standard VDM cube. Wrapper required. |
XE_CostCube | S4H | I_MaintOrderActualCostDataCube | SCAL_TT_DATE, EQUZ, EQUI, SKA1 + others | ERP-888, ERP-1013 | Standard VDM cost cube. Wrapper required. |
XE_MaintOps | S4H | I_MaintOrderOperation_DEX | Operation-level DEX | ERP-1092, ERP-1093, ERP-1096 | Standard DEX view. Wrapper required. |
XE_EqBOM | S4H | Z_I_EquipmentBomLink | EQST | ERP-1098 | Custom Z-extractor. |
XE_MaintPlan | S4H | I_MaintenancePlan | MPLA / T399W | ERP-1098 | Standard view. Wrapper required. |
XE_APMRecom | APM | Z_apm_tbd | APM system (TBD) | ERP-1013 | BLOCKED — APM extractor not defined. |
5. Inbound Layer
The Inbound Layer (Layer 1) receives delta-loaded records from source extractors. No field transformations are applied at this layer. Standard technical fields (load date/time, source system) are retained as delivered. Objects reside in the SSAL_S4Hx space (S/4 HANA sourced) and SSAL_APM space (APM sourced).
Code | Object Name (Tech) | Source Extractor | Notes |
1TXL_PMNotif | 1TL_S4Hx_I_PMNotifMaintenanceData | Z_I_PMNotifMaintenanceData (XE_PMNotif) | Initial + delta load. |
1TXL_MOTech | 1TL_S4Hx_I_MaintOrderTechObCube | I_MaintOrderTechObjCube (XE_MOTech) | Standard VDM wrapper. Delta load. |
1TXL_CostCube | 1TL_S4Hx_I_MaintOrderActualCostCube | I_MaintOrderActualCostDataCube (XE_CostCube) | Standard VDM wrapper. Delta load. |
1TXL_MaintOps | 1TL_S4Hx_I_MaintOrderOperation | I_MaintOrderOperation_DEX (XE_MaintOps) | DEX export. Delta load. |
1TXL_EqBOM | 1TL_S4Hx_I_EquipmentBomLink | Z_I_EquipmentBomLink (XE_EqBOM) | Custom Z-extractor. |
1TXL_MaintPlan | 1TL_S4Hx_I_MaintenancePlan | I_MaintenancePlan (XE_MaintPlan) | Standard view wrapper. |
1TXL_Recom (SSAL_APM) | TBD | Z_apm_tbd (XE_APMRecom) | BLOCKED — APM extractor not defined. |
6. Harmonisation Layer
The Harmonisation Layer (Layer 2) standardises objects within the SSAL_S4HARM space. For each source, a TL (table/load), TF (transformation flow), and VR (view) triplet is produced. The VR is the consumed object in Propagation. No business-logic transformations are applied; the purpose is to fix keys, apply BINTOHEX treatment to RAW UUID fields, and present a clean, stable interface.
The Harmonisation Layer (Layer 2) standardises objects within the SSAL_S4HARM space. For each source stream a TL (load), TF (transformation flow), and VR (view) triplet is produced. The VR is the interface object consumed by the Propagation Layer. The purpose is to establish stable keys, apply BINTOHEX treatment to RAW-type UUID fields, apply date format conversions where needed, and project only required fields downstream. No business-logic transformations are applied at this layer.
Row colour coding: Blue = TL, Purple = TF, Green = VR/VD, Amber = blocked or gap.
Type | Object Name | Source | Purpose | Filter | Projection | Formula / Aggregation | Notes |
TL | 2TL_S4HARM_I_PMNotifMaintenanceData (2TL_PMNotif) | 1TL_S4Hx_I_PMNotifMaintenanceData (1TXL_PMNotif) | Delta load of PM notification maintenance data. Set keys. Filled by 2TF_S4HARM_I_PMNotifMaintenanceData. | Add as Key: MaintenanceNotification Add as Key: NotificationItem | Supports ERP-1012, ERP-1013, ERP-1092, ERP-1096. | ||
TF | 2TF_S4HARM_I_PMNotifMaintenanceData | 1TL_S4Hx_I_PMNotifMaintenanceData (1TXL_PMNotif) | No transformations. | ||||
VR | 2VR_S4HARM_I_PMNotifMaintenanceData (2VR_PMNotif) | 2TL_S4HARM_I_PMNotifMaintenanceData | View on harmonised PM notification maintenance data. | MaintenanceNotification IS NOT NULL | Include: MaintenanceNotification Include: NotificationItem Include: Equipment Include: FunctionalLocation Include: RelevantFunctionalLocation Include: MaintenancePlant Include: MaintenancePlannerGroup Include: MaintenanceActivityType Include: NotificationType Include: MaintPriority Include: MaintenanceObjectIsDown Include: MaintObjectDowntimeDuration Include: MaintObjDowntimeDurationUnit Include: MalfunctionStartDate Include: MalfunctionStartTime Include: MalfunctionEndDate Include: MalfunctionEndTime Include: CreationDate Include: CreationTime Include: AvailyBeforeMalfunctionPercent Include: AvailyAfterMalfunctionPercent Include: AvailyAfterConclusionPercent Include: SystConditionBeforeMalfunction Include: SystConditionAfterMalfunction Include: SystConditionAfterCompletion Include: CompanyCode Include: DamageCode Include: ObjectPartCode Include: CauseCode Include: ABCIndicator | ||
TL | 2TL_S4HARM_I_MaintOrderTechObCube (2TL_MOTech) | 1TL_S4Hx_I_MaintOrderTechObCube (1TXL_MOTech) | Delta load of maintenance order technical object data. Set keys. Filled by 2TF_S4HARM_I_MaintOrderTechObCube. | Add as Key: MaintenanceOrder | Supports ERP-1012, ERP-1092, ERP-1093, ERP-1096, ERP-1098. | ||
TF | 2TF_S4HARM_I_MaintOrderTechObCube | 1TL_S4Hx_I_MaintOrderTechObCube (1TXL_MOTech) | No transformations. | ||||
VR | 2VR_S4HARM_I_MaintOrderTechObCube (2VR_MOTech) | 2TL_S4HARM_I_MaintOrderTechObCube | View on harmonised maintenance order / technical object data. | MaintenanceOrder IS NOT NULL AND MaintenanceOrder <> '' | Include: MaintenanceOrder Include: Equipment Include: FunctionalLocation Include: MaintenancePlant Include: MaintenancePlannerGroup Include: PlantSection Include: MainWorkCenter Include: WorkCenterInternalID Include: MaintenanceOrderType Include: MaintenanceActivityType Include: MaintenancePlan Include: TaskListGroup Include: TaskListGroupCounter Include: TaskListType Include: OrderUserStatus Include: ScheduledBasicStartDate Include: ScheduledBasicStartTime Include: ScheduledBasicEndDate Include: ScheduledBasicEndTime Include: ScheduledBasicStartDateTime Include: ScheduledBasicEndDateTime Include: ActualStartDate Include: ConfirmedEndDate Include: CompanyCode Include: WBSElementInternalID | ||
TL | 2TL_S4HARM_I_MaintOrderActualCostCube (2TL_CostCube) | 1TL_S4Hx_I_MaintOrderActualCostCube (1TXL_CostCube) | Delta load of maintenance order actual cost postings. Set keys. Filled by 2TF_S4HARM_I_MaintOrderActualCostCube. | Add as Key: MaintenanceOrder Add as Key: AccountingDocument Add as Key: FiscalYear Add as Key: AccountingDocumentItem | Supports ERP-888, ERP-1013. | ||
TF | 2TF_S4HARM_I_MaintOrderActualCostCube | 1TL_S4Hx_I_MaintOrderActualCostCube (1TXL_CostCube) | No transformations. | ||||
VR | 2VR_S4HARM_I_MaintOrderActualCostCube (2VR_CostCube) | 2TL_S4HARM_I_MaintOrderActualCostCube | View on harmonised maintenance order actual cost data. | MaintenanceOrder IS NOT NULL AND MaintenanceOrder <> '' | Include: MaintenanceOrder Include: AccountingDocument Include: FiscalYear Include: AccountingDocumentItem Include: CompanyCode Include: CompanyCodeCurrency Include: AmountInCompanyCodeCurrency Include: TransactionCurrency Include: AmountInTransactionCurrency Include: GLAccount Include: CostElement Include: MaintenanceOrderType Include: Plant Include: Equipment Include: FunctionalLocation Include: WBSElementInternalID Include: CostCenter Include: ControllingArea Include: PostingDate | ||
TL | 2TL_S4HARM_I_MaintOrderOperation (2TL_MaintOps) | 1TL_S4Hx_I_MaintOrderOperation (1TXL_MaintOps) | Delta load of maintenance order operation records. Set keys. Filled by 2TF_S4HARM_I_MaintOrderOperation. | Add as Key: MaintenanceOrder Add as Key: MaintenanceOrderOperation | Supports ERP-1092, ERP-1093, ERP-1096. | ||
TF | 2TF_S4HARM_I_MaintOrderOperation | 1TL_S4Hx_I_MaintOrderOperation (1TXL_MaintOps) | No transformations. | ||||
VR | 2VR_S4HARM_I_MaintOrderOperation (2VR_MaintOps) | 2TL_S4HARM_I_MaintOrderOperation | View on harmonised maintenance order operation data. | MaintenanceOrder IS NOT NULL AND MaintenanceOrderOperation IS NOT NULL | Include: MaintenanceOrder Include: MaintenanceOrderOperation Include: Plant Include: WorkCenter Include: WorkCenterPlant Include: WorkCenterInternalID Include: MaintenancePlannerGroup Include: MaintenanceOrderType Include: MaintenanceActivityType Include: OperationPlannedWork Include: OperationPlannedWorkUnit Include: ConfirmationTotalQuantity Include: ConfirmationTotalQuantityUnit Include: MaintOrdOperationWorkDuration Include: OplTStSchedldExecEndDte Include: LatestAcceptableCompletionDate Include: MaintOrdProcessPhaseCode Include: ConfirmedEndDate Include: ConfirmedEndTime Include: Equipment Include: FunctionalLocation Include: MaintOrdMainWorkCenter Include: MaintOrdMainWorkCenterPlant | ||
TL | 2TL_S4HARM_I_EquipmentBomLink (2TL_EqBOM) | 1TL_S4Hx_I_EquipmentBomLink (1TXL_EqBOM) | Delta load of equipment BOM link data. Set keys. Filled by 2TF_S4HARM_I_EquipmentBomLink. | Add as Key: Equipment Add as Key: BillOfMaterial Add as Key: BillOfMaterialCategory Add as Key: BillOfMaterialVariant | Supports ERP-1098. | ||
TF | 2TF_S4HARM_I_EquipmentBomLink | 1TL_S4Hx_I_EquipmentBomLink (1TXL_EqBOM) | No transformations. | ||||
VR | 2VR_S4HARM_I_EquipmentBomLink (2VR_EqBOM) | 2TL_S4HARM_I_EquipmentBomLink | View on harmonised equipment BOM link data. | Equipment IS NOT NULL AND Equipment <> '' | Include: Equipment Include: BillOfMaterial Include: BillOfMaterialCategory Include: BillOfMaterialVariant Include: BillOfMaterialVariantUsage Include: Plant | ||
VD | 2VD_S4HARM_Equipment (2VD_Equip) | I_Equipment (standard VDM) | Equipment master data dimension. Provides Equipment description, object type, plant, manufacturer for lookups across analytical models. | No TL/TF required. Standard dimension object sourced directly. | |||
TL | 2TL_S4HARM_I_MaintenancePlan (2TL_MaintPlan) | 1TL_S4Hx_I_MaintenancePlan (1TXL_MaintPlan) | Delta load of maintenance plan data (MPLA / T399W). Set keys. Filled by 2TF_S4HARM_I_MaintenancePlan. | Add as Key: MaintenancePlan | Supports ERP-1098 (Active Preventive Maintenance Strategy KPI). | ||
TF | 2TF_S4HARM_I_MaintenancePlan | 1TL_S4Hx_I_MaintenancePlan (1TXL_MaintPlan) | No transformations. | ||||
VR | 2VR_S4HARM_I_MaintenancePlan (2VR_MaintPlan) | 2TL_S4HARM_I_MaintenancePlan | View on harmonised maintenance plan data. | MaintenancePlan IS NOT NULL AND MaintenancePlan <> '' | Include: MaintenancePlan Include: MaintenancePlanDesc Include: MaintenanceStrategy Include: MaintenancePlanCategory Include: FunctionalLocation Include: Equipment Include: SchedulingStartDate Include: SchedulingStartTime Include: SchedulingEndDate Include: MaintPlanIsLockedAgainstCalls Include: CallHorizonInDays Include: SchedulingDuration Include: SchedulingDurationUnit Include: Plant Include: AuthorizationGroup | NOTE: PlantSection (BEBER) and MaintenancePlannerGroup (INGRP) not on I_MaintenancePlan. Resolved by join to 2VR_MOTech in Propagation Layer (3VF_A2DAMM_MaintenancePlan). See Section 6.4. | |
TL | 2TL_S4HARM_xxxxxx (2TL_Recom) | 1TXL_Recom (SSAL_APM) Z_apm_tbd | BLOCKED — APM recommendation data load. Object names and source TBD pending APM integration analysis. | BLOCKED | |||
VR | 2VR_S4HARM_xxxxxx (2VR_Recom) | 2TL_S4HARM_xxxxxx | BLOCKED — APM recommendation view. Filter, projection and formula TBD. | BLOCKED | BLOCKED | BLOCKED | BLOCKED |
PLACEHOLDER | WBS / Planned Cost (Placeholder) | CO / PS — source TBD | WBS planned cost input for ERP-888 budget comparison KPI. No standard SAP PM CDS view exposes WBS planned values. | TBD | TBD | TBD |
Propagation Layer
The Propagation Layer (Layer 3) applies business logic, joins, unions, and derivations to produce the fact views consumed by Analytical Models. VR objects are projection views. VF objects apply formulas and/or perform joins/unions.
Type | Object Name | Source(s) | Purpose | Filter | Projection | Formula / Aggregation / Joins | Notes |
VR | 3VR_A2DAMM_PMNotif (3VR_PMNotif) | 2VR_PMNotif | Projects notification grain. 1 row per notification. Includes breakdown flags, downtime duration, malfunction dates, priority, DamageCode, ObjectPartCode, CauseCode. | ||||
VR | 3VR_A2DAMM_MOTech (3VR_MOTech) | 2VR_MOTech | Projects order-centric grain. Includes scheduled dates, planner group, plant section, task list, order type, MaintenanceActivityType. | ||||
VR | 3VR_A2DAMM_UnplannedDowntime (3VR_UnplanDT) | 2VR_PMNotif | Unplanned downtime projection. | MaintenanceObjectIsDown = 'X' | PlannedVsUnplanned = 'UNPLANNED' SourceType = 'NOTIF' DowntimeHours = MaintObjectDowntimeDuration / 3600 StartDateTime = MalfunctionStartDate + Time EndDateTime = MalfunctionEndDate + Time | ||
VR | 3VR_A2DAMM_PlannedDowntime (3VR_PlanDT) | 2VR_MOTech | Planned downtime projection. | MaintenanceOrderType IN planned types | PlannedVsUnplanned = 'PLANNED' SourceType = 'ORDER' DowntimeHours = (ScheduledBasicEndDateTime - ScheduledBasicStartDateTime) / 3600 | ||
VF | 3VF_A2DAMM_DowntimeFact (3VF_DTFact) | UNION: 3VR_UnplanDT + 3VR_PlanDT | Union of planned and unplanned downtime. No pre-aggregation. | Union: Accept default union mappings | Supports ERP-1012. | ||
VF | 3VF_A2DAMM_PMNotifFact (3VF_PMNotif) | 3VR_PMNotif | Formula/calculation view. Adds derived measures for notification-level KPIs. | BreakdownNotificationCount = CASE WHEN MaintenanceObjectIsDown = 'X' THEN 1 ELSE 0 END EmergencyNotificationCount = CASE WHEN MaintPriority IN ('0','1') THEN 1 ELSE 0 END DowntimeHours = MaintObjectDowntimeDuration / 3600 MalfunctionCount = 1 per notification where MaintenanceObjectIsDown = X DamageCode passthrough ObjectPartCode passthrough CauseCode passthrough | Supports ERP-1012, ERP-1013, ERP-1092, ERP-1096. | ||
VF | 3VF_A2DAMM_MaintOrderTechFact (3VF_MOTech) | 3VR_MOTech | Formula/calculation view on order data. Adds derived flags. | TaskListUsageFlag = CASE WHEN TaskListGroup IS NOT NULL THEN 'X' ELSE '' END PlannedWindowSeconds = ScheduledBasicEndDateTime - ScheduledBasicStartDateTime OrderCount = 1 | Supports ERP-1012, ERP-1092, ERP-1098. | ||
VR | 3VR_A2DAMM_MaintOrderActualCostCube (3VR_CostCube) | 2VR_CostCube | Cost data projection for join into 3VF_MaintCosts. | CompanyCode IS NOT NULL | Supports ERP-888, ERP-1013. | ||
VR | 3VR_A2DAMM_AssetReplacementValue (3VR_ARV) | Placeholder | Asset Replacement Value derivation. Source TBD. | TBD | TBD | TBD | GAP G-02. |
VF | 3VF_A2DAMM_MaintenanceCost (3VF_MaintCosts) | JOIN: 3VR_CostCube + 3VR_ARV + WBS Placeholder + 3VR_MOTech (ActivityType) | Join of cost actuals, ARV, planned cost, and MaintenanceActivityType from order header for ERP-1013 cost split. | TBD | Cost fields, ARV, WBS planned, MaintenanceActivityType | Join key: MaintenanceOrder / Equipment MaintenanceActivityType from 3VR_MOTech — G-17 | PARKED pending ERP-888 confirmation and G-02/G-03 resolution. |
VR | 3VR_A2DAMM_MaintOrderOperation (3VR_MaintOps) | 2VR_MaintOps | Operation-grain projection. | MaintenanceOrder IS NOT NULL | |||
VF | 3VF_A2DAMM_MaintOrderOperation (3VF_MaintOps) | JOIN: 3VR_MaintOps + 3VR_MOTech | Formula view. Adds overdue/rework flags. Joins order header for PlannerGroup/PlantSection. | OverdueFlag = CASE WHEN OplTStSchedldExecEndDte < current_date AND order open THEN 'X' ReworkFlag = CASE WHEN MaintenanceActivityType = 'M08' THEN 'X' TaskListUsageFlag = CASE WHEN TaskListGroup IS NOT NULL THEN 'X' Join key: MaintenanceOrder | Supports ERP-1092, ERP-1093, ERP-1096. | ||
VR | 3VR_A2DAMM_EquipmentBomLink (3VR_EqBOM) | 2VR_EqBOM | Equipment BOM link projection. | ||||
VF | 3VF_A2DAMM_EquipmentBomLink (3VF_EqBOM) | JOIN: 3VR_EqBOM + 3VR_MOTech | Equipment BOM enriched with order/technical object data. | Join key: Equipment | Supports ERP-1098. | ||
VR | 3VR_A2DAMM_MaintenancePlan (3VR_MaintPlan) | 2VR_MaintPlan | Maintenance plan projection. Active plans filter. | MaintPlanIsLockedAgainstCalls = false | |||
VF | 3VF_A2DAMM_MaintenancePlan (3VF_MaintPlan) | JOIN: 3VR_MaintPlan + 3VR_MOTech | Join of maintenance plan to order data. Resolves PlantSection and PlannerGroup from order side. | JOIN: 3VR_MaintPlan.MaintenancePlan = 3VR_MOTech.MaintenancePlan DEDUPLICATE on MaintenancePlan grain to avoid double-counting | Supports ERP-1098. See G-12. | ||
VR | 3VR_A2DAMM_xxxxxx (3VR_Recom) | 2VR_Recom (APM) | APM recommendation propagation. TBD. | BLOCKED | BLOCKED | BLOCKED |
.1 3VF_A2DAMM_DowntimeFact - Union Detail
Two projections align schemas before the union:
- Unplanned: SourceType='NOTIF', PlannedVsUnplanned='UNPLANNED', DowntimeHours = MaintObjectDowntimeDuration/3600, FunctionalLocation from RelevantFunctionalLocation.
- Planned: SourceType='ORDER', PlannedVsUnplanned='PLANNED', DowntimeHours = (ScheduledBasicEndDateTime - ScheduledBasicStartDateTime)/3600.
Common union fields: Equipment, FunctionalLocation, MaintenancePlant, PlannerGroup, StartDateTime, EndDateTime, DowntimeHours, PlannedVsUnplanned, SourceType.
6.2 3VF_A2DAMM_MaintenanceCost - Join Detail
Joins 3VR_CostCube + 3VR_ARV + WBS Placeholder + 3VR_MOTech (for MaintenanceActivityType). Join key: MaintenanceOrder / Equipment.
GAP/ISSUE: ARV source not confirmed — G-01.
GAP/ISSUE: WBS Planned Cost source not confirmed — G-02.
GAP/ISSUE: MaintenanceActivityType join strategy to be confirmed — G-17.
6.3 3VF_A2DAMM_MaintOrderOperation - Join Detail
Joins 3VR_MaintOps (operation grain) to 3VR_MOTech (order header grain) via MaintenanceOrder to resolve PlannerGroup and PlantSection. No RESOURCEWORKCENTER field on I_MAINTORDEROPERATION_DEX; other WorkCenter fields available.
GAP/ISSUE: Work Center Capacity (KAKO/KAZY) not in any standard CDS — G-06.
GAP/ISSUE: Average Planning Lead Time: WO creation date field and notification-to-order join key to be confirmed — G-18.
GAP/ISSUE: % Repetitive Work without TL: notification failure code to order join pattern to be confirmed — G-19.
6.4 3VF_A2DAMM_MaintenancePlan - Join Detail
LEFT JOIN 3VR_MaintPlan to 3VR_MOTech ON MaintenancePlan key. Resolves PlantSection and PlannerGroup from order side. DEDUPLICATE on MaintenancePlan grain after join to avoid order-level double counting.
GAP/ISSUE: PlantSection and PlannerGroup not on I_MaintenancePlan — G-11.
7. Reporting Layer
The Reporting Layer (Layer 4) exposes Analytical Models (AMs) to SAC live connections. Objects in SPOD_A2DAMM are operational reporting models. Objects in SPLN_A2DAMM are planning models. SAC live connection constraint: all fields that must be reported together at the same grain must be joined in Propagation — they cannot be joined across separate AMs in SAC.
Code | AM Name (Tech) | Source | Supports ERPs | Notes | Status |
4MA_PMNotif | 4MA_A2DAMM_PMNotif | 3VF_PMNotif | ERP-1012, ERP-1013, ERP-1092, ERP-1096 | Notification-grain AM. Downtime, MTBF, MTTR, emergency notification KPIs. Failure reason analysis (DamageCode, ObjectPartCode, CauseCode). | |
4MA_MOTech | 4MA_A2DAMM_MOTech | 3VF_MOTech | ERP-1012, ERP-1013, ERP-1092, ERP-1098 | Maintenance order / technical object AM. Availability, planning compliance, task list, data compliance. | |
4MA_DownTime | 4MA_A2DAMM_DowntimeFact | 3VF_DTFact | ERP-1012 | Unified downtime fact AM (planned + unplanned union). | |
4MA_MaintCost | 4MA_A2DAMM_MaintCost | 3VF_MaintCosts | ERP-888, ERP-1013 | Maintenance cost AM. ERP-1013 requires: Top 10 by cost; cost split by MaintenanceActivityType for Reactive vs Proactive. ActivityType join from 3VR_MOTech required — G-17. PARKED pending ERP-888 go/no-go. | PARKED |
4MA_MaintOps | 4MA_A2DAMM_MaintOps | 3VF_MaintOps | ERP-1092, ERP-1093, ERP-1096 | Operations AM. Planning/scheduling/execution KPIs at operation grain. | |
4MA_EqBOM | 4MA_A2DAMM_EqBOM | 3VF_EqBOM | ERP-1098 | Equipment BOM AM. | |
4MA_MaintPlan | 4MA_A2DAMM_MaintPlan | 3VF_MaintPlan | ERP-1098 | Maintenance plan AM. Active preventive maintenance strategy KPI. | |
4MA_Recom | 4MA_A2DAMM_xxxxxx | 3VF_Recom (TBD) | ERP-1013 (APM) | APM recommendation AM. TBD pending APM integration — G-05. | BLOCKED |
4MP_ARV (SPLN) | 4MP_A2DAMM_ARV | 3VR_ARV (TBD) | ERP-888 | Planning AM — Asset Replacement Value input. SPLN_A2DAMM space. | TBD |
4MP_AMMKPI (SPLN) | 4MP_A2DAMM_AMMKPI | Multi-source | All | KPI targets planning AM. SPLN_A2DAMM space. | TBD |
7.1 4MA_A2DAMM_PMNotif - Calculated Measures
Measure Name | Calculation / Source Field | Aggregation | Notes |
Notification Count | Constant 1 per record | SUM | |
Breakdown Notification Count | CASE WHEN MaintenanceObjectIsDown = 'X' THEN 1 ELSE 0 END | SUM | |
Downtime Duration (Seconds) | MaintObjectDowntimeDuration (AUSZT) | SUM | |
Downtime Hours (Unplanned) | MaintObjectDowntimeDuration / 3600 | SUM | |
Emergency Notification Count | CASE WHEN MaintPriority IN ('0','1') THEN 1 ELSE 0 END | SUM | |
% Emergency Work | EmergencyNotificationCount / TotalNotificationCount * 100 | CALCULATED | |
MTTR (Hours) | Total Length of Downtime / No. of Breakdowns. SUM(MaintObjectDowntimeDuration) / COUNT(BreakdownNotifications) / 3600. Aggregation by FuncLoc hierarchy not required — simplified approach. | CALCULATED | |
MTBF (Hours) | MTBF = (Total Operating Time - Planned Downtime) / Count(Malfunction). Planned Downtime from ScheduledBasicEndDateTime-StartDateTime. Count(Malfunction) = COUNT where MaintenanceObjectIsDown=X. | CALCULATED | G-03 / G-16 — Total Operating Time not in SAP PM. |
Malfunction Count | COUNT of notifications WHERE MaintenanceObjectIsDown = X | SUM | Used as denominator in MTBF formula. |
Availability Before Malfunction (%) | AvailyBeforeMalfunctionPercent | AVG | |
Availability After Malfunction (%) | AvailyAfterMalfunctionPercent | AVG | |
Availability After Conclusion (%) | AvailyAfterConclusionPercent | AVG | |
Damage Code (Dimension) | DamageCode passthrough from I_PMNotifMaintenanceData. Failure reason analysis. | Dimension | New for ERP-1013. |
Object Part Code (Dimension) | ObjectPartCode passthrough. | Dimension | New for ERP-1013. |
Cause Code (Dimension) | CauseCode passthrough. | Dimension | New for ERP-1013. |
7.2 4MA_A2DAMM_DowntimeFact - Calculated Measures
MaintenanceObjectIsDown = X identifies breakdown downtime. Planned Downtime: anything not marked as breakdown is treated as planned preventive/corrective work. Total Operating Time assumption: 365 x 24 hours — approach to be agreed before build — G-03.
Measure Name | Calculation / Source Field | Aggregation | Notes |
Breakdown Notification Count | CASE WHEN MaintenanceObjectIsDown = 'X' THEN 1 ELSE 0 END | SUM | Unplanned side. |
Downtime Hours (Unplanned) | MaintObjectDowntimeDuration / 3600 | SUM | |
Planned Order Count | Constant 1 per planned order row | SUM | |
Planned Window Hours | (ScheduledBasicEndDateTime - ScheduledBasicStartDateTime) / 3600 | SUM | |
Unified Downtime Hours | CASE WHEN SourceType='NOTIF' THEN DowntimeHours ELSE PlannedWindowHours END | SUM | Down Time Type derived from Work Order Type / Breakdown Indicator from notification. |
Total Unplanned Downtime Hours | SUM(UnifiedDowntimeHours) WHERE PlannedVsUnplanned = 'UNPLANNED' | SUM (restricted) | |
Total Planned Downtime Hours | SUM(UnifiedDowntimeHours) WHERE PlannedVsUnplanned = 'PLANNED' | SUM (restricted) | |
Downtime Ratio (Planned / Unplanned) | TotalPlannedDowntime / NULLIF(TotalUnplannedDowntime, 0) | CALCULATED | |
Technical Availability % | (Total Operating Time - Breakdown Time - Planned Down Time) / Total Operating Time * 100 | CALCULATED | G-03 — Total Operating Time not in SAP PM. Assumption: 365 x 24 hours. |
7.3 4MA_A2DAMM_MaintOps - Calculated Measures
No RESOURCEWORKCENTER field on I_MAINTORDEROPERATION_DEX; other WorkCenter fields available. Planning is at FieldGrp level.
Measure Name | Calculation / Source Field | Aggregation | Notes |
Order Count (Proactive) | COUNT WHERE MaintenanceActivityType IN proactive types | SUM | |
Order Count (Reactive) | COUNT WHERE MaintenanceActivityType IN reactive types | SUM | |
Planning Compliance % | Planned WO / Total WO (not completed, not breakdown) * 100 | CALCULATED | |
Planned Man-Hours | SUM(OperationPlannedWork) by WorkCenter / PlannerGroup | SUM | Planned vs actual comparison approach to be confirmed. |
Actual Man-Hours (Confirmed) | SUM(ConfirmationTotalQuantity) | SUM | Total hours worked = hours confirmed on orders. |
Backlog Hours | SUM(OperationPlannedWork) for open/planned orders | SUM | Total planned work based on Work Center of the notification. |
Backlog Weeks | BacklogHours / WorkCenterCapacityHours | CALCULATED | G-06 — WC capacity not in CDS. |
Overdue Order Count | Order Level: Overdue Order = Final Confirmation Date - Final Due Date > 3 days | SUM | G-09. Source: I_MAINTORDERTECHOBJCUBE. |
Overdue % | OverdueOrderCount / TotalScheduledOrderCount * 100 | CALCULATED | 3-day tolerance. G-09. |
Rework Order Count | Reactive maintenance orders in Repair activity type vs technically completed orders within defined timeframe on same equipment | SUM | G-10. Drilldown by maintenance order. |
Rework % | ReworkOrderCount / TotalOrderCount * 100 | CALCULATED | |
MTTR (Hours) | SUM(MaintObjectDowntimeDuration) / COUNT(BreakdownNotifications) / 3600 | CALCULATED | From PMNotif join. |
Technician Productivity | Work Center hours booked on orders / Work Center total hours worked. Hours confirmed used as proxy for total hours worked. | CALCULATED | G-06 — WC capacity not in CDS. |
% Task List Usage | COUNT(OrdersWithTaskList) / TotalOrderCount * 100 | CALCULATED | |
% Emergency Work | COUNT(MaintPriority IN '0','1') / TotalNotificationCount * 100 | CALCULATED | From PMNotif join. |
Schedule Compliance % | Work completed as per weekly schedule (snapshot) / Total scheduled | CALCULATED | G-07 — frozen schedule flag not native. |
Schedule Attainment % | ConfirmationTotalQuantity / OperationPlannedWork for the frozen week * 100 | CALCULATED | Weekly grain. |
% Work Scheduled vs Available Capacity | Scheduled hours / WC available capacity | CALCULATED | G-06 — WC capacity not in CDS. |
% Break-In Work | Break-In Work Confirmation / Total Work Confirmation | CALCULATED | G-08. |
Frozen Schedule Adherence % | % Work rescheduled after freeze point | CALCULATED | G-07 — rescheduled flag not native. |
Planning Accuracy % (Hours) | OperationPlannedWork vs ConfirmationTotalQuantity / OperationPlannedWork * 100 | CALCULATED | |
Planning Accuracy % (Materials) | Planned Material Cost vs Actual Material Cost / Planned * 100 | CALCULATED | From cost cube join. Planned material cost field to be confirmed. |
Average Planning Lead Time (Days) | AVG(Work Order creation date - Notification creation date) for unplanned corrective, by MaintPriority | AVG | G-18 — WO creation date field to be confirmed on I_MaintOrderTechObjCube. |
% Repetitive Work without TL | COUNT(corrective orders without TaskListGroup on same Equipment, same ObjectPartCode, same DamageCode) / TotalCorrectiveOrders * 100 | CALCULATED | G-19 — join between PMNotif failure codes and order header required. |
7.4 4MA_A2DAMM_MaintPlan - Calculated Measures
Objects under evaluation for both Data Compliance and Active Preventive Maintenance Strategy not yet confirmed by business.
Measure Name | Calculation / Source Field | Aggregation | Notes |
Active Maintenance Plan Count | COUNT WHERE MaintPlanIsLockedAgainstCalls = false | SUM | G-11. |
Active Plans per Equipment | COUNT(Active Plans) grouped by Equipment | SUM | |
% Assets with Active PM Strategy | Assets with >= 1 active plan / Total assets * 100 | CALCULATED | Denominator definition to be agreed. |
% Data Compliance | Compliant Data Records / Total Data Records * 100 | CALCULATED | Objects under evaluation not yet confirmed by business. |
8. Variables (SAC Filters / Prompts)
Variable | Required / Optional | Type | Default | Notes |
Period (Date / Fiscal Period) | Optional | Interval | Last 30 days | Applied using CreationDate, ActualStartDate, or PostingDate depending on AM. |
Functional Location (Asset Hierarchy) | Optional | Hierarchy | No default | FunctionalLocation from I_PMNotifMaintenanceData or I_MaintOrderTechObjCube. |
Equipment | Optional | Multiple single values | No default | Direct equipment filter. |
Maintenance Plant | Optional | Multiple single values | No default | MaintenancePlant across all objects. |
Planner Group | Optional | Multiple single values | No default | Available in 4MA_MOTech and 4MA_MaintOps. Not on PMNotif alone - join required. |
Plant Section | Optional | Multiple single values | No default | PLANTSECTION (BEBER) - I_MaintOrderTechObjCube only. |
Maintenance Order Type | Optional | Multiple single values | No default | Used to split Capex/Opex, planned/unplanned. |
Work Center | Optional | Multiple single values | No default | WorkCenterInternalID in MaintOps and MOTech models. |
Notification Type | Optional | Multiple single values | No default | Available in PMNotif model (e.g. M2 = breakdown). |
9. Gaps Register
Items flagged HIGH priority are blockers for functional sign-off and build.
ID | ERP | Gap / Issue | Description | Status | Priority | Comments |
G-01 | ERP-888 | Asset Replacement Value (ARV) | No standard PM CDS coverage. Options: I_FixedAsset (FI-AA), manual input table, SAC planning model (4MP_ARV). | OPEN | High | |
G-02 | ERP-888 | WBS Planned Cost | No standard PM CDS view exposes WBS planned values. CO/PS extractor or manual table required. Ian to advise on Plan/Actual comparison approach. | OPEN | High | |
G-03 | ERP-888 / ERP-1012 | Total Operating Time | Not stored in SAP PM. Assumption: 365 x 24 hours per asset. Approach to be agreed before build. | OPEN | High | |
G-04 | ERP-1013 | MTBF Definition | MTBF = (Total Operating Time - Planned Downtime) / Count(Malfunction). Planned Downtime and Malfunction Count derivable from existing views. Total Operating Time still blocked — see G-03. | OPEN | High | |
G-05 | ERP-1013 | APM Recommendations | Z_apm_tbd not defined. All APM objects placeholders. Contact: Gokhan Yilmazturk. | BLOCKED | High | |
G-06 | ERP-1092 / ERP-1096 | Work Center Capacity | KAKO/KAZY not in any standard CDS. Backlog (Weeks) and Technician Productivity blocked without this. Total hours worked = hours confirmed on orders (Confirmation CDS view). | OPEN | High | |
G-07 | ERP-1093 | Frozen Schedule Flag | No native SAP PM field for frozen week/day schedule. Custom Z-field or activity type mapping required. | OPEN | Medium | |
G-08 | ERP-1093 | Break-In Work Flag | No native SAP field. Custom MaintenanceActivityType or status required. | OPEN | Medium | |
G-09 | ERP-1096 | Overdue Date Definition | Order Level Overdue confirmed. Overdue Order = Final Confirmation Date - Final Due Date > 3 days. Source: I_MAINTORDERTECHOBJCUBE. | OPEN | Medium | |
G-10 | ERP-1096 | Rework Window | Timeframe (same equipment, same failure within N days) must be agreed with business. | OPEN | Low | |
G-11 | ERP-1098 | PlantSection on MaintenancePlan | PLANTSECTION not on I_MaintenancePlan. Join from I_MaintOrderTechObjCube. Double-count risk — see Section 6.4. | OPEN | Medium | |
G-12 | ERP-1104 | MRO Cross-reference P2F | ERP-1104 uses 4MA_P2FINV_MaterialStock. No new A2D object required. | CROSS-REF | Low | |
G-13 | ERP-1156 | Cross-instance + DAE/ITAR | ERP-1156 cross-instance (ROW + China). DAE/ITAR review mandatory before build. | ITAR | High | |
G-14 | ERP-888 | CAPEX/OPEX Mapping | Z-field on WBS master determines Capex/Opex. Budget at PPM item level (Category field). Mapping table from business required. | OPEN | Medium | |
G-15 | ERP-1013 | ABC Indicator / Asset Category filter | ERP-1013 MTBF and Top 10 KPIs filter by Asset Category and ABC Indicator. ABCIndicator available on Equipment/FLOC master data. Confirm field presence on I_MaintOrderTechObjCube or join via 2VD_Equip required. | OPEN | Medium | |
G-16 | ERP-1013 | Total Operating Time for MTBF | MTBF formula requires Total Operating Time per asset. Not stored in SAP PM. Same blocker as G-03, elevated in priority for MTBF specifically. | OPEN | High | |
G-17 | ERP-1013 | MaintenanceActivityType in cost fact | ERP-1013 requires cost split by MaintenanceActivityType (Preventive/Corrective/Emergency). I_MaintOrderActualCostDataCube does not carry this field directly. Join to 3VR_MOTech via MaintenanceOrder required in 3VF_MaintCosts, or use MaintenanceOrderType as proxy with business-agreed mapping. Approach to be confirmed before build. | OPEN | High | |
G-18 | ERP-1092 | Average Planning Lead Time — WO creation date | Average Planning Lead Time requires the work order creation date to be joined to the notification creation date. Work order creation date field on I_MaintOrderTechObjCube to be confirmed. Join key between notification and resulting work order also to be confirmed. | OPEN | Medium | |
G-19 | ERP-1092 | % Repetitive Work without TL — notification-to-order join | % Repetitive Work without TL requires matching DamageCode and ObjectPartCode from notifications to corrective orders without a task list, on the same equipment. The join key between I_PMNotifMaintenanceData and I_MaintOrderTechObjCube for this pattern to be confirmed. DamageCode and ObjectPartCode already projected in 2VR_PMNotif. | OPEN | Medium | |
G-20 | ERP-1104 | Stock Over Max — MRP max stock level | Stock Over Max KPI requires the MRP maximum stock level per material/SLOC. This is not available in 4MA_P2FINV_MaterialStock or the current P2F harmonisation objects. Source: MM MRP master data. Additional extractor and harmonisation objects required. | OPEN | Medium | |
G-21 | ERP-1104 | Delivery Accuracy — purchasing/delivery CDS | Delivery Accuracy requires comparison of goods receipt date to PO confirmed delivery date. This is not covered by 4MA_P2FINV_MaterialStock. A purchasing or delivery CDS view (e.g. I_PurchaseOrderItemAPI01 or equivalent) is required. Source and object definition TBD. | OPEN | Medium | |
G-22 | ERP-1104 | Cycle Count KPIs — physical inventory CDS | Cycle Count Accuracy and Cycle Count Completion YTD require physical inventory CDS views (e.g. I_PhysicalInventoryDocument or equivalent) not currently in the P2F DDFS objects. Lambertus flagged potential alignment with ERP-436 (Physical Inventories managed by maintenance team). Scope alignment with ERP-436 required before build. | OPEN | Medium |
10. Shared Objects with P2F DDFS
Objects used by ERP-1104 and ERP-1156 are defined in the P2F DDFS (ERP-1041). No new A2D objects are required for these requirements.
Object (Tech Name) | Defined In | Used By (A2D) | Action |
4MA_P2FINV_MaterialStock | P2F DDFS (ERP-1041) | ERP-1104, ERP-1156 | Reuse. Apply MRO SLOC/Plant filter in SAC story for ERP-1104. |
2VR_S4HARM_GoodsMovementDocumentDEX | P2F DDFS (ERP-1041) | ERP-1104, ERP-1156 | Reuse. No new extractor required. |
2VR_S4HARM_I_BatchWhereUsedLevel | P2F DDFS (ERP-1041) | ERP-1104 (batch traceability) | Reuse from P2F ERP-410 delivery. |
3VR_P2FINV_BatchDel (join pattern) | P2F DDFS (ERP-1041) | ERP-1156 (delivery data) | Reuse join pattern. Do not rebuild. |
ERP-1156 note: Cross-instance architecture (ROW S/4 + China S/4) requires DAE/ITAR review and sign-off before any build activity.
11. Effort Estimate and Object Count
System | Component | Count | Estimated Days | Comments |
S/4 CDS | Custom extractors (Z_I_...) | 6 | 6 x 5 = 30 | XE_PMNotif existing. XE_EqBOM new. XE_APMRecom blocked. |
S/4 CDS | VDM wrappers (standard views) | 5 | 5 x 3 = 15 | I_MaintOrderTechObjCube, I_MaintOrderActualCostDataCube, I_MaintOrderOperation_DEX, I_MaintenancePlan, I_EquipmentBomLink. |
DSP | Inbound Layer (TL pairs) | 6 | Included above | One TL per extractor. |
DSP | Harmonisation Layer (VR + VD) | 8 | 8 x 3 = 24 | Standard harmonisation pattern. No complex transforms. |
DSP | Propagation Layer (VR/VF) | 12 | 12 x 5 = 60 | Includes union (DTFact), joins (MaintCosts, MaintOps, MaintPlan, EqBOM), formula views. |
DSP | Analytical Models (4MA/4MP) | 7 + 2 planning | 7 x 5 = 35 | Excludes ERP-1104/1156 (P2F reuse). 4MP_ARV and 4MP_AMMKPI in SPLN space. |
SAC | Dashboards / Stories | 8 x medium | 8 x 10 = 80 | One story per ERP. ERP-888 deferred. |
12. Data Access Controls
Data access control requirements for A2D AMs to be confirmed with the security workstream.
- Plant-level access restriction expected — Maintenance Plant is available as a dimension across all AMs.
- Planner Group restriction may be required for ERP-1092/1093/1096.
- ERP-1156 cross-instance data subject to DAE/ITAR access control review — no design until sign-off.
13. Currency Conversions
- 4MA_A2DAMM_MaintCost: AmountInCompanyCodeCurrency is the base measure. Multi-currency requirements to be confirmed with ERP-888 functional spec.
- All other A2D AMs contain no monetary measures — no currency conversion required.