I_PRATaxRptgHistoryND

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_PRATaxRptgHistoryND.
-- 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: IPVTAXRPTGHISTND

CREATE VIEW I_PRATaxRptgHistoryND 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,
  well_code AS NorthDakotaTaxExmpWellType,
  posting_code AS NorthDakotaPostalAreaCode,
  api_number AS APIWellNumber,
  api_name AS APIWellName,
  oil_gravity AS APIGravityRatio,
  other_no AS ProducerOrPurchaserNmbr,
  oth_fed_id_no_1 AS FederalIDByAgency,
  taxpayer_number AS TaxPayerIDByAgency,
  pool_code AS Reservoir,
  doc_no AS ValuationDocumentNumber,
  doc_year AS ValuationDocumentYear,
  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( '33' as oiu_pri_geo_loc ) AS PrimaryGeogrlLocation,
  cast( '/PRA/RP_WORKPLACE' as fqm_origin_trans_id ) AS OriginTransaction,
  brl_oil_pur_sld AS OilVolumeInBarrels,
  val_oil_pur_sld AS OilValueInCoCodeCrcy,
  exempt_value AS TaxExmpValInCoCodeCrcy,
  tax_value_oil AS TaxableOilValInCoCodeCrcy,
  pr_tax_due AS ProdnTaxDueAmtInCoCodeCrcy,
  pr_tax_prev AS ProdnTxPrevPaidAmtInCoCdCrcy,
  pr_tax_others AS ProdnTaxOthPaidAmtInCoCdCrcy,
  pr_tax_paid AS ProdnTaxPaidAmtInCoCodeCrcy,
  ex_tax_due AS ExtractnTxDueAmtInCoCodeCrcy,
  ex_tax_prev AS ExtractnTxPrevAmtInCoCdCrcy,
  ex_tax_others AS ExtractnTaxOthAmtInCoCdCrcy,
  ex_tax_paid AS ExtractnTaxPaidAmtInCoCdCrcy,
  additional_val AS AddlValInCoCodeCrcy,
  mkt_cost_01 AS MktgCost01InCoCodeCrcy,
  mkt_cost_02 AS MktgCost02InCoCodeCrcy,
  mkt_cost_03 AS MktgCost03InCoCodeCrcy,
  mkt_cost_04 AS MktgCost04InCoCodeCrcy,
  mkt_cost_05 AS MktgCost05InCoCodeCrcy,
  mkt_cost_06 AS MktgCost06InCoCodeCrcy,
  mkt_cost_07 AS MktgCost07InCoCodeCrcy,
  mkt_cost_08 AS MktgCost08InCoCodeCrcy,
  mkt_cost_09 AS MktgCost09InCoCodeCrcy,
  mkt_cost_10 AS MktgCost10InCoCodeCrcy,
  mkt_cost_reimb AS MktgReimbmtCostInCoCodeCrcy
FROM /pra/nd_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_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_JointVenture AS _UnitJointVenture ON CompanyCode = _UnitJointVenture.CompanyCode AND UnitJointVenture = _UnitJointVenture.JointVenture  -- 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_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PRATaxNDExmpWellType AS _NorthDakotaTaxExmpWellType ON NorthDakotaTaxExmpWellType = _NorthDakotaTaxExmpWellType.NorthDakotaTaxExmpWellType  -- association [0..1]
LEFT OUTER JOIN I_PRATaxNDPostalAreaCode AS _NorthDakotaPostalAreaCode ON NorthDakotaPostalAreaCode = _NorthDakotaPostalAreaCode.NorthDakotaPostalAreaCode  -- association [0..1]
LEFT OUTER JOIN I_PRATaxNDReservoir AS _Reservoir ON Reservoir = _Reservoir.Reservoir  -- 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_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]
;