I_PRAValnDocTransVolDetail

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_PRAValnDocTransVolDetail.
-- 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_PRAValnDocTransVolDetail AS
SELECT
  doc_no AS ValuationDocumentNumber,
  doc_year AS ValuationDocumentYear,
  line_no AS ValuationDocumentLineNumber,
  pos_no AS PRAPositionNumber,
  land1 AS Country,
  pri_geo_loc AS PrimaryGeogrlLocation,
  sec_geo_loc AS SecondaryGeogrlLocation,
  school_dist_cd AS PRASchoolDistrictCode,
  tax_cls AS PRATaxClass,
  ons_ofs_cd AS PRAJntVntrOnshoreOffshoreCode,
  system_srce_cd AS PRAValnTransSourceCode,
  pay_cd AS OwnerPaymentStatus,
  vname_type_cd AS PRAJointVentureUsageType,
  theo_cnd_tax_fl AS PRAIsThrtclCondensateTxCalc,
  ca_alloc_meth_cd AS PRACntrctlAllocMethodCode,
  related_ct AS PRARelatedContract,
  lvl_cd AS PRALevelCode,
  wi_own_no AS PRAWorkingInterestOwner,
  wi_int_type_cd AS OwnerInterestType,
  wi_own_isq_no AS OwnerInterestSequence,
  tr_bukrs AS CompanyCode,
  tr_vname AS JointVenture,
  tr_doi AS DivisionOfInterest,
  ni_own_no AS PRANetInterestOwner,
  ni_int_type_cd AS NetInterestOwnerInterestType,
  ni_own_isq_no AS NetIntrstOwnerInterestSequence,
  ni_frml_no AS PRAInterestFormulaNumber,
  tr_doi_sum_fl AS PRAIsSmmrzAtDivisionOfInterest,
  tot_gri_pc AS PRATotGrssRevnIntrstPercent,
  tot_nri_pc AS DOITotalNetRevnIntrstRatio,
  ct_decm AS PRAContractDecimalPercent,
  rel_ct_decm AS PRARltvContractDecimalPercent,
  sett_decm AS PRASettlementDecimalPercent,
  tot_mkt_grp_gri AS PRATotMktgGrpGrssRevnIntrstPct,
  mp_type_cd AS MeasurementPtType,
  orig_mp_no AS OriginatingMeasurementPt,
  mp_type_cd2 AS SecondMeasurementPointType,
  vl_type_cd AS VolumeType,
  vl_cls_cd AS VolumeClass,
  frml_actl_fl AS PRAIsActual,
  frml_entl_fl AS PRAIsEntitled,
  frml_sett_fl AS PRAIsSettlement,
  tot_ct_vl AS PRATotalContractVolume,
  tot_ct_vl_u AS PRATotalContractVolumeUnit,
  tot_gr_vl AS PRATotalGrossVolume,
  tot_gr_vl_u AS PRATotalGrossVolumeUnit,
  actl_gr_vl AS ActualGrossVolume,
  actl_gr_vl_u AS PRAActualGrossVolumeUnit,
  entl_gr_vl AS EntldGrossVolume,
  entl_gr_vl_u AS PRAEntitledGrossVolUnit,
  sett_gr_vl AS PRASettlementGrossVolume,
  sett_gr_vl_u AS PRASettlementGrossVolUnit,
  tot_ct_energy AS PRATotalContractEnergy,
  actl_energy AS ActualEnergy,
  actl_energy_u AS PRAActualEnergyUnit,
  entl_energy AS PRAEntitlementEnergy,
  entl_energy_u AS PRAEntitledEnergyUnit,
  sett_energy AS PRASettlementEnergy,
  sett_energy_u AS PRASettlementEnergyUnit,
  uncr_gr_vl AS PRAUncorrectedGrossVolume,
  uncr_gr_vl_u AS PRAUncorrectedGrossVolumeUnit,
  uncr_sett_gr_vl AS PRAUncorrectedSettlmtGrssVol,
  run_tkt_no AS PRARunTicketNumber,
  tot_tkt_days AS PRATotalTicketDays,
  prd_days AS ProductionDays,
  sale_dt_to AS PRASalesToDate,
  sale_dt_from AS PRASalesFromDate,
  tank_meter AS PRATransAcctsRblMsmtPt,
  grv_am AS PRADensityAtStdBaseCndnValue,
  density_u AS PRADensityAtStdBaseCndnUnit,
  dntyp AS PRADensityType,
  heat_value_fct_u AS PRAHeatingValueFactorUnit,
  act_heat_val_fct AS PRAActualHeatingFactorQty,
  set_heat_val_fct AS PRASettlmtHeatingValueFctrQty,
  ct_heat_val_fct AS PRAContrHeatingValueFactorQty,
  ct_heat_va_fct_u AS PRAContrHeatingValueFactorUnit,
  vl_timestamp AS PRA_CreationDateTime,
  trnsp_no AS Transporter,
  trnsp_ref_no AS TransporterReference,
  trnsp_rou_cd AS PRATransporterRouteCode,
  gaslift_wl_no AS PRAGasLiftWell,
  gaslift_wc_no AS PRAGasLiftWellCompletion,
  rej_rsn_cd AS PRARejectionReasonCode,
  ra_pct AS PRAReservoirFormationPercent,
  tik_pa_pc AS PRATakeInKindProcgAgrmtPct,
  ca_wgb_cd AS PRAWetGasBalancingCode,
  calc_wlr_fl AS PRAIsWetLessResidue,
  pct_ret_lse AS PRAReturnedToLeasePercent,
  actl_wlr_vl_am AS PRAActualWetLessResidueVolume,
  actl_wlr_vl_am_u AS PRAActlWetLessResidueVolUnit,
  entl_wlr_vl_am AS PRAEntldWetLessResidueVolume,
  entl_wlr_vl_am_u AS PRAEntldWetLessResidueVolUnit,
  sett_wlr_vl_am AS PRASettlmtWetLessResidueVolume,
  sett_wlr_vl_am_u AS SettlmtWetLessResidueVolUnit,
  ent_vl_alloc_dec AS PRAEntldVolAllocPercent,
  ent_eng_allc_dec AS PRAEntldEnergyAllocPercent,
  entl_sett_gr_vl AS PRAEntldSettlmtGrossVolume,
  ent_set_gr_vl_u AS PRAEntldSettlmtGrossVolUnit,
  entl_sett_energy AS PRAEntldSettlmtEnergyQuantity,
  entl_sett_eng_u AS PRAEntldSettlmtEnergyUnit,
  cost_center AS CostCenter,
  lse_vol AS PRALeaseVolume,
  lse_vol_u AS PRALeaseVolumeUnit,
  rej_zv_cd AS PRAValnRejectZeroVolumeCode,
  gplt_vname AS GasPlantJointVenture,
  gplt_doi_doi AS GasPlantDivisionOfInterest,
  orig_gri_pc AS PRAOriglGrssRevnIntrstPercent,
  entl_ct_decm AS PRAEntldContractDecimalPercent,
  e_set_wlr_vl_am AS EntldSettlmtWetLessResidueVol,
  e_set_wlr_vl_a_u AS EntldSettlmtWetLessResidueUnit,
  actl_ptr_vl_am AS PRAActlPlntThrmlReducnVolume,
  actl_ptr_vl_am_u AS PRAActlPlntThrmlReducnUnit,
  entl_ptr_vl_am AS PRAEntldPlntThrmlReducnVolume,
  entl_ptr_vl_am_u AS PRAEntldPlntThrmlReducnUnit,
  sett_ptr_vl_am AS PRASettlmtPlntThrmlReducnVol,
  sett_ptr_vl_am_u AS PRASettlmtPlntThrmlReducnUnit
