P_MeasuringPointLastMsmtDoc

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 P_MeasuringPointLastMsmtDoc.
-- 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.
-- SQL view name: PLASTMSMTDOC

CREATE VIEW P_MeasuringPointLastMsmtDoc AS
SELECT
  MeasurementDocument,
  I_MeasurementDocument.MeasuringPoint AS MeasuringPoint,
  MsmtRdngDate,
  MsmtRdngTime,
  MeasurementReadingDateTime,
  MsmtRdngSourceMeasurementDoc,
  MeasurementCounterReading,
  MsmtCntrRdngIsEntered,
  MeasurementReading,
  MsmtRdngIsEntered,
  MeasurementReadingInEntryUoM,
  MeasurementReadingEntryUoM,
  MsmtValuationCode,
  MeasurementDocumentCatalogType,
  MeasurementDocumentCodeGroup,
  MsmtRdngByUser,
  I_MeasurementDocument._MeasuringPoint AS _MeasuringPoint
FROM I_MeasurementDocument
LEFT OUTER JOIN P_MsrgPtLastMsmtDocTimestamp AS _MsrgPtLastMsmtDocTimestamp ON MeasuringPoint = _MsrgPtLastMsmtDocTimestamp.MeasuringPoint  -- association [1]
;