I_GHONtwkObjWellReading

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_GHONtwkObjWellReading.
-- 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 I_GHONtwkObjWellReading AS
SELECT
  a.GHONetworkID AS GHONetworkID,
  a.NetworkObject AS GHONetworkObjectID,
  a.UpstreamMsmtPoint AS UpstreamMsmtPoint,
  a.UpstreamMsmtFreq AS UpstreamMsmtFreq,
  a.QuantityType AS QuantityType,
  a.MeasurementGroup AS MeasurementGroup,
  a.NetworkMedium AS NetworkMedium,
  a.GHOCharacteristicName AS GHOCharacteristicName,
  a.UpstreamMsmt AS UpstreamMsmt,
  _ExtdMeasurementDocument.MeasurementDocument AS MeasurementDocument,
  _ExtdMeasurementDocument.UpstreamMsmtDate AS UpstreamMsmtDate,
  _ExtdMeasurementDocument.UpstreamMsmtTime AS UpstreamMsmtTime,
  a._MeasurementGroupText AS _MeasurementGroupText
FROM I_GHOExtdMsrgPtExpanded AS a
INNER JOIN I_GHONtwkObjects AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GHOExtdMeasurementDocument AS _ExtdMeasurementDocument ON a.UpstreamMsmtPoint = _ExtdMeasurementDocument.UpstreamMsmtPoint AND a.NetworkObject = _ExtdMeasurementDocument.GHONetworkObjectID AND a.UpstreamMsmtFreq = _ExtdMeasurementDocument.UpstreamMsmtFreq  -- association [0..*]
LEFT OUTER JOIN I_GHOProdnNtwkDetails AS _ProductionNetworkDetails ON GHONetworkID = _ProductionNetworkDetails.GHONetworkID  -- association [1..1]
LEFT OUTER JOIN I_GHONtwkObjects AS _NtwkObjects ON GHONetworkObjectID = _NtwkObjects.GHONetworkObjectID  -- association [0..*]
LEFT OUTER JOIN I_GhoFreqText AS _FrequencyText ON UpstreamMsmtFreq = _FrequencyText.AllocationFrequencyCode  -- association [0..*]
LEFT OUTER JOIN I_GHOCharacteristic AS _Characteristic ON GHOCharacteristicName = _Characteristic.GHOCharacteristicName  -- association [0..*]
LEFT OUTER JOIN I_GHONtwkObjMsmtItems AS _MsmtItems ON measurementdocument = _MsmtItems.MeasurementDocument AND a.GHOCharacteristicName = _MsmtItems.GHOCharacteristicName association[0..*] to I_GHONtwkObjMeasurements as _NtwkObjMeasurements on _NtwkObjMeasurements.GHONetworkID = a.GHONetworkID AND _NtwkObjMeasurements.GHONetworkObjectID = a.NetworkObject AND _NtwkObjMeasurements.MeasurementDocument = measurementdocument  -- association [0..*]
;