I_MaintTaskListForKeyDate

DDL: I_MAINTTASKLISTFORKEYDATE Type: view_entity COMPOSITE

Maintenance Task List for Key Date

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

1 data source(s) 47 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceTaskList I_MaintenanceTaskList from

Parameters (1)

NameTypeDefault
P_KeyDate datum

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_User _CreatedByUser _CreatedByUser.UserID = $projection.CreatedByUser
[0..1] I_User _LastChangedByUser _LastChangedByUser.UserID = $projection.LastChangedByUser

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Maintenance Task List for Key Date view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY TaskListType TaskListType
KEY TaskListGroup TaskListGroup
KEY TaskListGroupCounter TaskListGroupCounter
TaskListDesc TaskListDesc
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
TaskListKeyDate
TechnicalObject TechnicalObject
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc
WorkCenterInternalID WorkCenterInternalID
Plant Plant
WorkCenterTypeCode WorkCenterTypeCode
MaintenanceStrategy MaintenanceStrategy
SafetyRelevantObject SafetyRelevantObject
ResponsiblePlannerGroup ResponsiblePlannerGroup
Assembly Assembly
TaskListStatus TaskListStatus
ChangeNumber ChangeNumber
TaskListUsage TaskListUsage
ReferenceElement ReferenceElement
InspSubsetFieldCombination InspSubsetFieldCombination
InspExternalNumberingOfValues InspExternalNumberingOfValues
TaskListObjectKey TaskListObjectKey
Equipment Equipment
IsDeleted IsDeleted
IsMarkedForDeletion IsMarkedForDeletion
CreatedByUser CreatedByUser
LastChangedByUser LastChangedByUser
CreationDate CreationDate
LastChangeDate LastChangeDate
CreatedByUserDescription _CreatedByUser UserDescription
LastChangedByUserDescription _LastChangedByUser UserDescription
_TechnicalObject _TechnicalObject
_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc
_WorkCenter _WorkCenter
_MaintenanceStrategy _MaintenanceStrategy
_SafetyRelevance _SafetyRelevance
_Plant _Plant
_ResponsiblePlannerGroup _ResponsiblePlannerGroup
_Assembly _Assembly
_TaskListUsage _TaskListUsage
_TaskListStatus _TaskListStatus
_PMReferenceElement _PMReferenceElement
_InspSubsetFieldCombination _InspSubsetFieldCombination
_InspExtNumbering _InspExtNumbering
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Maintenance Task List for Key Date'
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE

define view entity I_MaintTaskListForKeyDate
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate: datum
  as select from I_MaintenanceTaskList

    association [0..1] to I_User                     as _CreatedByUser             on  _CreatedByUser.UserID = $projection.CreatedByUser
    association [0..1] to I_User                     as _LastChangedByUser         on  _LastChangedByUser.UserID = $projection.LastChangedByUser
{
  key TaskListType,
  key TaskListGroup,
  key TaskListGroupCounter,
  TaskListDesc,
  ValidityStartDate,
  ValidityEndDate,
  $session.system_date as TaskListKeyDate,
  TechnicalObject,
  TechObjIsEquipOrFuncnlLoc,
  WorkCenterInternalID,
  Plant,
  WorkCenterTypeCode,
  MaintenanceStrategy,
  SafetyRelevantObject,
  ResponsiblePlannerGroup,
  Assembly,
  TaskListStatus,
  ChangeNumber,
  TaskListUsage,
  ReferenceElement,
  InspSubsetFieldCombination,
  InspExternalNumberingOfValues,
  TaskListObjectKey,
  Equipment,
  IsDeleted,
  IsMarkedForDeletion,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  LastChangeDate,
  _CreatedByUser.UserDescription as CreatedByUserDescription,
  _LastChangedByUser.UserDescription as LastChangedByUserDescription,

  //Associations

  _TechnicalObject,
  _TechObjIsEquipOrFuncnlLoc,
  _WorkCenter,
  _MaintenanceStrategy,
  _SafetyRelevance,
  _Plant,
  _ResponsiblePlannerGroup,
  _Assembly,
  _TaskListUsage,
  _TaskListStatus,
  _PMReferenceElement,
  _InspSubsetFieldCombination,
  _InspExtNumbering,
  _CreatedByUser,
  _LastChangedByUser
}
where ValidityStartDate      <= $parameters.P_KeyDate
  and ValidityEndDate        >= $parameters.P_KeyDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCETASKLIST",
"I_USER"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONSSTATUS",
"I_BILLOFOPERATIONSUSAGE",
"I_INSPEXTNUMBERINGOFVALUES",
"I_INSPSUBSETFIELDCOMBINATION",
"I_MAINTENANCESTRATEGY",
"I_MATERIAL",
"I_PLANT",
"I_PMREFERENCEELEMENT",
"I_RESPONSIBLEPLANNERGROUP",
"I_SAFETYRELEVANCE",
"I_TECHNICALOBJECT",
"I_TECHOBJISEQUIPORFUNCNLLOC",
"I_USER",
"I_WORKCENTER"
],
"BASE":
[
"I_MAINTENANCETASKLIST"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More