Document Links

ERP-1043 - Getting issue details... STATUS

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
• 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 
• ERP-1156 – Cross-Instance Material Visibility – MRO Spares

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.

Data Flow Diagram

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.

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

Harmonisation Layer

2TL_S4HARM_I_PMNotifMaintenanceData (2TL_PMNotif)

Type: TL — Table / Load object

Source: 1TL_S4Hx_SYQ_I_PMNOTIFMAINTENANCEDATA (1TXL_PMNotif)

Purpose: Delta load of PM notification maintenance data. Sets composite key.

Keys:

• MaintenanceNotification
• NotificationItem

Supports: ERP-1012, ERP-1013, ERP-1092, ERP-1096

2TF_S4HARM_I_PMNotifMaintenanceData

Type: TF — Transformation Flow

Source: 1TL_S4Hx_SYQ_I_PMNOTIFMAINTENANCEDATA (1TXL_PMNotif)

Purpose: No transformations. Pass-through only.

2VR_S4HARM_I_PMNotifMaintenanceData (2VR_PMNotif)

Type: VR — Harmonisation View

Source: 2TL_S4HARM_SYQ_I_PMNOTIFMAINTENANCEDATA

Purpose: View on harmonised PM notification maintenance data. Interface object for Propagation Layer.

Filter: MaintenanceNotification IS NOT NULL

Projection:

• MaintenanceNotification
• NotificationItem
• Equipment
• FunctionalLocation
• RelevantFunctionalLocation
• MaintenancePlant
• MaintenancePlannerGroup
• MaintenanceActivityType
• NotificationType
• MaintPriority
• MaintenanceObjectIsDown
• MaintObjectDowntimeDuration
• MaintObjDowntimeDurationUnit
• MalfunctionStartDate
• MalfunctionStartTime
• MalfunctionEndDate
• MalfunctionEndTime
• CreationDate
• CreationTime
• AvailyBeforeMalfunctionPercent
• AvailyAfterMalfunctionPercent
• AvailyAfterConclusionPercent
• SystConditionBeforeMalfunction
• SystConditionAfterMalfunction
• SystConditionAfterCompletion
• CompanyCode
• (amber) DamageCode — new for ERP-1013 failure reason analysis
• (amber) ObjectPartCode — new for ERP-1013
• (amber) CauseCode — new for ERP-1013
• (amber) ABCIndicator — confirmed on I_MaintOrderTechObjCube; join to 2VR_MOTech on MaintenanceNotification key required for PMNotif-based filters (G-15)

Formula / Aggregation: None — harmonisation only

Notes: DamageCode, ObjectPartCode, CauseCode added for ERP-1013. ABCIndicator join pattern documented in G-15.

2TL_S4HARM_I_MaintOrderTechObCube (2TL_MOTech)

Type: TL — Table / Load object

Source: 1TL_S4Hx_I_MAINTORDERACTUALCOSTCUBE (1TXL_MOTech)

Purpose: Delta load of maintenance order / technical object data. Sets composite key.

Keys:

• MaintenanceOrder

Supports: ERP-1012, ERP-1092, ERP-1093, ERP-1096, ERP-1098

2TF_S4HARM_I_MaintOrderTechObCube

Type: TF — Transformation Flow

Source: 1TL_S4Hx_MAINTORDERACTUALCOSTCUBE (1TXL_MOTech)

Purpose: No transformations. Pass-through only.

2VR_S4HARM_I_MaintOrderTechObCube (2VR_MOTech)

Type: VR — Harmonisation View

Source: 2TL_S4HARM_I_MaintOrderTechObCube

Purpose: View on harmonised maintenance order / technical object data. Interface object for Propagation Layer.

Filter: MaintenanceOrder IS NOT NULL AND MaintenanceOrder <> ''

Projection:

