I_MAINTNOTIFACTIVITYTP

CDS View

Maint. Notif. Activity /w Tech. Obj.

I_MAINTNOTIFACTIVITYTP is a CDS View in S/4HANA. Maint. Notif. Activity /w Tech. Obj.. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_MaintNotifActivityTP view from CONSUMPTION Maintenance Notification Activity
C_ObjPgMaintNotifActivity view from CONSUMPTION Maintenance Notification Activity

Fields (22)

KeyField CDS FieldsUsed in Views
KEY MaintenanceNotification MaintenanceNotification 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 2
IsDeleted IsDeleted 1
MaintenanceNotificationItem MaintenanceNotificationItem 2
MaintNotifActivityCodeCatalog MaintNotifActivityCodeCatalog 1
MaintNotifActivityCodeGroup MaintNotifActivityCodeGroup 2
MaintNotifActivityForEdit MaintNotifActivityForEdit 1
MaintNotifActivitySortNumber MaintNotifActivitySortNumber 1
MaintNotifActyQtyFactor MaintNotifActyQtyFactor 2
MaintNotifActyTxt MaintNotifActyTxt 2
MaintNotificationActivityCode MaintNotificationActivityCode 2
PlannedEndDate PlannedEndDate 2
PlannedEndTime PlannedEndTime 2
PlannedStartDate PlannedStartDate 2
PlannedStartTime PlannedStartTime 2

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.

-- Maint. Notif. Activity /w Tech. Obj.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTNOTIFACTIVITYTP (
    MAINTENANCENOTIFICATION,
    MAINTNOTIFICATIONACTIVITY,
    _ISDELETED,
    _MAINTENANCENOTIFICATION,
    _MAINTENANCENOTIFICATIONITEM,
    _MAINTNOTIFACTIVITYCODECATALOG,
    _MAINTNOTIFACTIVITYCODEGROUP,
    _MAINTNOTIFICATIONACTIVITYCODE,
    CREATEDBYUSER,
    ISDELETED,
    MAINTENANCENOTIFICATIONITEM,
    MAINTNOTIFACTIVITYCODECATALOG,
    MAINTNOTIFACTIVITYCODEGROUP,
    MAINTNOTIFACTIVITYFOREDIT,
    MAINTNOTIFACTIVITYSORTNUMBER,
    MAINTNOTIFACTYQTYFACTOR,
    MAINTNOTIFACTYTXT,
    MAINTNOTIFICATIONACTIVITYCODE,
    PLANNEDENDDATE,
    PLANNEDENDTIME,
    PLANNEDSTARTDATE,
    PLANNEDSTARTTIME,
    PRIMARY KEY (MAINTENANCENOTIFICATION, MAINTNOTIFICATIONACTIVITY)
);