I_ONRRRptgHistoryPRADetails

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_ONRRRptgHistoryPRADetails.
-- 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.
-- SQL view name: IPVONRRRRHPRA

CREATE VIEW I_ONRRRptgHistoryPRADetails AS
SELECT
  sale_dt AS SalesDate,
  cast ( bukrs as fis_bukrs ) AS CompanyCode,
  vname AS JointVenture,
  doi_no AS DivisionOfInterest,
  wl_no AS Well,
  wc_no AS WellCompletion,
  vbeln AS PRAContract,
  vl_type_cd AS VolumeType,
  pd_cd AS Product,
  own_no AS PRAOwner,
  saknr AS GLAccount,
  kostl AS CostCenter,
  prdt_line_type AS ONRRBusinessTransactionType,
  run_id AS ProcessRun,
  ac_ind AS AgencyReportType,
  ppa_rsn_cd AS PriorPeriodAdjustmentReason,
  cast ( vol_uom as /pra/vol_uom ) AS VolumeUnit,
  cast (energy_uom as /pra/energy_uom ) AS EnergyUnit,
  waers AS Currency,
  dn_no AS DeliveryNetwork,
  master_level AS MasterDataRecordingLvl,
  lease_no AS ONRRLease,
  agreement_no AS ONRRAgreement,
  payor_cd AS ONRRPayerCode,
  comp_royalty_fl AS IsCompensatoryRoyalty,
  section_6_lse_fl AS IsSection6LeaseOverride,
  roy_relief_sh_fl AS IsShallowWaterRoyaltyRelieved,
  roy_relief_dp_fl AS IsDeepWaterRoyaltyRelieved,
  report_api_wl_fl AS IsRptgAtAPIWellLvl,
  alloc_percent AS AllocationPercent,
  ovr_royalty_rate AS OverrideRoyaltyRate,
  lessor_cd AS ONRRLessorType,
  tribal_allottee AS TribalOrAllotteeLeaseType,
  distributee_cd AS RoyaltyPaytDistributeeType,
  on_off_shore_ind AS OnOrOffShoreLeaseSale,
  index_zone AS IndianIndexZone,
  lease_name AS ONRRLeaseName,
  sect6_fl AS IsSection6Lease,
  trans37_fl AS HasTransactionCode37,
  trans38_fl AS HasTransactionCode38,
  sales_type_cd AS ONRRSalesType,
  api_well_no AS APIWellNumber,
  product_cd AS ONRRReportedProduct,
  transaction_cd AS ONRRReportedTransType,
  roy_rate AS RoyaltyRate,
  pay_method_cd AS ONRRPaymentMethod,
  status AS ONRRReportStatus,
  ovr_adj_cd AS ONRROverrideAdjmtReason,
  ovr_reject_fl AS IsRejectOverridden,
  ovr_pad_no AS OverrideDocument,
  ry_due_adj_ps_fl AS FutureRptHasRoyaltyDueAdjmt,
  recalculate_fl AS SalesFigureIsToBeRecalculated,
  cast( oiu_cruser as fclm_bam_created_by ) AS CreatedByUser,
  cast( oiu_timestamp as oiu_vdm_created_on_ts ) AS CreationDateTime,
  cast( '/PRA/FP_WORKPLACE' as fqm_origin_trans_id ) AS OriginTransaction,
  net_val AS OwnerNetAmount,
  net_vol AS OwnerNetVolInVolUnit,
  owner_gross_val AS OwnerGrossAmount,
  owner_energy AS OwnerEnergyInEnergyUnit,
  gross_val AS GrossAmount,
  gross_vol AS GrossVolInVolUnit,
  gross_energy AS GrossEnergyInEnergyUnit,
  trans_deduct_adj AS TranspAllwncDeductAdjmtAmt,
  proc_deduct_adj AS ProcgAllwncDeductAdjmtAmt,
  royalty_due_adj AS RoyaltyDueAdjustmentAmount,
  transportation AS TranspAllwncDeductAmt,
  processing AS ProcgAllwncDeductAmt,
  tax AS TaxAmount,
  tax_reimburse AS TaxReimbursementAmount,
  mkt_reimburse AS MarketingReimbursementAmount
