I_MAINTNOTIFICATIONTECHOBJ

CDS View
70 Fields 14 CDS Views

Technical Object for Maintenance Notification

I_MAINTNOTIFICATIONTECHOBJ is a CDS View in S/4HANA. Technical Object for Maintenance Notification. It contains 70 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
C_MaintNotificationQuickVw view from CONSUMPTION Quick View for Maintenance Notification
C_MaintNotificationTechObjTP view from CONSUMPTION Maintenance Notification Tech Object
C_Malfunctionreport view from CONSUMPTION Repair Malfunction Job List
I_LocationAnalysisCube view from COMPOSITE Location Analysis - Cube
I_MaintNotifDtaSrceOrdRecmdn view_entity from COMPOSITE Notifi Source data for Maintorder Recmdn
I_MaintNotificationChgHistory view inner COMPOSITE Maint. Notification Change History
I_MaintNotificationTP view from TRANSACTIONAL Maintenance Notification Tech. Object
I_NumberOfOpnNotifByTechObj view from COMPOSITE Number of Open Notifications by Technical Object
P_MaintNotifForScreeningC view from COMPOSITE
P_OpenMaintNotifForEquipment view from COMPOSITE Number of Open Notifs by Equipment
P_OpenMaintNotifForFuncnlLoc view from COMPOSITE Number of Open Notifs by functional loc
R_MaintenanceNotificationTP view_entity from TRANSACTIONAL Maintenance Notification Tech Object
R_MaintenanceWorkRequestTP view_entity from TRANSACTIONAL Maintenance Work Request
R_MaintNotificationPartnerTP view_entity from TRANSACTIONAL Maintenance Notification Partner

Fields (70)

KeyField CDS FieldsUsed in Views
KEY MaintenanceNotification MaintenanceNotification,MaintNotificationForEdit 7
KEY TechnicalObject ActiveTechnicalObject,TechnicalObject 5
KEY TechObjIsEquipOrFuncnlLoc ActiveTechnicalObjectType,TechObjIsEquipOrFuncnlLoc 6
_IsDeleted _IsDeleted 1
_MaintenanceOrder _MaintenanceOrder 1
_MaintNotificationCode _MaintNotificationCode 1
_MaintNotificationCodeGroup _MaintNotificationCodeGroup 1
_PMNotificationPhase _PMNotificationPhase 1
_PMNotificationPriority _PMNotificationPriority 2
_PMNotificationPriorityType _PMNotificationPriorityType 1
_PMNotificationType _PMNotificationType 1
_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc 1
CatalogProfile CatalogProfile 2
CompletionTime CompletionTime 3
CreatedByUser CreatedByUser 5
CreationDate CreationDate 4
CreationDateTime CreationDateTime 1
CreationTime CreationTime 3
Equipment Equipment 5
FunctionalLocation FunctionalLocation 4
InspectionLot InspectionLot 1
IsCompleted IsCompleted 1
IsDeleted IsDeleted 2
LastChangeDate LastChangeDate 3
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser 3
LastChangeTime LastChangeTime 2
LatestAcceptableCompletionDate LatestAcceptableCompletionDate 1
LocationDescription LocationDescription 2
MaintenanceActivityType MaintenanceActivityType 2
MaintenanceItem MaintenancePlanItemIntID 1
MaintenanceObjectIsDown MaintenanceObjectIsDown 2
MaintenanceOrder MaintenanceOrder 4
MaintenancePlan MaintenancePlan 1
MaintenanceWorkCenterPlant MaintenanceWorkCenterPlant,MainWorkCenterPlant 3
MaintNotifDowntimeDuration MaintNotifDowntimeDuration 1
MaintNotifExtReferenceNumber MaintNotifExtReferenceNumber 1
MaintNotificationCatalog MaintNotificationCatalog 3
MaintNotificationCode MaintNotificationCode 3
MaintNotificationCodeGroup MaintNotificationCodeGroup 2
MaintNotifInternalID MaintNotifInternalID 5
MaintObjDowntimeDurationUnit MaintObjDowntimeDurationUnit 2
MaintObjectDowntimeDuration MaintObjectDowntimeDuration 1
MaintPriority MaintPriority 6
MaintPriorityType MaintPriorityType 6
MalfunctionEffect MalfunctionEffect 4
MalfunctionEndDate MalfunctionEndDate 4
MalfunctionEndTime MalfunctionEndTime 4
MalfunctionStartDate MalfunctionStartDate 4
MalfunctionStartTime MalfunctionStartTime 4
NotificationCompletionDate NotificationCompletionDate 3
NotificationCreationDate NotificationCreationDate 5
NotificationCreationTime NotificationCreationTime 5
NotificationHasLongText NotificationHasLongText 1
NotificationOrigin NotificationOrigin 1
NotificationReferenceDate NotificationReferenceDate 3
NotificationReferenceTime NotificationReferenceTime 2
NotificationText NotificationText 5
NotificationTimeZone NotificationTimeZone 4
NotificationType NotificationType 6
NotifProcessingPhase NotifProcessingPhase 5
PersonResponsible PersonResponsible 3
ReportedByUser ReportedByUser 4
ReporterFullName ReporterFullName 4
RequiredEndDate RequiredEndDate 3
RequiredEndTime RequiredEndTime 3
RequiredStartDate ReferenceDate,RequiredStartDate 4
RequiredStartTime RequiredStartTime 3
WorkCenterInternalID WorkCenterInternalID 3
WorkCenterTypeCode WorkCenterTypeCode 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.

