I_MaintenanceNotificationTP_3

DDL: I_MAINTENANCENOTIFICATIONTP_3 Type: view_entity TRANSACTIONAL
128 Fields 1 Data Sources

Maintenance Notification - TP

I_MaintenanceNotificationTP_3 is a Transactional CDS View that provides data about "Maintenance Notification - TP" in SAP S/4HANA. It reads from 1 data source (R_MaintenanceNotificationTP) and exposes 128 fields with key field MaintenanceNotification.

Data Sources (1)

SourceAliasJoin Type
R_MaintenanceNotificationTP R_MaintenanceNotificationTP projection

Annotations (15)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Maintenance Notification - TP view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix NTF view
AbapCatalog.extensibility.quota.maximumFields 250 view
AbapCatalog.extensibility.quota.maximumBytes 5000 view
ObjectModel.sapObjectNodeType.name MaintenanceNotification view

Fields (128)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification MaintenanceNotif MaintenanceNotification Notification
MaintNotifInternalID MaintenanceNotif MaintNotifInternalID Object number
NotificationText MaintenanceNotif NotificationText Description
MaintPriority MaintenanceNotif MaintPriority Priority
MaintPriorityType MaintenanceNotif MaintPriorityType PriorityType
NotificationType MaintenanceNotif NotificationType Notifictn Type
NotifProcessingPhase MaintenanceNotif NotifProcessingPhase Notif. Phase
CreatedByUser MaintenanceNotif CreatedByUser User Name
LastChangedByUser MaintenanceNotif LastChangedByUser User Name
CreationDate MaintenanceNotif CreationDate Time Stamp
LastChangeTime MaintenanceNotif LastChangeTime Time changed
LastChangeDate MaintenanceNotif LastChangeDate Time Stamp
LastChangeDateTime MaintenanceNotif LastChangeDateTime Timestamp
CreationTime MaintenanceNotif CreationTime Time of Change
CreationDateTime MaintenanceNotif CreationDateTime Timestamp
ReportedByUser MaintenanceNotif ReportedByUser Reported By
ReporterFullName MaintenanceNotif ReporterFullName Full Name
PersonResponsible MaintenanceNotif PersonResponsible Person Responsible
MalfunctionEffect MaintenanceNotif MalfunctionEffect Effect
MalfunctionStartDate MaintenanceNotif MalfunctionStartDate Malfunct. Start
MalfunctionStartTime MaintenanceNotif MalfunctionStartTime Mal. Start (T.)
MalfunctionStartDateTime MaintenanceNotif MalfunctionStartDateTime Time Stamp
MalfunctionEndDate MaintenanceNotif MalfunctionEndDate Malfunct. End
MalfunctionEndTime MaintenanceNotif MalfunctionEndTime Malfunction End
MalfunctionEndDateTime MaintenanceNotif MalfunctionEndDateTime Time Stamp
MaintNotificationCatalog MaintenanceNotif MaintNotificationCatalog Catalog Type
MaintNotificationCode MaintenanceNotif MaintNotificationCode Coding
MaintNotificationCodeGroup MaintenanceNotif MaintNotificationCodeGroup Code Group
CatalogProfile MaintenanceNotif CatalogProfile Catalog Profile
NotificationCreationDate MaintenanceNotif NotificationCreationDate Notif. Date
NotificationCreationTime MaintenanceNotif NotificationCreationTime Notif. Time
NotificationCreationDateTime MaintenanceNotif NotificationCreationDateTime Time Stamp
NotificationTimeZone MaintenanceNotif NotificationTimeZone Notif.Time.Zone
RequiredStartDate MaintenanceNotif RequiredStartDate Req. Start Date
RequiredStartTime MaintenanceNotif RequiredStartTime Req. start time
MaintNotifRqdStartDateTime MaintenanceNotif MaintNotifRqdStartDateTime Time Stamp
RequiredEndDate MaintenanceNotif RequiredEndDate Req. End Date
RequiredEndTime MaintenanceNotif RequiredEndTime Req. end time
MaintNotifRqdEndDateTime MaintenanceNotif MaintNotifRqdEndDateTime Time Stamp
LatestAcceptableCompletionDate MaintenanceNotif LatestAcceptableCompletionDate Final Due Date
MaintenanceObjectIsDown MaintenanceNotif MaintenanceObjectIsDown Breakdown
TextObjectCategory MaintenanceNotif TextObjectCategory Text object
TextObjectType MaintenanceNotif TextObjectType Text ID
TechnicalObject MaintenanceNotif TechnicalObject Technical Object
TechObjIsEquipOrFuncnlLoc MaintenanceNotif TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
TechnicalObjectLabel MaintenanceNotif TechnicalObjectLabel Tech. Object
MaintenancePlanningPlant MaintenanceNotif MaintenancePlanningPlant Planning Plant
MaintenancePlannerGroup MaintenanceNotif MaintenancePlannerGroup Planner Group
AssetManufacturerName MaintenanceNotif AssetManufacturerName Manufacturer
PlantSection MaintenanceNotif PlantSection Plant Section
ABCIndicator MaintenanceNotif ABCIndicator ABC Indicator
ManufacturerPartTypeName MaintenanceNotif ManufacturerPartTypeName Model number
FunctionalLocation MaintenanceNotif FunctionalLocation Object ID
FunctionalLocationLabelName MaintenanceNotif FunctionalLocationLabelName Functional Loc.
AssetLocation MaintenanceNotif AssetLocation Location
LocationName MaintenanceNotif LocationName Location Name
TechnicalObjectCategory MaintenanceNotif TechnicalObjectCategory Tech. Obj. Category
TechnicalObjectType MaintenanceNotif TechnicalObjectType Text object
MaintenancePlant MaintenanceNotif MaintenancePlant Plant
WorkCenterInternalID MaintenanceNotif WorkCenterInternalID Work Center
MaintenanceWorkCenterPlant MaintenanceNotif MaintenanceWorkCenterPlant Work Ctr Plant
MainWorkCenter MaintenanceNotif MainWorkCenter Work Center
MaintenanceWorkCenter MaintenanceNotif MaintenanceWorkCenter Work Center
WorkCenterTypeCode MaintenanceNotif WorkCenterTypeCode Object Type
MainWorkCenterPlant MaintenanceNotif MainWorkCenterPlant Plnt WorkCenter
LocationDescription MaintenanceNotif LocationDescription Current Location
NmbrOfOpenMaintNotifications MaintenanceNotif NmbrOfOpenMaintNotifications Open Notifications
NumberOfOrders MaintenanceNotif NumberOfOrders Open Notifications
MaintWorkRequestAttchKey MaintenanceNotif MaintWorkRequestAttchKey Object Key
MaintNotifSourceApplication MaintenanceNotif MaintNotifSourceApplication Source Application
ActiveTechnicalObject MaintenanceNotif ActiveTechnicalObject Tech. Object
MaintNotifRespPartnerFunction MaintenanceNotif MaintNotifRespPartnerFunction Partner Funct.
PersonResponsibleName MaintenanceNotif PersonResponsibleName Person Resp.
MaintenanceOrder MaintenanceNotif MaintenanceOrder Order
MaintenanceOrderType MaintenanceNotif MaintenanceOrderType Order Type
MaintEvtIsCreatedByCurrentUser MaintenanceNotif MaintEvtIsCreatedByCurrentUser Truth Value
MaintenanceActivityType MaintenanceNotif MaintenanceActivityType MaintActivType
MaintObjDowntimeDurationUnit MaintenanceNotif MaintObjDowntimeDurationUnit Unit
MaintObjectDowntimeDuration MaintenanceNotif MaintObjectDowntimeDuration Breakdown Dur.
NotificationReferenceDate MaintenanceNotif NotificationReferenceDate Reference Date
NotificationReferenceTime MaintenanceNotif NotificationReferenceTime ReferenceTime
NotificationCompletionDate MaintenanceNotif NotificationCompletionDate Completion Date
CompletionTime MaintenanceNotif CompletionTime Completion Time
AssetRoom MaintenanceNotif AssetRoom Room
MaintNotifProcessPhaseCode MaintenanceNotif MaintNotifProcessPhaseCode Process Phase
MaintNotifProcessSubPhaseCode MaintenanceNotif MaintNotifProcessSubPhaseCode Process Subphase
MaintNotifRejectionReasonCode MaintenanceNotif MaintNotifRejectionReasonCode Reason Code
MaintNotifExtReferenceNumber MaintenanceNotif MaintNotifExtReferenceNumber Reference No.
MaintenanceTaskListType MaintenanceNotif MaintenanceTaskListType Task List Type
TaskListGroup MaintenanceNotif TaskListGroup Group
TaskListGroupCounter MaintenanceNotif TaskListGroupCounter Group Counter
TaskList MaintenanceNotif TaskList
TaskListKeyDate MaintenanceNotif TaskListKeyDate
MaintNotifDetectionCatalog MaintenanceNotif MaintNotifDetectionCatalog Detection Meth Prfl
MaintNotifDetectionCodeGroup MaintenanceNotif MaintNotifDetectionCodeGroup Detection Meth Grp
MaintNotifDetectionCode MaintenanceNotif MaintNotifDetectionCode Detection Meth
TechObjInstallationLocation MaintenanceNotif TechObjInstallationLocation Identifying Assets
IdentifyingLabel MaintenanceNotif IdentifyingLabel Ident. Label
WorkRequestTextTemplate MaintenanceNotif WorkRequestTextTemplate Long txt Tmpl
MaintRequestEditableLongText MaintenanceNotif MaintRequestEditableLongText Long Text
_CreatedByUser MaintenanceNotif _CreatedByUser
_MaintenanceOrder MaintenanceNotif _MaintenanceOrder
_MaintenanceWorkCenterPlant MaintenanceNotif _MaintenanceWorkCenterPlant
_MaintNotifDetectCodeGroupTxt MaintenanceNotif _MaintNotifDetectCodeGroupTxt
_MaintNotifDetectCodeTxt MaintenanceNotif _MaintNotifDetectCodeTxt
_MaintNotificationCode MaintenanceNotif _MaintNotificationCode
_MaintNotificationCodeGroup MaintenanceNotif _MaintNotificationCodeGroup
_MaintNotifRejectionReasonTxt MaintenanceNotif _MaintNotifRejectionReasonTxt
_MaintPlant MaintenanceNotif _MaintPlant
_MaintPlantGroup MaintenanceNotif _MaintPlantGroup
_MainWorkCenter MaintenanceNotif _MainWorkCenter
_Phase MaintenanceNotif _Phase
_PMNotificationPhase MaintenanceNotif _PMNotificationPhase
_PMNotificationPriority MaintenanceNotif _PMNotificationPriority
_PMNotificationType MaintenanceNotif _PMNotificationType
_EAMProcessSubPhase MaintenanceNotif _SubPhase
_SupFunctionalLocationText MaintenanceNotif _SupFunctionalLocationText
_TaskListDesc MaintenanceNotif _TaskListDesc
_TechnicalObject MaintenanceNotif _TechnicalObject
_TechnicalObjectText MaintenanceNotif _TechnicalObjectText
_TechnicalObjQuickVw MaintenanceNotif _TechnicalObjQuickVw
_TechObjIsEquipOrFuncnlLoc MaintenanceNotif _TechObjIsEquipOrFuncnlLoc
_TechObjIsEquipOrFuncnlLocDesc MaintenanceNotif _TechObjIsEquipOrFuncnlLocDesc
_TextObjectPlainLongText MaintenanceNotif _TextObjectPlainLongText
_MalfunctionEffect _MalfunctionEffect
_PMNotifMaintenanceData _PMNotifMaintenanceData
_MaintNotifPersonResponsible _MaintNotifPersonResponsible
_ActiveSystemStatus _ActiveSystemStatus

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

