R_MaintOrderConfirmationTP

DDL: R_MAINTORDERCONFIRMATIONTP SQL: RMAINTORDCONFTP Type: view_entity COMPOSITE

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 32 fields with key fields MaintOrderConf, MaintOrderConfCntrValue. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrderConfirmation I_MaintenanceOrderConfirmation from

Associations (1)

CardinalityTargetAliasCondition
[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 (32)

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
_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


{

  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,

      /* Composition */
      _LongText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDERCONFIRMATION"
],
"ASSOCIATED":
[
"R_MAINTORDERCONFLONGTEXTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/