_PMNOTIFMAINTENANCEDATA

24 Fields

_PMNOTIFMAINTENANCEDATA is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
_Equipment _Equipment 2
_MaintenanceActivityType _MaintenanceActivityType 1
_MaintenancePlannerGroup _MaintenancePlannerGroup 1
_MaintenancePlanPlant _MaintenancePlanPlant 1
Assembly Assembly 3
Equipment Equipment 5
LatestAcceptableCompletionDate LatestAcceptableCompletionDate 1
LocationDescription LocationDescription 1
MaintenanceActivityType MaintenanceActivityType 2
MaintenanceObjectIsDown MaintenanceObjectIsDown 2
MaintenancePlannerGroup MaintenancePlannerGroup 5
MaintenancePlanningPlant MaintenancePlanningPlant 5
MaintenanceRevision MaintenanceRevision 1
MaintenanceTaskListType MaintenanceTaskListType 1
MaintNotifDetectionCatalog MaintNotifDetectionCatalog 1
MaintNotifDetectionCode MaintNotifDetectionCode 1
MaintNotifDetectionCodeGroup MaintNotifDetectionCodeGroup 1
MaintNotifProcessingContext MaintNotifProcessingContext 1
MaintNotifProcessPhaseCode MaintNotifProcessPhaseCode 3
MaintNotifProcessSubPhaseCode MaintNotifProcessSubPhaseCode 2
MalfunctionEffect MalfunctionEffect 1
NotificationPersonResponsible PersonResponsible 1
TaskListGroup TaskListGroup 1
TaskListGroupCounter TaskListGroupCounter 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 _PMNOTIFMAINTENANCEDATA (
    _EQUIPMENT,
    _MAINTENANCEACTIVITYTYPE,
    _MAINTENANCEPLANNERGROUP,
    _MAINTENANCEPLANPLANT,
    ASSEMBLY,
    EQUIPMENT,
    LATESTACCEPTABLECOMPLETIONDATE,
    LOCATIONDESCRIPTION,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEOBJECTISDOWN,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCEREVISION,
    MAINTENANCETASKLISTTYPE,
    MAINTNOTIFDETECTIONCATALOG,
    MAINTNOTIFDETECTIONCODE,
    MAINTNOTIFDETECTIONCODEGROUP,
    MAINTNOTIFPROCESSINGCONTEXT,
    MAINTNOTIFPROCESSPHASECODE,
    MAINTNOTIFPROCESSSUBPHASECODE,
    MALFUNCTIONEFFECT,
    NOTIFICATIONPERSONRESPONSIBLE,
    TASKLISTGROUP,
    TASKLISTGROUPCOUNTER
);

Learn More