• MaintenanceOrder
• Equipment
• FunctionalLocation
• MaintenancePlant
• MaintenancePlannerGroup
• PlantSection
• MainWorkCenter
• WorkCenterInternalID
• MaintenanceOrderType
• MaintenanceActivityType
• MaintenancePlan
• TaskListGroup
• TaskListGroupCounter
• TaskListType
• OrderUserStatus
• ScheduledBasicStartDate
• ScheduledBasicStartTime
• ScheduledBasicEndDate
• ScheduledBasicEndTime
• ScheduledBasicStartDateTime
• ScheduledBasicEndDateTime
• ActualStartDate
• ConfirmedEndDate
• CompanyCode
• WBSElementInternalID

Formula / Aggregation: None — harmonisation only

2TL_S4HARM_I_MaintOrderActualCostCube (2TL_CostCube)

Type: TL — Table / Load object

Source: 1TL_S4Hx_I_MAINTORDERACTUALCOSTCUBE (1TXL_CostCube)

Purpose: Delta load of maintenance order actual cost postings. Sets composite key.

Keys:

• MaintenanceOrder
• AccountingDocument
• FiscalYear
• AccountingDocumentItem

Supports: ERP-888, ERP-1013

2TF_S4HARM_I_MaintOrderActualCostCube

Type: TF — Transformation Flow

Source: 1TL_S4Hx_I_MAINTORDERACTUALCOSTCUBE (1TXL_CostCube)

Purpose: No transformations. Pass-through only.

2VR_S4HARM_I_MaintOrderActualCostCube (2VR_CostCube)

Type: VR — Harmonisation View

Source: 2TL_S4HARM_I_MaintOrderActualCostCube

Purpose: View on harmonised maintenance order actual cost data.

Filter: MaintenanceOrder IS NOT NULL AND MaintenanceOrder <> ''

Projection:

• MaintenanceOrder
• AccountingDocument
• FiscalYear
• AccountingDocumentItem
• CompanyCode
• CompanyCodeCurrency
• AmountInCompanyCodeCurrency
• GlobalCurrency
• AmountInGlobalCurrency
• TransactionCurrency
• AmountInTransactionCurrency
• GLAccount
• CostElementGroup
• MaintenanceOrderType
• MaintenanceActivityType
• MaintenanceOrderIsPlanned
• Plant
• PlantSection
• Equipment
• FunctionalLocation
• MaintenancePlant
• MaintenancePlannerGroup
• MainWorkCenterInternalID
• MaintOrdMainWorkCenter
• MaintOrdMainWorkCenterPlant
• CostCenter
• ControllingArea
• PostingDate
• PostingMonth
• FiscalPeriod

Formula / Aggregation: None — harmonisation only

Notes: WBSElementInternalID is NOT on I_MaintOrderActualCostDataCube — removed from this projection. ActivityType confirmed present directly on cost cube; no join to MOTech required for cost type split.

2TL_S4HARM_I_MaintOrderOperation (2TL_MaintOps)

Type: TL — Table / Load object

Source: 1TL_S4Hx_I_MAINTORDEROPERATION (1TXL_MaintOps)

Purpose: Delta load of maintenance order operation records. Sets composite key.

Keys:

• MaintenanceOrder
• MaintenanceOrderOperation

Supports: ERP-1092, ERP-1093, ERP-1096

2TF_S4HARM_I_MaintOrderOperation

Type: TF — Transformation Flow

Source: 1TL_S4Hx_I_MAINTORDEROPERATION (1TXL_MaintOps)

Purpose: No transformations. Pass-through only.

2VR_S4HARM_I_MaintOrderOperation (2VR_MaintOps)

Type: VR — Harmonisation View

Source: 2TL_S4HARM_I_MaintOrderOperation

Purpose: View on harmonised maintenance order operation data.

Filter: MaintenanceOrder IS NOT NULL AND MaintenanceOrderOperation IS NOT NULL

Projection:

