I_PRA_US_AKRyRptOOStueHistory

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_PRA_US_AKRyRptOOStueHistory.
-- 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_PRA_US_AKRyRptOOStueHistory AS
SELECT
  cast(bukrs as bukrs preserving type ) AS PRAInternalCompanyCode,
  sales_dt AS PRASalesDate,
  cast(pdcd as oiu_full_pd_cd preserving type ) AS PRAProduct,
  cast(wl_no as oiu_wl_no preserving type ) AS Well,
  cast(wc_no as oiu_wc_no preserving type ) AS WellCompletion,
  cast(mp_no as oiu_mp_no preserving type ) AS MeasurementPoint,
  cast(vname as jv_name preserving type ) AS PRAJointVenture,
  cast(doi_no as oiu_doi_no preserving type ) AS DivisionOfInterest,
  cast(dn_no as oiu_dn_no preserving type ) AS DeliveryNetwork,
  cast(ct_no as oiu_ct_no preserving type ) AS PRAContract,
  cast(vl_type_cd as oiu_vt_cd preserving type ) AS VolumeType,
  cast(own_no as oiu_own_no preserving type ) AS PRAOwner,
  cast(own_int_type_cd as oiu_part_int_type preserving type ) AS OwnerInterestType,
  own_isq_no AS OwnerInterestSequence,
  kostl AS VarblDataCostCenter,
  rev_book_adj_ind AS TaxRptgRvslOrBkgOrAdjmt,
  unit_vname AS PRAUnitVenture,
  operated_fl AS PRAIsMsmtPointOperated,
  orig_mp_no AS OriginatingMeasurementPt,
  acct_no AS GLAccount,
  ps_base_qy AS PressureBaseQty,
  grv_qy AS APIGravityRatio,
  pay_cd AS PRANewPaymentCode,
  own_int_decm_qy AS PRAOwnNetRevnInterestPercent,
  own_bal_decm_qy AS PRAOwnerDisbursementDcmls,
  pri_geo_loc AS PrimaryGeogrlLocation,
  counc AS PRACounty,
  enty_cd AS PRALegalForm,
  waers AS PRACurrency,
  vol_uom AS PRAVolumeUnitOfMeasure,
  energy_uom AS PRAEnergyUoM,
  heat_val_uom AS PRAHeatingValueUnitOfMeasure,
  pres_uom AS PRAPressureUnitOfMeasure,
  btu_qy AS PRABritishThermalUnitQuantity,
  prd_days AS ProductionDays,
  disb_decimal AS DisbursementDecimalRatio,
  nri_decimal AS NetRevenueInterestRatio,
  doc_no AS ValuationDocumentNumber,
  doc_year AS ValuationDocumentYear,
  gross_vol AS GrossVolInVolUnit,
  gross_energy AS GrossEnergyInEnergyUnit,
  gross_pvr AS GrossVolReducnInVolUnit,
  gross_ptr AS GrossThermReductionInQuantity,
  net_vol AS OwnerNetVolInVolUnit,
  owner_energy AS OwnerEnergyInEnergyUnit,
  own_pvr AS OwnrVolReducnInVolUnit,
  own_ptr AS OwnerThermReductionInQuantity,
  gross_val AS GrossLessDeductionAmt,
  owner_gross_val AS OwnerGrossAmount,
  net_val AS OwnerNetAmount,
  net_transp_am AS PRATaxRoytyRptgNetTranspAmount,
  net_oth_mk_am AS PRATaxRoytyRptgNetOthMktgAmt,
  ded_rmb_am AS PRANetReimbmtMarketingAmount,
  tax_am AS PRATaxAmount,
  tax_rmb_am AS PRATaxReimbmtAmount,
  option1 AS PRATaxRoytyRptgOption1,
  option2 AS PRATaxRoytyRptgOption2,
  option3 AS PRATaxRoytyRptgOption3,
  interface_fl AS TransactionIsLegacyData,
  reference_run_id AS PRAReferenceRunID,
  prof_link_guid AS PRA_US_AKReportingLink,
  master_level AS MasterDataRecordingLvl,
  product_cd AS PRA_US_AKProductCode,
  report_cd AS PRA_US_AKReportCode,
  ac_unit_cd AS PRA_US_AKAccountingUnitCode,
  ac_unit_nm AS PRA_US_AKAccountingUnitName,
  royalty_decimal AS PRARoyaltyDecimals,
  os_decimal AS PRA_US_AKOutsdSubstantialDcmls,
  gd_only_ct AS ContrIsForGravityDifferential,
  allocation_factor AS PRA_US_AKAllocationFactor,
  oiu_cruser AS PRACreatedByName,
  oiu_timestamp AS PRA_CreationDateTime
FROM /pra/akr_ooshst
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON PRAInternalCompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PRAProductText AS _ProductText ON PRAProduct = _ProductText.Product AND _ProductText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PRAWell AS _Well ON Well = _Well.Well  -- association [0..1]
LEFT OUTER JOIN I_PRAWellCompletion AS _WellCompletion ON Well = _WellCompletion.Well AND WellCompletion = _WellCompletion.WellCompletion  -- association [0..1]
LEFT OUTER JOIN I_MeasurementPoint AS _MeasurementPoint ON MeasurementPoint = _MeasurementPoint.MeasurementPoint  -- association [0..1]
LEFT OUTER JOIN I_PRAJointVenture AS _JointVenture ON PRAInternalCompanyCode = _JointVenture.CompanyCode AND PRAJointVenture = _JointVenture.PRAJointVenture  -- association [0..1]
LEFT OUTER JOIN I_DivisionOfInterest AS _DivisionOfInterest ON PRAInternalCompanyCode = _DivisionOfInterest.CompanyCode AND DivisionOfInterest = _DivisionOfInterest.DivisionOfInterest AND PRAJointVenture = _DivisionOfInterest.JointVenture  -- association [0..1]
LEFT OUTER JOIN I_DeliveryNetwork AS _DeliveryNetwork ON DeliveryNetwork = _DeliveryNetwork.DeliveryNetwork  -- association [0..1]
LEFT OUTER JOIN I_PRAContract AS _Contract ON PRAContract = _Contract.PRAContract  -- association [0..1]
LEFT OUTER JOIN I_VolumeTypeText AS _VolumeTypeText ON VolumeType = _VolumeTypeText.VolumeType AND _VolumeTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PRAOwner AS _Owner ON PRAOwner = _Owner.PRAOwner  -- association [0..1]
LEFT OUTER JOIN I_OwnerInterestTypeText AS _OwnerInterestTypeText ON OwnerInterestType = _OwnerInterestTypeText.OwnerInterestType AND _OwnerInterestTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TaxRptgRvslOrBkgOrAdjmtText AS _TaxRptgRvslOrBkgOrAdjmtText ON TaxRptgRvslOrBkgOrAdjmt = _TaxRptgRvslOrBkgOrAdjmtText.TaxRptgRvslOrBkgOrAdjmt AND _TaxRptgRvslOrBkgOrAdjmtText.Language = $session.system_language  -- association [0..1]
;