_MAINTENANCETASKLIST

_MAINTENANCETASKLIST is an SAP database table in S/4HANA. It contains 33 fields.

Fields (33)

KeyField CDS FieldsUsed in Views
_Assembly _Assembly 1
_InspExtNumbering _InspExtNumbering 1
_InspSubsetFieldCombination _InspSubsetFieldCombination 1
_MaintenanceStrategy _MaintenanceStrategy 1
_Plant _Plant 1
_ResponsiblePlannerGroup _ResponsiblePlannerGroup 1
_SafetyRelevance _SafetyRelevance 1
_TaskListStatus _TaskListStatus 1
_TaskListUsage _TaskListUsage 1
_TechnicalObject _TechnicalObject 1
_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc 1
Assembly Assembly 1
ChangeNumber ChangeNumber 1
Equipment Equipment 2
FunctionalLocation FunctionalLocation 1
InspExternalNumberingOfValues InspExternalNumberingOfValues 1
InspSubsetFieldCombination InspSubsetFieldCombination 1
LastChangeDate LastChangeDate 1
MaintenanceStrategy MaintenanceStrategy 1
Plant Plant 3
ReferenceElement ReferenceElement 1
ResponsiblePlannerGroup ResponsiblePlannerGroup 4
SafetyRelevantObject SafetyRelevantObject 1
TaskListDesc TaskListDesc 5
TaskListObjectKey TaskListObjectKey 1
TaskListStatus TaskListStatus 4
TaskListUsage TaskListUsage 1
TechnicalObject TechnicalObject 1
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc 2
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1
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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _MAINTENANCETASKLIST (
    _ASSEMBLY,
    _INSPEXTNUMBERING,
    _INSPSUBSETFIELDCOMBINATION,
    _MAINTENANCESTRATEGY,
    _PLANT,
    _RESPONSIBLEPLANNERGROUP,
    _SAFETYRELEVANCE,
    _TASKLISTSTATUS,
    _TASKLISTUSAGE,
    _TECHNICALOBJECT,
    _TECHOBJISEQUIPORFUNCNLLOC,
    ASSEMBLY,
    CHANGENUMBER,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    INSPEXTERNALNUMBERINGOFVALUES,
    INSPSUBSETFIELDCOMBINATION,
    LASTCHANGEDATE,
    MAINTENANCESTRATEGY,
    PLANT,
    REFERENCEELEMENT,
    RESPONSIBLEPLANNERGROUP,
    SAFETYRELEVANTOBJECT,
    TASKLISTDESC,
    TASKLISTOBJECTKEY,
    TASKLISTSTATUS,
    TASKLISTUSAGE,
    TECHNICALOBJECT,
    TECHOBJISEQUIPORFUNCNLLOC,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE
);