I_PRATaxRptgHistoryOK

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_PRATaxRptgHistoryOK.
-- 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: IPVTAXRPTGHISTOK

CREATE VIEW I_PRATaxRptgHistoryOK AS
SELECT
  cast(bukrs as fis_bukrs preserving type ) AS CompanyCode,
  sales_dt AS SalesDate,
  pdcd AS Product,
  wl_no AS Well,
  wc_no AS WellCompletion,
  mp_no AS MeasurementPoint,
  vname AS JointVenture,
  doi_no AS DivisionOfInterest,
  dn_no AS DeliveryNetwork,
  ct_no AS PRAContract,
  vl_type_cd AS VolumeType,
  tax_cls AS TaxClassification,
  pun AS ProductionUnitNumber,
  rev_book_adj_ind AS TaxRptgRvslOrBkgOrAdjmt,
  cast(alloc_percent as oiu_vdm_allocation_percentage) AS AllocationRatio,
  prod_purc_ind AS ProducerOrPurchaserCode,
  cast(unit_vname as oiu_vdm_unit_venture preserving type) AS UnitJointVenture,
  pay_fl AS HasSeveranceTaxPaytOblgn,
  rpt_fl AS SeveranceTaxRptgType,
  cast('US' as land1_gp) AS Country,
  cast( '35' as oiu_pri_geo_loc ) AS PrimaryGeogrlLocation,
  uom AS BaseUnit,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  cast(val_tax_rat as oiu_vdm_val_tax_rat) AS TaxRate,
  cast(other_party as oiu_vdm_producer_purchaser) AS ProducerOrPurchaserNmbr,
  doc_no AS ValuationDocumentNumber,
  doc_year AS ValuationDocumentYear,
  exempt_code_1 AS TaxExemptCode1,
  exempt_code_2 AS TaxExemptCode2,
  exempt_code_3 AS TaxExemptCode3,
  exempt_code_4 AS TaxExemptCode4,
  exempt_code_5 AS TaxExemptCode5,
  master_level AS MasterDataRecordingLvl,
  prod_purch_no AS ExtProducerOrPurchaserNmbr,
  ok_product_code AS ProductType,
  taxpayer_number AS TaxPayerIDByAgency,
  fein_ssn AS ReportingCompany,
  production_date AS ProductionDate,
  cast(oiu_cruser as fclm_bam_created_by) AS CreatedByUser,
  cast(oiu_timestamp as oiu_vdm_created_on_ts) AS CreationDateTime,
  gross_vol AS GrossVolInBaseUnit,
  gross_val AS GrossValInCoCodeCrcy,
  tax_vol AS TaxableVolInBaseUnit,
  tax_val AS TaxableValInCoCodeCrcy,
  exe_enttype1_vol AS TaxExmptVol1InBaseUnit,
  exe_enttype1_val AS TaxExmptVal1InCoCdCrcy,
  exe_enttype2_vol AS TaxExmptVol2InBaseUnit,
  exe_enttype2_val AS TaxExmptVal2InCoCdCrcy,
  exe_enttype3_vol AS TaxExmptVol3InBaseUnit,
  exe_enttype3_val AS TaxExmptVal3InCoCdCrcy,
  exe_enttype4_vol AS TaxExmptVol4InBaseUnit,
  exe_enttype4_val AS TaxExmptVal4InCoCdCrcy,
  exe_enttype5_vol AS TaxExmptVol5InBaseUnit,
  exe_enttype5_val AS TaxExmptVal5InCoCdCrcy,
  eor_vol AS EnhncdOilRcvryVolInBaseUnit,
  eor_val AS EnhncdOilRcvryValInCoCdCrcy,
  mkt_cost AS MktgCostInCoCodeCrcy,
  mkt_cost_reimb AS MktgReimbmtCostInCoCodeCrcy,
  gp_tax_amt AS GrossProdnTaxAmtInCoCodeCrcy,
  pe_tax_amt AS PetroleumExcsTxAmtInCoCdCrcy,
  rf_tax_amt AS RevolvingFundTxAmtInCoCdCrcy,
  mp_tax_amt AS MarginProdgTxAmtInCoCdCrcy,
  kw_tax_amt AS KoiwaTribeTaxAmtInCoCodeCrcy,
  cast(ca_tax_amt as oiu_vdm_shoshone_arapaho_tax) AS ArapahoTribeTaxAmtInCoCdCrcy,
  cast( '/PRA/RP_WORKPLACE' as fqm_origin_trans_id ) AS OriginTransaction
FROM oiut5_taxhstp
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- 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_MeasurementPoint AS _MeasurementPoint ON MeasurementPoint = _MeasurementPoint.MeasurementPoint  -- 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_DeliveryNetwork AS _DeliveryNetwork ON DeliveryNetwork = _DeliveryNetwork.DeliveryNetwork  -- 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_TaxClassification AS _TaxClassification ON Country = _TaxClassification.Country AND PrimaryGeogrlLocation = _TaxClassification.PrimaryGeogrlLocation AND TaxClassification = _TaxClassification.TaxClassification  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _HasSeveranceTaxPaytOblgn ON HasSeveranceTaxPaytOblgn = _HasSeveranceTaxPaytOblgn.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _SeveranceTaxRptgType ON SeveranceTaxRptgType = _SeveranceTaxRptgType.IndicatorValue  -- 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_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_PrimaryGeogrlLocation AS _PrimaryGeogrlLocation ON Country = _PrimaryGeogrlLocation.Country AND PrimaryGeogrlLocation = _PrimaryGeogrlLocation.PrimaryGeogrlLocation  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON CompanyCodeCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PRATaxOKExemptCode AS _TaxExemptCode1 ON TaxExemptCode1 = _TaxExemptCode1.TaxExemptCode  -- association [0..1]
LEFT OUTER JOIN I_PRATaxOKExemptCode AS _TaxExemptCode2 ON TaxExemptCode2 = _TaxExemptCode2.TaxExemptCode  -- association [0..1]
LEFT OUTER JOIN I_PRATaxOKExemptCode AS _TaxExemptCode3 ON TaxExemptCode3 = _TaxExemptCode3.TaxExemptCode  -- association [0..1]
LEFT OUTER JOIN I_PRATaxOKExemptCode AS _TaxExemptCode4 ON TaxExemptCode4 = _TaxExemptCode4.TaxExemptCode  -- association [0..1]
LEFT OUTER JOIN I_PRATaxOKExemptCode AS _TaxExemptCode5 ON TaxExemptCode5 = _TaxExemptCode5.TaxExemptCode  -- association [0..1]
LEFT OUTER JOIN I_PRAProduct AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_TaxRptgRvslOrBkgOrAdjmtCode AS _TaxRptgRvslOrBkgOrAdjmt ON TaxRptgRvslOrBkgOrAdjmt = _TaxRptgRvslOrBkgOrAdjmt.TaxRptgRvslOrBkgOrAdjmt  -- association [0..1]
LEFT OUTER JOIN I_ProducerOrPurchaserCode AS _ProducerOrPurchaserCode ON ProducerOrPurchaserCode = _ProducerOrPurchaserCode.ProducerOrPurchaserCode  -- association [0..1]
LEFT OUTER JOIN I_PRATaxMstrDataRecgLvl AS _MasterDataRecordingLvl ON MasterDataRecordingLvl = _MasterDataRecordingLvl.MasterDataRecordingLvl  -- association [0..1]
LEFT OUTER JOIN I_PRATaxOkProductType AS _ProductType ON ProductType = _ProductType.ProductType  -- association [0..1]
;