I_PRAAnnRptgChkDetTmpPrevYear

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_PRAAnnRptgChkDetTmpPrevYear.
-- 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_PRAAnnRptgChkDetTmpPrevYear AS
SELECT
  wh_run_id AS PRAWithholdingProcessRun,
  run_id AS ProcessRun,
  cast( check_no as oiu_vdm_check_number) AS PRACheckNumber,
  own_no AS PRAOwner,
  vname AS JointVenture,
  doi_no AS DivisionOfInterest,
  wl_no AS Well,
  wc_no AS WellCompletion,
  cast( substring(own_int_type_seq, 1, 2) as oiu_part_int_type) AS OwnerInterestType,
  cast( right(own_int_type_seq, 2) as oiu_own_isq_no) AS OwnerInterestSequence,
  sale_dt AS SalesDate,
  pd_cd AS PRAProduct,
  cast(disb_decimal as dec12_2) AS DisbursementDecimalRatio,
  saknr AS GLAccount,
  record_type AS RecordType,
  cast ( bukrs as fis_bukrs preserving type ) AS CompanyCode,
  cast ( acct_period as oiu_vdm_acct_period ) AS PRAAccountingPeriod,
  nri_decimal AS NetRevenueInterestRatio,
  dn_no AS DeliveryNetwork,
  cast( land1 as land1_gp preserving type ) AS Country,
  regio AS Region,
  counc AS County,
  unit_vname AS UnitJointVenture,
  cast( vol_uom as /pra/vol_uom ) AS VolumeUnit,
  cast( energy_uom as /pra/energy_uom ) AS EnergyUnit,
  sus_rsn_cd AS SuspenseReason,
  ppa_rsn_cd AS PriorPeriodAdjustmentReason,
  aes_cd AS PRAActualEntitledSettlement,
  gross_vol AS GrossVolInVolUnit,
  gross_val AS GrossAmount,
  owner_gross_val AS OwnerGrossAmount,
  net_val AS OwnerNetAmount,
  net_vol AS OwnerNetVolInVolUnit,
  gross_energy AS GrossEnergyInEnergyUnit,
  owner_energy AS OwnerEnergyInEnergyUnit,
  gross_tot_mkt AS GrossMarketingCost,
  gross_tot_taxes AS GrossTaxAmount,
  owner_tot_mkt AS TotalMarketingAmt,
  owner_tot_taxes AS OwnerTaxAmount,
  owner_tot_other AS TotalDeductionAmt,
  grs_less_tax_mkt AS GrossLessDeductionAmt,
  heat_val AS HeatingValue,
  cast( heat_val_uom as /pra/heating_uom ) AS HeatingValUnit,
  price AS PRAPrice,
  rej_cd AS PaymentHeaderRejectionRsn,
  dtl_rej_cd AS PaymentDetailRejectionRsn,
  comment_no AS PRACommentNumber,
  check_dt AS PaymentDate,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime
FROM /pra/wh_ck_dtl_t
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ProcessRun AS _ProcessRun ON ProcessRun = _ProcessRun.ProcessRun AND PRAWithholdingProcessRun = _ProcessRun.ProcessRun  -- association [0..1]
LEFT OUTER JOIN I_PRAPaymentHeaderAttribute AS _PaymentHeader ON ProcessRun = _PaymentHeader.ProcessRun AND PRACheckNumber = _PaymentHeader.PRACheckNumber  -- association [0..1]
LEFT OUTER JOIN I_PRAOwner AS _PRAOwner ON PRAOwner = _PRAOwner.PRAOwner  -- association [0..1]
LEFT OUTER JOIN I_OwnerInterestType AS _OwnerInterestType ON OwnerInterestType = _OwnerInterestType.OwnerInterestType  -- 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_PRAProduct AS _Product ON PRAProduct = _Product.Product  -- 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_PaymentRecordType AS _RecordType ON RecordType = _RecordType.RecordType  -- association [0..1]
LEFT OUTER JOIN I_DeliveryNetwork AS _DeliveryNetwork ON DeliveryNetwork = _DeliveryNetwork.DeliveryNetwork  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _Region ON Country = _Region.Country AND Region = _Region.Region  -- association [0..1]
LEFT OUTER JOIN I_PRACounty AS _County ON Country = _County.Country AND Region = _County.Region AND County = _County.County  -- association [0..1]
LEFT OUTER JOIN I_PRAJointVenture AS _UnitJointVenture ON CompanyCode = _UnitJointVenture.CompanyCode AND UnitJointVenture = _UnitJointVenture.PRAJointVenture  -- association [0..1]
LEFT OUTER JOIN I_SuspenseReason AS _SuspenseReason ON SuspenseReason = _SuspenseReason.SuspenseReason  -- association [0..1]
LEFT OUTER JOIN I_PriorPeriodAdjustmentReason AS _PriorPeriodAdjustmentReason ON PriorPeriodAdjustmentReason = _PriorPeriodAdjustmentReason.PriorPeriodAdjustmentReason  -- association [0..1]
LEFT OUTER JOIN I_Calculationbasis AS _CalculationBasis ON PRAActualEntitledSettlement = _CalculationBasis.CalculationBasis  -- association [0..1]
LEFT OUTER JOIN I_PaymentDtlRejectionRsn AS _PaymentDetldRejectionRsn ON PaymentDetailRejectionRsn = _PaymentDetldRejectionRsn.PaymentDetailRejectionRsn  -- association [0..1]
LEFT OUTER JOIN I_PaymentHdrRejectionRsn AS _PaymentHeaderRejectionRsn ON PaymentHeaderRejectionRsn = _PaymentHeaderRejectionRsn.PaymentHeaderRejectionRsn  -- 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_UnitOfMeasure AS _HeatingValUnit ON HeatingValUnit = _HeatingValUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
;