I_MAINTENANCENOTIFICATION

CDS View
72 Fields 25 CDS Views

Maintenance Notification

I_MAINTENANCENOTIFICATION is a CDS View in S/4HANA. Maintenance Notification. It contains 72 fields. 25 CDS views read from this table.

CDS Views using this table (25)

ViewTypeJoinVDMDescription
C_MaintenanceNotificationVH view from CONSUMPTION Maintenance Notification Value Help
C_MaintNotificationDateMonitor view from CONSUMPTION Date Monitor
C_MaintNotifOutputParamDetn view from CONSUMPTION Maintenance Notification OM Parameter Determination
C_ObjPgMaintNotifWithDesc view from CONSUMPTION Maintenance Notification w/ Description
C_PMNotificationHeader view from CONSUMPTION Maintenance Notification
C_TechObjMaintNotification view from CONSUMPTION Maintenance Notifications for Technical Object
C_TechObjMaintNotification view union_all CONSUMPTION Maintenance Notifications for Technical Object
CRMS4_IU_I_UMN view_entity from Utilities Maintenance Notification
I_DFS_MaintNotificationTechSts view from COMPOSITE Interface view for Tech Status of Notif
I_MAIFDynamicFormObjectKeyVH view_entity union_all COMPOSITE Mobile App Dynamic Form Object Keys
I_MaintNotifAssignOrderInput view from COMPOSITE Maint Notification Assign Order Input
I_MaintNotifEmailParameter view from BASIC Email Parameters for Maint Notification
I_MaintNotificationTechObj view from COMPOSITE Technical Object for Maintenance Notification
I_MaintNotifLongText view from COMPOSITE PM: Maintenance Notification Long Text
I_MaintNotifPredictionData view from BASIC prediction data with RDT
I_MaintNotifQueryNode view from BASIC Maintenance Notification Query Node
I_MaintNotifStdVH view from COMPOSITE Maintenance Notification
I_MaintNotifTrainingData view from BASIC Training Data for Model training
P_MaintenanceJobAndWorkItem view from COMPOSITE
P_MaintenanceJobAndWorkItem view union_all COMPOSITE
P_MaintNotificationPartner view from COMPOSITE
P_MaintNotificationSearch view from BASIC
P_MaintNotifRefObject view from CONSUMPTION
P_MaintNotifTechObjBreakdown view from COMPOSITE
P_MaintPlngBcktNotification view from CONSUMPTION Auxiliary View for Notifications in Planning Bucket

Fields (72)

