C_MaintenanceTaskListDEX

DDL: C_MAINTENANCETASKLISTDEX Type: view_entity CONSUMPTION
47 Fields 1 Data Sources 2 Associations

Maintenance Task List Data for DEX

C_MaintenanceTaskListDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Maintenance Task List · Asset Management

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

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-PRM-TL
CapabilitiesData Source for Data Extraction
PackageAsset Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceTaskList I_MaintenanceTaskList from

Associations (2)

CardinalityTargetAliasCondition
[0..1] C_EquipmentDataDEX _EquipmentData _EquipmentData.Equipment = $projection.Equipment and _EquipmentData.ValidityEndDate = '99991231' and _EquipmentData.EquipUsagePeriodSequenceNumber = '001'
[0..1] C_FunctionalLocationDEX _FunctionalLocationData _FunctionalLocationData.FunctionalLocation = $projection.FunctionalLocation

Annotations (13)

NameValueLevelField
EndUserText.label Maintenance Task List Data for DEX view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Analytics.internalName #LOCAL view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.modelingPattern #ANALYTICAL_FACT view
ObjectModel.sapObjectNodeType.name MaintenanceTaskList view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY TaskListType TaskListType Task List Type
KEY TaskListGroup TaskListGroup Key for Task List Group
KEY TaskListGroupCounter TaskListGroupCounter Group Counter
KEY TaskListVersionCounter TaskListVersionCounter Internal counter
TaskListDesc TaskListDesc Routing Description
ControllingArea ControllingArea Controlling Area
MaintenancePlanningPlant MaintenancePlanningPlant Maintenance Planning Plant
Plant Plant Valuation Area
ResponsiblePlannerGroup ResponsiblePlannerGroup Responsible Planner Group or Department
Assembly Assembly Pegged Reqmt
MaintenanceStrategy MaintenanceStrategy Maintenance Strategy
TaskListUsage TaskListUsage Task List Usage
BillOfOperationIsConfigurable BillOfOperationIsConfigurable Configurable Material
TaskListStatus TaskListStatus Status
OperationSystemCondition OperationSystemCondition System Condition
IsDeleted IsDeleted Deletion Indicator
IsMarkedForDeletion IsMarkedForDeletion Indicator: Delete completely in reorganization run
ValidityStartDate ValidityStartDate Validity Start Date
CreationDate CreationDate Date Record Created On
LastChangeDate LastChangeDate Date of the last change made to the task list
LastChangeDateTime LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
WorkCenter _WorkCenter WorkCenter Work Center
WorkCenterPlant _WorkCenter Plant Plant of Work Center
Equipment Equipment Equipment Number
FunctionalLocation FunctionalLocation Functional Location
TechnicalObject TechnicalObject Technical Object
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Technical Object Type
_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
_TechnicalObject _TechnicalObject

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 C_MaintenanceTaskListDEX.
-- 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.

CREATE VIEW C_MaintenanceTaskListDEX 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,
  TechnicalObject,
  TechObjIsEquipOrFuncnlLoc,
  _WorkCenter._WorkCenter AS _WorkCenter,
  _WorkCenter._Plant AS _WorkCenterPlant
FROM I_MaintenanceTaskList
LEFT OUTER JOIN C_EquipmentDataDEX AS _EquipmentData ON _EquipmentData.Equipment = Equipment AND _EquipmentData.ValidityEndDate = '99991231' AND _EquipmentData.EquipUsagePeriodSequenceNumber = '001'  -- association [0..1]
LEFT OUTER JOIN C_FunctionalLocationDEX AS _FunctionalLocationData ON _FunctionalLocationData.FunctionalLocation = FunctionalLocation  -- association [0..1]
;

Learn More