MAINTNTF_D

Transparent Table Application Table
134 Fields 2 CDS Views

Draft table for entity R_MAINTENANCENOTIFICATIONTP

MAINTNTF_D is an SAP database table in S/4HANA. Draft table for entity R_MAINTENANCENOTIFICATIONTP. It contains 134 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_MaintenanceNotificationDraft view_entity from EXTENSION Maintenance Notification - Extension
R_MaintenanceNotificationDraft view_entity from BASIC Maintenance Notification data

Fields (134)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY maintenancenotification QMNUM Notification
KEY draftuuid SDRAFT_UUID Draft Document ID
maintnotifinternalid QMOBJNR Object number
notificationtext QMTXT Description
maintpriority PRIOK Priority
maintprioritytype ARTPR PriorityType
genericprioritycolorcode abap.int1
notificationtype QMART Notifictn Type
notifprocessingphase QM_PHASE Notif. Phase
createdbyuser ERNAM Created By
lastchangedbyuser AENAM Changed By
creationdate ERDAT Created On
lastchangetime AEZEIT Changed At
lastchangedate AEDAT Changed On
lastchangedatetime TZNTSTMPS Time Stamp
creationtime ERZEIT Created At
creationdatetime TZNTSTMPS Time Stamp
reportedbyuser QMNAM Reported By
reporterfullname AD_NAMTEXT Full Name
personresponsible EAMS_PERSON_RESPONSIBLE Person Resp. ID
malfunctioneffect AUSWK Effect
malfunctionstartdate AUSVN Malfunct. Start
malfunctionstarttime AUZTV Mal. Start (T.)
malfunctionstartdatetime TZNTSTMPS Time Stamp
malfunctionenddate AUSBS Malfunct. End
malfunctionendtime AUZTB Malfunction End
malfunctionenddatetime TZNTSTMPS Time Stamp
maintnotificationcatalog QMKAT Catalog Type
maintnotificationcode QMCOD Coding
maintnotificationcodegroup QMGRP Code Group
catalogprofile RBNR Catalog Profile
notificationcreationdate QMDAT Notif. Date
notificationcreationtime MZEIT Notif. Time
notificationcreationdatetime TZNTSTMPS Time Stamp
notificationtimezone TZONSO Notif.Time.Zone
requiredstartdate EAM_REQ_START_DATE Req. Start Date
requiredstarttime STRUR Req. start time
maintnotifrqdstartdatetime TZNTSTMPS Time Stamp
requiredenddate EAM_REQ_END_DATE Req. End Date
requiredendtime LTRUR Req. end time
maintnotifrqdenddatetime TZNTSTMPS Time Stamp
latestacceptablecompletiondate VDM_LACD_DATE Final Due Date
maintenanceobjectisdown MSAUS Breakdown
textobjectcategory TDOBJECT Text object
textobjecttype TDID Text ID
maintrequesteditablelongtext ESH_E_SR_LONGTEXT Long Text
maintnotiflongtextforedit ESH_E_SR_LONGTEXT Long Text
technicalobject EAMS_TEC_OBJ Tech. Object
techobjisequiporfuncnlloc EAMS_TEC_OBJ_TYPE_VALUE Tech. Obj. Type
technicalobjectlabel EAMS_TEC_OBJ Tech. Object
maintenanceplanningplant IWERK Planning Plant
maintenanceplannergroup INGRP Planner Group
assetmanufacturername HERST Manufacturer
plantsection BEBER Plant Section
abcindicator ABCKZ ABC Indic.
superiortechnicalobjectlabel EAMS_TECH_OBJ_ALPHA_CONV Technical Object
manufacturerparttypename TYPBZ Model number
functionallocation EAMS_UI_OID_NAME Object ID
functionallocationlabelname ILOM_STRNO Functional Loc.
assetlocation PMLOC Location
locationname LOCATIONNAME Location Name
technicalobjectcategory EAMS_TEC_OBJ_CAT Tech. Obj. Category
technicalobjecttype EQART Object Type
maintenanceplant SWERK MaintPlant
workcenterinternalid LGWID Work Center
maintenanceworkcenterplant QARBPWERKS Work Ctr Plant
mainworkcenter PPH_ARBPL Work Center
maintenanceworkcenter PPH_ARBPL Work Center
workcentertypecode CR_OBJTY Object Type
mainworkcenterplant WERKS_D Plant
locationdescription PM_LOC_DESC Current Location
nmbrofopenmaintnotifications EAM_OPEN_NOTIFICATIONS Open Notifications
numberoforders EAM_OPEN_NOTIFICATIONS Open Notifications
maintworkrequestattchkey OBJKY Object Key
maintnotifwithleadingzeros CHAR12 Character Field of Length 12
maintnotifsourceapplication PM_SOURCE_APPL Source Application
activetechnicalobject EAMS_TEC_OBJ Tech. Object
activetechnicalobjecttype EAMS_TEC_OBJ_TYPE_VALUE Tech. Obj. Type
maintnotifresppartnerfunction PARVW_UNV Partner Funct.
personresponsiblename EAMS_PERSON_RESPONSIBLE_NAME Person Resp.
concatenatedactivesyststsname VDM_J_SYSTEM_STATUS_CONCAT_T Concatenated System Status
concatenatedactiveuserstsname VDM_J_USER_STATUS_CONCAT_T Concatenated User Status
maintenanceorder AUFNR Order
maintenanceordertype AUFART Order Type
maintevtiscreatedbycurrentuser ABAP_BOOLEAN Truth Value
maintenanceactivitytype EAM_MAINT_ACTIVITY_TYPE Activity Type
maintobjdowntimedurationunit MAUEH Unit
maintobjectdowntimeduration AUSZT Breakdown Dur.
notificationreferencedate BEZDT Reference Date
notificationreferencetime BEZUR_D ReferenceTime
notificationcompletiondate QMDAB Completion Date
completiontime QMZAB Completion Time
assetroom RAUMNR Room
maintobjectfreedefinedattrib EQFNR Sort Field
maintnotifprocessphasecode EAM_OSTAT_PHASE Process Phase
maintnotifprocesssubphasecode EAM_OSTAT_SPHASE Process Subphase
maintnotifrejectionreasoncode EAM_REJREASONCODE Reason Code
maintnotifextreferencenumber QMEXTNR Reference No.
maintenancetasklisttype PLNTY Task List Type
tasklistgroup PLNNR Group
tasklistgroupcounter PLNAL Group Counter
tasklist abap.char
tasklistkeydate abap.dats
maintnotifdetectioncatalog DETECTIONCATALOG Detection Meth Prfl
maintnotifdetectioncodegroup DETECTIONCODEGROUP Detection Meth Grp
maintnotifdetectioncode DETECTIONCODE Detection Meth
maintnotifprocessingcontext MAINTNOTIFPROCESSINGCONTEXT Notif Procg Context
techobjinstallationlocation EAM_TECHOBJ_INSTALLATION_LOC Identifying Assets
identifyinglabel ILOM_LEVEL_KZ_KZ2_DESC Ident. Label
workrequesttexttemplate EAM_LTXT_TMPLT_DESC Long txt Tmpl
maintnotifprocgcntxtisallwd ABAP_BOOLEAN Truth Value
hierarchynodelevel HRYLEVEL Hierarchy Level
previousfinalduedate LACD_OLD Prev. Final Due Date
origlltstaccptblcompletiondate ORIGLLTSTACCPTBLCOMPLETIONDATE Orig. Final Due Date
maintnotifreferencedatetime TZNTSTMPS Time Stamp
maintnotifcompletiondatetime TZNTSTMPS Time Stamp
superiorfunctionallocation EAMS_UI_OID_NAME Object ID
maintnotifdowntimeduration EAUSZT Breakdown Dur.
bopfuuid SDRAFT_UUID Draft Document ID
maintnotiffailureeffectcatalog FAILURE_EFFECT_CATALOG Failure Effect Catlg
maintnotifflreeffectcodegroup FAILURE_EFFECT_CODE_GRP Fail Effect Code Grp
maintnotiffailureeffectcode FAILURE_EFFECT_CODE Failure Effect Code
maintenancerevision REVNI Revision
inspectionlot QPLOS Inspection Lot
maintorderfollowonnotification AUFNR Order
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityconsistencystatus abap.char
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes
dummy_qmih_incl_eew_ps CFD_DUMMY Dummy

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.

