I_PRARoyaltyTexasGLODetail

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_PRARoyaltyTexasGLODetail.
-- 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_PRARoyaltyTexasGLODetail AS
SELECT
  run_id AS ProcessRun,
  bukrs AS CompanyCode,
  sales_dt AS SalesDate,
  pdcd AS PRAProduct,
  wl_no AS Well,
  wc_no AS WellCompletion,
  mp_no AS MeasurementPoint,
  vname AS PRAJointVenture,
  doi_no AS DivisionOfInterest,
  dn_no AS DeliveryNetwork,
  ct_no AS PRAContract,
  vl_type_cd AS VolumeType,
  owner_identifier AS UniqueOwnerReference,
  lease_identifier AS PRALeaseIdentifier,
  rev_book_adj_ind AS TaxRptgRvslOrBkgOrAdjmt,
  out_of_statute AS PRAIsOutOfStatute,
  immaterial AS PRAImmaterialRecord,
  unit_vname AS UnitJointVenture,
  acct_no AS GLAccount,
  chv_rpt_cd AS PRACostCenter,
  uom AS BaseUnit,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  ps_base_qy AS PressureBaseQty,
  grv_qy AS APIGravityRatio,
  pay_cd AS OwnerPaymentStatus,
  own_int_decm_qy AS NetRevenueInterestRatio,
  own_bal_decm_qy AS DisbursementDecimalRatio,
  pu_no AS Purchaser,
  affiliated_sale AS IsAffiliatedSale,
  gr_qy AS GrossVolInBaseUnit,
  gr_am AS PRAGrossAmount,
  txn_val_am AS OwnerGrossValInCoCodeCrcy,
  trans_am AS PRATransactionAmount,
  trans_qy AS PRATransactionQuantity,
  mmbtu_ovl_am AS OwnerEnergyInMMBTU,
  plt_vl_gred_am AS PRAGrossPlantVolReducnAmt,
  plt_vl_ored_am AS PRAOwnerPlantVolReducnAmt,
  ded_rmb_am AS PRADeductionReimbmtAmt,
  net_transp_am AS PRATaxRoytyRptgNetTranspAmount,
  net_oth_mk_am AS OtherMktgCostInCoCodeCrcy,
  tax_rmb_am AS PRATaxReimbmtAmount,
  tax_am AS PRATaxAmount,
  trans_qy_ex AS TransacQtyInBaseUnit,
  btu_qy AS HeatingValue,
  original_report AS AgencyReportType,
  gas_disp_code AS AgencyGasDispositionType,
  master_level AS PRAMasterLevel,
  rrc_level AS RailRoadCommsnMstrDataRecgLvl,
  purchaser_id AS PurchaserIDByAgency,
  operator_id AS PRAOperatorIdentifier,
  glo_lease AS ReportingAgencyLease,
  glo_unit_no AS UnitNumberByAgency,
  royalty_decimal AS AgencyNetRevenueInterestRatio,
  unit_vname_flag AS JointVentureIsUnit,
  alloc_percent AS PRAAllocationPercent,
  tract_part_fact AS PRATractParticipationFactor,
  county_lse_ind AS PRAIsCountyLease,
  rrc_district_no AS TexasRailRoadCommsnDistrict,
  rrc_oil_lease_no AS TexasRailRoadCommsnOilLease,
  rrc_gas_well_id AS TexasRailRoadCommsnGasWell,
  rrc_drill_permit AS TexasRailRoadCommsnDrillPermit,
  rrc_field_name AS TexasRailRoadCommsnFieldName,
  rrc_lease_name AS TexasRailRoadCommsnLeaseName,
  prop_alias_name AS PRAPropertyAliasName,
  operator_no AS PRAOperator,
  pay_report_flag AS AgencyPayOrReportType,
  doc_no AS ValuationDocumentNumber,
  doc_year AS PRAWellDocumentYear,
  interface_fl AS PRAIsInterface,
  reference_run_id AS PRAReferenceRunID,
  btu_qy_ext AS HeatingValueExtQty,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime
FROM /pra/r3_prdta
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PRAProduct AS _Product ON _Product.Product = PRAProduct  -- association [1..1]
LEFT OUTER JOIN I_Well AS _Well ON _Well.Well = Well  -- association [0..1]
LEFT OUTER JOIN I_WellCompletion AS _WellCompletion ON _WellCompletion.Well = 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 _UnitJointVenture ON _UnitJointVenture.PRAJointVenture = UnitJointVenture AND _UnitJointVenture.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PRAJointVenture AS _PRAJointVenture ON _PRAJointVenture.PRAJointVenture = PRAJointVenture AND _PRAJointVenture.CompanyCode = CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PRAMaintDOI AS _PRAMaintDOI ON _PRAMaintDOI.CompanyCode = CompanyCode AND _PRAMaintDOI.PRAJointVenture = PRAJointVenture AND _PRAMaintDOI.DivisionOfInterest = DivisionOfInterest  -- association [1..1]
LEFT OUTER JOIN I_DeliveryNetwork AS _DeliveryNetwork ON _DeliveryNetwork.DeliveryNetwork = DeliveryNetwork  -- association [1..1]
LEFT OUTER JOIN I_PRAContract AS _PRAContract ON _PRAContract.PRAContract = PRAContract  -- association [1..1]
LEFT OUTER JOIN I_OwnerPaymentStatus AS _OwnerPaymentStatus ON _OwnerPaymentStatus.OwnerPaymentStatus = OwnerPaymentStatus  -- association [1..1]
LEFT OUTER JOIN I_PRARoytyTXGLOAgencyRptType AS _PRARoytyTXGLOAgencyRptType ON _PRARoytyTXGLOAgencyRptType.AgencyReportType = AgencyReportType  -- association [1..1]
LEFT OUTER JOIN I_PRARoytyTXGLOGasDsposType AS _PRARoytyTXGLOGasDsposType ON _PRARoytyTXGLOGasDsposType.AgencyGasDispositionType = AgencyGasDispositionType  -- association [1..1]
LEFT OUTER JOIN I_AgencyPayOrReportType AS _AgencyPayOrReportType ON _AgencyPayOrReportType.AgencyPayOrReportType = AgencyPayOrReportType  -- association [1..1]
LEFT OUTER JOIN I_VolumeType AS _VolumeType ON _VolumeType.VolumeType = VolumeType  -- association [1..1]
LEFT OUTER JOIN I_TaxRptgRvslOrBkgOrAdjmtCode AS _TaxRptgRvslOrBkgOrAdjmt ON _TaxRptgRvslOrBkgOrAdjmt.TaxRptgRvslOrBkgOrAdjmt = TaxRptgRvslOrBkgOrAdjmt  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON _BaseUnit.UnitOfMeasure = BaseUnit  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = CompanyCodeCurrency  -- association [0..1]
;