I_PRATstValnCrsRefVH

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_PRATstValnCrsRefVH.
-- 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: IPRAVALNCRSREFVH

CREATE VIEW I_PRATstValnCrsRefVH AS
SELECT
  dn_no AS DeliveryNetwork,
  vname AS PRAJointVenture,
  doi_no AS DivisionOfInterest,
  ct_no AS PRAContract,
  wl_no AS Well,
  wc_no AS WellCompletion,
  mp_no AS MeasurementPoint,
  _DeliveryNetwork.DeliveryNetworkName AS DeliveryNetworkName,
  _PRAJointVenture.PRAJointVentureName AS PRAJointVentureName,
  _PRAMaintDOI.DivisionOfInterestDesc AS DivisionOfInterestDesc,
  _PRAContract.PRAContractDesc AS PRAContractDesc,
  _Well.WellName AS WellName,
  _WellCompletion.WellCompletionName AS WellCompletionName,
  _MeasurementPoint.MeasurementPtName AS MeasurementPtName,
  bukrs AS CompanyCode,
  majpd_cd AS MajorProduct,
  freq_cd AS AllocationFrequency,
  eff_from_dt AS EffectiveFromDate,
  eff_to_dt AS EffectiveToDate,
  vcr_no AS PRAValnCrsRefNumber,
  frml_no AS PRAFormulaNumber,
  mp_type_cd AS MeasurementPtType,
  ca_dvrs_fl AS PRAHasContractDiversity,
  stlmt_dvrs_fl AS PRAHasSettlementDiversity,
  vcr_appr_fl AS PRAValnCrossRefIsApproved,
  group_cd AS PRAGroupCode,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime
FROM oiu_rv_vcr
LEFT OUTER JOIN I_DeliveryNetwork AS _DeliveryNetwork ON DeliveryNetwork = _DeliveryNetwork.DeliveryNetwork  -- association [1..1]
LEFT OUTER JOIN I_PRAJointVenture AS _PRAJointVenture ON PRAJointVenture = _PRAJointVenture.PRAJointVenture AND CompanyCode = _PRAJointVenture.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PRAMaintDOI AS _PRAMaintDOI ON PRAJointVenture = _PRAMaintDOI.PRAJointVenture AND DivisionOfInterest = _PRAMaintDOI.DivisionOfInterest AND CompanyCode = _PRAMaintDOI.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PRAContract AS _PRAContract ON PRAContract = _PRAContract.PRAContract  -- association [1..1]
LEFT OUTER JOIN I_Well AS _Well ON Well = _Well.Well  -- association [1..1]
LEFT OUTER JOIN I_WellCompletion AS _WellCompletion ON Well = _WellCompletion.Well AND WellCompletion = _WellCompletion.WellCompletion  -- association [1..1]
LEFT OUTER JOIN I_MeasurementPoint AS _MeasurementPoint ON MeasurementPoint = _MeasurementPoint.MeasurementPoint  -- association [1..1]
LEFT OUTER JOIN I_MajorProduct AS _MajorProduct ON MajorProduct = _MajorProduct.MajorProduct  -- association [0..1]
LEFT OUTER JOIN I_PRAValuationFormulaID AS _PRAValuationFormulaID ON _PRAValuationFormulaID.PRAFormulaNumber = PRAFormulaNumber  -- association [1..1]
LEFT OUTER JOIN I_MeasurementPtType AS _MeasurementPtType ON _MeasurementPtType.MeasurementPtType = MeasurementPtType  -- association [1..1]
LEFT OUTER JOIN I_AllocationFrequencyCode AS _AllocationFrequencyCode ON AllocationFrequency = _AllocationFrequencyCode.AllocationFrequency  -- association [1..1]
LEFT OUTER JOIN I_PRAGroupCodeVH AS _PRAGroupCodeVH ON PRAGroupCode = _PRAGroupCodeVH.PRAGroupCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [1..1]
;