C_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 C_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 C_GHONtwkObjWellReading AS
SELECT
  cast(GHONetworkID as gho_network_id preserving type ) AS GHONetworkID,
  cast(GHONetworkObjectID as gho_ntwkobj_id preserving type ) AS GHONetworkObjectID,
  cast(UpstreamMsmtFreq as gho_measurement_freq_id preserving type ) AS UpstreamMsmtFreq,
  cast(MeasurementDocument as gho_msmt_document_number preserving type ) AS MeasurementDocument,
  cast(GHOCharacteristicName as gho_mstmt_group_id preserving type ) AS GHOCharacteristicName,
  _FrequencyText[1: Language = $session.system_language ].FrequencyDescription AS FrequencyDescription,
  cast(_NtwkObjects._FunctionalLocationLabel.FunctionalLocationLabelName as gho_well_labelname preserving type ) AS WellName,
  cast(_NtwkObjects._FunctionalLocation._FunctionalLocationText[1: Language = $session.system_language ].FunctionalLocationName as gho_well_desc preserving type ) AS WellDescription,
  _NtwkObjects.NetworkObjectType AS GHOWellNtwkObjType,
  cast(_NtwkObjects.ExternalNetworkObjectID as gho_well_ext_id preserving type ) AS ExternalWellIdentifier,
  _MsmtItems.GHOMeasurementValue AS GHOMeasurementValue,
  cast(0 as gho_quantity_in_dec ) AS GHOAllocationQuantity,
  _MsmtItems.AllocationRuleUnitOfMsmt AS AllocationRuleUnitOfMsmt,
  MeasurementGroup,
  cast(_MeasurementGroupText[1:Language = $session.system_language ].MeasurementTypeDesc as gho_msmt_group_desc preserving type ) AS MeasurementTypeDesc,
  cast(UpstreamMsmtPoint as gho_measurement_point preserving type ) AS UpstreamMsmtPoint,
  cast(UpstreamMsmtDate as gho_measurement_date preserving type ) AS UpstreamMsmtDate,
  cast(UpstreamMsmtTime as gho_production_time preserving type ) AS UpstreamMsmtTime,
  _NtwkObjMeasurements.AllocUnitOfMsmtRuleUUID AS AllocUnitOfMsmtRuleUUID
FROM I_GHONtwkObjWellReading
;