A_MeasurementDocument

DDL: A_MEASUREMENTDOCUMENT Type: view_entity COMPOSITE Package: VDM_EAM_MEASUREMENTDOCUMENT

Measurement Documents

A_MeasurementDocument is a Composite CDS View that provides data about "Measurement Documents" in SAP S/4HANA. It reads from 1 data source (R_MeasurementDocumentTP) and exposes 32 fields with key field MeasurementDocument. It is exposed through 2 OData services (API_MEASUREMENTDOCUMENT, ASQL_F7184). Part of development package VDM_EAM_MEASUREMENTDOCUMENT.

Data Sources (1)

SourceAliasJoin Type
R_MeasurementDocumentTP R_MeasurementDocumentTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Measurement Documents view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

OData Services (2)

ServiceBindingVersionContractRelease
API_MEASUREMENTDOCUMENT API_MEASUREMENTDOCUMENT V4 C2 C1
ASQL_F7184 ASQL_F7184 C2 NOT_RELEASED

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY MeasurementDocument MeasurementDocument
MeasurementDocumentOrigin MeasurementDocumentOrigin
MeasuringPoint MeasuringPoint
MeasuringPointPositionNumber MeasuringPointPositionNumber
MsmtRdngDate MsmtRdngDate
MsmtRdngTime MsmtRdngTime
MeasurementReadingDateTime MeasurementReadingDateTime
MsmtDocumentCreationDateTime MsmtDocumentCreationDateTime
Characteristic Characteristic Field Name
MsmtDocumentReferredOrder MsmtDocumentReferredOrder
RefdMaintOrderOpStatusObject RefdMaintOrderOpStatusObject Object number
MaintenanceOrderOperation MaintenanceOrderOperation Suboperation
MaintenanceOrderSubOperation MaintenanceOrderSubOperation Suboperation
MsmtIsDoneAfterTaskCompltn MsmtIsDoneAfterTaskCompltn
CharcValueUnit CharcValueUnit Internal UoM
MsmtDocumentSIUnitOfMeasure MsmtDocumentSIUnitOfMeasure
MeasurementReading MeasurementReading
MeasurementReadingInEntryUoM MeasurementReadingInEntryUoM
MeasurementReadingEntryUoM MeasurementReadingEntryUoM
MeasurementCounterReading MeasurementCounterReading
MsmtCounterReadingDifference MsmtCounterReadingDifference
TotalMsmtRdngIsSetExternally TotalMsmtRdngIsSetExternally
MeasuringPointTargetValue MeasuringPointTargetValue
MsmtValuationCode MsmtValuationCode
MeasurementDocumentText MeasurementDocumentText
MeasurementDocumentHasLongText MeasurementDocumentHasLongText
MsmtRdngByUser MsmtRdngByUser
MsmtRdngStatus MsmtRdngStatus
MsmtCntrReadingDiffIsEntered MsmtCntrReadingDiffIsEntered
MsmtRdngIsReversed MsmtRdngIsReversed
AuthorizationGroup AuthorizationGroup AuthorizGroup
MsmtCounterReadingIsReplaced MsmtCounterReadingIsReplaced

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_MeasurementDocument.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_MeasurementDocument AS
SELECT
  MeasurementDocument,
  MeasurementDocumentOrigin,
  MeasuringPoint,
  MeasuringPointPositionNumber,
  MsmtRdngDate,
  MsmtRdngTime,
  MeasurementReadingDateTime,
  MsmtDocumentCreationDateTime,
  Characteristic,
  MsmtDocumentReferredOrder,
  RefdMaintOrderOpStatusObject,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  MsmtIsDoneAfterTaskCompltn,
  CharcValueUnit,
  MsmtDocumentSIUnitOfMeasure,
  MeasurementReading,
  MeasurementReadingInEntryUoM,
  MeasurementReadingEntryUoM,
  MeasurementCounterReading,
  MsmtCounterReadingDifference,
  TotalMsmtRdngIsSetExternally,
  MeasuringPointTargetValue,
  MsmtValuationCode,
  MeasurementDocumentText,
  MeasurementDocumentHasLongText,
  MsmtRdngByUser,
  MsmtRdngStatus,
  MsmtCntrReadingDiffIsEntered,
  MsmtRdngIsReversed,
  AuthorizationGroup,
  MsmtCounterReadingIsReplaced
FROM R_MeasurementDocumentTP
;