I_PRAValuationFormulaDetail

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_PRAValuationFormulaDetail.
-- 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_PRAValuationFormulaDetail AS
SELECT
  frml_no AS PRAFormulaNumber,
  seq_no AS PRASequenceNumber,
  eff_from_dt AS EffectiveFromDate,
  eff_to_dt AS EffectiveToDate,
  bukrs_1 AS PRACompanyCode1,
  rvwd_type_cd_1 AS PRAFormulaReserveWordType1,
  rvwd_cd_1 AS PRAValuationReservedWord1,
  vsrc_cd_1 AS PRAValuationSourceCode1,
  vsrc_no_1 AS PRAValuationSource1,
  vsrc_wc_no_1 AS PRAValnSourceWellCompletion1,
  doi_no_1 AS PRADivisionOfInterest1,
  ctsrc_no_1 AS PRASourceContractNumber1,
  ctsrc_type_cd_1 AS PRASourceContractType1,
  bukrs_2 AS PRACompanyCode2,
  rvwd_type_cd_2 AS PRAFormulaReserveWordType2,
  rvwd_cd_2 AS PRAValuationReservedWord2,
  vsrc_cd_2 AS PRAValuationSourceCode2,
  vsrc_no_2 AS PRAValuationSource2,
  vsrc_wc_no_2 AS PRAValnSourceWellCompletion2,
  doi_no_2 AS PRADivisionOfInterest2,
  ctsrc_no_2 AS PRASourceContractNumber2,
  ctsrc_type_cd_2 AS PRASourceContractType2,
  func_cd AS PRAFunction,
  rslt_cd AS PRAValnReserveWordResult,
  rslt_taxtype AS SeveranceTaxType,
  appr_fl AS PRAUnitVentureIsApproved,
  rslt_actentst_cd AS PRAActualEntitledSettlement,
  affil_fl_1 AS PRAAffiliateFlag1IsChecked,
  peratfi_cd_1 AS PRAPercentRateFixedCode1,
  vt_type_cd_1 AS PRAVolumeType1,
  majpd_cd_1 AS PRAMajorProductCode1,
  matnr_1 AS PRAMaterial1,
  pur_no_1 AS PRAPurchaser1,
  affil_fl_2 AS PRAAffiliateFlag2IsChecked,
  peratfi_cd_2 AS PRAPercentRateFixedCode2,
  vt_type_cd_2 AS PRAVolumeType2,
  majpd_cd_2 AS PRAMajorProductCode2,
  matnr_2 AS PRAMaterial2,
  pur_no_2 AS PRAPurchaser2,
  rvwd_cd_1_u AS PRAValuationReservedWord1Unit,
  rvwd_cd_2_u AS PRAValuationReservedWord2Unit,
  tr_no_1 AS PRATractNumber1,
  tr_no_2 AS PRATractNumber2,
  rslt_tax_cls AS PRATaxClass,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime
