I_MaintenanceTaskListTP

DDL: I_MAINTENANCETASKLISTTP SQL: IMAINTTASKLISTTP Type: view_entity TRANSACTIONAL

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
KEY TaskListGroup I_MaintenanceTaskList TaskListGroup
KEY TaskListGroupCounter I_MaintenanceTaskList TaskListGroupCounter
TaskListDesc I_MaintenanceTaskList TaskListDesc
MaintenanceStrategy I_MaintenanceTaskList MaintenanceStrategy
Plant I_MaintenanceTaskList Plant
ResponsiblePlannerGroup I_MaintenanceTaskList ResponsiblePlannerGroup
WorkCenterTypeCode I_MaintenanceTaskList WorkCenterTypeCode
WorkCenterInternalID I_MaintenanceTaskList WorkCenterInternalID
TaskListStatus I_MaintenanceTaskList TaskListStatus
ValidityStartDate I_MaintenanceTaskList ValidityStartDate
ValidityEndDate I_MaintenanceTaskList ValidityEndDate
ChangeNumber I_MaintenanceTaskList ChangeNumber
Assembly I_MaintenanceTaskList Assembly
OperationSystemCondition I_MaintenanceTaskList OperationSystemCondition
ReferenceElement I_MaintenanceTaskList ReferenceElement
TaskListUsage I_MaintenanceTaskList TaskListUsage
InspSubsetFieldCombination I_MaintenanceTaskList InspSubsetFieldCombination
InspExternalNumberingOfValues I_MaintenanceTaskList InspExternalNumberingOfValues
TechObjIsEquipOrFuncnlLoc I_MaintenanceTaskList TechObjIsEquipOrFuncnlLoc
TechnicalObject I_MaintenanceTaskList TechnicalObject
TaskListObjectKey I_MaintenanceTaskList TaskListObjectKey
SafetyRelevantObject I_MaintenanceTaskList SafetyRelevantObject
IsDeleted I_MaintenanceTaskList IsDeleted
Equipment I_MaintenanceTaskList Equipment
FunctionalLocationLabelName I_MaintenanceTaskList FunctionalLocationLabelName
TaskListVersionCounter I_MaintenanceTaskList TaskListVersionCounter
LastChangeDate I_MaintenanceTaskList LastChangeDate
LastChangedByUser I_MaintenanceTaskList LastChangedByUser
CreatedByUser I_MaintenanceTaskList CreatedByUser
CreationDate I_MaintenanceTaskList CreationDate
BillOfOperationsUsage I_MaintenanceTaskList BillOfOperationsUsage
MaintenancePlanningPlant I_MaintenanceTaskList MaintenancePlanningPlant
TaskListIsHierarchical I_MaintenanceTaskList TaskListIsHierarchical
IsMarkedForDeletion I_MaintenanceTaskList IsMarkedForDeletion
_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
//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

//@AbapCatalog.sqlViewName: 'IMAINTTASKLISTTP'

@AccessControl.authorizationCheck: #CHECK
//@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Maintenance Task List'
@ObjectModel.compositionRoot: true
//@ObjectModel.transactionalProcessingEnabled: true

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
//@ObjectModel.writeActivePersistence: 'IMAINTTASKLISTTP'

@VDM.viewType: #TRANSACTIONAL


define root view entity I_MaintenanceTaskListTP
  as select from I_MaintenanceTaskList as _MaintenanceTaskList
  association [0..*] to I_MaintTaskListOperationTP as _MaintTaskListOperationTP on  _MaintTaskListOperationTP.TaskListType         = $projection.TaskListType
                                                                                and _MaintTaskListOperationTP.TaskListGroup        = $projection.TaskListGroup
                                                                                and _MaintTaskListOperationTP.TaskListGroupCounter = $projection.TaskListGroupCounter
{
  key _MaintenanceTaskList.TaskListType,
  key _MaintenanceTaskList.TaskListGroup,
  key _MaintenanceTaskList.TaskListGroupCounter,

      _MaintenanceTaskList.TaskListDesc,
      _MaintenanceTaskList.MaintenanceStrategy,
      _MaintenanceTaskList.Plant,
      _MaintenanceTaskList.ResponsiblePlannerGroup,
      _MaintenanceTaskList.WorkCenterTypeCode,
      _MaintenanceTaskList.WorkCenterInternalID,
      _MaintenanceTaskList.TaskListStatus,
      _MaintenanceTaskList.ValidityStartDate,
      _MaintenanceTaskList.ValidityEndDate,
      _MaintenanceTaskList.ChangeNumber,
      _MaintenanceTaskList.Assembly,
      _MaintenanceTaskList.OperationSystemCondition,
      _MaintenanceTaskList.ReferenceElement,
      _MaintenanceTaskList.TaskListUsage,
      _MaintenanceTaskList.InspSubsetFieldCombination,
      _MaintenanceTaskList.InspExternalNumberingOfValues,
      _MaintenanceTaskList.TechObjIsEquipOrFuncnlLoc,
      _MaintenanceTaskList.TechnicalObject,
      _MaintenanceTaskList.TaskListObjectKey,
      _MaintenanceTaskList.SafetyRelevantObject,
      _MaintenanceTaskList.IsDeleted,
      _MaintenanceTaskList.Equipment,
      _MaintenanceTaskList.FunctionalLocationLabelName,
      _MaintenanceTaskList.TaskListVersionCounter,
      _MaintenanceTaskList.LastChangeDate,
      _MaintenanceTaskList.LastChangedByUser,
      _MaintenanceTaskList.CreatedByUser,
      _MaintenanceTaskList.CreationDate,
      _MaintenanceTaskList.BillOfOperationsUsage,
      _MaintenanceTaskList.MaintenancePlanningPlant,
      _MaintenanceTaskList.TaskListIsHierarchical,
      _MaintenanceTaskList.IsMarkedForDeletion,

      _MaintenanceTaskList._Assembly,
      _MaintenanceTaskList._InspExtNumbering,
      _MaintenanceTaskList._InspSubsetFieldCombination,
      _MaintenanceTaskList._MaintenanceStrategy,
      _MaintenanceTaskList._MaintTaskListOperation,
      _MaintenanceTaskList._OperationSystemCondition,
      _MaintenanceTaskList._Plant,
      _MaintenanceTaskList._PMReferenceElement,
      _MaintenanceTaskList._ResponsiblePlannerGroup,
      _MaintenanceTaskList._SafetyRelevance,
      _MaintenanceTaskList._TaskListGroup,
      _MaintenanceTaskList._TaskListStatus,
      _MaintenanceTaskList._TaskListType,
      _MaintenanceTaskList._TaskListUsage,
      _MaintenanceTaskList._TechnicalObject,
      _MaintenanceTaskList._TechObjIsEquipOrFuncnlLoc,
      _MaintenanceTaskList._WorkCenter,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MaintTaskListOperationTP
}