• MaintenanceOrder
• MaintenanceOrderOperation
• Plant
• WorkCenter
• WorkCenterPlant
• WorkCenterInternalID
• MaintenancePlannerGroup
• MaintenanceOrderType
• MaintenanceActivityType
• OperationPlannedWork
• OperationPlannedWorkUnit
• ConfirmationTotalQuantity
• ConfirmationTotalQuantityUnit
• MaintOrdOperationWorkDuration
• OplTStSchedldExecEndDte
• LatestAcceptableCompletionDate
• MaintOrdProcessPhaseCode
• ConfirmedEndDate
• ConfirmedEndTime
• Equipment
• FunctionalLocation
• MaintOrdMainWorkCenter
• MaintOrdMainWorkCenterPlant

Formula / Aggregation: None — harmonisation only

2TL_S4HARM_I_EquipmentBomLink (2TL_EqBOM)

Type: TL — Table / Load object

Source: 1TL_S4Hx_SYQ_I_EQUIPMENTBOMLINK (1TXL_EqBOM)

Purpose: Delta load of equipment BOM link data. Sets composite key.

Keys:

• Equipment
• BillOfMaterial
• BillOfMaterialCategory
• BillOfMaterialVariant

Supports: ERP-1098

2TF_S4HARM_I_EquipmentBomLink

Type: TF — Transformation Flow

Source: 1TL_S4Hx_SYQ_I_EQUIPMENTBOMLINK (1TXL_EqBOM)

Purpose: No transformations. Pass-through only.

2VR_S4HARM_I_EquipmentBomLink (2VR_EqBOM)

Type: VR — Harmonisation View

Source: 2TL_S4HARM_I_EquipmentBomLink

Purpose: View on harmonised equipment BOM link data.

Filter: Equipment IS NOT NULL AND Equipment <> ''

Projection:

• Equipment
• BillOfMaterial
• BillOfMaterialCategory
• BillOfMaterialVariant
• BillOfMaterialVariantUsage
• Plant

2VD_S4HARM_Equipment (2VD_Equip)

Type: VD — Dimension View

Source: I_Equipment (standard VDM — no TL/TF required)

Purpose: Equipment master data dimension. Provides Equipment description, object type, plant, and manufacturer for lookups across Analytical Models.

Projection: All standard fields from I_Equipment required by AM dimension usage.

Notes: No Replication Flow required. Sourced directly from standard VDM view.

2TL_S4HARM_I_MaintenancePlan (2TL_MaintPlan)

Type: TL — Table / Load object

Source: 1TL_S4Hx_I_MAINTENANCEPLAN (1TXL_MaintPlan)

Purpose: Delta load of maintenance plan data (MPLA / T399W). Sets key.

Keys:

• MaintenancePlan

Supports: ERP-1098 — Active Preventive Maintenance Strategy KPI

2TF_S4HARM_I_MaintenancePlan

Type: TF — Transformation Flow

Source: 1TL_S4Hx_I_MAINTENANCEPLAN (1TXL_MaintPlan)

Purpose: No transformations. Pass-through only.

2VR_S4HARM_I_MaintenancePlan (2VR_MaintPlan)

Type: VR — Harmonisation View

Source: 2TL_S4HARM_I_MaintenancePlan

Purpose: View on harmonised maintenance plan data.

Filter: MaintenancePlan IS NOT NULL AND MaintenancePlan <> ''

Projection:

• MaintenancePlan
• MaintenancePlanDesc
• MaintenanceStrategy
• MaintenancePlanCategory
• FunctionalLocation
• Equipment
• SchedulingStartDate
• SchedulingStartTime
• SchedulingEndDate
• MaintPlanIsLockedAgainstCalls
• CallHorizonInDays
• SchedulingDuration
• SchedulingDurationUnit
• Plant
• AuthorizationGroup

Formula / Aggregation: None — harmonisation only

Notes: PlantSection (BEBER) and MaintenancePlannerGroup (INGRP) are NOT on I_MaintenancePlan. These are resolved by join to 2VR_MOTech in the Propagation Layer (3VF_A2DAMM_MaintenancePlan) — see Section 6.7.

2TL_S4HARM_I_WorkCenterCapacity (2TL_WCCap)

Type:    TL — Table / Load object

