I_MeasurementDocument

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 I_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.
-- SQL view name: IMEASDOC

CREATE VIEW I_MeasurementDocument AS
SELECT
  mdocm AS MeasurementDocument,
  point AS MeasuringPoint,
  idate AS MsmtRdngDate,
  itime AS MsmtRdngTime,
  invts AS MsmtRdngInvertedDateTime,
  cntrg AS MsmtRdngIsForCounter,
  mdtxt AS MeasurementDocumentText,
  mlang AS Language,
  kzltx AS MeasurementDocumentHasLongText,
  readr AS MsmtRdngByUser,
  erdat AS CreationDate,
  eruhr AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aenam AS LastChangedByUser,
  lvorm AS SingleLevelDeletionLogicFlag,
  gener AS MeasurementDocumentOrigin,
  prueflos AS InspectionLot,
  merknr AS InspectionCharacteristic,
  rootd AS MsmtRdngSourceMeasurementDoc,
  tolty AS ProdnRsceToolTypeCode,
  tolid AS ProdnRsceToolInternalID,
  woobj AS MsmtDocumentReferredOrder,
  docaf AS MsmtIsDoneAfterTaskCompltn,
  readg AS MeasurementReading,
  readgi AS MsmtRdngIsEntered,
  recdv AS MeasurementReadingInEntryUoM,
  recdvi AS MsmtReadingInEntryUoMIsEntered,
  recdu AS MeasurementReadingEntryUoM,
  _MeasuringPoint._UnitOfMeasure._Dimension.UnitOFMeasureSiUnit AS MsmtDocumentSIUnitOfMeasure,
  cntrr AS MeasurementCounterReading,
  cntrri AS MsmtCntrRdngIsEntered,
  cdiff AS MsmtCounterReadingDifference,
  idiff AS MsmtCntrReadingDiffIsEntered,
  exchg AS MsmtCounterReadingIsReplaced,
  totex AS TotalMsmtRdngIsSetExternally,
  codct AS MeasurementDocumentCatalogType,
  codgr AS MeasurementDocumentCodeGroup,
  vlcod AS MsmtValuationCode,
  cvers AS MsmtValuationCodeVersNmbr,
  prest AS MsmtRdngStatus,
  cancl AS MsmtRdngIsReversed,
  mbewertg AS InspectionValuationResult,
  intvl AS MsmtRdngIsIntervalDoc,
  idat1 AS MsmtRdngIntervalStartDate,
  itim1 AS MsmtRdngIntervalStartTime,
  woob1 AS MaintOrderOperationInternalID
FROM imrg
LEFT OUTER JOIN I_MeasuringPoint AS _MeasuringPoint ON MeasuringPoint = _MeasuringPoint.MeasuringPoint  -- association [1..1]
LEFT OUTER JOIN I_Language AS _Language ON _Language.Language = Language  -- association [0..1]
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [0..1]
LEFT OUTER JOIN I_MeasurementDocument AS _MsmtRdngSourceMeasurementDoc ON MsmtRdngSourceMeasurementDoc = _MsmtRdngSourceMeasurementDoc.MeasurementDocument  -- association [0..1]
LEFT OUTER JOIN I_ControllingObject AS _ControllingObject ON MsmtDocumentReferredOrder = _ControllingObject.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON MeasurementReadingEntryUoM = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Inspectioncatalog AS _MsmtDocumentCatalogType ON MeasurementDocumentCatalogType = _MsmtDocumentCatalogType.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCodeGroup AS _MeasurementDocumentCodeGroup ON MeasurementDocumentCatalogType = _MeasurementDocumentCodeGroup.InspectionCatalog AND MeasurementDocumentCodeGroup = _MeasurementDocumentCodeGroup.InspectionCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_InspectionCode AS _MeasurementValuationCode ON MeasurementDocumentCatalogType = _MeasurementValuationCode.InspectionCatalog AND MeasurementDocumentCodeGroup = _MeasurementValuationCode.InspectionCodeGroup AND MsmtValuationCode = _MeasurementValuationCode.InspectionCode  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON MsmtDocumentReferredOrder = _MaintenanceOrder.MaintenanceOrderInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceNotification AS _MaintenanceNotification ON MsmtDocumentReferredOrder = _MaintenanceNotification.MaintNotifInternalID  -- association [0..1]
;