CDS标准视图：测量文档数据 I_MeasurementDocumentData

@AbapCatalog.sqlViewName: 'IMEASDOCDATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Measurement Document Data'

@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'MeasurementDocument'
@Metadata.ignorePropagatedAnnotations: true

@Analytics: {
  dataCategory: #FACT,
  dataExtraction: {
    enabled: true
  }
}

@ObjectModel: {
  usageType: {
    dataClass: #TRANSACTIONAL,
    serviceQuality: #C,
    sizeCategory: #L
  }
}

@ObjectModel.modelingPattern:           #EXTRACTION_DATA_SOURCE
@ObjectModel.supportedCapabilities:     [ #EXTRACTION_DATA_SOURCE ]



define view I_MeasurementDocumentData
  as select from I_MeasurementDocument
    inner join   I_MeasuringPointData on I_MeasurementDocument.MeasuringPoint = I_MeasuringPointData.MeasuringPoint
{
  key I_MeasurementDocument.MeasurementDocument,

      @ObjectModel.foreignKey.association: '_MeasuringPoint'
      I_MeasurementDocument.MeasuringPoint,

      @ObjectModel.foreignKey.association: '_Language'
      I_MeasurementDocument.Language,

      I_MeasurementDocument.MeasurementDocumentText,

      I_MeasurementDocument.MsmtRdngDate,

      I_MeasurementDocument.MsmtRdngTime,

      @Semantics.dateTime: true
      I_MeasurementDocument.MeasurementReadingDateTime,

      I_MeasurementDocument.MeasurementDocumentHasLongText,

      I_MeasurementDocument.MsmtRdngByUser,

      @Semantics.systemDate.createdAt: true
      I_MeasurementDocument.CreationDate,

      I_MeasurementDocument.CreationTime,

      @Semantics.dateTime: true
      I_MeasurementDocument.MsmtDocumentCreationDateTime,

      @Semantics.user.createdBy: true
      I_MeasurementDocument.CreatedByUser,

      @Semantics.systemDate.lastChangedAt: true
      I_MeasurementDocument.LastChangeDate,

      @Semantics.user.lastChangedBy: true
      I_MeasurementDocument.LastChangedByUser,

      I_MeasurementDocument.SingleLevelDeletionLogicFlag,

      I_MeasurementDocument.MeasurementDocumentOrigin,

      @ObjectModel.foreignKey.association: '_InspectionLot'
      I_MeasurementDocument.InspectionLot,

      I_MeasurementDocument.InspectionCharacteristic,

      @ObjectModel.foreignKey.association: '_MsmtRdngSourceMeasurementDoc'
      I_MeasurementDocument.MsmtRdngSourceMeasurementDoc,

      I_MeasurementDocument.ProdnRsceToolTypeCode,

      I_MeasurementDocument.ProdnRsceToolInternalID,

      @ObjectModel.foreignKey.association: '_ControllingObject'
      I_MeasurementDocument.MsmtDocumentReferredOrder,

      I_MeasurementDocument.MsmtIsDoneAfterTaskCompltn,

      @Semantics.quantity.unitOfMeasure: 'MeasurementReadingEntryUoM'
      I_MeasurementDocument.MeasurementReading,

      @Semantics.quantity.unitOfMeasure: 'MeasurementReadingEntryUoM'
      I_MeasurementDocument.MeasurementReadingInEntryUoM,

      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      @Semantics.unitOfMeasure: true
      I_MeasurementDocument.MeasurementReadingEntryUoM,

      I_MeasurementDocument.MsmtDocumentSIUnitOfMeasure,

      @Semantics.quantity.unitOfMeasure: 'MeasurementReadingEntryUoM'
      I_MeasurementDocument.MeasurementCounterReading,

      @Semantics.quantity.unitOfMeasure: 'MeasurementReadingEntryUoM'
      I_MeasurementDocument.MsmtCounterReadingDifference,

      I_MeasurementDocument.MsmtCntrReadingDiffIsEntered,

      I_MeasurementDocument.MsmtCounterReadingIsReplaced,

      @ObjectModel.foreignKey.association: '_MsmtDocumentCatalogType'
      I_MeasurementDocument.MeasurementDocumentCatalogType,

      @ObjectModel.foreignKey.association: '_MeasurementDocumentCodeGroup'
      I_MeasurementDocument.MeasurementDocumentCodeGroup,

      @ObjectModel.foreignKey.association: '_MeasurementValuationCode'
      I_MeasurementDocument.MsmtValuationCode,

      I_MeasurementDocument.MsmtValuationCodeVersNmbr,

      I_MeasurementDocument.MsmtRdngStatus,

      I_MeasurementDocument.MsmtRdngIsReversed,

      I_MeasurementDocument.InspectionValuationResult,

      I_MeasurementDocument.MsmtRdngIsIntervalDoc,

      I_MeasurementDocument.MsmtRdngIntervalStartDate,

      I_MeasurementDocument.MsmtRdngIntervalStartTime,

      I_MeasurementDocument.MaintOrderOperationInternalID,

      cast( case when I_MeasurementDocument.MeasurementReading < _MeasuringPoint.MeasuringPointMinimumThreshold then 1
      else 0 end as eam_msmt_rdng_under_threshold)             as MsmtReadingIsUnderThreshold,

      cast( case when I_MeasurementDocument.MeasurementReading > _MeasuringPoint.MeasuringPointMaximumThreshold then 1
      else 0 end as eam_msmt_rdng_over_threshold)              as MsmtReadingIsOverThreshold,

      I_MeasurementDocument._MeasuringPoint.AuthorizationGroup as AuthorizationGroup,
      // Propagate association(s)
      I_MeasurementDocument._Language,
      I_MeasurementDocument._MeasuringPoint,
      I_MeasurementDocument._InspectionLot,
      I_MeasurementDocument._MsmtRdngSourceMeasurementDoc,
      I_MeasurementDocument._ControllingObject,
      I_MeasurementDocument._UnitOfMeasure,
      I_MeasurementDocument._MsmtDocumentCatalogType,
      I_MeasurementDocument._MeasurementDocumentCodeGroup,
      I_MeasurementDocument._MeasurementValuationCode
}