-- Technical Object for Maintenance Notification
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTNOTIFICATIONTECHOBJ (
    MAINTENANCENOTIFICATION,
    TECHNICALOBJECT,
    TECHOBJISEQUIPORFUNCNLLOC,
    _ISDELETED,
    _MAINTENANCEORDER,
    _MAINTNOTIFICATIONCODE,
    _MAINTNOTIFICATIONCODEGROUP,
    _PMNOTIFICATIONPHASE,
    _PMNOTIFICATIONPRIORITY,
    _PMNOTIFICATIONPRIORITYTYPE,
    _PMNOTIFICATIONTYPE,
    _TECHOBJISEQUIPORFUNCNLLOC,
    CATALOGPROFILE,
    COMPLETIONTIME,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONDATETIME,
    CREATIONTIME,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    INSPECTIONLOT,
    ISCOMPLETED,
    ISDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    LATESTACCEPTABLECOMPLETIONDATE,
    LOCATIONDESCRIPTION,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEITEM,
    MAINTENANCEOBJECTISDOWN,
    MAINTENANCEORDER,
    MAINTENANCEPLAN,
    MAINTENANCEWORKCENTERPLANT,
    MAINTNOTIFDOWNTIMEDURATION,
    MAINTNOTIFEXTREFERENCENUMBER,
    MAINTNOTIFICATIONCATALOG,
    MAINTNOTIFICATIONCODE,
    MAINTNOTIFICATIONCODEGROUP,
    MAINTNOTIFINTERNALID,
    MAINTOBJDOWNTIMEDURATIONUNIT,
    MAINTOBJECTDOWNTIMEDURATION,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    MALFUNCTIONEFFECT,
    MALFUNCTIONENDDATE,
    MALFUNCTIONENDTIME,
    MALFUNCTIONSTARTDATE,
    MALFUNCTIONSTARTTIME,
    NOTIFICATIONCOMPLETIONDATE,
    NOTIFICATIONCREATIONDATE,
    NOTIFICATIONCREATIONTIME,
    NOTIFICATIONHASLONGTEXT,
    NOTIFICATIONORIGIN,
    NOTIFICATIONREFERENCEDATE,
    NOTIFICATIONREFERENCETIME,
    NOTIFICATIONTEXT,
    NOTIFICATIONTIMEZONE,
    NOTIFICATIONTYPE,
    NOTIFPROCESSINGPHASE,
    PERSONRESPONSIBLE,
    REPORTEDBYUSER,
    REPORTERFULLNAME,
    REQUIREDENDDATE,
    REQUIREDENDTIME,
    REQUIREDSTARTDATE,
    REQUIREDSTARTTIME,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (MAINTENANCENOTIFICATION, TECHNICALOBJECT, TECHOBJISEQUIPORFUNCNLLOC)
);

Learn More