I_GHONtwkObjMeasurements

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_GHONtwkObjMeasurements.
-- 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_GHONtwkObjMeasurements AS
SELECT
  cast (netid as gho_network_id preserving type) AS GHONetworkID,
  cast (netobj as gho_ntwkobj_id preserving type ) AS GHONetworkObjectID,
  alloc_material AS AllocationMaterial,
  quantity_type AS GHOQuantityType,
  prod_timestamp AS ProdnAllocDateTime,
  alloc_type AS ProductionAllocationType,
  frequency AS AllocationFrequencyCode,
  gho_meas_cat_id AS GHOMeasurementCategoryID,
  bus_key AS AllocUnitOfMsmtRuleUUID,
  mdocm AS MeasurementDocument,
  status_object_number AS StatusObjectNumber,
  trnsp_no AS Transporter,
  trnsp_ref_no AS TransporterReference,
  tkt_no AS TicketNumber,
  cast(originating_mp as gho_originating_meas_point preserving type ) AS GHOOriginatingMsmtPoint,
  cast( to_prod_network as gho_assigned_prod_network preserving type ) AS AssignedToProdnNetwork,
  cast(to_network_obj as gho_de_netobj_id preserving type ) AS ToNetworkObjectID,
  to_netobj_type AS ToNetworkObjectType,
  ld_oil_wo_recov AS LoadOilTransferWithoutRecovery,
  cast(ref_network_id as gho_prodflow_prodnet_id preserving type ) AS ProdnFlwProdnNtwk,
  cast( ref_node_id as gho_node_id preserving type ) AS ProdnFlwProdnNtwkObject,
  created_by AS CreatedByUserName,
  created_tst AS GHOCreatedOnDateTime,
  changed_by AS ChangedByUserName,
  changed_tst AS GHOChangedOnDateTime
FROM gho_imrg_std_h
LEFT OUTER JOIN I_Material AS _AllocatedMaterial ON AllocationMaterial = _AllocatedMaterial.Material  -- association [1..1]
LEFT OUTER JOIN I_GHONtwkObjMsmtItems AS _MsmtItems ON MeasurementDocument = _MsmtItems.MeasurementDocument  -- association [0..*]
LEFT OUTER JOIN I_GHONtwkObjTransporterText AS _TransporterText ON Transporter = _TransporterText.Transporter  -- association [0..*]
LEFT OUTER JOIN I_GHONtwkObjStdMsmtItems AS _StandarizedMsmtItems ON AllocUnitOfMsmtRuleUUID = _StandarizedMsmtItems.AllocUnitOfMsmtRuleUUID  -- association [0..*]
LEFT OUTER JOIN I_GhoMeasDocExtn_Db AS _MeasurementDocument ON MeasurementDocument = _MeasurementDocument.UpstreamMsmtDoc  -- association [0..*]
LEFT OUTER JOIN I_GHONtwkObjects AS _NtwkObjects ON GHONetworkObjectID = _NtwkObjects.GHONetworkObjectID  -- association [0..*]
LEFT OUTER JOIN I_GhoFreqText AS _FrequencyText ON AllocationFrequencyCode = _FrequencyText.AllocationFrequencyCode  -- association [0..*]
LEFT OUTER JOIN I_GHOProdnNtwkDetails AS _ProductionNetworkDetails ON GHONetworkID = _ProductionNetworkDetails.GHONetworkID  -- association [1..1]
LEFT OUTER JOIN I_GHONtwkAllocRuleQtyType AS _NtwkAllocRuleQtyType ON GHOQuantityType = _NtwkAllocRuleQtyType.NtwkAllocQtyType  -- association [0..*]
LEFT OUTER JOIN I_GHOMsmtCategoryText AS _MsmtCategoryText ON GHOMeasurementCategoryID = _MsmtCategoryText.GHOMeasurementCategoryID  -- association [0..*]
LEFT OUTER JOIN I_GHONtwkObjects AS _OriginatingMsmtPt ON GHOOriginatingMsmtPoint = _OriginatingMsmtPt.GHONetworkObjectID  -- association [1..1]
LEFT OUTER JOIN I_GHONtwkObjects AS _ToNetworkObjectID ON ToNetworkObjectID = _ToNetworkObjectID.GHONetworkObjectID  -- association [1..1]
LEFT OUTER JOIN I_GHOProdnNtwkDetails AS _AssignedToProdnNetwork ON AssignedToProdnNetwork = _AssignedToProdnNetwork.GHONetworkID  -- association [1..1]
LEFT OUTER JOIN I_GHONtwkObjects AS _ProdnFlwProdnNtwkObj ON GHONetworkObjectID = _ProdnFlwProdnNtwkObj.GHONetworkObjectID  -- association [1..1]
LEFT OUTER JOIN I_GHOProdnNtwkDetails AS _ProdnFlwProdnNtwk ON AssignedToProdnNetwork = _ProdnFlwProdnNtwk.GHONetworkID  -- association [1..1]
LEFT OUTER JOIN I_ReadDomainFixedValues AS _AllocationTypeText ON ProductionAllocationType = _AllocationTypeText.DomainValue AND _AllocationTypeText.SAPDataDictionaryDomain = 'GHO_ALLOC_TYPE'  -- association [0..*]
LEFT OUTER JOIN I_GHOMaterialMedium AS _MaterialMedium ON AllocationMaterial = _MaterialMedium.Material  -- association [1..1]
LEFT OUTER JOIN I_CustomerToBusinessPartner AS _BusinessPartner ON Transporter = _BusinessPartner.Customer  -- association [0..1]
LEFT OUTER JOIN I_GHOQuantityType AS _QuantityType ON GHOQuantityType = _QuantityType.GHOQuantityType  -- association [0..*]
;