Source:  1TL_S4Hx_I_WORKCENTERCAPACITY (1TXL_WCCap)

Purpose: Delta load of Work Center Capacity definition records. Sets composite key. Filled by 2TF_S4HARM_I_WorkCenterCapacity.

Keys:

    WorkCenterInternalID

    CapacityInternalID

    ValidityStartDate

Supports: ERP-1092, ERP-1093, ERP-1096

2TF_S4HARM_I_WorkCenterCapacity

Type:    TF — Transformation Flow

Source:  1TL_S4Hx_I_WORKCENTERCAPACITY (1TXL_WCCap)

Purpose: No transformations. Pass-through only.

2VR_S4HARM_I_WorkCenterCapacity (2VR_WCCap)

Type:    VR — Harmonisation View

Source:  2TL_S4HARM_I_WorkCenterCapacity

Purpose: View on harmonised Work Center Capacity definition data. Interface object for Propagation Layer. Provides capacity quantity and formula fields used to derive available hours per Work Center per period.

Filter:  WorkCenterInternalID IS NOT NULL AND ValidityStartDate <= current_date AND ValidityEndDate >= current_date

Projection:

WorkCenter

WorkCenterInternalID

WorkCenterTypeCode

WorkCenterCategoryCode

Plant

Capacity

CapacityInternalID

CapacityQuantityUnit

CapacityCategoryCode

CapacityCategoryAllocation

ProcgCapRequirementFormula

SetupCapRequirementFormula

TeardownCapRequirementFormula

OtherCapRequirementFormula

ValidityStartDate

ValidityEndDate

Formula / Aggregation:  None — harmonisation only.

Notes:  All 20 fields on I_WorkCenterCapacity are dimension-type. Capacity available hours are derived at Propagation Layer by applying the formula fields against shift/calendar data. WorkCenterInternalID is the join key to 2VR_MaintOps and 2VR_MOTech.

Note: The following two objects have been removed as the related KPIs have been deleted from ERP-1013.

2VR_S4HARM_xxxxxx (2VR_Recom) — BLOCKED

Type: VR — Harmonisation View

Source: 2TL_S4HARM_xxxxxx

Purpose: BLOCKED. APM recommendation view. Filter, projection and formula TBD.

Filter: BLOCKED

Projection: BLOCKED

Formula / Aggregation: BLOCKED

Notes: G-05.

2TL_S4HARM_xxxxxx (2TL_Recom) — BLOCKED

Type: TL — Table / Load object

Source: 1TXL_Recom (SSAL_APM) — Z_apm_tbd

Purpose: BLOCKED. APM recommendation data load. Object names and source TBD pending APM integration analysis.

Notes: G-05. Contact: Gokhan Yilmazturk.

WBS / Planned Cost (Placeholder)

Type: PLACEHOLDER

Source: CO / PS — source TBD

Purpose: WBS planned cost input for ERP-888 budget comparison KPI. No standard SAP PM CDS view exposes WBS planned values.

Filter: TBD

Projection: TBD

Formula / Aggregation: TBD

Notes: G-02. Source options: CO/PS extractor, SAC planning model (4MP_ARV), or manual input table.

Propagation Layer

3VR_A2DAMM_PMNotif (3VR_PMNotif)

Type: VR — Projection View

Source: 2VR_PMNotif

Purpose: Projects notification grain for downstream consumption. One row per notification. Includes breakdown flags, downtime duration, malfunction dates, priority, DamageCode, ObjectPartCode, and CauseCode.

Filter: None additional — inherits from 2VR_PMNotif

Projection: All fields from 2VR_PMNotif

Formula / Aggregation: None

Supports: ERP-1012, ERP-1013, ERP-1092, ERP-1096

3VR_A2DAMM_MOTech (3VR_MOTech)

Type: VR — Projection View

Source: 2VR_MOTech

Purpose: Projects order-centric grain. Includes scheduled dates, planner group, plant section, task list, order type, and MaintenanceActivityType.