-- Draft table for entity R_MAINTENANCENOTIFICATIONTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MAINTNTF_D (
    MANDT,                           -- Client [MANDT]
    MAINTENANCENOTIFICATION,         -- Notification [QMNUM]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    MAINTNOTIFINTERNALID,            -- Object number [QMOBJNR]
    NOTIFICATIONTEXT,                -- Description [QMTXT]
    MAINTPRIORITY,                   -- Priority [PRIOK]
    MAINTPRIORITYTYPE,               -- PriorityType [ARTPR]
    GENERICPRIORITYCOLORCODE,        -- abap.int1
    NOTIFICATIONTYPE,                -- Notifictn Type [QMART]
    NOTIFPROCESSINGPHASE,            -- Notif. Phase [QM_PHASE]
    CREATEDBYUSER,                   -- Created By [ERNAM]
    LASTCHANGEDBYUSER,               -- Changed By [AENAM]
    CREATIONDATE,                    -- Created On [ERDAT]
    LASTCHANGETIME,                  -- Changed At [AEZEIT]
    LASTCHANGEDATE,                  -- Changed On [AEDAT]
    LASTCHANGEDATETIME,              -- Time Stamp [TZNTSTMPS]
    CREATIONTIME,                    -- Created At [ERZEIT]
    CREATIONDATETIME,                -- Time Stamp [TZNTSTMPS]
    REPORTEDBYUSER,                  -- Reported By [QMNAM]
    REPORTERFULLNAME,                -- Full Name [AD_NAMTEXT]
    PERSONRESPONSIBLE,               -- Person Resp. ID [EAMS_PERSON_RESPONSIBLE]
    MALFUNCTIONEFFECT,               -- Effect [AUSWK]
    MALFUNCTIONSTARTDATE,            -- Malfunct. Start [AUSVN]
    MALFUNCTIONSTARTTIME,            -- Mal. Start (T.) [AUZTV]
    MALFUNCTIONSTARTDATETIME,        -- Time Stamp [TZNTSTMPS]
    MALFUNCTIONENDDATE,              -- Malfunct. End [AUSBS]
    MALFUNCTIONENDTIME,              -- Malfunction End [AUZTB]
    MALFUNCTIONENDDATETIME,          -- Time Stamp [TZNTSTMPS]
    MAINTNOTIFICATIONCATALOG,        -- Catalog Type [QMKAT]
    MAINTNOTIFICATIONCODE,           -- Coding [QMCOD]
    MAINTNOTIFICATIONCODEGROUP,      -- Code Group [QMGRP]
    CATALOGPROFILE,                  -- Catalog Profile [RBNR]
    NOTIFICATIONCREATIONDATE,        -- Notif. Date [QMDAT]
    NOTIFICATIONCREATIONTIME,        -- Notif. Time [MZEIT]
    NOTIFICATIONCREATIONDATETIME,    -- Time Stamp [TZNTSTMPS]
    NOTIFICATIONTIMEZONE,            -- Notif.Time.Zone [TZONSO]
    REQUIREDSTARTDATE,               -- Req. Start Date [EAM_REQ_START_DATE]
    REQUIREDSTARTTIME,               -- Req. start time [STRUR]
    MAINTNOTIFRQDSTARTDATETIME,      -- Time Stamp [TZNTSTMPS]
    REQUIREDENDDATE,                 -- Req. End Date [EAM_REQ_END_DATE]
    REQUIREDENDTIME,                 -- Req. end time [LTRUR]
    MAINTNOTIFRQDENDDATETIME,        -- Time Stamp [TZNTSTMPS]
    LATESTACCEPTABLECOMPLETIONDATE,  -- Final Due Date [VDM_LACD_DATE]
    MAINTENANCEOBJECTISDOWN,         -- Breakdown [MSAUS]
    TEXTOBJECTCATEGORY,              -- Text object [TDOBJECT]
    TEXTOBJECTTYPE,                  -- Text ID [TDID]
    MAINTREQUESTEDITABLELONGTEXT,    -- Long Text [ESH_E_SR_LONGTEXT]
    MAINTNOTIFLONGTEXTFOREDIT,       -- Long Text [ESH_E_SR_LONGTEXT]
    TECHNICALOBJECT,                 -- Tech. Object [EAMS_TEC_OBJ]
    TECHOBJISEQUIPORFUNCNLLOC,       -- Tech. Obj. Type [EAMS_TEC_OBJ_TYPE_VALUE]
    TECHNICALOBJECTLABEL,            -- Tech. Object [EAMS_TEC_OBJ]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [IWERK]
    MAINTENANCEPLANNERGROUP,         -- Planner Group [INGRP]
    ASSETMANUFACTURERNAME,           -- Manufacturer [HERST]
    PLANTSECTION,                    -- Plant Section [BEBER]
    ABCINDICATOR,                    -- ABC Indic. [ABCKZ]
    SUPERIORTECHNICALOBJECTLABEL,    -- Technical Object [EAMS_TECH_OBJ_ALPHA_CONV]
    MANUFACTURERPARTTYPENAME,        -- Model number [TYPBZ]
    FUNCTIONALLOCATION,              -- Object ID [EAMS_UI_OID_NAME]
    FUNCTIONALLOCATIONLABELNAME,     -- Functional Loc. [ILOM_STRNO]
    ASSETLOCATION,                   -- Location [PMLOC]
    LOCATIONNAME,                    -- Location Name [LOCATIONNAME]
    TECHNICALOBJECTCATEGORY,         -- Tech. Obj. Category [EAMS_TEC_OBJ_CAT]
    TECHNICALOBJECTTYPE,             -- Object Type [EQART]
    MAINTENANCEPLANT,                -- MaintPlant [SWERK]
    WORKCENTERINTERNALID,            -- Work Center [LGWID]
    MAINTENANCEWORKCENTERPLANT,      -- Work Ctr Plant [QARBPWERKS]
    MAINWORKCENTER,                  -- Work Center [PPH_ARBPL]
    MAINTENANCEWORKCENTER,           -- Work Center [PPH_ARBPL]
    WORKCENTERTYPECODE,              -- Object Type [CR_OBJTY]
    MAINWORKCENTERPLANT,             -- Plant [WERKS_D]
    LOCATIONDESCRIPTION,             -- Current Location [PM_LOC_DESC]
    NMBROFOPENMAINTNOTIFICATIONS,    -- Open Notifications [EAM_OPEN_NOTIFICATIONS]
    NUMBEROFORDERS,                  -- Open Notifications [EAM_OPEN_NOTIFICATIONS]
    MAINTWORKREQUESTATTCHKEY,        -- Object Key [OBJKY]
    MAINTNOTIFWITHLEADINGZEROS,      -- Character Field of Length 12 [CHAR12]
    MAINTNOTIFSOURCEAPPLICATION,     -- Source Application [PM_SOURCE_APPL]
    ACTIVETECHNICALOBJECT,           -- Tech. Object [EAMS_TEC_OBJ]
    ACTIVETECHNICALOBJECTTYPE,       -- Tech. Obj. Type [EAMS_TEC_OBJ_TYPE_VALUE]
    MAINTNOTIFRESPPARTNERFUNCTION,   -- Partner Funct. [PARVW_UNV]
    PERSONRESPONSIBLENAME,           -- Person Resp. [EAMS_PERSON_RESPONSIBLE_NAME]
    CONCATENATEDACTIVESYSTSTSNAME,   -- Concatenated System Status [VDM_J_SYSTEM_STATUS_CONCAT_T]
    CONCATENATEDACTIVEUSERSTSNAME,   -- Concatenated User Status [VDM_J_USER_STATUS_CONCAT_T]
    MAINTENANCEORDER,                -- Order [AUFNR]
    MAINTENANCEORDERTYPE,            -- Order Type [AUFART]
    MAINTEVTISCREATEDBYCURRENTUSER,  -- Truth Value [ABAP_BOOLEAN]
    MAINTENANCEACTIVITYTYPE,         -- Activity Type [EAM_MAINT_ACTIVITY_TYPE]
    MAINTOBJDOWNTIMEDURATIONUNIT,    -- Unit [MAUEH]
    MAINTOBJECTDOWNTIMEDURATION,     -- Breakdown Dur. [AUSZT]
    NOTIFICATIONREFERENCEDATE,       -- Reference Date [BEZDT]
    NOTIFICATIONREFERENCETIME,       -- ReferenceTime [BEZUR_D]
    NOTIFICATIONCOMPLETIONDATE,      -- Completion Date [QMDAB]
    COMPLETIONTIME,                  -- Completion Time [QMZAB]
    ASSETROOM,                       -- Room [RAUMNR]
    MAINTOBJECTFREEDEFINEDATTRIB,    -- Sort Field [EQFNR]
    MAINTNOTIFPROCESSPHASECODE,      -- Process Phase [EAM_OSTAT_PHASE]
    MAINTNOTIFPROCESSSUBPHASECODE,   -- Process Subphase [EAM_OSTAT_SPHASE]
    MAINTNOTIFREJECTIONREASONCODE,   -- Reason Code [EAM_REJREASONCODE]
    MAINTNOTIFEXTREFERENCENUMBER,    -- Reference No. [QMEXTNR]
    MAINTENANCETASKLISTTYPE,         -- Task List Type [PLNTY]
    TASKLISTGROUP,                   -- Group [PLNNR]
    TASKLISTGROUPCOUNTER,            -- Group Counter [PLNAL]
    TASKLIST,                        -- abap.char
    TASKLISTKEYDATE,                 -- abap.dats
    MAINTNOTIFDETECTIONCATALOG,      -- Detection Meth Prfl [DETECTIONCATALOG]
    MAINTNOTIFDETECTIONCODEGROUP,    -- Detection Meth Grp [DETECTIONCODEGROUP]
    MAINTNOTIFDETECTIONCODE,         -- Detection Meth [DETECTIONCODE]
    MAINTNOTIFPROCESSINGCONTEXT,     -- Notif Procg Context [MAINTNOTIFPROCESSINGCONTEXT]
    TECHOBJINSTALLATIONLOCATION,     -- Identifying Assets [EAM_TECHOBJ_INSTALLATION_LOC]
    IDENTIFYINGLABEL,                -- Ident. Label [ILOM_LEVEL_KZ_KZ2_DESC]
    WORKREQUESTTEXTTEMPLATE,         -- Long txt Tmpl [EAM_LTXT_TMPLT_DESC]
    MAINTNOTIFPROCGCNTXTISALLWD,     -- Truth Value [ABAP_BOOLEAN]
    HIERARCHYNODELEVEL,              -- Hierarchy Level [HRYLEVEL]
    PREVIOUSFINALDUEDATE,            -- Prev. Final Due Date [LACD_OLD]
    ORIGLLTSTACCPTBLCOMPLETIONDATE,  -- Orig. Final Due Date [ORIGLLTSTACCPTBLCOMPLETIONDATE]
    MAINTNOTIFREFERENCEDATETIME,     -- Time Stamp [TZNTSTMPS]
    MAINTNOTIFCOMPLETIONDATETIME,    -- Time Stamp [TZNTSTMPS]
    SUPERIORFUNCTIONALLOCATION,      -- Object ID [EAMS_UI_OID_NAME]
    MAINTNOTIFDOWNTIMEDURATION,      -- Breakdown Dur. [EAUSZT]
    BOPFUUID,                        -- Draft Document ID [SDRAFT_UUID]
    MAINTNOTIFFAILUREEFFECTCATALOG,  -- Failure Effect Catlg [FAILURE_EFFECT_CATALOG]
    MAINTNOTIFFLREEFFECTCODEGROUP,   -- Fail Effect Code Grp [FAILURE_EFFECT_CODE_GRP]
    MAINTNOTIFFAILUREEFFECTCODE,     -- Failure Effect Code [FAILURE_EFFECT_CODE]
    MAINTENANCEREVISION,             -- Revision [REVNI]
    INSPECTIONLOT,                   -- Inspection Lot [QPLOS]
    MAINTORDERFOLLOWONNOTIFICATION,  -- Order [AUFNR]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- abap.char
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_QMIH_INCL_EEW_PS,          -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, MAINTENANCENOTIFICATION, DRAFTUUID)
);

Learn More