I_MaintTaskListOpTechObj

DDL: I_MAINTTASKLISTOPTECHOBJ SQL: IMAINTTLOPTECOBJ Type: view COMPOSITE Package: ODATA_EAM_TASKLIST_MAN

Maint. Task List Operation w/ Tech. Obj.

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

1 data source(s) 70 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintTaskListOperation I_MaintTaskListOperation from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_TechnicalObject _TechnicalObject _TechnicalObject.TechnicalObject = $projection.TechnicalObject and _TechnicalObject.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc
[0..1] I_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc
[0..1] I_Currency _Currency _Currency.Currency = $projection.OpExternalProcessingCurrency
[0..1] I_PurgInfoRecdOrgPlantData _PurgInfoRecdOrgPlantData _PurgInfoRecdOrgPlantData.PurchasingInfoRecord = $projection.PurchasingInfoRecord and _PurgInfoRecdOrgPlantData.PurchasingOrganization = $projection.PurchasingOrganization and _PurgInfoRecdOrgPlantData.PurchasingInfoRecordCategory = $projection.PurchasingInfoRecordCategory and _PurgInfoRecdOrgPlantData.Plant = $projection.Plant

Annotations (9)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IMAINTTLOPTECOBJ view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Maint. Task List Operation w/ Tech. Obj. view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view

Fields (70)

KeyFieldSource TableSource FieldDescription
KEY TaskListType I_MaintTaskListOperation TaskListType
KEY TaskListGroup I_MaintTaskListOperation TaskListGroup
KEY TaskListGroupCounter I_MaintTaskListOperation TaskListGroupCounter
KEY TaskListSequence I_MaintTaskListOperation TaskListSequence
KEY TaskListOperationInternalId I_MaintTaskListOperation TaskListOperationInternalId
TaskListOpBOMItmIntVersCounter I_MaintTaskListOperation TaskListOpBOMItmIntVersCounter
MaintenanceTaskListOperation I_MaintTaskListOperation MaintenanceTaskListOperation
MaintTaskListSubOperation I_MaintTaskListOperation MaintTaskListSubOperation
OperationText I_MaintTaskListOperation OperationText
OperationControlProfile I_MaintTaskListOperation OperationControlProfile
WorkCenterInternalID I_MaintTaskListOperation WorkCenterInternalID
WorkCenterTypeCode I_MaintTaskListOperation WorkCenterTypeCode
Plant I_MaintTaskListOperation Plant
OpPlannedWorkQuantity I_MaintTaskListOperation OpPlannedWorkQuantity
OpWorkQuantityUnit I_MaintTaskListOperation OpWorkQuantityUnit
ChangeNumber I_MaintTaskListOperation ChangeNumber
ValidityStartDate I_MaintTaskListOperation ValidityStartDate
ValidityEndDate I_MaintTaskListOperation ValidityEndDate
OperationStandardTextCode I_MaintTaskListOperation OperationStandardTextCode
PurchasingInfoRecdAddlGrpgName I_MaintTaskListOperation PurchasingInfoRecdAddlGrpgName
PurchasingInfoRecord I_MaintTaskListOperation PurchasingInfoRecord
PurchasingInfoRecordCategory I_MaintTaskListOperation PurchasingInfoRecordCategory
PurchasingOrganization I_MaintTaskListOperation PurchasingOrganization
Supplier I_MaintTaskListOperation Supplier
PurchaseContract I_MaintTaskListOperation PurchaseContract
PurchaseContractItem I_MaintTaskListOperation PurchaseContractItem
OperationStandardDuration I_MaintTaskListOperation OperationStandardDuration
OperationStandardDurationUnit I_MaintTaskListOperation OperationStandardDurationUnit
NumberOfCapacities I_MaintTaskListOperation NumberOfCapacities
OperationSystemCondition I_MaintTaskListOperation OperationSystemCondition
CostCtrActivityType I_MaintTaskListOperation CostCtrActivityType
OperationCalculationControl I_MaintTaskListOperation OperationCalculationControl
Assembly I_MaintTaskListOperation Assembly
PurchaseOrderQty I_MaintTaskListOperation PurchaseOrderQty
PurchaseOrderQuantityUnit I_MaintTaskListOperation PurchaseOrderQuantityUnit
FunctionalLocation I_MaintTaskListOperation FunctionalLocation
Equipment I_MaintTaskListOperation Equipment
IsDeleted I_MaintTaskListOperation IsDeleted
IsImplicitlyDeleted I_MaintTaskListOperation IsImplicitlyDeleted
TaskListOperationObjectKey I_MaintTaskListOperation TaskListOperationObjectKey
MaintOperationExecStageCode I_MaintTaskListOperation MaintOperationExecStageCode
BillOfOperationsGroup I_MaintTaskListOperation BillOfOperationsGroup
BillOfOperationsType I_MaintTaskListOperation BillOfOperationsType
BOOOperationInternalID I_MaintTaskListOperation BOOOperationInternalID
_Currency _Currency
_Assembly I_MaintTaskListOperation _Assembly
_ChangeMaster I_MaintTaskListOperation _ChangeMaster
_Equipment I_MaintTaskListOperation _Equipment
_FunctionalLocation I_MaintTaskListOperation _FunctionalLocation
_MaintenanceTaskList I_MaintTaskListOperation _MaintenanceTaskList
_OperationCalculationControl I_MaintTaskListOperation _OperationCalculationControl
_OperationControlProfile I_MaintTaskListOperation _OperationControlProfile
_OperationStandardText I_MaintTaskListOperation _OperationStandardText
_OperationSystemCondition I_MaintTaskListOperation _OperationSystemCondition
_Plant I_MaintTaskListOperation _Plant
_PurchaseContract I_MaintTaskListOperation _PurchaseContract
_PurchaseContractItem I_MaintTaskListOperation _PurchaseContractItem
_PurchasingInfoRecord I_MaintTaskListOperation _PurchasingInfoRecord
_PurchasingOrganization I_MaintTaskListOperation _PurchasingOrganization
_Supplier I_MaintTaskListOperation _Supplier
_TaskListType I_MaintTaskListOperation _TaskListType
_TaskListGroup I_MaintTaskListOperation _TaskListGroup
_TaskListGroupCounter I_MaintTaskListOperation _TaskListGroupCounter
_TaskListSequence I_MaintTaskListOperation _TaskListSequence
_TaskListOperationInternalId I_MaintTaskListOperation _TaskListOperationInternalId
_WorkCenter I_MaintTaskListOperation _WorkCenter
_WorkCenterType I_MaintTaskListOperation _WorkCenterType
_MaintOperationExecStageCode I_MaintTaskListOperation _MaintOperationExecStageCode
_TechnicalObject _TechnicalObject
_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IMAINTTLOPTECOBJ'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Maint. Task List Operation w/ Tech. Obj.'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #COMPOSITE


