I_MaintOrderOperComp

DDL: I_MAINTORDEROPERCOMP SQL: IMTORDOPRCOMP Type: view COMPOSITE

Maintenance Order Operation Component

I_MaintOrderOperComp is a Composite CDS View that provides data about "Maintenance Order Operation Component" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderComponent_2) and exposes 54 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, MaintOrderComponentInternalID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrderComponent_2 I_MaintenanceOrderComponent_2 from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_MaintOrderOperTechObj _MaintenanceOrderOperation $projection.MaintenanceOrder = _MaintenanceOrderOperation.MaintenanceOrder and $projection.MaintenanceOrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation
[1..1] I_MaintOrderTechObj _MaintenanceOrder $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
[0..*] I_StatusObjectActiveStatus _StatusObjectActiveStatus $projection.MaintOrderComponentInternalID = _StatusObjectActiveStatus.StatusObject

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMTORDOPRCOMP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Order Operation Component view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey MaintOrderComponentInternalID view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder
KEY MaintenanceOrderOperation MaintenanceOrderOperation
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation
KEY MaintOrderComponentInternalID MaintOrderComponentInternalID
MaintenanceOrderComponent MaintenanceOrderComponent
Reservation Reservation
ReservationItem ReservationItem
ReservationType ReservationType
Material Material
MaterialGroup MaterialGroup
ComponentDescription ComponentDescription
RequirementQuantityInBaseUnit RequirementQuantityInBaseUnit
BaseUnit BaseUnit
MaintOrderCompDebitCreditCode MaintOrderCompDebitCreditCode
Plant Plant
StorageLocation StorageLocation
MaintOrderRoutingNumber MaintOrderRoutingNumber
MaintOrderOperationCounter MaintOrderOperationCounter
ItemCategory MaintComponentItemCategory
PurchaseRequisition PurchaseRequisition
PurchaseRequisitionItem PurchaseRequisitionItem
PurReqnOrResvnGeneration PurReqnOrResvnGeneration
MaterialCompIsProcuredDirectly MaterialCompIsProcuredDirectly
Supplier Supplier
StatusIsActiveendasxloekasIsDeleted
QuantityWithdrawnInBaseUnit QuantityWithdrawnInBaseUnit
PerformancePeriodStartDate PerformancePeriodStartDate
PerformancePeriodStartTime PerformancePeriodStartTime
PerformancePeriodEndDate PerformancePeriodEndDate
PerformancePeriodEndTime PerformancePeriodEndTime
LeanServiceDuration LeanServiceDuration
LeanServiceDurationUnit LeanServiceDurationUnit
MaintOrdOpComponentCurrency MaintOrdOpComponentCurrency
DistributionFunction DistributionFunction
SrvcSchedgIsAlignedWthOpWrkCtr SrvcSchedgIsAlignedWthOpWrkCtr
OverallLimitAmount OverallLimitAmount
ExpectedOverallLimitAmount ExpectedOverallLimitAmount
RqmtDateIsEnteredManually RqmtDateIsEnteredManually
FldLogsDelivIsHeldOnShore FldLogsDelivIsHeldOnShore
FldLogsSupplyProcess FldLogsSupplyProcess
_Supplier _Supplier
_Material _Material
_MaterialText _MaterialText
_MaterialGroup _MaterialGroup
_StatusObject _StatusObject
_Plant _Plant
_ItemCategoryText _ItemCategoryText
_StorageLocation _StorageLocation
_SafetyRelevance _SafetyRelevance
_UnitOfMeasure _UnitOfMeasure
_PurReqnOrResvnGeneration _PurReqnOrResvnGeneration
_MaintenanceOrder _MaintenanceOrder
_StatusObjectActiveStatus _StatusObjectActiveStatus
_MaintenanceOrderOperation _MaintenanceOrderOperation
@AbapCatalog.sqlViewName: 'IMTORDOPRCOMP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Order Operation Component'
@VDM.viewType: #COMPOSITE