Filter: None additional — inherits from 2VR_MOTech

Projection: All fields from 2VR_MOTech

Formula / Aggregation: None

Supports: ERP-1012, ERP-1013, ERP-1092, ERP-1093, ERP-1096, ERP-1098

3VR_A2DAMM_UnplannedDowntime (3VR_UnplanDT)

Type: VR — Projection / Calculation View

Source: 2VR_PMNotif

Purpose: Unplanned downtime projection. Filters notifications flagged as breakdown and derives downtime in hours.

Filter: MaintenanceObjectIsDown = 'X'

Projection: Equipment, FunctionalLocation, MaintenancePlant, PlannerGroup, StartDateTime, EndDateTime, DowntimeHours, PlannedVsUnplanned, SourceType

Formula / Aggregation:

• PlannedVsUnplanned = 'UNPLANNED'
• SourceType = 'NOTIF'
• DowntimeHours = MaintObjectDowntimeDuration / 3600
• StartDateTime = MalfunctionStartDate + MalfunctionStartTime
• EndDateTime = MalfunctionEndDate + MalfunctionEndTime
• FunctionalLocation sourced from RelevantFunctionalLocation

Notes: Input to union in 3VF_DTFact.

3VR_A2DAMM_PlannedDowntime (3VR_PlanDT)

Type: VR — Projection / Calculation View

Source: 2VR_MOTech

Purpose: Planned downtime projection. Derives downtime window from scheduled order dates.

Filter: MaintenanceOrderType IN planned types

Projection: Equipment, FunctionalLocation, MaintenancePlant, PlannerGroup, StartDateTime, EndDateTime, DowntimeHours, PlannedVsUnplanned, SourceType

Formula / Aggregation:

• PlannedVsUnplanned = 'PLANNED'
• SourceType = 'ORDER'
• DowntimeHours = (ScheduledBasicEndDateTime - ScheduledBasicStartDateTime) / 3600

Notes: Input to union in 3VF_DTFact.

3VF_A2DAMM_DowntimeFact (3VF_DTFact)

Type: VF — Union / Calculation View

Source: UNION: 3VR_UnplanDT + 3VR_PlanDT

Purpose: Unified downtime fact combining planned and unplanned downtime. No pre-aggregation — grain retained at event level.

Filter: None

Projection: Common union schema: Equipment, FunctionalLocation, MaintenancePlant, PlannerGroup, StartDateTime, EndDateTime, DowntimeHours, PlannedVsUnplanned, SourceType

Formula / Aggregation: Union — accept default union field mappings. No additional derivations.

Supports: ERP-1012

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.

3VF_A2DAMM_PMNotifFact (3VF_PMNotif)

Type: VF — Calculation View

Source: 3VR_PMNotif

Purpose: Formula view on notification data. Adds derived binary and count measures for notification-level KPIs.

Filter: None

Projection: All fields from 3VR_PMNotif plus derived measures below

Formula / Aggregation:

• 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

3VF_A2DAMM_MaintOrderTechFact (3VF_MOTech)

Type: VF — Calculation View

Source: 3VR_MOTech

Purpose: Formula view on order data. Adds derived flags for planning and task list usage.

Filter: None

Projection: All fields from 3VR_MOTech plus derived measures below

Formula / Aggregation:

• TaskListUsageFlag = CASE WHEN TaskListGroup IS NOT NULL THEN 'X' ELSE '' END
• PlannedWindowSeconds = ScheduledBasicEndDateTime - ScheduledBasicStartDateTime
• OrderCount = 1

Supports: ERP-1012, ERP-1092, ERP-1098

3VR_A2DAMM_MaintOrderActualCostCube (3VR_CostCube)

Type: VR — Projection View

Source: 2VR_CostCube

Purpose: Cost data projection for consumption by 3VF_MaintCosts. Applies company code filter.

Filter: CompanyCode IS NOT NULL

Projection: All fields from 2VR_CostCube

Formula / Aggregation: None

Supports: ERP-888, ERP-1013

