I_PRAValnDocTransUnitVolume

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_PRAValnDocTransUnitVolume.
-- 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_PRAValnDocTransUnitVolume AS
SELECT
  doc_no AS ValuationDocumentNumber,
  doc_year AS PRAWellTestDocYear,
  line_no AS ValuationDocumentLineNumber,
  pos_no AS PRAPositionNumber,
  tr_bukrs AS CompanyCode,
  tr_vname AS PRAJointVenture,
  tr_doi AS DivisionOfInterest,
  school_dist_cd AS PRASchoolDistrictCode,
  tax_cls AS PRATaxClass,
  vl_type_cd AS VolumeType,
  vl_cls_cd AS VolumeClass,
  lvl_cd AS PRALevelCode,
  wi_own_no AS PRAWorkingInterestOwner,
  wi_int_type_cd AS OwnerInterestType,
  wi_own_isq_no AS OwnerInterestSequence,
  ni_own_no AS PRANetInterestOwner,
  ni_int_type_cd AS NetInterestOwnerInterestType,
  ni_own_isq_no AS NetIntrstOwnerInterestSequence,
  orig_mp_no AS OriginatingMeasurementPt,
  mp_type_cd AS MeasurementPtType,
  pc_wl_no AS Well,
  pc_wc_no AS WellCompletion,
  pc_mp_no AS MeasurementPoint,
  oicontnr AS PRAContract,
  kalsm AS SDPricingProcedure,
  kschl AS ConditionType,
  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,
  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,
  act_heat_val_fct AS PRAActualHeatingFactorQty,
  heat_value_fct_u AS PRAHeatingValueFactorUnit,
  trnsp_no AS Transporter,
  trnsp_ref_no AS TransporterReference
FROM oiurv_doc_volunt
LEFT OUTER JOIN I_VolumeClass AS _VolumeClass ON _VolumeClass.VolumeClass = VolumeClass  -- association [0..1]
LEFT OUTER JOIN I_PRALevelCodeVH AS _PRALevelCodeVH ON _PRALevelCodeVH.PRALevelCode = PRALevelCode  -- association [0..1]
;