_MAINTENANCENOTIFICATION

25 Fields

_MAINTENANCENOTIFICATION is an SAP database table in S/4HANA. It contains 25 fields.

Fields (25)

KeyField CDS FieldsUsed in Views
_PMNotificationType _PMNotificationType 4
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreationTime CreationTime 1
LastChangeDateTime LastChangeDateTime 1
MaintenanceOrder MaintenanceOrder 1
MaintenanceWorkCenterPlant MaintenanceWorkCenterPlant 1
MaintNotificationCatalog MaintNotificationCatalog 1
MaintNotificationCode MaintNotificationCode 1
MaintNotificationCodeGroup MaintNotificationCodeGroup 1
MaintNotifInternalID MaintNotifInternalID 2
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr 1
MaintPriority MaintPriority 2
MaintPriorityType MaintPriorityType 1
NotificationCreationDate NotificationCreationDate 4
NotificationHasLongText NotificationHasLongText 1
NotificationOrigin NotificationOrigin 3
NotificationText DocumentText,MaintenanceNotificationText,NotificationText 9
NotificationType NotificationType 7
NotifProcessingPhase MaintenanceProcessingPhase 1
ReportedByUser ReportedByUser 1
RequiredEndDate RequiredEndDate 1
RequiredStartDate RequiredStartDate 1
WorkCenterInternalID WorkCenterInternalID 1
WorkCenterTypeCode WorkCenterTypeCode 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _MAINTENANCENOTIFICATION (
    _PMNOTIFICATIONTYPE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    LASTCHANGEDATETIME,
    MAINTENANCEORDER,
    MAINTENANCEWORKCENTERPLANT,
    MAINTNOTIFICATIONCATALOG,
    MAINTNOTIFICATIONCODE,
    MAINTNOTIFICATIONCODEGROUP,
    MAINTNOTIFINTERNALID,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    NOTIFICATIONCREATIONDATE,
    NOTIFICATIONHASLONGTEXT,
    NOTIFICATIONORIGIN,
    NOTIFICATIONTEXT,
    NOTIFICATIONTYPE,
    NOTIFPROCESSINGPHASE,
    REPORTEDBYUSER,
    REQUIREDENDDATE,
    REQUIREDSTARTDATE,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE
);

Learn More