I_MaintTaskListOpPRT

DDL: I_MAINTTASKLISTOPPRT SQL: IMAINTTLOPPRT Type: view COMPOSITE

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 26 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter, TaskListSequence, TaskListOperationInternalId. It has 3 associations to related views.

1 data source(s) 26 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 (9)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IMAINTTLOPPRT view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE 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 (26)

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 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IMAINTTLOPPRT'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Maint. Task List Operation PRT'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #COMPOSITE


define view 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,
      
      ProdnRsceToolStandardWorkQty,
      
      ProdnRsceToolStdWorkQtyUnit,
      
      ProdnRsceToolTotQtyCalcFormula,
      
      ProdnRsceToolUsageQuantity,
      
      ProdnRsceToolUsageQuantityUnit,
      
      ProdnRsceToolUsageQtyCalcFmla,
      
      ProductionResourceType,
      
      ProductionResourceInternalID,
      
      ProdnRsceToolText,
      
      IsDeleted,

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

      /* Associations - locally defined */
      _MaintenanceTaskList,
      _ProdnRsceToolByInternalKey
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BOOOPERATIONPRTCHANGESTATE"
],
"ASSOCIATED":
[
"I_MAINTENANCETASKLIST",
"I_MAINTENANCETASKLISTTYPE",
"I_PRODNRSCETOOLBYINTERNALKEY",
"I_PRODNRSCETOOLMASTERDATA",
"I_PRODNRSCETOOLQTYCALCFORMULA",
"I_PRODUCTIONRESOURCETYPE",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_BOOOPERATIONPRTCHANGESTATE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More