FROM oiu_rv_frmld
LEFT OUTER JOIN I_PRAValuationFormulaID AS _PRAValuationFormulaID ON _PRAValuationFormulaID.PRAFormulaNumber = PRAFormulaNumber  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode1 ON _CompanyCode1.CompanyCode = PRACompanyCode1  -- association [0..1]
LEFT OUTER JOIN I_PRAMaintDOI AS _PRAMaintDOI1 ON _PRAMaintDOI1.CompanyCode = PRACompanyCode1 AND _PRAMaintDOI1.DivisionOfInterest = PRADivisionOfInterest1  -- association [0..1]
LEFT OUTER JOIN I_PRAContract AS _PRAContract1 ON _PRAContract1.PRAContract = PRASourceContractNumber1  -- association [0..1]
LEFT OUTER JOIN I_PRAContractType AS _PRAContractType1 ON _PRAContractType1.PRAContractType = PRASourceContractType1  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode2 ON _CompanyCode2.CompanyCode = PRACompanyCode2  -- association [0..1]
LEFT OUTER JOIN I_PRAMaintDOI AS _PRAMaintDOI2 ON _PRAMaintDOI2.CompanyCode = PRACompanyCode2 AND _PRAMaintDOI2.DivisionOfInterest = PRADivisionOfInterest2  -- association [0..1]
LEFT OUTER JOIN I_PRAContract AS _PRAContract2 ON _PRAContract2.PRAContract = PRASourceContractNumber2  -- association [0..1]
LEFT OUTER JOIN I_PRAContractType AS _PRAContractType2 ON _PRAContractType2.PRAContractType = PRASourceContractType2  -- association [0..1]
LEFT OUTER JOIN I_VolumeType AS _VolumeType1 ON _VolumeType1.VolumeType = PRAVolumeType1  -- association [0..1]
LEFT OUTER JOIN I_PRAMatlMjrProdMappg AS _PRAMatlMjrProdMappg1 ON _PRAMatlMjrProdMappg1.Material = PRAMaterial1  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer1 ON _Customer1.Customer = PRAPurchaser1  -- association [0..1]
LEFT OUTER JOIN I_VolumeType AS _VolumeType2 ON _VolumeType2.VolumeType = PRAVolumeType2  -- association [0..1]
LEFT OUTER JOIN I_PRAMatlMjrProdMappg AS _PRAMatlMjrProdMappg2 ON _PRAMatlMjrProdMappg2.Material = PRAMaterial2  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer2 ON _Customer2.Customer = PRAPurchaser2  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure1 ON _UnitOfMeasure1.UnitOfMeasure = PRAValuationReservedWord1Unit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure2 ON _UnitOfMeasure2.UnitOfMeasure = PRAValuationReservedWord2Unit  -- association [0..1]
LEFT OUTER JOIN I_Calculationbasis AS _CalculationBasis ON _CalculationBasis.CalculationBasis = PRAActualEntitledSettlement  -- association [0..1]
LEFT OUTER JOIN I_PRAReservedWordTypeVH AS _PRAReservedWordType1 ON _PRAReservedWordType1.PRAReserveWordType = PRAFormulaReserveWordType1  -- association [0..1]
LEFT OUTER JOIN I_PRAValuationSourceVH AS _PRAValuationSource1 ON _PRAValuationSource1.PRAValuationSourceCode1 = PRAValuationSourceCode1  -- association [0..1]
LEFT OUTER JOIN I_PRAReservedWordTypeVH AS _PRAReservedWordType2 ON _PRAReservedWordType2.PRAReserveWordType = PRAFormulaReserveWordType2  -- association [0..1]
LEFT OUTER JOIN I_PRAValuationSourceVH AS _PRAValuationSource2 ON _PRAValuationSource2.PRAValuationSourceCode1 = PRAValuationSourceCode2  -- association [0..1]
LEFT OUTER JOIN I_PRAFunctionVH AS _PRAFunction ON _PRAFunction.PRAFunction = PRAFunction  -- association [0..1]
LEFT OUTER JOIN I_PRAPctgRateFixedCodeVH AS _PRAPerRateFixedCode1 ON _PRAPerRateFixedCode1.PRAPercentRateFixedCode1 = PRAPercentRateFixedCode1  -- association [0..1]
LEFT OUTER JOIN I_MajorProduct AS _MajorProduct1 ON _MajorProduct1.MajorProduct = PRAMajorProductCode1  -- association [0..1]
LEFT OUTER JOIN I_PRAPctgRateFixedCodeVH AS _PRAPerRateFixedCode2 ON _PRAPerRateFixedCode2.PRAPercentRateFixedCode1 = PRAPercentRateFixedCode2  -- association [0..1]
LEFT OUTER JOIN I_MajorProduct AS _MajorProduct2 ON _MajorProduct2.MajorProduct = PRAMajorProductCode2  -- association [0..1]
LEFT OUTER JOIN I_PRAValuationReserveWordVH AS _ReserveWord1 ON _ReserveWord1.PRAValnReserveWordResult = PRAValuationReservedWord1  -- association [0..1]
LEFT OUTER JOIN I_PRAValuationReserveWordVH AS _ReserveWord2 ON _ReserveWord2.PRAValnReserveWordResult = PRAValuationReservedWord2  -- association [0..1]
LEFT OUTER JOIN I_PRAValuationReserveWordVH AS _ReserveWordVH ON _ReserveWordVH.PRAValnReserveWordResult = PRAValnReserveWordResult  -- association [0..1]
;