I_PRATaxRptgHistWYConsvn

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_PRATaxRptgHistWYConsvn.
-- 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: IPVTXRPTGHWYC

CREATE VIEW I_PRATaxRptgHistWYConsvn 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,
  rev_book_adj_ind AS TaxRptgRvslOrBkgOrAdjmt,
  prod_purc_ind AS ProducerOrPurchaserCode,
  unit_vname AS UnitJointVenture,
  pay_fl AS HasSeveranceTaxPaytOblgn,
  rpt_fl AS SeveranceTaxRptgType,
  uom AS BaseUnit,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  ret_lse_pc AS ReturnedProductRatio,
  County,
  api_well_number AS APIWellNumber,
  side_track_no AS WyomingTaxRptgSideTrackNmbr,
  Reservoir,
  rpt_grp_no AS TaxRptgGroupNumber,
  field_name AS GeologicFieldName,
  lease_unit_name AS AgencyLeaseOrUnitName,
  operated_flag AS EntityIsCompanyOperated,
  tax_district AS District,
  gas_plant_name AS PlantName,
  master_level AS MasterDataRecordingLvl,
  operator_id AS OperatorIDByAgency,
  operator_name AS OperatorName,
  purchaser_name AS PurchaserName,
  ogind AS ProductType,
  doc_no AS ValuationDocumentNumber,
  doc_year AS ValuationDocumentYear,
  Operator,
  Purchaser,
  cast(oiu_cruser as fclm_bam_created_by) AS CreatedByUser,
  cast(oiu_timestamp as oiu_vdm_created_on_ts) AS CreationDateTime,
  cast('US' as land1_gp ) AS Country,
  cast( '49' as oiu_pri_geo_loc ) AS PrimaryGeogrlLocation,
  cast( '/PRA/RP_WORKPLACE' as fqm_origin_trans_id ) AS OriginTransaction,
  gross_vol AS GrossVolInBaseUnit,
  tax_vol AS TaxableVolInBaseUnit,
  tax_val AS TaxableValInCoCodeCrcy,
  exempt_vol AS TaxExmptVolInBaseUnit,
  tax_amt AS GrossTaxAmtInCoCodeCrcy,
  tax_reimb AS TaxReimbmtAmtInCoCodeCrcy,
  wet_less_res AS WetGasLessResidueGasVolInMCF,
  blps_gross_vol AS GrossSalesVolInBaseUnit,
  plant_proc_vol AS PlantProcgVolInBaseUnit
FROM oiux6_wy_ctaxhst
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_PRAJointVenture AS _UnitJointVenture ON CompanyCode = _UnitJointVenture.CompanyCode AND UnitJointVenture = _UnitJointVenture.PRAJointVenture  -- 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_TaxRptgRvslOrBkgOrAdjmtCode AS _TaxRptgRvslOrBkgOrAdjmt ON TaxRptgRvslOrBkgOrAdjmt = _TaxRptgRvslOrBkgOrAdjmt.TaxRptgRvslOrBkgOrAdjmt  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _EntityIsCompanyOperated ON EntityIsCompanyOperated = _EntityIsCompanyOperated.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_PRATaxMstrDataRecgLvl AS _MasterDataRecordingLvl ON MasterDataRecordingLvl = _MasterDataRecordingLvl.MasterDataRecordingLvl  -- 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_ProducerOrPurchaserCode AS _ProducerOrPurchaserCode ON ProducerOrPurchaserCode = _ProducerOrPurchaserCode.ProducerOrPurchaserCode  -- association [0..1]
LEFT OUTER JOIN I_SecondaryGeogrlLocation AS _County ON Country = _County.Country AND PrimaryGeogrlLocation = _County.PrimaryGeogrlLocation AND County = _County.SecondaryGeogrlLocation  -- association [0..1]
LEFT OUTER JOIN I_PRATaxWYProductType AS _ProductType ON ProductType = _ProductType.ProductType  -- association [0..1]
LEFT OUTER JOIN I_CalendarYear AS _ValuationDocumentYear ON ValuationDocumentYear = _ValuationDocumentYear.CalendarYear  -- association [0..1]
LEFT OUTER JOIN I_ValuationDocumentHdr AS _ValuationDocumentHdr ON ValuationDocumentNumber = _ValuationDocumentHdr.ValuationDocumentNumber AND ValuationDocumentYear = _ValuationDocumentHdr.ValuationDocumentYear  -- association [0..1]
;