FROM oiurv_doc_voldtl
LEFT OUTER JOIN I_PRAOnshoreOffshoreCodeVH AS _PRAOnshoreOffshoreCodeVH ON _PRAOnshoreOffshoreCodeVH.PRAJntVntrOnshoreOffshoreCode = PRAJntVntrOnshoreOffshoreCode  -- association [0..1]
LEFT OUTER JOIN I_PRAValnTransSrceCodeVH AS _PRAValnTransSrcCodeVH ON _PRAValnTransSrcCodeVH.PRAValnTransSourceCode = PRAValnTransSourceCode  -- association [0..1]
LEFT OUTER JOIN I_OwnerPaymentStatus AS _OwnerPaymentStatus ON _OwnerPaymentStatus.OwnerPaymentStatus = OwnerPaymentStatus  -- association [0..1]
LEFT OUTER JOIN I_PRAJointVentureUsageTypeVH AS _PRAJointVentureUsageTypeVH ON _PRAJointVentureUsageTypeVH.PRAJointVentureUsageType = PRAJointVentureUsageType  -- association [0..1]
LEFT OUTER JOIN I_PRAContrAllocMethodCodeVH AS _PRAAllocMethodCodeVH ON _PRAAllocMethodCodeVH.PRACntrctlAllocMethodCode = PRACntrctlAllocMethodCode  -- association [0..1]
LEFT OUTER JOIN I_PRALevelCodeVH AS _PRALevelCodeVH ON _PRALevelCodeVH.PRALevelCode = PRALevelCode  -- association [0..1]
LEFT OUTER JOIN I_VolumeClass AS _VolumeClass ON _VolumeClass.VolumeClass = VolumeClass  -- association [0..1]
LEFT OUTER JOIN I_PRADensityTypeVH AS _PRADensityTypeVH ON _PRADensityTypeVH.PRADensityType = PRADensityType  -- association [0..1]
LEFT OUTER JOIN I_PRAWetGasBalancingCodeVH AS _PRAWetGasBalancingCodeVH ON _PRAWetGasBalancingCodeVH.PRAWetGasBalancingCode = PRAWetGasBalancingCode  -- association [0..1]
;