3VR_A2DAMM_AssetReplacementValue (3VR_ARV) — GAP

Type: VR — Placeholder

Source: TBD — G-01

Purpose: Asset Replacement Value derivation for ERP-888 Asset Economical Viability KPI.

Filter: TBD

Projection: TBD

Formula / Aggregation: TBD

Notes: G-01. ARV source options: I_FixedAsset (FI-AA), manual input table, or SAC planning model (4MP_ARV). Blocked until source confirmed.

3VF_A2DAMM_MaintenanceCost (3VF_MaintCosts) — PARKED

Type: VF — Join / Calculation View

Source: JOIN: 3VR_CostCube + 3VR_ARV + WBS Planned Cost Placeholder

Purpose: Join of cost actuals, Asset Replacement Value, and WBS planned cost. MaintenanceActivityType available directly on 3VR_CostCube — no additional join to MOTech required for activity type split.

Filter: TBD

Projection: Cost fields, ARV, WBS planned cost

Join: Join key: MaintenanceOrder / Equipment

Formula / Aggregation: Cost type split by MaintenanceActivityType (confirmed on I_MaintOrderActualCostDataCube directly).

Notes: PARKED pending ERP-888 go/no-go and resolution of G-01 (ARV) and G-02 (WBS Planned Cost).

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.

3VR_A2DAMM_MaintOrderOperation (3VR_MaintOps)

Type: VR — Projection View

Source: 2VR_MaintOps

Purpose: Operation-grain projection for consumption by 3VF_MaintOps.

Filter: MaintenanceOrder IS NOT NULL

Projection: All fields from 2VR_MaintOps

Formula / Aggregation: None

3VF_A2DAMM_MaintOrderOperation (3VF_MaintOps)

Type:    VF — Join / Calculation View

Source:  JOIN: 3VR_MaintOps + 3VR_MOTech + 3VR_WCCap

Purpose: Formula view. Joins operation-grain data to order header (PlannerGroup, PlantSection) and Work Center Capacity definition (available capacity hours). Adds overdue, rework, task list, and capacity-derived flags.

Filter:  None

Projection:  All 3VR_MaintOps fields + PlannerGroup, PlantSection, TaskListGroup from MOTech + capacity fields from WCCap

Joins:

    3VR_MaintOps.MaintenanceOrder = 3VR_MOTech.MaintenanceOrder

    3VR_MaintOps.WorkCenterInternalID = 3VR_WCCap.WorkCenterInternalID

    (LEFT JOIN — operations without a matched capacity record are retained)

Formula / Aggregation:

    OverdueFlag = CASE WHEN OplTStSchedldExecEndDte < current_date AND order status is open THEN 'X' ELSE '' END

    ReworkFlag = CASE WHEN MaintenanceActivityType = 'M08' THEN 'X' ELSE '' END

    TaskListUsageFlag = CASE WHEN TaskListGroup IS NOT NULL THEN 'X' ELSE '' END

    WorkCenterCapacityUnit = CapacityQuantityUnit from 3VR_WCCap

    WorkCenterCapacityFormula = ProcgCapRequirementFormula from 3VR_WCCap

    Note: Available capacity hours per period are calculated in SAC as a post-aggregation measure using the capacity formula fields and shift schedule — not pre-calculated in DSP.

Supports:  ERP-1092, ERP-1093, ERP-1096

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-17.

3VR_A2DAMM_EquipmentBomLink (3VR_EqBOM)

Type: VR — Projection View

Source: 2VR_EqBOM

Purpose: Equipment BOM link projection for consumption by 3VF_EqBOM.

Filter: None additional

Projection: All fields from 2VR_EqBOM

Formula / Aggregation: None

3VF_A2DAMM_EquipmentBomLink (3VF_EqBOM)

Type: VF — Join View

Source: JOIN: 3VR_EqBOM + 3VR_MOTech

Purpose: Enriches Equipment BOM link data with order and technical object attributes from MOTech.

Filter: None

