I_PRATaxRptgHistoryTexas

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_PRATaxRptgHistoryTexas.
-- 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: IPVTAXHISTTX

CREATE VIEW I_PRATaxRptgHistoryTexas 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,
  tax_type AS SeveranceTaxType,
  tier_tax_ind AS TierTaxType,
  rev_book_adj_ind AS TaxRptgRvslOrBkgOrAdjmt,
  prod_purc_ind AS ProducerOrPurchaserCode,
  cast( unit_vname as /pra/unit_vname preserving type ) AS UnitJointVenture,
  pay_fl AS HasSeveranceTaxPaytOblgn,
  rpt_fl AS SeveranceTaxRptgType,
  api_well_number AS APIWellNumber,
  county AS TexasCounty,
  lease_number AS ReportingAgencyLease,
  off_lease_cd AS OnOrOffLeaseSale,
  master_level AS MasterDataRecordingLvl,
  other_party_no AS OtherPartyTaxPayerIDByAgency,
  cast(other_party as oiu_vdm_producer_purchaser preserving type ) AS ProducerOrPurchaserNmbr,
  commodity_type AS CommodityType,
  exemption_type AS TaxExmpType,
  taxpayer_number AS TaxPayerIDByAgency,
  taxpayer_name AS TaxPayerName,
  cast( oiu_cruser as fclm_bam_created_by ) AS CreatedByUser,
  cast( oiu_timestamp as oiu_vdm_created_on_ts ) AS CreationDateTime,
  cast( 1 as oiu_vdm_no_of_items ) AS NumberOfItems,
  cast( 'US ' as land1_gp ) AS Country,
  cast( '42' as oiu_pri_geo_loc ) AS PrimaryGeogrlLocation,
  cast( '/PRA/RP_WORKPLACE' as fqm_origin_trans_id ) AS OriginTransaction,
  uom AS BaseUnit,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  gravity AS APIGravityRatio,
  lease_gross_vol AS TransacVolInBaseUnit,
  gross_vol AS GrossVolInBaseUnit,
  gross_val AS GrossValInCoCodeCrcy,
  tax_vol AS TaxableVolInBaseUnit,
  tax_val AS TaxableValInCoCodeCrcy,
  exempt_vol AS TaxExmptVolInBaseUnit,
  exempt_val AS TaxExmptValInCoCodeCrcy,
  mkt_cost AS MktgCostInCoCodeCrcy,
  mkt_cost_reimb AS MktgReimbmtCostInCoCodeCrcy,
  tax_amt AS GrossTaxAmtInCoCodeCrcy,
  tax_reimb AS TaxReimbmtAmtInCoCodeCrcy
FROM oiux3_tx_taxhst
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PRAProduct AS _Product ON Product = _Product.Product  -- 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_SeveranceTaxType AS _SeveranceTaxType ON Country = _SeveranceTaxType.Country AND PrimaryGeogrlLocation = _SeveranceTaxType.PrimaryGeogrlLocation AND SeveranceTaxType = _SeveranceTaxType.SeveranceTaxType  -- association [0..1]
LEFT OUTER JOIN I_PRATierTaxType AS _TierTaxType ON TierTaxType = _TierTaxType.TierTaxType  -- association [0..1]
LEFT OUTER JOIN I_TaxRptgRvslOrBkgOrAdjmtCode AS _TaxRptgRvslOrBkgOrAdjmt ON TaxRptgRvslOrBkgOrAdjmt = _TaxRptgRvslOrBkgOrAdjmt.TaxRptgRvslOrBkgOrAdjmt  -- 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_PRATaxTexasCounty AS _TexasCounty ON TexasCounty = _TexasCounty.TexasCounty  -- association [0..1]
LEFT OUTER JOIN I_PRATaxTXLease AS _ReportingAgencyLease ON ReportingAgencyLease = _ReportingAgencyLease.ReportingAgencyLease  -- association [0..1]
LEFT OUTER JOIN I_PRATaxOnOrOffLeaseSale AS _OnOrOffLeaseSale ON OnOrOffLeaseSale = _OnOrOffLeaseSale.OnOrOffLeaseSale  -- association [0..1]
LEFT OUTER JOIN I_PRATaxMstrDataRecgLvl AS _MasterDataRecordingLvl ON MasterDataRecordingLvl = _MasterDataRecordingLvl.MasterDataRecordingLvl  -- association [0..1]
LEFT OUTER JOIN I_PRATaxTXCommodityType AS _CommodityType ON CommodityType = _CommodityType.CommodityType  -- association [0..1]
LEFT OUTER JOIN I_ProducerOrPurchaserCode AS _ProducerOrPurchaserCode ON ProducerOrPurchaserCode = _ProducerOrPurchaserCode.ProducerOrPurchaserCode  -- 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_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_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
;