FROM /pra/fp_prdt_hst
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PRAJointVenture AS _PRAJointVenture ON CompanyCode = _PRAJointVenture.CompanyCode AND JointVenture = _PRAJointVenture.PRAJointVenture  -- association [0..1]
LEFT OUTER JOIN I_DivisionOfInterest AS _DivisionOfInterest ON CompanyCode = _DivisionOfInterest.CompanyCode AND JointVenture = _DivisionOfInterest.JointVenture AND DivisionOfInterest = _DivisionOfInterest.DivisionOfInterest  -- association [0..1]
LEFT OUTER JOIN I_Well AS _Well ON Well = _Well.Well  -- association [0..1]
LEFT OUTER JOIN I_WellCompletion AS _WellCompletion ON Well = _WellCompletion.Well AND WellCompletion = _WellCompletion.WellCompletion  -- association [0..1]
LEFT OUTER JOIN I_PRAContract AS _PRAContract ON PRAContract = _PRAContract.PRAContract  -- association [0..1]
LEFT OUTER JOIN I_VolumeType AS _VolumeType ON VolumeType = _VolumeType.VolumeType  -- association [0..1]
LEFT OUTER JOIN I_PRAProduct AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_PRAOwner AS _PRAOwner ON PRAOwner = _PRAOwner.PRAOwner  -- association [0..1]
LEFT OUTER JOIN I_PRAGLAccount AS _GLAccount ON CompanyCode = _GLAccount.CompanyCode AND GLAccount = _GLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_PRACostCenter AS _CostCenter ON CompanyCode = _CostCenter.CompanyCode AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_PriorPeriodAdjustmentReason AS _PriorPeriodAdjustmentReason ON PriorPeriodAdjustmentReason = _PriorPeriodAdjustmentReason.PriorPeriodAdjustmentReason  -- association [0..1]
LEFT OUTER JOIN I_ONRRBusinessTransType AS _ONRRBusinessTransactionType ON ONRRBusinessTransactionType = _ONRRBusinessTransactionType.ONRRBusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN I_PRAONRRProcessRun AS _ProcessRun ON ProcessRun = _ProcessRun.ProcessRun  -- association [0..1]
LEFT OUTER JOIN I_AgencyReportType AS _AgencyReportType ON AgencyReportType = _AgencyReportType.AgencyReportType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnit ON VolumeUnit = _VolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EnergyUnit ON EnergyUnit = _EnergyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_DeliveryNetwork AS _DeliveryNetwork ON DeliveryNetwork = _DeliveryNetwork.DeliveryNetwork  -- association [0..1]
LEFT OUTER JOIN I_PRAMasterDataRecordingLevel AS _MasterDataRecordingLvl ON MasterDataRecordingLvl = _MasterDataRecordingLvl.MasterDataRecordingLvl  -- association [0..1]
LEFT OUTER JOIN I_ONRRPayerCode AS _ONRRPayerCode ON ONRRPayerCode = _ONRRPayerCode.ONRRPayerCode  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsCompensatoryRoyalty ON IsCompensatoryRoyalty = _IsCompensatoryRoyalty.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsSection6LeaseOverride ON IsSection6LeaseOverride = _IsSection6LeaseOverride.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsShallowWaterRoyaltyRelieved ON IsShallowWaterRoyaltyRelieved = _IsShallowWaterRoyaltyRelieved.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsDeepWaterRoyaltyRelieved ON IsDeepWaterRoyaltyRelieved = _IsDeepWaterRoyaltyRelieved.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsRptgAtAPIWellLvl ON IsRptgAtAPIWellLvl = _IsRptgAtAPIWellLvl.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_PRAONRRLessorType AS _ONRRLessorType ON ONRRLessorType = _ONRRLessorType.ONRRLessorType  -- association [0..1]
LEFT OUTER JOIN I_TribalAllotteeLeaseType AS _TribalOrAllotteeLeaseType ON TribalOrAllotteeLeaseType = _TribalOrAllotteeLeaseType.TribalOrAllotteeLeaseType  -- association [0..1]
LEFT OUTER JOIN I_RoyaltyPaytDistributeeType AS _RoyaltyPaytDistributeeType ON RoyaltyPaytDistributeeType = _RoyaltyPaytDistributeeType.RoyaltyPaytDistributeeType  -- association [0..1]
LEFT OUTER JOIN I_OnOffShoreLeaseSale AS _OnOrOffShoreLeaseSale ON OnOrOffShoreLeaseSale = _OnOrOffShoreLeaseSale.OnOrOffShoreLeaseSale  -- association [0..1]
LEFT OUTER JOIN I_IndianIndexZone AS _IndianIndexZone ON IndianIndexZone = _IndianIndexZone.IndianIndexZone  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsSection6Lease ON IsSection6Lease = _IsSection6Lease.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _HasTransactionCode37 ON HasTransactionCode37 = _HasTransactionCode37.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _HasTransactionCode38 ON HasTransactionCode38 = _HasTransactionCode38.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_PRAONRRSalesType AS _ONRRSalesType ON ONRRSalesType = _ONRRSalesType.ONRRSalesType  -- association [0..1]
LEFT OUTER JOIN I_ONRRRepProd AS _ONRRReportedProduct ON ONRRReportedProduct = _ONRRReportedProduct.ONRRReportedProduct  -- association [0..1]
LEFT OUTER JOIN I_ONRRRepTransType AS _ONRRReportedTransType ON ONRRReportedTransType = _ONRRReportedTransType.ONRRReportedTransType  -- association [0..1]
LEFT OUTER JOIN I_ONRRPayMeth AS _ONRRPaymentMethod ON ONRRPaymentMethod = _ONRRPaymentMethod.ONRRPaymentMethod  -- association [0..1]
LEFT OUTER JOIN I_ONRRReportStatus AS _ONRRReportStatus ON ONRRReportStatus = _ONRRReportStatus.ONRRReportStatus  -- association [0..1]
LEFT OUTER JOIN I_ONRROverAdjmtReason AS _ONRROverrideAdjmtReason ON ONRROverrideAdjmtReason = _ONRROverrideAdjmtReason.ONRROverrideAdjmtReason  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsRejectOverridden ON IsRejectOverridden = _IsRejectOverridden.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _FutureRptHasRoyaltyDueAdjmt ON FutureRptHasRoyaltyDueAdjmt = _FutureRptHasRoyaltyDueAdjmt.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _SalesFigureIsToBeRecalculated ON SalesFigureIsToBeRecalculated = _SalesFigureIsToBeRecalculated.IndicatorValue  -- association [0..1]
;