C_MaintOrderConfirmationTP

DDL: C_MAINTORDERCONFIRMATIONTP SQL: CMAINTORDCONFTP Type: view CONSUMPTION Package: ODATA_EAM_MALFUNCTION_MANAGE

Maintenance Order Confirmation

C_MaintOrderConfirmationTP is a Consumption CDS View that provides data about "Maintenance Order Confirmation" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderConfTP) and exposes 25 fields with key fields MaintOrderConf, MaintOrderConfCntrValue. It has 4 associations to related views. Part of development package ODATA_EAM_MALFUNCTION_MANAGE.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrderConfTP I_MaintenanceOrderConfTP from

Associations (4)

CardinalityTargetAliasCondition
[0..1] C_MaintOrderOperationTP _MaintOrderOperationTP _MaintOrderOperationTP.MaintenanceOrder = $projection.MaintenanceOrder and _MaintOrderOperationTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation
[0..1] I_PMTimeUnitVH _ActualWorkUnit _ActualWorkUnit.UnitOfMeasure = $projection.ActualWorkQuantityUnit
[0..1] I_PMTimeUnitVH _ActualWorkExtQuantityUnit _ActualWorkExtQuantityUnit.UnitOfMeasure = $projection.ActualWorkExternalQuantityUnit
[0..1] I_PMTimeUnitVH _RemainingWorkExtQuantityUnit _RemainingWorkExtQuantityUnit.UnitOfMeasure = $projection.RemainingWorkExtQuantityUnit

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CMAINTORDCONFTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Order Confirmation view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY MaintOrderConf I_MaintenanceOrderConfTP MaintOrderConf
KEY MaintOrderConfCntrValue I_MaintenanceOrderConfTP MaintOrderConfCntrValue
MaintOrderConfForEdit I_MaintenanceOrderConfTP MaintOrderConfForEdit
MaintOrderConfCntrValueForEdit I_MaintenanceOrderConfTP MaintOrderConfCntrValueForEdit
MaintenanceOrder I_MaintenanceOrderConfTP MaintenanceOrder
MaintenanceOrderOperation I_MaintenanceOrderConfTP MaintenanceOrderOperation
MaintenanceOrderSubOperation
ActualWorkQuantity I_MaintenanceOrderConfTP ActualWorkQuantity
ActualWorkQuantityUnit I_MaintenanceOrderConfTP ActualWorkQuantityUnit
ActualWorkQtyInExternalUnit I_MaintenanceOrderConfTP ActualWorkQtyInExternalUnit
ActualWorkExternalQuantityUnit I_MaintenanceOrderConfTP ActualWorkExternalQuantityUnit
PostingDate I_MaintenanceOrderConfTP PostingDate
IsFinalConfirmation I_MaintenanceOrderConfTP IsFinalConfirmation Final Confirmation
RemainingWorkQuantity I_MaintenanceOrderConfTP RemainingWorkQuantity
RemainingWorkQuantityUnit I_MaintenanceOrderConfTP RemainingWorkQuantityUnit
RemainingWorkQtyInExternalUnit I_MaintenanceOrderConfTP RemainingWorkQtyInExternalUnit
RemainingWorkExtQuantityUnit I_MaintenanceOrderConfTP RemainingWorkExtQuantityUnit
Plant I_MaintenanceOrderConfTP Plant
PersonnelNumber I_MaintenanceOrderConfTP PersonnelNumber Performed By
_MaintOrderOperationTP _MaintOrderOperationTP
_ActualWorkUnit _ActualWorkUnit
_ActualWorkExtQuantityUnit _ActualWorkExtQuantityUnit
_RemainingWorkExtQuantityUnit _RemainingWorkExtQuantityUnit
_MaintenanceOrder _MaintenanceOrder
_PersonnelName _PersonnelName
@AbapCatalog.sqlViewName: 'CMAINTORDCONFTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Order Confirmation'

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #CONSUMPTION

@ObjectModel: {
  semanticKey: ['MaintOrderConf', 'MaintOrderConfCntrValue'],
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true,
  transactionalProcessingDelegated: true,
  compositionRoot:true,
  draftEnabled: true
}

define view C_MaintOrderConfirmationTP
  as select from I_MaintenanceOrderConfTP
  association [0..1] to C_MaintOrderOperationTP as _MaintOrderOperationTP        on  _MaintOrderOperationTP.MaintenanceOrder          = $projection.MaintenanceOrder
                                                                                 and _MaintOrderOperationTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation
  association [0..1] to I_PMTimeUnitVH          as _ActualWorkUnit               on  _ActualWorkUnit.UnitOfMeasure = $projection.ActualWorkQuantityUnit
  association [0..1] to I_PMTimeUnitVH          as _ActualWorkExtQuantityUnit    on  _ActualWorkExtQuantityUnit.UnitOfMeasure = $projection.ActualWorkExternalQuantityUnit
  association [0..1] to I_PMTimeUnitVH          as _RemainingWorkExtQuantityUnit on  _RemainingWorkExtQuantityUnit.UnitOfMeasure = $projection.RemainingWorkExtQuantityUnit
{
  key I_MaintenanceOrderConfTP.MaintOrderConf,
  key I_MaintenanceOrderConfTP.MaintOrderConfCntrValue,
      I_MaintenanceOrderConfTP.MaintOrderConfForEdit,
      I_MaintenanceOrderConfTP.MaintOrderConfCntrValueForEdit,

      I_MaintenanceOrderConfTP.MaintenanceOrder,
      I_MaintenanceOrderConfTP.MaintenanceOrderOperation,
      cast( I_MaintenanceOrderConfTP.MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type ) as MaintenanceOrderSubOperation,

      @Semantics.quantity.unitOfMeasure: 'ActualWorkQuantityUnit'
      I_MaintenanceOrderConfTP.ActualWorkQuantity,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_ActualWorkUnit'
      I_MaintenanceOrderConfTP.ActualWorkQuantityUnit,
      I_MaintenanceOrderConfTP.ActualWorkQtyInExternalUnit,
      @Consumption.valueHelp: '_ActualWorkExtQuantityUnit'
      I_MaintenanceOrderConfTP.ActualWorkExternalQuantityUnit,
      I_MaintenanceOrderConfTP.PostingDate,
      @EndUserText.label: 'Final Confirmation'
      I_MaintenanceOrderConfTP.IsFinalConfirmation,
      I_MaintenanceOrderConfTP.RemainingWorkQuantity,
      I_MaintenanceOrderConfTP.RemainingWorkQuantityUnit,
      I_MaintenanceOrderConfTP.RemainingWorkQtyInExternalUnit,
      @Consumption.valueHelp: '_RemainingWorkExtQuantityUnit'
      I_MaintenanceOrderConfTP.RemainingWorkExtQuantityUnit,
      I_MaintenanceOrderConfTP.Plant,

      @Consumption.valueHelpDefinition: [
          { entity:  { name:    'I_PersWrkAgrmtSrchHelp',
                       element: 'PersonWorkAgreement' }
          }]
      @EndUserText.label: 'Performed By'
      I_MaintenanceOrderConfTP.PersonnelNumber,
      _MaintOrderOperationTP,
      _ActualWorkUnit,
      _ActualWorkExtQuantityUnit,
      _RemainingWorkExtQuantityUnit,

      _MaintenanceOrder,
      _PersonnelName
}