define view I_MaintTaskListOpTechObj
  as select from I_MaintTaskListOperation

  association [0..1] to I_TechnicalObject           as _TechnicalObject           on  _TechnicalObject.TechnicalObject           = $projection.TechnicalObject
                                                                                  and _TechnicalObject.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc

  association [0..1] to I_TechObjIsEquipOrFuncnlLoc as _TechObjIsEquipOrFuncnlLoc on  _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc

  association [0..1] to I_Currency                  as _Currency                  on  _Currency.Currency = $projection.OpExternalProcessingCurrency

  association [0..1] to I_PurgInfoRecdOrgPlantData  as _PurgInfoRecdOrgPlantData  on  _PurgInfoRecdOrgPlantData.PurchasingInfoRecord         = $projection.PurchasingInfoRecord
                                                                                  and _PurgInfoRecdOrgPlantData.PurchasingOrganization       = $projection.PurchasingOrganization
                                                                                  and _PurgInfoRecdOrgPlantData.PurchasingInfoRecordCategory = $projection.PurchasingInfoRecordCategory
                                                                                  and _PurgInfoRecdOrgPlantData.Plant                        = $projection.Plant
{
  key I_MaintTaskListOperation.TaskListType,

  key I_MaintTaskListOperation.TaskListGroup,

  key I_MaintTaskListOperation.TaskListGroupCounter,

  key I_MaintTaskListOperation.TaskListSequence,

  key I_MaintTaskListOperation.TaskListOperationInternalId,
      I_MaintTaskListOperation.TaskListOpBOMItmIntVersCounter,

      I_MaintTaskListOperation.MaintenanceTaskListOperation,

      I_MaintTaskListOperation.MaintTaskListSubOperation,

      I_MaintTaskListOperation.OperationText,

      @ObjectModel.foreignKey.association: '_TechnicalObject'
      case when I_MaintTaskListOperation.Equipment != '' then
                  cast( I_MaintTaskListOperation.Equipment as eams_tec_obj )
           when I_MaintTaskListOperation.Equipment = '' and
                I_MaintTaskListOperation.FunctionalLocation != '' then
                  cast(  I_MaintTaskListOperation.FunctionalLocation as eams_tec_obj )
           else cast('' as eams_tec_obj ) end       as TechnicalObject,

      @ObjectModel.foreignKey.association: '_TechObjIsEquipOrFuncnlLoc'
      @UI.textArrangement: #TEXT_ONLY
      cast( case when I_MaintTaskListOperation.Equipment != '' then
                  'EAMS_EQUI'
           when I_MaintTaskListOperation.Equipment = '' and
                I_MaintTaskListOperation.FunctionalLocation != '' then
                  'EAMS_FL'
           else '' end as eams_tec_obj_type_value ) as TechObjIsEquipOrFuncnlLoc,

      I_MaintTaskListOperation.OperationControlProfile,

      I_MaintTaskListOperation.WorkCenterInternalID,

      I_MaintTaskListOperation.WorkCenterTypeCode,

      I_MaintTaskListOperation.Plant,

      I_MaintTaskListOperation.OpPlannedWorkQuantity,

      I_MaintTaskListOperation.OpWorkQuantityUnit,

      I_MaintTaskListOperation.ChangeNumber,

      I_MaintTaskListOperation.ValidityStartDate,

      I_MaintTaskListOperation.ValidityEndDate,

      I_MaintTaskListOperation.OperationStandardTextCode,

      I_MaintTaskListOperation.PurchasingInfoRecdAddlGrpgName,

      @DefaultAggregation: #NONE
      @Semantics.amount.currencyCode: 'OpExternalProcessingCurrency'
      case when I_MaintTaskListOperation.PurchasingInfoRecord <> ''
           then case when _PurgInfoRecdOrgPlantData.PurchaseOrderPriceUnit <> _PurchasingInfoRecord.PurgDocOrderQuantityUnit
                     then _PurgInfoRecdOrgPlantData.NetPriceAmount * division (_PurgInfoRecdOrgPlantData.OrderPriceUnitToOrderUnitNmrtr, _PurgInfoRecdOrgPlantData.OrdPriceUnitToOrderUnitDnmntr, 0 )
                     else _PurgInfoRecdOrgPlantData.NetPriceAmount end
            else I_MaintTaskListOperation.OpExternalProcessingPrice
      end                                           as OpExternalProcessingPrice,

      @ObjectModel.foreignKey.association: '_Currency'
      @Semantics.currencyCode:true
      case when I_MaintTaskListOperation.PurchasingInfoRecord <> ''
           then _PurgInfoRecdOrgPlantData.Currency
           else I_MaintTaskListOperation.OpExternalProcessingCurrency
      end                                           as OpExternalProcessingCurrency,

      @DefaultAggregation: #NONE
      case when I_MaintTaskListOperation.PurchasingInfoRecord <> ''
           then _PurgInfoRecdOrgPlantData.MaterialPriceUnitQty
           else I_MaintTaskListOperation.NumberOfOperationPriceUnits
      end                                           as NumberOfOperationPriceUnits,

      I_MaintTaskListOperation.PurchasingInfoRecord,

      I_MaintTaskListOperation.PurchasingInfoRecordCategory,

      I_MaintTaskListOperation.PurchasingOrganization,

      I_MaintTaskListOperation.Supplier,

      I_MaintTaskListOperation.PurchaseContract,

      I_MaintTaskListOperation.PurchaseContractItem,

      I_MaintTaskListOperation.OperationStandardDuration,

      I_MaintTaskListOperation.OperationStandardDurationUnit,

      I_MaintTaskListOperation.NumberOfCapacities,

      I_MaintTaskListOperation.OperationSystemCondition,

      I_MaintTaskListOperation.CostCtrActivityType,

      I_MaintTaskListOperation.OperationCalculationControl,

      I_MaintTaskListOperation.Assembly,

      I_MaintTaskListOperation.PurchaseOrderQty,

      I_MaintTaskListOperation.PurchaseOrderQuantityUnit,

      I_MaintTaskListOperation.FunctionalLocation,

      I_MaintTaskListOperation.Equipment,

      I_MaintTaskListOperation.IsDeleted,

      I_MaintTaskListOperation.IsImplicitlyDeleted,

      I_MaintTaskListOperation.TaskListOperationObjectKey,

      I_MaintTaskListOperation.MaintOperationExecStageCode,
      @Consumption.hidden: true
      I_MaintTaskListOperation.BillOfOperationsGroup,
      @Consumption.hidden: true
      I_MaintTaskListOperation.BillOfOperationsType,
      @Consumption.hidden: true
      I_MaintTaskListOperation.BOOOperationInternalID,

      /* Associations */
      _Currency,
      I_MaintTaskListOperation._Assembly,
      I_MaintTaskListOperation._ChangeMaster,
      I_MaintTaskListOperation._Equipment,
      I_MaintTaskListOperation._FunctionalLocation,
      I_MaintTaskListOperation._MaintenanceTaskList,
      I_MaintTaskListOperation._OperationCalculationControl,
      I_MaintTaskListOperation._OperationControlProfile,
      I_MaintTaskListOperation._OperationStandardText,
      I_MaintTaskListOperation._OperationSystemCondition,
      I_MaintTaskListOperation._Plant,
      I_MaintTaskListOperation._PurchaseContract,
      I_MaintTaskListOperation._PurchaseContractItem,
      I_MaintTaskListOperation._PurchasingInfoRecord,
      I_MaintTaskListOperation._PurchasingOrganization,
      I_MaintTaskListOperation._Supplier,
      I_MaintTaskListOperation._TaskListType,
      I_MaintTaskListOperation._TaskListGroup,
      I_MaintTaskListOperation._TaskListGroupCounter,
      I_MaintTaskListOperation._TaskListSequence,
      I_MaintTaskListOperation._TaskListOperationInternalId,
      I_MaintTaskListOperation._WorkCenter,
      I_MaintTaskListOperation._WorkCenterType,
      I_MaintTaskListOperation._MaintOperationExecStageCode,

      /* Associations - locally defined */
      _TechnicalObject,
      _TechObjIsEquipOrFuncnlLoc
}

Learn More