What is C_PRATaxRptgHistoryOKQRY in SAP S/4HANA?

C_PRATaxRptgHistoryOKQRY is a consumption CDS view in SAP S/4HANA. PRA Tax Reporting History Oklahoma Query It contains 63 fields.

Which tables does C_PRATaxRptgHistoryOKQRY read from?

C_PRATaxRptgHistoryOKQRY reads data from: I_PRATaxRptgHistoryOK.

What VDM layer is C_PRATaxRptgHistoryOKQRY?

C_PRATaxRptgHistoryOKQRY is classified as a Consumption view optimized for specific business scenarios and reporting.

C_PRATaxRptgHistoryOKQRY

DDL: C_PRATAXRPTGHISTORYOKQRY SQL: CPVTAXRPTGHISTOK Type: view CONSUMPTION

63 Fields 1 Data Sources

PRA Tax Reporting History Oklahoma Query

C_PRATaxRptgHistoryOKQRY (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

C_PRATaxRptgHistoryOKQRY is a Consumption CDS View that provides data about "PRA Tax Reporting History Oklahoma Query" in SAP S/4HANA. It reads from 1 data source (I_PRATaxRptgHistoryOK) and exposes 63 fields with key fields CompanyCode, SalesDate, Product, Well, WellCompletion.

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	IS-OIL-PRA
Package	Cross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_PRATaxRptgHistoryOK	I_PRATaxRptgHistoryOK	from

Annotations (9)

Name	Value	Level
EndUserText.label	PRA Tax Reporting History Oklahoma Query	view
Analytics.query	true	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
AbapCatalog.sqlViewName	CPVTAXRPTGHISTOK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (63)

Key	Field	Source Field	Description
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	SalesDate	SalesDate	Sales Date / Month
KEY	Product	Product	Full three char. product code (Major and Detail Products)
KEY	Well	Well	Well ID number
KEY	WellCompletion	WellCompletion	Well Completion Number
KEY	MeasurementPoint	MeasurementPoint	Measurement point number
KEY	JointVenture	JointVenture	Joint venture
KEY	DivisionOfInterest	DivisionOfInterest	Division of Interest (DOI)
KEY	DeliveryNetwork	DeliveryNetwork	Delivery network number
KEY	PRAContract	PRAContract	Contract Number
KEY	VolumeType	VolumeType	Volume type code
KEY	TaxClassification	TaxClassification	Tax class.
KEY	ProductionUnitNumber	ProductionUnitNumber	Tax 2.0 - OKGP15 - Production Unit Number
KEY	TaxRptgRvslOrBkgOrAdjmt	TaxRptgRvslOrBkgOrAdjmt	Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment
	AllocationRatio	AllocationRatio	Tax 2.0 - Allocation Percentage
	ProducerOrPurchaserCode	ProducerOrPurchaserCode	Producer or Purchaser
	UnitJointVenture	UnitJointVenture	Unit Venture
	HasSeveranceTaxPaytOblgn	HasSeveranceTaxPaytOblgn	Tax Severance Tax Calculation Payment Obligations Types
	SeveranceTaxRptgType	SeveranceTaxRptgType	State Severance Tax Reporting Indicators
	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	TaxRate	TaxRate	Value tax rate
	ProducerOrPurchaserNmbr	ProducerOrPurchaserNmbr	Producer/Purchaser
	ValuationDocumentNumber	ValuationDocumentNumber	Val. document number
	ValuationDocumentYear	ValuationDocumentYear	Mat. Doc. Year
	TaxExemptCode1	TaxExemptCode1	Tax 2.0 OKGP - Entity Type 01 Exempt Code
	TaxExemptCode2	TaxExemptCode2	Tax 2.0 OKGP - Entity Type 02 Exempt Code
	TaxExemptCode3	TaxExemptCode3	Tax 2.0 OKGP - Entity Type 03 Exempt Code
	TaxExemptCode4	TaxExemptCode4	Tax 2.0 OKGP - Entity Type 04 Exempt Code
	TaxExemptCode5	TaxExemptCode5	Tax 2.0 OKGP - Entity Type 05 Exempt Code
	MasterDataRecordingLvl	MasterDataRecordingLvl	Tax 2.0 - Master Level
	ExtProducerOrPurchaserNmbr	ExtProducerOrPurchaserNmbr	Tax 2.0 - Oklahoma Producer/Purchaser Number
	ProductType	ProductType	Tax 2.0 - Oklahoma Product Code
	TaxPayerIDByAgency	TaxPayerIDByAgency	Tax 2.0 - Oklahoma Taxpayer Number
	ReportingCompany	ReportingCompany	Tax 2.0 - FEIN/SSN
	ProductionDate	ProductionDate	Tax 2.0 OK - Production Date (YYYYMM)
	CreatedByUser	CreatedByUser	Created By
	CreationDateTime	CreationDateTime	Created On Timestamp
	GrossVolInBaseUnit	GrossVolInBaseUnit	Gross Volume
	GrossValInCoCodeCrcy	GrossValInCoCodeCrcy	Gross Value
	TaxableVolInBaseUnit	TaxableVolInBaseUnit	Taxable Volume
	TaxableValInCoCodeCrcy	TaxableValInCoCodeCrcy	Taxable Value
	TaxExmptVol1InBaseUnit	TaxExmptVol1InBaseUnit	Tax 2.0 - Exempt Entity Type 1 Volume
	TaxExmptVal1InCoCdCrcy	TaxExmptVal1InCoCdCrcy	Tax 2.0 - Exempt Entity Type 1 Value
	TaxExmptVol2InBaseUnit	TaxExmptVol2InBaseUnit	Tax 2.0 - Exempt Entity Type 2 Volume
	TaxExmptVal2InCoCdCrcy	TaxExmptVal2InCoCdCrcy	Tax 2.0 - Exempt Entity Type 2 Value
	TaxExmptVol3InBaseUnit	TaxExmptVol3InBaseUnit	Tax 2.0 - Exempt Entity Type 3 Volume
	TaxExmptVal3InCoCdCrcy	TaxExmptVal3InCoCdCrcy	Tax 2.0 - Exempt Entity Type 3 Value
	TaxExmptVol4InBaseUnit	TaxExmptVol4InBaseUnit	Tax 2.0 - Exempt Entity Type 4 Volume
	TaxExmptVal4InCoCdCrcy	TaxExmptVal4InCoCdCrcy	Tax 2.0 - Exempt Entity Type 4 Value
	TaxExmptVol5InBaseUnit	TaxExmptVol5InBaseUnit	Tax 2.0 - Exempt Entity Type 5 Volume
	TaxExmptVal5InCoCdCrcy	TaxExmptVal5InCoCdCrcy	Tax 2.0 - Exempt Entity Type 5 Value
	EnhncdOilRcvryVolInBaseUnit	EnhncdOilRcvryVolInBaseUnit	EOR Volume
	EnhncdOilRcvryValInCoCdCrcy	EnhncdOilRcvryValInCoCdCrcy	EOR Value
	MktgCostInCoCodeCrcy	MktgCostInCoCodeCrcy	Marketing Cost
	MktgReimbmtCostInCoCodeCrcy	MktgReimbmtCostInCoCodeCrcy	Marketing Cost Reimbursement
	GrossProdnTaxAmtInCoCodeCrcy	GrossProdnTaxAmtInCoCodeCrcy	Tax 2.0 - Gross Production Tax Amount
	PetroleumExcsTxAmtInCoCdCrcy	PetroleumExcsTxAmtInCoCdCrcy	Tax 2.0 - Petroleum Excise Tax Amount
	RevolvingFundTxAmtInCoCdCrcy	RevolvingFundTxAmtInCoCdCrcy	Tax 2.0 - Revolving Fund Tax Amount
	MarginProdgTxAmtInCoCdCrcy	MarginProdgTxAmtInCoCdCrcy	Tax 2.0 - Marginally Producing Tax Amount
	KoiwaTribeTaxAmtInCoCodeCrcy	KoiwaTribeTaxAmtInCoCodeCrcy	Tax 2.0 - Kiowa Tax Amount
	ArapahoTribeTaxAmtInCoCdCrcy	ArapahoTribeTaxAmtInCoCdCrcy	Shoshone Arapaho Tax
	Country	Country	Country/Region Key
	PrimaryGeogrlLocation	PrimaryGeogrlLocation	Primary Geographical Location

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 C_PRATaxRptgHistoryOKQRY.
-- 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: CPVTAXRPTGHISTOK

CREATE VIEW C_PRATaxRptgHistoryOKQRY AS
SELECT
  CompanyCode,
  SalesDate,
  Product,
  Well,
  WellCompletion,
  MeasurementPoint,
  JointVenture,
  DivisionOfInterest,
  DeliveryNetwork,
  PRAContract,
  VolumeType,
  TaxClassification,
  ProductionUnitNumber,
  TaxRptgRvslOrBkgOrAdjmt,
  AllocationRatio,
  ProducerOrPurchaserCode,
  UnitJointVenture,
  HasSeveranceTaxPaytOblgn,
  SeveranceTaxRptgType,
  CompanyCodeCurrency,
  TaxRate,
  ProducerOrPurchaserNmbr,
  ValuationDocumentNumber,
  ValuationDocumentYear,
  TaxExemptCode1,
  TaxExemptCode2,
  TaxExemptCode3,
  TaxExemptCode4,
  TaxExemptCode5,
  MasterDataRecordingLvl,
  ExtProducerOrPurchaserNmbr,
  ProductType,
  TaxPayerIDByAgency,
  ReportingCompany,
  ProductionDate,
  CreatedByUser,
  CreationDateTime,
  GrossVolInBaseUnit,
  GrossValInCoCodeCrcy,
  TaxableVolInBaseUnit,
  TaxableValInCoCodeCrcy,
  TaxExmptVol1InBaseUnit,
  TaxExmptVal1InCoCdCrcy,
  TaxExmptVol2InBaseUnit,
  TaxExmptVal2InCoCdCrcy,
  TaxExmptVol3InBaseUnit,
  TaxExmptVal3InCoCdCrcy,
  TaxExmptVol4InBaseUnit,
  TaxExmptVal4InCoCdCrcy,
  TaxExmptVol5InBaseUnit,
  TaxExmptVal5InCoCdCrcy,
  EnhncdOilRcvryVolInBaseUnit,
  EnhncdOilRcvryValInCoCdCrcy,
  MktgCostInCoCodeCrcy,
  MktgReimbmtCostInCoCodeCrcy,
  GrossProdnTaxAmtInCoCodeCrcy,
  PetroleumExcsTxAmtInCoCdCrcy,
  RevolvingFundTxAmtInCoCdCrcy,
  MarginProdgTxAmtInCoCdCrcy,
  KoiwaTribeTaxAmtInCoCodeCrcy,
  ArapahoTribeTaxAmtInCoCdCrcy,
  Country,
  PrimaryGeogrlLocation
FROM I_PRATaxRptgHistoryOK
;

Depth:

C_PRATaxRptgHistoryOKQRY view

I_PRATaxRptgHistoryOK view