I_GHOWellWellCompletionTest

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_GHOWellWellCompletionTest.
-- 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_GHOWellWellCompletionTest AS
SELECT
  InspectionLot,
  GHONetworkID,
  GHOWellCompletionID,
  GHOWellID,
  _WellCompStandardItems.AllocationRuleUnitOfMsmt AS AllocationRuleUnitOfMsmt,
  _WellTestPriority.GHOWellTestCategoryID AS GHOWellTestCategoryID,
  ValidFromDateTime,
  ValidToDateTime,
  EffectiveFromDateTime,
  EffectiveToDateTime,
  _WellCompStandardItems.MeasurementGroup AS MeasurementGroup,
  _WellCompStandardItems.AllocationRuleMsmtValue AS AllocationRuleMsmtValue,
  _WellCompStandardItems._MsmtMappedToMedium.NetworkMedium AS NetworkMedium,
  _WellCompStandardItems._MeasurementGroupText AS _MeasurementGroupText,
  _WellCompStandardItems._MsmtMappedToMedium._MediumText AS _MediumText
FROM I_GHOWellCompStandardResults
LEFT OUTER JOIN I_GHOUnitOfMsmtRuleExpanded AS _UnitOfMsmtRule ON GHONetworkID = _UnitOfMsmtRule.GHONetworkID AND ( ValidFromDateTime >= _UnitOfMsmtRule.ValidFromDateTime AND ValidToDateTime <= _UnitOfMsmtRule.ValidToDateTime ) AND _UnitOfMsmtRule.NetworkMedium = networkmedium AND _UnitOfMsmtRule.AllocationRuleUnitOfMsmt = allocationruleunitofmsmt  -- association [0..*]
LEFT OUTER JOIN I_GHOAllocMsmtPrioRuleExpanded AS _WellPriorityRules ON GHOWellID = _WellPriorityRules.GHONetworkObjectID AND GHONetworkID = _WellPriorityRules.GHONetworkID AND ( ValidFromDateTime >= _WellPriorityRules.ValidFromDateTime AND ValidToDateTime <= _WellPriorityRules.ValidToDateTime ) AND ghowelltestcategoryid = _WellPriorityRules.GHOMeasurementCategoryID  -- association [0..*]
LEFT OUTER JOIN I_GHOAllocMsmtPrioRuleExpanded AS _WellCompPriorityRules ON GHOWellCompletionID = _WellCompPriorityRules.GHONetworkObjectID AND GHONetworkID = _WellCompPriorityRules.GHONetworkID AND ( ValidFromDateTime >= _WellCompPriorityRules.ValidFromDateTime AND ValidToDateTime <= _WellCompPriorityRules.ValidToDateTime ) AND ghowelltestcategoryid = _WellCompPriorityRules.GHOMeasurementCategoryID  -- association [0..*]
LEFT OUTER JOIN I_GHOAllocMsmtPrioRuleExpanded AS _AllocMsmtPriorityRules ON GHONetworkID = _AllocMsmtPriorityRules.GHONetworkID AND ( ValidFromDateTime >= _AllocMsmtPriorityRules.ValidFromDateTime AND ValidToDateTime <= _AllocMsmtPriorityRules.ValidToDateTime ) AND ghowelltestcategoryid = _AllocMsmtPriorityRules.GHOMeasurementCategoryID  -- association [0..*]
LEFT OUTER JOIN I_GHOMsmtCategoryText AS _MsmtCategoryText ON ghowelltestcategoryid = _MsmtCategoryText.GHOMeasurementCategoryID  -- association [0..*]
;