What is C_PRATaxRptgHistWYConsvnQry in SAP S/4HANA?

C_PRATaxRptgHistWYConsvnQry is a consumption CDS view in SAP S/4HANA. PRA Tax Rptg Hist Wyoming Consvn Qry It contains 50 fields.

Which tables does C_PRATaxRptgHistWYConsvnQry read from?

C_PRATaxRptgHistWYConsvnQry reads data from: I_PRATaxRptgHistWYConsvn.

What VDM layer is C_PRATaxRptgHistWYConsvnQry?

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

C_PRATaxRptgHistWYConsvnQry

DDL: C_PRATAXRPTGHISTWYCONSVNQRY SQL: CPVTAXRPTGHWYC Type: view CONSUMPTION

50 Fields 1 Data Sources

PRA Tax Rptg Hist Wyoming Consvn Qry

C_PRATaxRptgHistWYConsvnQry (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_PRATaxRptgHistWYConsvnQry is a Consumption CDS View that provides data about "PRA Tax Rptg Hist Wyoming Consvn Qry" in SAP S/4HANA. It reads from 1 data source (I_PRATaxRptgHistWYConsvn) and exposes 50 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_PRATaxRptgHistWYConsvn	I_PRATaxRptgHistWYConsvn	from

Annotations (9)

Name	Value	Level
EndUserText.label	PRA Tax Rptg Hist Wyoming Consvn Qry	view
Analytics.query	true	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
AbapCatalog.sqlViewName	CPVTAXRPTGHWYC	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (50)

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	TaxRptgRvslOrBkgOrAdjmt	TaxRptgRvslOrBkgOrAdjmt	Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment
	ProducerOrPurchaserCode	ProducerOrPurchaserCode	Producer or Purchaser
	UnitJointVenture	UnitJointVenture	Joint venture
	HasSeveranceTaxPaytOblgn	HasSeveranceTaxPaytOblgn	Tax Severance Tax Calculation Payment Obligations Types
	SeveranceTaxRptgType	SeveranceTaxRptgType	State Severance Tax Reporting Indicators
	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	ReturnedProductRatio	ReturnedProductRatio	Percent Returned to Lease
	County	County	Tax 2.0 - Wyoming County Identifier
	APIWellNumber	APIWellNumber	Tax 2.0 - Wyoming API Well Number
	WyomingTaxRptgSideTrackNmbr	WyomingTaxRptgSideTrackNmbr	Tax 2.0 - Wyoming Side Track Number
	Reservoir	Reservoir	Tax 2.0 - Wyoming Reservoir
	TaxRptgGroupNumber	TaxRptgGroupNumber	Tax 2.0 - Wyoming Report Group Number
	GeologicFieldName	GeologicFieldName	Tax 2.0 - Wyoming Field Name
	AgencyLeaseOrUnitName	AgencyLeaseOrUnitName	Tax 2.0 - Wyoming Lease Unit Name / API
	EntityIsCompanyOperated	EntityIsCompanyOperated	Tax 2.0 - Operated Flag
	District	District	Tax 2.0 - Wyoming Tax District
	MasterDataRecordingLvl	MasterDataRecordingLvl	Texas Master Data Level
	OperatorIDByAgency	OperatorIDByAgency	Tax 2.0 - Wyoming Operator ID
	Operator	Operator	Type of OPTION component in row type of a Ranges type
	OperatorName	OperatorName	Tax 2.0 - Operator Name
	Purchaser	Purchaser	Master Record
	PurchaserName	PurchaserName	Tax 2.0 - Purchaser Name
	ProductType	ProductType	Oil and Gas Indicator
	ValuationDocumentNumber	ValuationDocumentNumber	Val. document number
	ValuationDocumentYear	ValuationDocumentYear	Mat. Doc. Year
	CreatedByUser	CreatedByUser	Created By
	CreationDateTime	CreationDateTime	Created On Timestamp
	GrossVolInBaseUnit	GrossVolInBaseUnit	Gross Volume
	TaxableVolInBaseUnit	TaxableVolInBaseUnit	Taxable Volume
	TaxableValInCoCodeCrcy	TaxableValInCoCodeCrcy	Taxable Value
	TaxExmptVolInBaseUnit	TaxExmptVolInBaseUnit	Exempt Volume
	GrossTaxAmtInCoCodeCrcy	GrossTaxAmtInCoCodeCrcy	Tax Amount
	TaxReimbmtAmtInCoCodeCrcy	TaxReimbmtAmtInCoCodeCrcy	Tax Reimbursement
	WetGasLessResidueGasVolInMCF	WetGasLessResidueGasVolInMCF	Tax 2.0 - Wet Less Residue Volume (MCF)
	GrossSalesVolInBaseUnit	GrossSalesVolInBaseUnit	Tax 2.0 - Wyoming Before Lease Plant Split Gross Volume
	PlantProcgVolInBaseUnit	PlantProcgVolInBaseUnit	Tax 2.0 - Wyoming Plant Processing Volume
	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_PRATaxRptgHistWYConsvnQry.
-- 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: CPVTAXRPTGHWYC

CREATE VIEW C_PRATaxRptgHistWYConsvnQry AS
SELECT
  CompanyCode,
  SalesDate,
  Product,
  Well,
  WellCompletion,
  MeasurementPoint,
  JointVenture,
  DivisionOfInterest,
  DeliveryNetwork,
  PRAContract,
  VolumeType,
  TaxClassification,
  TaxRptgRvslOrBkgOrAdjmt,
  ProducerOrPurchaserCode,
  UnitJointVenture,
  HasSeveranceTaxPaytOblgn,
  SeveranceTaxRptgType,
  CompanyCodeCurrency,
  ReturnedProductRatio,
  County,
  APIWellNumber,
  WyomingTaxRptgSideTrackNmbr,
  Reservoir,
  TaxRptgGroupNumber,
  GeologicFieldName,
  AgencyLeaseOrUnitName,
  EntityIsCompanyOperated,
  District,
  MasterDataRecordingLvl,
  OperatorIDByAgency,
  Operator,
  OperatorName,
  Purchaser,
  PurchaserName,
  ProductType,
  ValuationDocumentNumber,
  ValuationDocumentYear,
  CreatedByUser,
  CreationDateTime,
  GrossVolInBaseUnit,
  TaxableVolInBaseUnit,
  TaxableValInCoCodeCrcy,
  TaxExmptVolInBaseUnit,
  GrossTaxAmtInCoCodeCrcy,
  TaxReimbmtAmtInCoCodeCrcy,
  WetGasLessResidueGasVolInMCF,
  GrossSalesVolInBaseUnit,
  PlantProcgVolInBaseUnit,
  Country,
  PrimaryGeogrlLocation
FROM I_PRATaxRptgHistWYConsvn
;

Depth:

C_PRATaxRptgHistWYConsvnQry view

I_PRATaxRptgHistWYConsvn view