I_MaintenanceTaskListTP

DDL: I_MAINTENANCETASKLISTTP SQL: IMAINTTASKLISTTP Type: view_entity TRANSACTIONAL
53 Fields 1 Data Sources 1 Associations

Maintenance Task List

I_MaintenanceTaskListTP is a Transactional CDS View that provides data about "Maintenance Task List" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceTaskList) and exposes 53 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceTaskList _MaintenanceTaskList from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_MaintTaskListOperationTP _MaintTaskListOperationTP _MaintTaskListOperationTP.TaskListType = $projection.TaskListType and _MaintTaskListOperationTP.TaskListGroup = $projection.TaskListGroup and _MaintTaskListOperationTP.TaskListGroupCounter = $projection.TaskListGroupCounter

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Task List view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #TRANSACTIONAL view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY TaskListType I_MaintenanceTaskList TaskListType Task List Type
KEY TaskListGroup I_MaintenanceTaskList TaskListGroup Group
KEY TaskListGroupCounter I_MaintenanceTaskList TaskListGroupCounter Group Counter
TaskListDesc I_MaintenanceTaskList TaskListDesc
MaintenanceStrategy I_MaintenanceTaskList MaintenanceStrategy
Plant I_MaintenanceTaskList Plant Valuation Area
ResponsiblePlannerGroup I_MaintenanceTaskList ResponsiblePlannerGroup
WorkCenterTypeCode I_MaintenanceTaskList WorkCenterTypeCode Object Type
WorkCenterInternalID I_MaintenanceTaskList WorkCenterInternalID Work Center
TaskListStatus I_MaintenanceTaskList TaskListStatus
ValidityStartDate I_MaintenanceTaskList ValidityStartDate Validity Start Date
ValidityEndDate I_MaintenanceTaskList ValidityEndDate ValidTo
ChangeNumber I_MaintenanceTaskList ChangeNumber Change Number
Assembly I_MaintenanceTaskList Assembly Pegged Reqmt
OperationSystemCondition I_MaintenanceTaskList OperationSystemCondition SystemCondition
ReferenceElement I_MaintenanceTaskList ReferenceElement Ref. Element PM/PS
TaskListUsage I_MaintenanceTaskList TaskListUsage
InspSubsetFieldCombination I_MaintenanceTaskList InspSubsetFieldCombination
InspExternalNumberingOfValues I_MaintenanceTaskList InspExternalNumberingOfValues
TechObjIsEquipOrFuncnlLoc I_MaintenanceTaskList TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
TechnicalObject I_MaintenanceTaskList TechnicalObject Technical Object
TaskListObjectKey I_MaintenanceTaskList TaskListObjectKey
SafetyRelevantObject I_MaintenanceTaskList SafetyRelevantObject
IsDeleted I_MaintenanceTaskList IsDeleted TRUE
Equipment I_MaintenanceTaskList Equipment Equipment check
FunctionalLocationLabelName I_MaintenanceTaskList FunctionalLocationLabelName Functional Loc.
TaskListVersionCounter I_MaintenanceTaskList TaskListVersionCounter
LastChangeDate I_MaintenanceTaskList LastChangeDate Time Stamp
LastChangedByUser I_MaintenanceTaskList LastChangedByUser User Name
CreatedByUser I_MaintenanceTaskList CreatedByUser User Name
CreationDate I_MaintenanceTaskList CreationDate Time Stamp
BillOfOperationsUsage I_MaintenanceTaskList BillOfOperationsUsage
MaintenancePlanningPlant I_MaintenanceTaskList MaintenancePlanningPlant Planning Plant
TaskListIsHierarchical I_MaintenanceTaskList TaskListIsHierarchical
IsMarkedForDeletion I_MaintenanceTaskList IsMarkedForDeletion Purch.org. data
_Assembly I_MaintenanceTaskList _Assembly
_InspExtNumbering I_MaintenanceTaskList _InspExtNumbering
_InspSubsetFieldCombination I_MaintenanceTaskList _InspSubsetFieldCombination
_MaintenanceStrategy I_MaintenanceTaskList _MaintenanceStrategy
_MaintTaskListOperation I_MaintenanceTaskList _MaintTaskListOperation
_OperationSystemCondition I_MaintenanceTaskList _OperationSystemCondition
_Plant I_MaintenanceTaskList _Plant
_PMReferenceElement I_MaintenanceTaskList _PMReferenceElement
_ResponsiblePlannerGroup I_MaintenanceTaskList _ResponsiblePlannerGroup
_SafetyRelevance I_MaintenanceTaskList _SafetyRelevance
_TaskListGroup I_MaintenanceTaskList _TaskListGroup
_TaskListStatus I_MaintenanceTaskList _TaskListStatus
_TaskListType I_MaintenanceTaskList _TaskListType
_TaskListUsage I_MaintenanceTaskList _TaskListUsage
_TechnicalObject I_MaintenanceTaskList _TechnicalObject
_TechObjIsEquipOrFuncnlLoc I_MaintenanceTaskList _TechObjIsEquipOrFuncnlLoc
_WorkCenter I_MaintenanceTaskList _WorkCenter
_MaintTaskListOperationTP _MaintTaskListOperationTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MaintenanceTaskListTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMAINTTASKLISTTP

CREATE VIEW I_MaintenanceTaskListTP AS
SELECT
  _MaintenanceTaskList.TaskListType AS TaskListType,
  _MaintenanceTaskList.TaskListGroup AS TaskListGroup,
  _MaintenanceTaskList.TaskListGroupCounter AS TaskListGroupCounter,
  _MaintenanceTaskList.TaskListDesc AS TaskListDesc,
  _MaintenanceTaskList.MaintenanceStrategy AS MaintenanceStrategy,
  _MaintenanceTaskList.Plant AS Plant,
  _MaintenanceTaskList.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  _MaintenanceTaskList.WorkCenterTypeCode AS WorkCenterTypeCode,
  _MaintenanceTaskList.WorkCenterInternalID AS WorkCenterInternalID,
  _MaintenanceTaskList.TaskListStatus AS TaskListStatus,
  _MaintenanceTaskList.ValidityStartDate AS ValidityStartDate,
  _MaintenanceTaskList.ValidityEndDate AS ValidityEndDate,
  _MaintenanceTaskList.ChangeNumber AS ChangeNumber,
  _MaintenanceTaskList.Assembly AS Assembly,
  _MaintenanceTaskList.OperationSystemCondition AS OperationSystemCondition,
  _MaintenanceTaskList.ReferenceElement AS ReferenceElement,
  _MaintenanceTaskList.TaskListUsage AS TaskListUsage,
  _MaintenanceTaskList.InspSubsetFieldCombination AS InspSubsetFieldCombination,
  _MaintenanceTaskList.InspExternalNumberingOfValues AS InspExternalNumberingOfValues,
  _MaintenanceTaskList.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _MaintenanceTaskList.TechnicalObject AS TechnicalObject,
  _MaintenanceTaskList.TaskListObjectKey AS TaskListObjectKey,
  _MaintenanceTaskList.SafetyRelevantObject AS SafetyRelevantObject,
  _MaintenanceTaskList.IsDeleted AS IsDeleted,
  _MaintenanceTaskList.Equipment AS Equipment,
  _MaintenanceTaskList.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  _MaintenanceTaskList.TaskListVersionCounter AS TaskListVersionCounter,
  _MaintenanceTaskList.LastChangeDate AS LastChangeDate,
  _MaintenanceTaskList.LastChangedByUser AS LastChangedByUser,
  _MaintenanceTaskList.CreatedByUser AS CreatedByUser,
  _MaintenanceTaskList.CreationDate AS CreationDate,
  _MaintenanceTaskList.BillOfOperationsUsage AS BillOfOperationsUsage,
  _MaintenanceTaskList.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _MaintenanceTaskList.TaskListIsHierarchical AS TaskListIsHierarchical,
  _MaintenanceTaskList.IsMarkedForDeletion AS IsMarkedForDeletion,
  _MaintenanceTaskList._Assembly AS _Assembly,
  _MaintenanceTaskList._InspExtNumbering AS _InspExtNumbering,
  _MaintenanceTaskList._InspSubsetFieldCombination AS _InspSubsetFieldCombination,
  _MaintenanceTaskList._MaintenanceStrategy AS _MaintenanceStrategy,
  _MaintenanceTaskList._MaintTaskListOperation AS _MaintTaskListOperation,
  _MaintenanceTaskList._OperationSystemCondition AS _OperationSystemCondition,
  _MaintenanceTaskList._Plant AS _Plant,
  _MaintenanceTaskList._PMReferenceElement AS _PMReferenceElement,
  _MaintenanceTaskList._ResponsiblePlannerGroup AS _ResponsiblePlannerGroup,
  _MaintenanceTaskList._SafetyRelevance AS _SafetyRelevance,
  _MaintenanceTaskList._TaskListGroup AS _TaskListGroup,
  _MaintenanceTaskList._TaskListStatus AS _TaskListStatus,
  _MaintenanceTaskList._TaskListType AS _TaskListType,
  _MaintenanceTaskList._TaskListUsage AS _TaskListUsage,
  _MaintenanceTaskList._TechnicalObject AS _TechnicalObject,
  _MaintenanceTaskList._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc,
  _MaintenanceTaskList._WorkCenter AS _WorkCenter
FROM I_MaintenanceTaskList AS _MaintenanceTaskList
LEFT OUTER JOIN I_MaintTaskListOperationTP AS _MaintTaskListOperationTP ON _MaintTaskListOperationTP.TaskListType = TaskListType AND _MaintTaskListOperationTP.TaskListGroup = TaskListGroup AND _MaintTaskListOperationTP.TaskListGroupCounter = TaskListGroupCounter  -- association [0..*]
;

Learn More