CREATE VIEW I_MaintenanceNotificationTP_3 AS
SELECT
  MaintenanceNotif.MaintenanceNotification AS MaintenanceNotification,
  MaintenanceNotif.MaintNotifInternalID AS MaintNotifInternalID,
  MaintenanceNotif.NotificationText AS NotificationText,
  MaintenanceNotif.MaintPriority AS MaintPriority,
  MaintenanceNotif.MaintPriorityType AS MaintPriorityType,
  MaintenanceNotif.NotificationType AS NotificationType,
  MaintenanceNotif.NotifProcessingPhase AS NotifProcessingPhase,
  MaintenanceNotif.CreatedByUser AS CreatedByUser,
  MaintenanceNotif.LastChangedByUser AS LastChangedByUser,
  MaintenanceNotif.CreationDate AS CreationDate,
  MaintenanceNotif.LastChangeTime AS LastChangeTime,
  MaintenanceNotif.LastChangeDate AS LastChangeDate,
  MaintenanceNotif.LastChangeDateTime AS LastChangeDateTime,
  MaintenanceNotif.CreationTime AS CreationTime,
  MaintenanceNotif.CreationDateTime AS CreationDateTime,
  MaintenanceNotif.ReportedByUser AS ReportedByUser,
  MaintenanceNotif.ReporterFullName AS ReporterFullName,
  MaintenanceNotif.PersonResponsible AS PersonResponsible,
  MaintenanceNotif.MalfunctionEffect AS MalfunctionEffect,
  MaintenanceNotif.MalfunctionStartDate AS MalfunctionStartDate,
  MaintenanceNotif.MalfunctionStartTime AS MalfunctionStartTime,
  MaintenanceNotif.MalfunctionStartDateTime AS MalfunctionStartDateTime,
  MaintenanceNotif.MalfunctionEndDate AS MalfunctionEndDate,
  MaintenanceNotif.MalfunctionEndTime AS MalfunctionEndTime,
  MaintenanceNotif.MalfunctionEndDateTime AS MalfunctionEndDateTime,
  MaintenanceNotif.MaintNotificationCatalog AS MaintNotificationCatalog,
  MaintenanceNotif.MaintNotificationCode AS MaintNotificationCode,
  MaintenanceNotif.MaintNotificationCodeGroup AS MaintNotificationCodeGroup,
  MaintenanceNotif.CatalogProfile AS CatalogProfile,
  MaintenanceNotif.NotificationCreationDate AS NotificationCreationDate,
  MaintenanceNotif.NotificationCreationTime AS NotificationCreationTime,
  MaintenanceNotif.NotificationCreationDateTime AS NotificationCreationDateTime,
  MaintenanceNotif.NotificationTimeZone AS NotificationTimeZone,
  MaintenanceNotif.RequiredStartDate AS RequiredStartDate,
  MaintenanceNotif.RequiredStartTime AS RequiredStartTime,
  MaintenanceNotif.MaintNotifRqdStartDateTime AS MaintNotifRqdStartDateTime,
  MaintenanceNotif.RequiredEndDate AS RequiredEndDate,
  MaintenanceNotif.RequiredEndTime AS RequiredEndTime,
  MaintenanceNotif.MaintNotifRqdEndDateTime AS MaintNotifRqdEndDateTime,
  MaintenanceNotif.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  MaintenanceNotif.MaintenanceObjectIsDown AS MaintenanceObjectIsDown,
  MaintenanceNotif.TextObjectCategory AS TextObjectCategory,
  MaintenanceNotif.TextObjectType AS TextObjectType,
  MaintenanceNotif.TechnicalObject AS TechnicalObject,
  MaintenanceNotif.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  MaintenanceNotif.TechnicalObjectLabel AS TechnicalObjectLabel,
  MaintenanceNotif.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  MaintenanceNotif.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  MaintenanceNotif.AssetManufacturerName AS AssetManufacturerName,
  MaintenanceNotif.PlantSection AS PlantSection,
  MaintenanceNotif.ABCIndicator AS ABCIndicator,
  MaintenanceNotif.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  MaintenanceNotif.FunctionalLocation AS FunctionalLocation,
  MaintenanceNotif.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  MaintenanceNotif.AssetLocation AS AssetLocation,
  MaintenanceNotif.LocationName AS LocationName,
  MaintenanceNotif.TechnicalObjectCategory AS TechnicalObjectCategory,
  MaintenanceNotif.TechnicalObjectType AS TechnicalObjectType,
  MaintenanceNotif.MaintenancePlant AS MaintenancePlant,
  MaintenanceNotif.WorkCenterInternalID AS WorkCenterInternalID,
  MaintenanceNotif.MaintenanceWorkCenterPlant AS MaintenanceWorkCenterPlant,
  MaintenanceNotif.MainWorkCenter AS MainWorkCenter,
  MaintenanceNotif.MaintenanceWorkCenter AS MaintenanceWorkCenter,
  MaintenanceNotif.WorkCenterTypeCode AS WorkCenterTypeCode,
  MaintenanceNotif.MainWorkCenterPlant AS MainWorkCenterPlant,
  MaintenanceNotif.LocationDescription AS LocationDescription,
  MaintenanceNotif.NmbrOfOpenMaintNotifications AS NmbrOfOpenMaintNotifications,
  MaintenanceNotif.NumberOfOrders AS NumberOfOrders,
  MaintenanceNotif.MaintWorkRequestAttchKey AS MaintWorkRequestAttchKey,
  MaintenanceNotif.MaintNotifSourceApplication AS MaintNotifSourceApplication,
  MaintenanceNotif.ActiveTechnicalObject AS ActiveTechnicalObject,
  MaintenanceNotif.MaintNotifRespPartnerFunction AS MaintNotifRespPartnerFunction,
  MaintenanceNotif.PersonResponsibleName AS PersonResponsibleName,
  MaintenanceNotif.MaintenanceOrder AS MaintenanceOrder,
  MaintenanceNotif.MaintenanceOrderType AS MaintenanceOrderType,
  MaintenanceNotif.MaintEvtIsCreatedByCurrentUser AS MaintEvtIsCreatedByCurrentUser,
  MaintenanceNotif.MaintenanceActivityType AS MaintenanceActivityType,
  MaintenanceNotif.MaintObjDowntimeDurationUnit AS MaintObjDowntimeDurationUnit,
  MaintenanceNotif.MaintObjectDowntimeDuration AS MaintObjectDowntimeDuration,
  MaintenanceNotif.NotificationReferenceDate AS NotificationReferenceDate,
  MaintenanceNotif.NotificationReferenceTime AS NotificationReferenceTime,
  MaintenanceNotif.NotificationCompletionDate AS NotificationCompletionDate,
  MaintenanceNotif.CompletionTime AS CompletionTime,
  MaintenanceNotif.AssetRoom AS AssetRoom,
  MaintenanceNotif.MaintNotifProcessPhaseCode AS MaintNotifProcessPhaseCode,
  MaintenanceNotif.MaintNotifProcessSubPhaseCode AS MaintNotifProcessSubPhaseCode,
  MaintenanceNotif.MaintNotifRejectionReasonCode AS MaintNotifRejectionReasonCode,
  MaintenanceNotif.MaintNotifExtReferenceNumber AS MaintNotifExtReferenceNumber,
  MaintenanceNotif.MaintenanceTaskListType AS MaintenanceTaskListType,
  MaintenanceNotif.TaskListGroup AS TaskListGroup,
  MaintenanceNotif.TaskListGroupCounter AS TaskListGroupCounter,
  MaintenanceNotif.TaskList AS TaskList,
  MaintenanceNotif.TaskListKeyDate AS TaskListKeyDate,
  MaintenanceNotif.MaintNotifDetectionCatalog AS MaintNotifDetectionCatalog,
  MaintenanceNotif.MaintNotifDetectionCodeGroup AS MaintNotifDetectionCodeGroup,
  MaintenanceNotif.MaintNotifDetectionCode AS MaintNotifDetectionCode,
  MaintenanceNotif.TechObjInstallationLocation AS TechObjInstallationLocation,
  MaintenanceNotif.IdentifyingLabel AS IdentifyingLabel,
  MaintenanceNotif.WorkRequestTextTemplate AS WorkRequestTextTemplate,
  MaintenanceNotif.MaintRequestEditableLongText AS MaintRequestEditableLongText,
  MaintenanceNotif._CreatedByUser AS _CreatedByUser,
  MaintenanceNotif._MaintenanceOrder AS _MaintenanceOrder,
  MaintenanceNotif._MaintenanceWorkCenterPlant AS _MaintenanceWorkCenterPlant,
  MaintenanceNotif._MaintNotifDetectCodeGroupTxt AS _MaintNotifDetectCodeGroupTxt,
  MaintenanceNotif._MaintNotifDetectCodeTxt AS _MaintNotifDetectCodeTxt,
  MaintenanceNotif._MaintNotificationCode AS _MaintNotificationCode,
  MaintenanceNotif._MaintNotificationCodeGroup AS _MaintNotificationCodeGroup,
  MaintenanceNotif._MaintNotifRejectionReasonTxt AS _MaintNotifRejectionReasonTxt,
  MaintenanceNotif._MaintPlant AS _MaintPlant,
  MaintenanceNotif._MaintPlantGroup AS _MaintPlantGroup,
  MaintenanceNotif._MainWorkCenter AS _MainWorkCenter,
  MaintenanceNotif._Phase AS _Phase,
  MaintenanceNotif._PMNotificationPhase AS _PMNotificationPhase,
  MaintenanceNotif._PMNotificationPriority AS _PMNotificationPriority,
  MaintenanceNotif._PMNotificationType AS _PMNotificationType,
  MaintenanceNotif._SubPhase AS _EAMProcessSubPhase,
  MaintenanceNotif._SupFunctionalLocationText AS _SupFunctionalLocationText,
  MaintenanceNotif._TaskListDesc AS _TaskListDesc,
  MaintenanceNotif._TechnicalObject AS _TechnicalObject,
  MaintenanceNotif._TechnicalObjectText AS _TechnicalObjectText,
  MaintenanceNotif._TechnicalObjQuickVw AS _TechnicalObjQuickVw,
  MaintenanceNotif._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc,
  MaintenanceNotif._TechObjIsEquipOrFuncnlLocDesc AS _TechObjIsEquipOrFuncnlLocDesc,
  MaintenanceNotif._TextObjectPlainLongText AS _TextObjectPlainLongText
FROM R_MaintenanceNotificationTP
;

Learn More