P_MaintNotifTechObjBreakdown

DDL: P_MAINTNOTIFTECHOBJBREAKDOWN SQL: PMNTOBD Type: view COMPOSITE
44 Fields 1 Data Sources 2 Associations

P_MaintNotifTechObjBreakdown is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MaintenanceNotification) and exposes 44 fields with key field MaintenanceNotification. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceNotification I_MaintenanceNotification from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_EquiFuncnlLocUnionBreakdown _TechnicalObject _TechnicalObject.TechnicalObject = $projection.TechnicalObject and _TechnicalObject.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc
[0..1] I_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PMNTOBD view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification I_MaintenanceNotification MaintenanceNotification Notification
NotificationText I_MaintenanceNotification NotificationText Description
FunctionalLocation
Equipment
MaintenanceOrder I_MaintenanceNotification MaintenanceOrder Order
MaintPriority I_MaintenanceNotification MaintPriority Priority
MaintPriorityType I_MaintenanceNotification MaintPriorityType PriorityType
NotifProcessingPhase I_MaintenanceNotification NotifProcessingPhase Notif. Phase
NotificationType I_MaintenanceNotification NotificationType Notifictn Type
MaintenanceWorkCenterPlant I_MaintenanceNotification MaintenanceWorkCenterPlant Work Ctr Plant
WorkCenterInternalID I_MaintenanceNotification WorkCenterInternalID Work Center
WorkCenterTypeCode I_MaintenanceNotification WorkCenterTypeCode Object Type
MaintenancePlant
MalfunctionStartDate
MalfunctionStartTime
MalfunctionEndDate
MalfunctionEndTime
MaintenanceObjectIsDown
MaintObjectDowntimeDuration
MaintObjDowntimeDurationUnit
NotificationCreationDate I_MaintenanceNotification NotificationCreationDate Notif. Date
NotificationCreationTime I_MaintenanceNotification NotificationCreationTime Notif. Time
NotificationReferenceDate I_MaintenanceNotification NotificationReferenceDate Reference Date
NotificationReferenceTime I_MaintenanceNotification NotificationReferenceTime ReferenceTime
NotificationCompletionDate I_MaintenanceNotification NotificationCompletionDate Completion Date
CompletionTime I_MaintenanceNotification NotificationCompletionTime Completion Time
CreationDate I_MaintenanceNotification CreationDate Time Stamp
CreationTime I_MaintenanceNotification CreationTime Time of Change
NotificationTimeZone I_MaintenanceNotification NotificationTimeZone Notif.Time.Zone
IsDeleted I_MaintenanceNotification IsDeleted TRUE
OperationStartDateTime
_FunctionalLocation
_Equipment
_TechnicalObject _TechnicalObject
_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc
_IsDeleted I_MaintenanceNotification _IsDeleted
_MaintenanceOrder I_MaintenanceNotification _MaintenanceOrder
_PMNotifMaintenanceData I_MaintenanceNotification _PMNotifMaintenanceData
_PMNotificationPriority I_MaintenanceNotification _PMNotificationPriority
_PMNotificationPriorityType I_MaintenanceNotification _PMNotificationPriorityType
_MainWorkCenter I_MaintenanceNotification _MainWorkCenter
_WorkCenterType I_MaintenanceNotification _WorkCenterType
_PMNotificationPhase I_MaintenanceNotification _PMNotificationPhase
_MaintenanceWorkCenterPlant I_MaintenanceNotification _MaintenanceWorkCenterPlant

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_MaintNotifTechObjBreakdown.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PMNTOBD

CREATE VIEW P_MaintNotifTechObjBreakdown AS
SELECT
  I_MaintenanceNotification.MaintenanceNotification AS MaintenanceNotification,
  I_MaintenanceNotification.NotificationText AS NotificationText,
  I_MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  I_MaintenanceNotification._PMNotifMaintenanceData.Equipment AS Equipment,
  I_MaintenanceNotification.MaintenanceOrder AS MaintenanceOrder,
  I_MaintenanceNotification.MaintPriority AS MaintPriority,
  I_MaintenanceNotification.MaintPriorityType AS MaintPriorityType,
  I_MaintenanceNotification.NotifProcessingPhase AS NotifProcessingPhase,
  I_MaintenanceNotification.NotificationType AS NotificationType,
  I_MaintenanceNotification.MaintenanceWorkCenterPlant AS MaintenanceWorkCenterPlant,
  I_MaintenanceNotification.WorkCenterInternalID AS WorkCenterInternalID,
  I_MaintenanceNotification.WorkCenterTypeCode AS WorkCenterTypeCode,
  I_MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  I_MaintenanceNotification._PMNotifMaintenanceData.MalfunctionStartDate AS MalfunctionStartDate,
  I_MaintenanceNotification._PMNotifMaintenanceData.MalfunctionStartTime AS MalfunctionStartTime,
  I_MaintenanceNotification._PMNotifMaintenanceData.MalfunctionEndDate AS MalfunctionEndDate,
  I_MaintenanceNotification._PMNotifMaintenanceData.MalfunctionEndTime AS MalfunctionEndTime,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintenanceObjectIsDown AS MaintenanceObjectIsDown,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintObjectDowntimeDuration AS MaintObjectDowntimeDuration,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintObjDowntimeDurationUnit AS MaintObjDowntimeDurationUnit,
  I_MaintenanceNotification.NotificationCreationDate AS NotificationCreationDate,
  I_MaintenanceNotification.NotificationCreationTime AS NotificationCreationTime,
  I_MaintenanceNotification.NotificationReferenceDate AS NotificationReferenceDate,
  I_MaintenanceNotification.NotificationReferenceTime AS NotificationReferenceTime,
  I_MaintenanceNotification.NotificationCompletionDate AS NotificationCompletionDate,
  I_MaintenanceNotification.NotificationCompletionTime AS CompletionTime,
  I_MaintenanceNotification.CreationDate AS CreationDate,
  I_MaintenanceNotification.CreationTime AS CreationTime,
  I_MaintenanceNotification.NotificationTimeZone AS NotificationTimeZone,
  I_MaintenanceNotification.IsDeleted AS IsDeleted,
  cast(0 as timestamp) AS OperationStartDateTime,
  I_MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment._FunctionalLocation AS _FunctionalLocation,
  I_MaintenanceNotification._PMNotifMaintenanceData._Equipment AS _Equipment,
  I_MaintenanceNotification._IsDeleted AS _IsDeleted,
  I_MaintenanceNotification._MaintenanceOrder AS _MaintenanceOrder,
  I_MaintenanceNotification._PMNotifMaintenanceData AS _PMNotifMaintenanceData,
  I_MaintenanceNotification._PMNotificationPriority AS _PMNotificationPriority,
  I_MaintenanceNotification._PMNotificationPriorityType AS _PMNotificationPriorityType,
  I_MaintenanceNotification._MainWorkCenter AS _MainWorkCenter,
  I_MaintenanceNotification._WorkCenterType AS _WorkCenterType,
  I_MaintenanceNotification._PMNotificationPhase AS _PMNotificationPhase,
  I_MaintenanceNotification._MaintenanceWorkCenterPlant AS _MaintenanceWorkCenterPlant
FROM I_MaintenanceNotification
LEFT OUTER JOIN P_EquiFuncnlLocUnionBreakdown AS _TechnicalObject ON _TechnicalObject.TechnicalObject = TechnicalObject AND _TechnicalObject.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
;

Learn More