I_MAINTENANCETASKLIST

CDS View
52 Fields 11 CDS Views

Maintenance Task List

I_MAINTENANCETASKLIST is a CDS View in S/4HANA. Maintenance Task List. It contains 52 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_MaintenanceTaskListDEX view_entity from CONSUMPTION Maintenance Task List Data for DEX
C_MaintTaskListQuickVw view from CONSUMPTION Task list long text quickview
I_MaintenanceTaskListData view from COMPOSITE Maintenance Task List Data
I_MaintenanceTaskListStdVH view_entity from COMPOSITE Maintenance Task List
I_MaintenanceTaskListTP view_entity from TRANSACTIONAL Maintenance Task List
I_MaintenanceTaskListValueHelp view from COMPOSITE Maintenance Task List
I_MaintTaskListForKeyDate view_entity from COMPOSITE Maintenance Task List for Key Date
P_MaintTaskListLatestDesc view_entity from COMPOSITE Maintenance Task List Latest Description
P_MaintTaskListSearch view from COMPOSITE Maintenance Tasklist anchor view for CDS search model
R_MaintenanceTaskListBasicTP view_entity from TRANSACTIONAL TP View for Tasklist Header Details
R_TaskListLongTextTP view_entity from TRANSACTIONAL Long Text view for Maintenance Tasklist

Fields (52)

KeyField CDS FieldsUsed in Views
KEY TaskListGroup TaskListGroup 2
KEY TaskListGroupCounter TaskListGroupCounter 2
KEY TaskListType TaskListType 2
KEY TaskListVersionCounter TaskListVersionCounter 2
_Assembly _Assembly 1
_InspExtNumbering _InspExtNumbering 1
_InspSubsetFieldCombination _InspSubsetFieldCombination 1
_MaintenanceStrategy _MaintenanceStrategy 1
_MaintTaskListOperation _MaintTaskListOperation 1
_OperationSystemCondition _OperationSystemCondition 1
_Plant _Plant 1
_PMReferenceElement _PMReferenceElement 1
_ResponsiblePlannerGroup _ResponsiblePlannerGroup 1
_SafetyRelevance _SafetyRelevance 1
_TaskListGroup _TaskListGroup 1
_TaskListStatus _TaskListStatus 1
_TaskListType _TaskListType 1
_TaskListUsage _TaskListUsage 1
_TechnicalObject _TechnicalObject 1
_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc 1
_WorkCenter _WorkCenter 1
Assembly Assembly 1
BillOfOperationsUsage BillOfOperationsUsage 1
ChangeNumber ChangeNumber 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
Equipment Equipment 1
FunctionalLocationLabelName FunctionalLocationLabelName 1
InspExternalNumberingOfValues InspExternalNumberingOfValues 1
InspSubsetFieldCombination InspSubsetFieldCombination 1
IsDeleted IsDeleted 1
IsMarkedForDeletion IsMarkedForDeletion 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
MaintenancePlanningPlant MaintenancePlanningPlant 1
MaintenanceStrategy MaintenanceStrategy 1
OperationSystemCondition OperationSystemCondition 1
Plant Plant 1
ReferenceElement ReferenceElement 1
ResponsiblePlannerGroup ResponsiblePlannerGroup 1
SafetyRelevantObject SafetyRelevantObject 1
TaskListDesc TaskListDesc 1
TaskListIsHierarchical TaskListIsHierarchical 1
TaskListObjectKey TaskListObjectKey 1
TaskListStatus TaskListStatus 1
TaskListUsage TaskListUsage 1
TechnicalObject TechnicalObject 1
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc 1
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2
WorkCenterInternalID WorkCenterInternalID 1
WorkCenterTypeCode WorkCenterTypeCode 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 Task List
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTENANCETASKLIST (
    TASKLISTGROUP,
    TASKLISTGROUPCOUNTER,
    TASKLISTTYPE,
    TASKLISTVERSIONCOUNTER,
    _ASSEMBLY,
    _INSPEXTNUMBERING,
    _INSPSUBSETFIELDCOMBINATION,
    _MAINTENANCESTRATEGY,
    _MAINTTASKLISTOPERATION,
    _OPERATIONSYSTEMCONDITION,
    _PLANT,
    _PMREFERENCEELEMENT,
    _RESPONSIBLEPLANNERGROUP,
    _SAFETYRELEVANCE,
    _TASKLISTGROUP,
    _TASKLISTSTATUS,
    _TASKLISTTYPE,
    _TASKLISTUSAGE,
    _TECHNICALOBJECT,
    _TECHOBJISEQUIPORFUNCNLLOC,
    _WORKCENTER,
    ASSEMBLY,
    BILLOFOPERATIONSUSAGE,
    CHANGENUMBER,
    CREATEDBYUSER,
    CREATIONDATE,
    EQUIPMENT,
    FUNCTIONALLOCATIONLABELNAME,
    INSPEXTERNALNUMBERINGOFVALUES,
    INSPSUBSETFIELDCOMBINATION,
    ISDELETED,
    ISMARKEDFORDELETION,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCESTRATEGY,
    OPERATIONSYSTEMCONDITION,
    PLANT,
    REFERENCEELEMENT,
    RESPONSIBLEPLANNERGROUP,
    SAFETYRELEVANTOBJECT,
    TASKLISTDESC,
    TASKLISTISHIERARCHICAL,
    TASKLISTOBJECTKEY,
    TASKLISTSTATUS,
    TASKLISTUSAGE,
    TECHNICALOBJECT,
    TECHOBJISEQUIPORFUNCNLLOC,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (TASKLISTGROUP, TASKLISTGROUPCOUNTER, TASKLISTTYPE, TASKLISTVERSIONCOUNTER)
);

Learn More