I_MaintenanceTaskListData

DDL: I_MAINTENANCETASKLISTDATA SQL: IPMTASKLISTDATA Type: view COMPOSITE
44 Fields 1 Data Sources 2 Associations

Maintenance Task List Data

I_MaintenanceTaskListData is a Composite CDS View (Dimension) that provides data about "Maintenance Task List Data" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceTaskList) and exposes 44 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter, TaskListVersionCounter. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Data CategoryDimension
StatusReleased
Data Extraction TypeDelta-enabled, the extraction is based on field LastChangeDateTime .
Purpose
This CDS view provides the prerequisites for answering the following business questions: What are the details of the maintenance task lists (equipment/functional location/general task lists)? Which functional location is the maintenance task list assigned to? Which piece of equipment is the maintenance task list assigned to? Is the maintenance task list marked for deletion? What are the location details of the maintenance task list? What are the account assignment details of the maintenance task list? Note This CDS view is modeled for usage as a DataSource in Business Warehouse. We recommend that you only use it for this purpose.

Prerequisites
You have authorizations to display the relevant maintenance task lists in transactions IA03 , IA09 , IA13 , and IA07 . This check is based on the following fields: Task Lists by PM Planning Plant, Work Scheduler, Status ( I_ROUT1 ) Cost Center ( I_KOSTL ) Maintenance Planner Group ( I_INGRP ) Maintenance Planning Plant ( I_IWERK ) Maintenance Plant ( I_SWERK ) Authorization Group ( I_BEGRP )

Structure
Business Objects This view is built on the following business objects: Maintenance task list Main CDS parameters and filters This CDS view does not have any input parameters. Measures and attributes Some important measures and attributes are: Maintenance task list data Functional location number Equipment number Deletion flag Location data, for example Maintenance Plant Account assignment data, for example Cost Center and Controlling Area

Constraints
This CDS view contains only maintenance task lists (equipment, functional location, and general task lists), it does not support other task list types.

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceTaskList I_MaintenanceTaskList from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_EquipmentData _EquipmentData _EquipmentData.Equipment = $projection.Equipment
[0..1] I_FunctionalLocationData _FunctionalLocationData _FunctionalLocationData.FunctionalLocation = $projection.FunctionalLocation

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IPMTASKLISTDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Task List Data view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey TaskListVersionCounter view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.byElement.name LastChangeDateTime view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.modelingPattern #EXTRACTION_DATA_SOURCE view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.sapObjectNodeType.name MaintenanceTaskList view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY TaskListType TaskListType Task List Type
KEY TaskListGroup TaskListGroup Group
KEY TaskListGroupCounter TaskListGroupCounter Group Counter
KEY TaskListVersionCounter TaskListVersionCounter
TaskListDesc TaskListDesc
ControllingArea ControllingArea Controlling Area
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
Plant Plant Valuation Area
ResponsiblePlannerGroup ResponsiblePlannerGroup
Assembly Assembly Pegged Reqmt
MaintenanceStrategy MaintenanceStrategy
TaskListUsage TaskListUsage
BillOfOperationIsConfigurable BillOfOperationIsConfigurable
TaskListStatus TaskListStatus
OperationSystemCondition OperationSystemCondition SystemCondition
IsDeleted IsDeleted TRUE
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
ValidityStartDate ValidityStartDate Validity Start Date
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
LastChangeDateTime LastChangeDateTime Timestamp
WorkCenter _WorkCenter WorkCenter Work Center
WorkCenterPlant _WorkCenter Plant Valuation Area
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
_Assembly _Assembly
_ControllingArea _ControllingArea
_Equipment _Equipment
_EquipmentData _EquipmentData
_FunctionalLocation _FunctionalLocation
_FunctionalLocationData _FunctionalLocationData
_ConfigurableIndicator _ConfigurableIndicator
_MaintenancePlanningPlant _MaintenancePlanningPlant
_MaintenanceStrategy _MaintenanceStrategy
_OperationSystemCondition _OperationSystemCondition
_Plant _Plant
_ResponsiblePlannerGroup _ResponsiblePlannerGroup
_TaskListStatus _TaskListStatus
_TaskListType _TaskListType
_TaskListGroup _TaskListGroup
_TaskListGroupCounter _TaskListGroupCounter
_TaskListUsage _TaskListUsage
_WorkCenter _WorkCenter _WorkCenter
_WorkCenterPlant _WorkCenter _Plant

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_MaintenanceTaskListData.
-- 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: IPMTASKLISTDATA

CREATE VIEW I_MaintenanceTaskListData AS
SELECT
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  TaskListVersionCounter,
  TaskListDesc,
  ControllingArea,
  MaintenancePlanningPlant,
  Plant,
  ResponsiblePlannerGroup,
  Assembly,
  MaintenanceStrategy,
  TaskListUsage,
  BillOfOperationIsConfigurable,
  TaskListStatus,
  OperationSystemCondition,
  IsDeleted,
  IsMarkedForDeletion,
  ValidityStartDate,
  CreationDate,
  LastChangeDate,
  LastChangeDateTime,
  _WorkCenter.WorkCenter AS WorkCenter,
  _WorkCenter.Plant AS WorkCenterPlant,
  Equipment,
  FunctionalLocation,
  _WorkCenter._WorkCenter AS _WorkCenter,
  _WorkCenter._Plant AS _WorkCenterPlant
FROM I_MaintenanceTaskList
LEFT OUTER JOIN I_EquipmentData AS _EquipmentData ON _EquipmentData.Equipment = Equipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationData AS _FunctionalLocationData ON _FunctionalLocationData.FunctionalLocation = FunctionalLocation  -- association [0..1]
;

Learn More