@ObjectModel.representativeKey: 'MaintOrderComponentInternalID'
@ObjectModel.semanticKey:  [ 'MaintenanceOrder', 'MaintenanceOrderOperation', 'MaintOrderComponentInternalID' ]

//@ObjectModel: {

//    createEnabled: true,

//    updateEnabled: true,

//    deleteEnabled: true

//}


@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

define view I_MaintOrderOperComp
  as select from I_MaintenanceOrderComponent_2 
  /* BOPF associations: */
  association [1..1] to I_MaintOrderOperTechObj    as _MaintenanceOrderOperation on  $projection.MaintenanceOrder          = _MaintenanceOrderOperation.MaintenanceOrder
                                                                                 and $projection.MaintenanceOrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation
  association [1..1] to I_MaintOrderTechObj        as _MaintenanceOrder          on  $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
  association [0..*] to I_StatusObjectActiveStatus as _StatusObjectActiveStatus  on  $projection.MaintOrderComponentInternalID = _StatusObjectActiveStatus.StatusObject
{
      @ObjectModel.foreignKey.association: '_MaintenanceOrder'
  key MaintenanceOrder,
      @ObjectModel.foreignKey.association: '_MaintenanceOrderOperation'
  key MaintenanceOrderOperation,
  key MaintenanceOrderSubOperation, 
  key MaintOrderComponentInternalID,
      MaintenanceOrderComponent,
      Reservation,
      ReservationItem,
      ReservationType,
      Material,
      MaterialGroup,
      ComponentDescription,
      RequirementQuantityInBaseUnit,
      BaseUnit,
      MaintOrderCompDebitCreditCode,
      Plant,
      StorageLocation,
      MaintOrderRoutingNumber,
      MaintOrderOperationCounter,
      MaintComponentItemCategory as ItemCategory,
      PurchaseRequisition,
      PurchaseRequisitionItem,
      PurReqnOrResvnGeneration,
      MaterialCompIsProcuredDirectly,
      Supplier,

      cast( case when IsDeleted = '' then IsDeleted
           else coalesce( _StatusObjectActiveStatus[ 1: StatusCode = 'I0013' ].StatusIsActive, '' ) end as xloek ) as IsDeleted,
      QuantityWithdrawnInBaseUnit,
      PerformancePeriodStartDate,
      PerformancePeriodStartTime,
      PerformancePeriodEndDate,
      PerformancePeriodEndTime,
      LeanServiceDuration,
      LeanServiceDurationUnit,
      @Semantics.currencyCode: true
      MaintOrdOpComponentCurrency,
      DistributionFunction,
      SrvcSchedgIsAlignedWthOpWrkCtr,
      @Semantics.amount.currencyCode: 'MaintOrdOpComponentCurrency'
      OverallLimitAmount,
      @Semantics.amount.currencyCode: 'MaintOrdOpComponentCurrency'
      ExpectedOverallLimitAmount,
      RqmtDateIsEnteredManually,
      cast(
        case
            when RqmtDateIsEnteredManually = 'X' then 'M'
            when DistributionFunction = 'S10' then ''
            when DistributionFunction = 'S50' then 'X'
        end as cc4_delvry_date_adj preserving type )                                                                 as MaintOrdCompDeliveryDateAdjmt,
      FldLogsDelivIsHeldOnShore,
      FldLogsSupplyProcess,

      /* Associations */
      _Supplier,
      _Material,
      _MaterialText,
      _MaterialGroup,
      _StatusObject,
      _Plant,
      _ItemCategoryText,
      _StorageLocation,
      _SafetyRelevance,
      _UnitOfMeasure,
      _PurReqnOrResvnGeneration,
      //@ObjectModel.association.type: [#TO_COMPOSITION_ROOT]

      _MaintenanceOrder,
      _StatusObjectActiveStatus,
      //@ObjectModel.association.type: [#TO_COMPOSITION_PARENT]

      _MaintenanceOrderOperation
}