Projection: All 3VR_EqBOM fields + Equipment attributes, FunctionalLocation, MaintenancePlant from MOTech

Join: 3VR_EqBOM.Equipment = 3VR_MOTech.Equipment

Formula / Aggregation: None — join only

Supports: ERP-1098

3VR_A2DAMM_MaintenancePlan (3VR_MaintPlan)

Type: VR — Projection View

Source: 2VR_MaintPlan

Purpose: Maintenance plan projection. Filters to active plans only.

Filter: MaintPlanIsLockedAgainstCalls = false

Projection: All fields from 2VR_MaintPlan

Formula / Aggregation: None

3VF_A2DAMM_MaintenancePlan (3VF_MaintPlan)

Type: VF — Join / Deduplication View

Source: JOIN: 3VR_MaintPlan + 3VR_MOTech

Purpose: Joins maintenance plan to order data to resolve PlantSection and PlannerGroup, which are not available on I_MaintenancePlan directly.

Filter: MaintPlanIsLockedAgainstCalls = false (inherited from 3VR_MaintPlan)

Projection: All 3VR_MaintPlan fields + PlantSection, MaintenancePlannerGroup from MOTech side

Join: 3VR_MaintPlan.MaintenancePlan = 3VR_MOTech.MaintenancePlan

Formula / Aggregation:

• DEDUPLICATE on MaintenancePlan grain after join — avoids order-level double counting
• PlantSection and PlannerGroup resolved from MOTech side of join

Notes: G-11 — PlantSection and PlannerGroup not on I_MaintenancePlan.

Supports: ERP-1098

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.

3VR_A2DAMM_WorkCenterCapacity (3VR_WCCap) 

Type:    VR — Projection View

Source:  2VR_WCCap

Purpose: Work Center Capacity projection for downstream join. Provides capacity formula and unit fields used to calculate available hours per Work Center per period.

Filter:  Inherits validity date filter from 2VR_WCCap

Projection:  All fields from 2VR_WCCap

Formula / Aggregation:  None

Supports:  ERP-1092, ERP-1093, ERP-1096

3VR_A2DAMM_xxxxxx (3VR_Recom) — BLOCKED

Type: VR — Placeholder

Source: 2VR_Recom (APM)

Purpose: APM recommendation propagation. Definition TBD.

Filter: BLOCKED

Projection: BLOCKED

Formula / Aggregation: BLOCKED

Notes: G-05. All APM objects are placeholders pending APM integration analysis.

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.

4MA_A2DAMM_MaintCost

Source: 3VF_A2DAMM_MaintenanceCost (3VF_MaintCosts). Supports: ERP-888 (PARKED), ERP-1013.

Status: PARKED pending ERP-888 go/no-go decision. ERP-1013 cost KPIs (Top 10 Bad Actors, Reactive vs Proactive cost split) will be delivered from this AM once unparked. MaintenanceActivityType is confirmed available directly on I_MaintOrderActualCostDataCube — no join to MOTech required for activity type split. G-01 (ARV source) and G-02 (WBS Planned Cost / budget source) must be resolved before build.

4MA_A2DAMM_PMNotif - Calculated Measures

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.

4MA_A2DAMM_MaintOps - Calculated Measures

No RESOURCEWORKCENTER field on I_MAINTORDEROPERATION_DEX; other WorkCenter fields available. Planning is at FieldGrp level.

4MA_A2DAMM_MaintPlan - Calculated Measures

Objects under evaluation for both Data Compliance and Active Preventive Maintenance Strategy not yet confirmed by business.

Variables (SAC Filters / Prompts)

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.

ERP-1156 note: Cross-instance architecture (ROW S/4 + China S/4) requires DAE/ITAR review and sign-off before any build activity.

Effort Estimate and Object Count

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.

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.

Appendix

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.

Gaps Register

Items flagged HIGH priority are blockers for functional sign-off and build.

apps-fileview.texmex_20260329.08_p2 h1Document Linksh1.txt Displaying h1Document Linksh1.txt.