R_MaintOrderConfirmationTP

DDL: R_MAINTORDERCONFIRMATIONTP SQL: RMAINTORDCONFTP Type: view_entity COMPOSITE Package: VDM_EAM_MAINTORDERCONFIRMATION

Maintenance Order Confirmation

R_MaintOrderConfirmationTP is a Composite CDS View that provides data about "Maintenance Order Confirmation" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderConfirmation) and exposes 35 fields with key fields MaintOrderConf, MaintOrderConfCntrValue. It has 2 associations to related views. Part of development package VDM_EAM_MAINTORDERCONFIRMATION.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrderConfirmation I_MaintenanceOrderConfirmation from

Associations (2)

CardinalityTargetAliasCondition
[0..1] E_MaintenanceOrderConfirmation _MaintOrdConfExtension $projection.MaintOrderConf = _MaintOrdConfExtension.MaintOrderConf and $projection.MaintOrderConfCntrValue = _MaintOrdConfExtension.MaintOrderConfCntrValue
[0..1] R_MaintOrderConfLongTextTP _LongText

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Order Confirmation view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name MaintenanceOrderConfirmation view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY MaintOrderConf MaintOrderConf
KEY MaintOrderConfCntrValue MaintOrderConfCntrValue
MaintenanceOrder MaintenanceOrder
MaintenanceOrderOperation
MaintenanceOrderSubOperation
PersonnelNumber PersonnelNumber
ActualWorkQuantity ActualWorkQuantity
ActualWorkQuantityUnit ActualWorkQuantityUnit
ActualDuration ActualDuration
ActualDurationUnit ActualDurationUnit
OperationConfirmedStartDate OperationConfirmedStartDate
OperationConfirmedStartTime OperationConfirmedStartTime
OperationConfirmedEndDate OperationConfirmedEndDate
OperationConfirmedEndTime OperationConfirmedEndTime
IsFinalConfirmation IsFinalConfirmation
NoFurtherWorkQuantityIsExpd NoFurtherWorkQuantityIsExpd
RemainingWorkQuantity RemainingWorkQuantity
RemainingWorkQuantityUnit RemainingWorkQuantityUnit
PostingDate PostingDate
ActivityType ActivityType
OpenReservationsIsCleared OpenReservationsIsCleared
ConfirmationText ConfirmationText
EmployeeWageType EmployeeWageType
EmployeeWageGroup EmployeeWageGroup
VarianceReasonCode VarianceReasonCode
CapacityInternalID CapacityInternalID
NmbrOfMaintTechnicianCapSplits NmbrOfMaintTechnicianCapSplits
MaterialDocument MaterialDocument
AccountingIndicatorCode AccountingIndicatorCode
ActyConfFcstdEndDate ActyConfFcstdEndDate
ActyConfFcstdEndTime ActyConfFcstdEndTime
IsReversed IsReversed
IsReversal IsReversal
CancldMaintOrderConfCntrValue CancldMaintOrderConfCntrValue
_LongText _LongText
//@AbapCatalog.sqlViewName: 'RMAINTORDCONFTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Order Confirmation'
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations:true
//@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #M, dataClass: #TRANSACTIONAL}
@ObjectModel.sapObjectNodeType:{name: 'MaintenanceOrderConfirmation'}
//@AbapCatalog.extensibility:{

//  extensible: true,

//  dataSources: ['_MaintOrdConfExtension'],

//  elementSuffix: 'CON',

//  quota:{

//    maximumBytes: 2040, //This is calculated with formula - 2* <Customer Percentage from SCFD_REGISTRY> * <number of chars as defined in SCFD_REGISTRY>

//    maximumFields: 204 //This is calculated with formula - 2* <Customer Percentage from SCFD_REGISTRY> * <max number of fields in SCFD_REGISTRY>

//  }

//}

define root view entity R_MaintOrderConfirmationTP
  as select from I_MaintenanceOrderConfirmation
  composition [0..1] of R_MaintOrderConfLongTextTP     as _LongText
  -- Extensions, do not expose as association:
  association [0..1] to E_MaintenanceOrderConfirmation as _MaintOrdConfExtension on $projection.MaintOrderConf = _MaintOrdConfExtension.MaintOrderConf
                                                                                 and $projection.MaintOrderConfCntrValue = _MaintOrdConfExtension.MaintOrderConfCntrValue
//  association[0..1] to I_MaintenanceOrderConfirmation as _CancelledConfirmations on _CancelledConfirmations.MaintOrderConf = $projection.MaintOrderConf and

//                                                                                   _CancelledConfirmations.MaintOrderConfCntrValue = $projection.MaintOrderConfCntrValue

                                                                  
                                                                                 
                                                                                   
{

  key MaintOrderConf,
  key MaintOrderConfCntrValue,
      MaintenanceOrder,
      cast(MaintenanceOrderOperation as eam_maintorderoperation preserving type )    as MaintenanceOrderOperation,
      cast(MaintenanceOrderSubOperation as eam_maintorderoperation preserving type ) as MaintenanceOrderSubOperation,

      PersonnelNumber,
      @Semantics.quantity.unitOfMeasure: 'ActualWorkQuantityUnit'
      ActualWorkQuantity,
      //      @Semantics.unitOfMeasure: true

      ActualWorkQuantityUnit,

      @Semantics.quantity.unitOfMeasure: 'ActualDurationUnit'
      ActualDuration,
      //      @Semantics.unitOfMeasure: true

      ActualDurationUnit,

      OperationConfirmedStartDate,
      OperationConfirmedStartTime,
      OperationConfirmedEndDate,
      OperationConfirmedEndTime,

      IsFinalConfirmation,
      NoFurtherWorkQuantityIsExpd,

      @Semantics.quantity.unitOfMeasure: 'RemainingWorkQuantityUnit'
      RemainingWorkQuantity,
      //      @Semantics.unitOfMeasure: true

      RemainingWorkQuantityUnit,

      PostingDate,
      ActivityType,
      OpenReservationsIsCleared,
      ConfirmationText,

      EmployeeWageType,
      EmployeeWageGroup,
      VarianceReasonCode,
      CapacityInternalID,
      NmbrOfMaintTechnicianCapSplits,
      MaterialDocument,

      //op fields

      AccountingIndicatorCode,
      ActyConfFcstdEndDate,
      ActyConfFcstdEndTime,
      //      "Exposing the reversal fields to this API

      IsReversed,
      IsReversal,
      CancldMaintOrderConfCntrValue,
      //Cancel Confirmation longtext

//      case

//      when CancldMaintOrderConfCntrValue is not initial then

//      _CancelledConfirmations._OrderConfLongText.PlainLongText 

//      else null

//      end  as MaintOrdConfCanclnLongText,

      
   
      /* Composition */
      _LongText
}