I_MAINTNOTIFICATIONACTIVITY

CDS View
26 Fields 4 CDS Views

Maintenance Notification Activity

I_MAINTNOTIFICATIONACTIVITY is a CDS View in S/4HANA. Maintenance Notification Activity. It contains 26 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_MaintNotifActivityCount view from CONSUMPTION Activity counter for Maintenance Notification
I_MaintNotifActivityTechObj view from COMPOSITE Maint. Notif. Activity /w Tech. Obj.
P_Damageanalysiscube view union_all COMPOSITE
R_MaintNotificationActivityTP view_entity from TRANSACTIONAL Maintenance Notification Activity

Fields (26)

KeyField CDS FieldsUsed in Views
KEY MaintenanceNotification MaintenanceNotification 2
KEY MaintenanceNotificationItem MaintenanceNotificationItem 2
KEY MaintNotificationActivity MaintNotificationActivity 2
_IsDeleted _IsDeleted 1
_MaintenanceNotification _MaintenanceNotification 2
_MaintenanceNotificationItem _MaintenanceNotificationItem 1
_MaintNotifActivityCodeCatalog _MaintNotifActivityCodeCatalog 1
_MaintNotifActivityCodeGroup _MaintNotifActivityCodeGroup 1
_MaintNotificationActivityCode _MaintNotificationActivityCode 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreationTime CreationTime 1
IsDeleted IsDeleted 1
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangeTime LastChangeTime 1
MaintNotifActivityCodeCatalog MaintNotifActivityCodeCatalog 2
MaintNotifActivityCodeGroup MaintNotifActivityCodeGroup 2
MaintNotifActivitySortNumber MaintNotifActivitySortNumber 1
MaintNotifActyQtyFactor MaintNotifActyQtyFactor 1
MaintNotifActyTxt MaintNotifActyTxt 1
MaintNotificationActivityCode MaintNotificationActivityCode 2
PlannedEndDate PlannedEndDate 1
PlannedEndTime PlannedEndTime 1
PlannedStartDate PlannedStartDate 1
PlannedStartTime PlannedStartTime 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.

-- Maintenance Notification Activity
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTNOTIFICATIONACTIVITY (
    MAINTENANCENOTIFICATION,
    MAINTENANCENOTIFICATIONITEM,
    MAINTNOTIFICATIONACTIVITY,
    _ISDELETED,
    _MAINTENANCENOTIFICATION,
    _MAINTENANCENOTIFICATIONITEM,
    _MAINTNOTIFACTIVITYCODECATALOG,
    _MAINTNOTIFACTIVITYCODEGROUP,
    _MAINTNOTIFICATIONACTIVITYCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    ISDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGETIME,
    MAINTNOTIFACTIVITYCODECATALOG,
    MAINTNOTIFACTIVITYCODEGROUP,
    MAINTNOTIFACTIVITYSORTNUMBER,
    MAINTNOTIFACTYQTYFACTOR,
    MAINTNOTIFACTYTXT,
    MAINTNOTIFICATIONACTIVITYCODE,
    PLANNEDENDDATE,
    PLANNEDENDTIME,
    PLANNEDSTARTDATE,
    PLANNEDSTARTTIME,
    PRIMARY KEY (MAINTENANCENOTIFICATION, MAINTENANCENOTIFICATIONITEM, MAINTNOTIFICATIONACTIVITY)
);

Learn More