KeyField CDS FieldsUsed in Views
KEY MaintenanceNotification MaintenanceNotification,Notification 12
KEY MaintNotifInternalID MaintenanceJobInternalID,MaintNotifInternalID,StatusObject 6
_CreatedByUser _CreatedByUser 1
_IsCompleted _IsCompleted 2
_IsDeleted _IsDeleted 3
_LastChangedByUser _LastChangedByUser 1
_LinearAssetManagementData _LinearAssetManagementData 1
_MaintenanceNotificationItem _MaintenanceNotificationItem 1
_Maintenancenotificationtask _Maintenancenotificationtask 1
_MaintenanceOrder _MaintenanceOrder 3
_MaintenancePartner _MaintenancePartner 2
_MaintenanceWorkCenterPlant _MaintenanceWorkCenterPlant 3
_MaintNotificationActivity _MaintNotificationActivity 1
_MaintNotificationCatalog _MaintNotificationCatalog 2
_MaintNotificationCode _MaintNotificationCode 2
_MaintNotificationCodeGroup _MaintNotificationCodeGroup 2
_MainWorkCenter _MainWorkCenter 3
_Material _Material 1
_NotificationHasLongText _NotificationHasLongText 1
_PMNotificationPhase _PMNotificationPhase 3
_PMNotificationPriority _PMNotificationPriority 3
_PMNotificationPriorityType _PMNotificationPriorityType 3
_PMNotificationType _PMNotificationType 2
_PMNotifMaintenanceData _PMNotifMaintenanceData 4
_ReportedByUser _ReportedByUser 2
_StatusObject _StatusObject 2
_StatusObjectActiveStatus _StatusObjectActiveStatus 2
_TechnicalObjectCodeCatalog _TechnicalObjectCodeCatalog 1
_WorkCenterType _WorkCenterType 3
AdditionalDeviceData AdditionalDeviceData 1
CatalogProfile CatalogProfile 2
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
CreationDateTime CreationDateTime 1
CreationTime CreationTime 2
DfsMaintNotificationObjectNmbr DfsMaintNotificationObjectNmbr 2
InspectionLot InspectionLot 1
IsCompleted IsCompleted 2
IsDeleted IsDeleted 3
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 1
LongTextLanguage LongTextLanguage 1
MaintenanceOrder MaintenanceOrder 4
MaintenanceWorkCenterPlant MaintenanceWorkCenterPlant 4
MaintNotifExtReferenceNumber MaintNotifExtReferenceNumber 2
MaintNotificationCatalog MaintNotificationCatalog 2
MaintNotificationCode MaintNotificationCode 3
MaintNotificationCodeGroup MaintNotificationCodeGroup 3
MaintPriority MaintPriority 4
MaintPriorityType MaintPriorityType 4
MasterLanguage MasterLanguage 1
Material Material 1
NotificationCompletionDate NotificationCompletionDate 2
NotificationCompletionTime CompletionTime,NotificationCompletionTime 2
NotificationCreationDate NotificationCreationDate 2
NotificationCreationTime NotificationCreationTime 2
NotificationHasLongText NotificationHasLongText 1
NotificationOrigin NotificationOrigin 2
NotificationReferenceDate NotificationReferenceDate 2
NotificationReferenceTime NotificationReferenceTime 2
NotificationText MAIFDynFormObjectDescription,NotificationText 10
NotificationTimeZone NotificationTimeZone 3
NotificationType NotificationType 7
NotifProcessingPhase NotifProcessingPhase 5
ReportedByUser ReportedByUser 2
RequiredEndDate RequiredEndDate 2
RequiredEndTime RequiredEndTime 2
RequiredStartDate RequiredStartDate 2
RequiredStartTime RequiredStartTime 2
SerialNumber SerialNumber 1
WorkCenterInternalID WorkCenterInternalID 3
WorkCenterTypeCode WorkCenterTypeCode 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Maintenance Notification
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTENANCENOTIFICATION (
    MAINTENANCENOTIFICATION,
    MAINTNOTIFINTERNALID,
    _CREATEDBYUSER,
    _ISCOMPLETED,
    _ISDELETED,
    _LASTCHANGEDBYUSER,
    _LINEARASSETMANAGEMENTDATA,
    _MAINTENANCENOTIFICATIONITEM,
    _MAINTENANCENOTIFICATIONTASK,
    _MAINTENANCEORDER,
    _MAINTENANCEPARTNER,
    _MAINTENANCEWORKCENTERPLANT,
    _MAINTNOTIFICATIONACTIVITY,
    _MAINTNOTIFICATIONCATALOG,
    _MAINTNOTIFICATIONCODE,
    _MAINTNOTIFICATIONCODEGROUP,
    _MAINWORKCENTER,
    _MATERIAL,
    _NOTIFICATIONHASLONGTEXT,
    _PMNOTIFICATIONPHASE,
    _PMNOTIFICATIONPRIORITY,
    _PMNOTIFICATIONPRIORITYTYPE,
    _PMNOTIFICATIONTYPE,
    _PMNOTIFMAINTENANCEDATA,
    _REPORTEDBYUSER,
    _STATUSOBJECT,
    _STATUSOBJECTACTIVESTATUS,
    _TECHNICALOBJECTCODECATALOG,
    _WORKCENTERTYPE,
    ADDITIONALDEVICEDATA,
    CATALOGPROFILE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONDATETIME,
    CREATIONTIME,
    DFSMAINTNOTIFICATIONOBJECTNMBR,
    INSPECTIONLOT,
    ISCOMPLETED,
    ISDELETED,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LONGTEXTLANGUAGE,
    MAINTENANCEORDER,
    MAINTENANCEWORKCENTERPLANT,
    MAINTNOTIFEXTREFERENCENUMBER,
    MAINTNOTIFICATIONCATALOG,
    MAINTNOTIFICATIONCODE,
    MAINTNOTIFICATIONCODEGROUP,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    MASTERLANGUAGE,
    MATERIAL,
    NOTIFICATIONCOMPLETIONDATE,
    NOTIFICATIONCOMPLETIONTIME,
    NOTIFICATIONCREATIONDATE,
    NOTIFICATIONCREATIONTIME,
    NOTIFICATIONHASLONGTEXT,
    NOTIFICATIONORIGIN,
    NOTIFICATIONREFERENCEDATE,
    NOTIFICATIONREFERENCETIME,
    NOTIFICATIONTEXT,
    NOTIFICATIONTIMEZONE,
    NOTIFICATIONTYPE,
    NOTIFPROCESSINGPHASE,
    REPORTEDBYUSER,
    REQUIREDENDDATE,
    REQUIREDENDTIME,
    REQUIREDSTARTDATE,
    REQUIREDSTARTTIME,
    SERIALNUMBER,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (MAINTENANCENOTIFICATION, MAINTNOTIFINTERNALID)
);

Learn More