I_MAINTENANCENOTIFICATIONTASK

CDS View
36 Fields 7 CDS Views

Maintenance Notification Task

I_MAINTENANCENOTIFICATIONTASK is a CDS View in S/4HANA. Maintenance Notification Task. It contains 36 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_MaintNotificationTaskCount view from CONSUMPTION Number of tasks for Maintenance Notif.
I_MaintNotifTaskTechObj view from COMPOSITE Maint. Notification Task /w Tech. Obj.
P_MaintNotifOutStdgReldTaskCnt view from COMPOSITE
P_MaintNotifSuccssflTaskCount view from COMPOSITE
P_MaintNotifTaskCount view from COMPOSITE
R_MaintNotificationItemTaskTP view_entity from TRANSACTIONAL Maintenance Notification Item Task
R_MaintNotificationTaskTP view_entity from TRANSACTIONAL Maintenance Notification Task

Fields (36)

KeyField CDS FieldsUsed in Views
KEY MaintenanceNotification MaintenanceNotification 5
KEY MaintenanceNotificationItem MaintenanceNotificationItem 2
KEY MaintenanceNotificationTask MaintenanceNotificationTask 1
_ContactPerson _ContactPerson 1
_Customer _Customer 1
_Employee _Employee 1
_IsDeleted _IsDeleted 1
_MaintenanceNotification _MaintenanceNotification 1
_MaintenanceNotificationItem _MaintenanceNotificationItem 1
_MaintNotificationTaskCode _MaintNotificationTaskCode 1
_MaintNotifTaskCodeCatalog _MaintNotifTaskCodeCatalog 1
_MaintNotifTaskCodeGroup _MaintNotifTaskCodeGroup 1
_OrganizationalUnitText _OrganizationalUnitText 1
_PartnerFunction _PartnerFunction 1
_PositionText _PositionText 1
_StatusObject _StatusObject 1
_StatusObjectStatus _StatusObjectStatus 1
_Supplier _Supplier 1
_User _User 1
CompletedByUser CompletedByUser 1
CompletionDate CompletionDate 1
CompletionTime CompletionTime 1
IsDeleted IsDeleted 1
LastChangeDateTime LastChangeDateTime 1
MaintenanceNotificationCause MaintenanceNotificationCause 1
MaintNotifTaskCode MaintNotifTaskCode 1
MaintNotifTaskCodeCatalog MaintNotifTaskCodeCatalog 1
MaintNotifTaskCodeGroup MaintNotifTaskCodeGroup 1
MaintNotifTaskInternalID MaintNotifTaskInternalID 1
MaintNotifTaskTxt MaintNotifTaskTxt 1
PlannedEndDate PlannedEndDate 1
PlannedEndTime PlannedEndTime 1
PlannedStartDate PlannedStartDate 1
PlannedStartTime PlannedStartTime 1
ResponsiblePerson ResponsiblePerson 1
ResponsiblePersonFunctionCode ResponsiblePersonFunctionCode 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 Task
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTENANCENOTIFICATIONTASK (
    MAINTENANCENOTIFICATION,
    MAINTENANCENOTIFICATIONITEM,
    MAINTENANCENOTIFICATIONTASK,
    _CONTACTPERSON,
    _CUSTOMER,
    _EMPLOYEE,
    _ISDELETED,
    _MAINTENANCENOTIFICATION,
    _MAINTENANCENOTIFICATIONITEM,
    _MAINTNOTIFICATIONTASKCODE,
    _MAINTNOTIFTASKCODECATALOG,
    _MAINTNOTIFTASKCODEGROUP,
    _ORGANIZATIONALUNITTEXT,
    _PARTNERFUNCTION,
    _POSITIONTEXT,
    _STATUSOBJECT,
    _STATUSOBJECTSTATUS,
    _SUPPLIER,
    _USER,
    COMPLETEDBYUSER,
    COMPLETIONDATE,
    COMPLETIONTIME,
    ISDELETED,
    LASTCHANGEDATETIME,
    MAINTENANCENOTIFICATIONCAUSE,
    MAINTNOTIFTASKCODE,
    MAINTNOTIFTASKCODECATALOG,
    MAINTNOTIFTASKCODEGROUP,
    MAINTNOTIFTASKINTERNALID,
    MAINTNOTIFTASKTXT,
    PLANNEDENDDATE,
    PLANNEDENDTIME,
    PLANNEDSTARTDATE,
    PLANNEDSTARTTIME,
    RESPONSIBLEPERSON,
    RESPONSIBLEPERSONFUNCTIONCODE,
    PRIMARY KEY (MAINTENANCENOTIFICATION, MAINTENANCENOTIFICATIONITEM, MAINTENANCENOTIFICATIONTASK)
);

Learn More