I_MaintTaskListOpPRT

DDL: I_MAINTTASKLISTOPPRT Type: view_entity COMPOSITE Package: ODATA_EAM_TASKLIST_MAN

Maint. Task List Operation PRT

I_MaintTaskListOpPRT is a Composite CDS View that provides data about "Maint. Task List Operation PRT" in SAP S/4HANA. It reads from 1 data source (I_BOOOperationPRTChangeState) and exposes 27 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter, TaskListSequence, TaskListOperationInternalId. It has 3 associations to related views. Part of development package ODATA_EAM_TASKLIST_MAN.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_BOOOperationPRTChangeState I_BOOOperationPRTChangeState from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ProdnRsceToolByInternalKey _ProdnRsceToolByInternalKey _ProdnRsceToolByInternalKey.ProductionResourceType = $projection.ProductionResourceType and _ProdnRsceToolByInternalKey.ProductionResourceInternalID = $projection.ProductionResourceInternalID
[1..1] I_MaintenanceTaskList _MaintenanceTaskList _MaintenanceTaskList.TaskListType = $projection.TaskListType and _MaintenanceTaskList.TaskListGroup = $projection.TaskListGroup and _MaintenanceTaskList.TaskListGroupCounter = $projection.TaskListGroupCounter
[1..1] I_MaintenanceTaskListType _TaskListType _TaskListType.TaskListType = $projection.TaskListType

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maint. Task List Operation PRT view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY TaskListType BillOfOperationsType
KEY TaskListGroup BillOfOperationsGroup
KEY TaskListGroupCounter BillOfOperationsVariant
KEY TaskListSequence BillOfOperationsSequence
KEY TaskListOperationInternalId BOOOperationInternalID
KEY TaskListOpPRTIntID BOOOperationPRTInternalID
KEY TaskListOpPRTIntVersCounter BOOOperationPRTIntVersCounter
ProdnRsceToolItemNumber ProdnRsceToolItemNumber
ProdnRsceToolStandardWorkQty ProdnRsceToolStandardWorkQty
ProdnRsceToolStdWorkQtyUnit ProdnRsceToolStdWorkQtyUnit
ProdnRsceToolTotQtyCalcFormula ProdnRsceToolTotQtyCalcFormula
ProdnRsceToolUsageQuantity ProdnRsceToolUsageQuantity
ProdnRsceToolUsageQuantityUnit ProdnRsceToolUsageQuantityUnit
ProdnRsceToolUsageQtyCalcFmla ProdnRsceToolUsageQtyCalcFmla
ProductionResourceType ProductionResourceType
ProductionResourceInternalID ProductionResourceInternalID
ProdnRsceToolText ProdnRsceToolText
IsDeleted IsDeleted
_ProductionResourceType _ProductionResourceType
_ProdnRsceToolMasterData _ProdnRsceToolMasterData
_ProdnRsceToolTotQtyCalcFmla _ProdnRsceToolTotQtyCalcFmla
_ProdnRsceToolUsageQtyCalcFmla _ProdnRsceToolUsageQtyCalcFmla
_ProductionResourceToolUnit _ProductionResourceToolUnit
_ProdnResourceToolUsageUnit _ProdnResourceToolUsageUnit
_MaintenanceTaskList _MaintenanceTaskList
_ProdnRsceToolByInternalKey _ProdnRsceToolByInternalKey
_TaskListType _TaskListType 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maint. Task List Operation PRT'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #COMPOSITE


define view entity I_MaintTaskListOpPRT
  as select from I_BOOOperationPRTChangeState
  
  association [1..1] to I_ProdnRsceToolByInternalKey as _ProdnRsceToolByInternalKey on  _ProdnRsceToolByInternalKey.ProductionResourceType       = $projection.ProductionResourceType
                                                                                    and _ProdnRsceToolByInternalKey.ProductionResourceInternalID = $projection.ProductionResourceInternalID
  
  association [1..1] to I_MaintenanceTaskList        as _MaintenanceTaskList        on  _MaintenanceTaskList.TaskListType         = $projection.TaskListType
                                                                                    and _MaintenanceTaskList.TaskListGroup        = $projection.TaskListGroup
                                                                                    and _MaintenanceTaskList.TaskListGroupCounter = $projection.TaskListGroupCounter
  
  association [1..1] to I_MaintenanceTaskListType    as _TaskListType               on  _TaskListType.TaskListType = $projection.TaskListType

{
      @ObjectModel.foreignKey.association: '_TaskListType'
  key BillOfOperationsType          as TaskListType,

  key BillOfOperationsGroup         as TaskListGroup,

  key BillOfOperationsVariant       as TaskListGroupCounter,

  key BillOfOperationsSequence      as TaskListSequence,

  key BOOOperationInternalID        as TaskListOperationInternalId,

  key BOOOperationPRTInternalID     as TaskListOpPRTIntID,

  key BOOOperationPRTIntVersCounter as TaskListOpPRTIntVersCounter,

      ProdnRsceToolItemNumber,
      
      @Semantics.quantity.unitOfMeasure: 'PRODNRSCETOOLSTDWORKQTYUNIT' 
ProdnRsceToolStandardWorkQty,
      
      ProdnRsceToolStdWorkQtyUnit,
      
      ProdnRsceToolTotQtyCalcFormula,
      
      @Semantics.quantity.unitOfMeasure: 'PRODNRSCETOOLUSAGEQUANTITYUNIT' 
ProdnRsceToolUsageQuantity,
      
      ProdnRsceToolUsageQuantityUnit,
      
      ProdnRsceToolUsageQtyCalcFmla,
      
      ProductionResourceType,
      
      ProductionResourceInternalID,
      
      ProdnRsceToolText,
      
      IsDeleted,

      /* Associations */
      _ProductionResourceType,
      _ProdnRsceToolMasterData,
      _ProdnRsceToolTotQtyCalcFmla,
      _ProdnRsceToolUsageQtyCalcFmla,
      _ProductionResourceToolUnit,
      _ProdnResourceToolUsageUnit,

      /* Associations - locally defined */
      _MaintenanceTaskList,
      _ProdnRsceToolByInternalKey,
      _TaskListType
}

Learn More