C_PRATaxRptgHistoryTXQry

DDL: C_PRATAXRPTGHISTORYTXQRY SQL: CPVTAXTXHISTQ Type: view CONSUMPTION
48 Fields 1 Data Sources

PRA Tax Reporting History Texas Query

C_PRATaxRptgHistoryTXQry (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_PRATaxRptgHistoryTXQry is a Consumption CDS View that provides data about "PRA Tax Reporting History Texas Query" in SAP S/4HANA. It reads from 1 data source (I_PRATaxRptgHistoryTexas) and exposes 48 fields.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentIS-OIL-PRA
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_PRATaxRptgHistoryTexas I_PRATaxRptgHistoryTexas from

Annotations (9)

NameValueLevelField
EndUserText.label PRA Tax Reporting History Texas Query view
Analytics.query true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName CPVTAXTXHISTQ view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (48)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode Receiver Company Code
SalesDate SalesDate Sales Date / Month
Product Product Full three char. product code (Major and Detail Products)
Well Well Well ID number
WellCompletion WellCompletion Well Completion Number
MeasurementPoint MeasurementPoint Measurement point number
JointVenture JointVenture Joint venture
DivisionOfInterest DivisionOfInterest Division of Interest (DOI)
DeliveryNetwork DeliveryNetwork Delivery network number
PRAContract PRAContract Contract Number
VolumeType VolumeType Volume type code
TaxClassification TaxClassification Tax class.
Country Country Country/Region Key
PrimaryGeogrlLocation PrimaryGeogrlLocation Primary Geographical Location
SeveranceTaxType SeveranceTaxType Severance Tax Type
TierTaxType TierTaxType Tier Tax
TaxRptgRvslOrBkgOrAdjmt TaxRptgRvslOrBkgOrAdjmt Reversal/Booking/Adjustment
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
APIWellNumber APIWellNumber API Well Number
TexasCounty TexasCounty Texas County Identifier
ReportingAgencyLease ReportingAgencyLease Texas Lease Number
OnOrOffLeaseSale OnOrOffLeaseSale Texas On-/Off-Lease Sale Code
MasterDataRecordingLvl MasterDataRecordingLvl Texas Master Data Level
OtherPartyTaxPayerIDByAgency OtherPartyTaxPayerIDByAgency Texas Taxpayer Number of Other Party
ProducerOrPurchaserNmbr ProducerOrPurchaserNmbr Producer/Purchaser
CommodityType CommodityType Texas Commodity Type
TaxExmpType TaxExmpType Texas Exemption Type
TaxPayerIDByAgency TaxPayerIDByAgency Texas Taxpayer Number
TaxPayerName TaxPayerName Taxpayer Name
CreatedByUser CreatedByUser Created By
CreationDateTime CreationDateTime Created On Timestamp
NumberOfItems NumberOfItems Number of Items
BaseUnit BaseUnit Measurement unit
APIGravityRatio APIGravityRatio Gravity
TransacVolInBaseUnit TransacVolInBaseUnit Lease Gross Volume
GrossVolInBaseUnit GrossVolInBaseUnit Gross Volume
GrossValInCoCodeCrcy GrossValInCoCodeCrcy Gross Value
TaxableVolInBaseUnit TaxableVolInBaseUnit Taxable Volume
TaxableValInCoCodeCrcy TaxableValInCoCodeCrcy Taxable Value
TaxExmptVolInBaseUnit TaxExmptVolInBaseUnit Exempt Volume
TaxExmptValInCoCodeCrcy TaxExmptValInCoCodeCrcy Exempt Value
MktgCostInCoCodeCrcy MktgCostInCoCodeCrcy Marketing Cost
MktgReimbmtCostInCoCodeCrcy MktgReimbmtCostInCoCodeCrcy Marketing Cost Reimbursement
GrossTaxAmtInCoCodeCrcy GrossTaxAmtInCoCodeCrcy Tax Amount
TaxReimbmtAmtInCoCodeCrcy TaxReimbmtAmtInCoCodeCrcy Tax Reimbursement

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_PRATaxRptgHistoryTXQry.
-- 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: CPVTAXTXHISTQ

CREATE VIEW C_PRATaxRptgHistoryTXQry AS
SELECT
  CompanyCode,
  SalesDate,
  Product,
  Well,
  WellCompletion,
  MeasurementPoint,
  JointVenture,
  DivisionOfInterest,
  DeliveryNetwork,
  PRAContract,
  VolumeType,
  TaxClassification,
  Country,
  PrimaryGeogrlLocation,
  SeveranceTaxType,
  TierTaxType,
  TaxRptgRvslOrBkgOrAdjmt,
  ProducerOrPurchaserCode,
  UnitJointVenture,
  HasSeveranceTaxPaytOblgn,
  SeveranceTaxRptgType,
  APIWellNumber,
  TexasCounty,
  ReportingAgencyLease,
  OnOrOffLeaseSale,
  MasterDataRecordingLvl,
  OtherPartyTaxPayerIDByAgency,
  ProducerOrPurchaserNmbr,
  CommodityType,
  TaxExmpType,
  TaxPayerIDByAgency,
  TaxPayerName,
  CreatedByUser,
  CreationDateTime,
  NumberOfItems,
  BaseUnit,
  APIGravityRatio,
  TransacVolInBaseUnit,
  GrossVolInBaseUnit,
  GrossValInCoCodeCrcy,
  TaxableVolInBaseUnit,
  TaxableValInCoCodeCrcy,
  TaxExmptVolInBaseUnit,
  TaxExmptValInCoCodeCrcy,
  MktgCostInCoCodeCrcy,
  MktgReimbmtCostInCoCodeCrcy,
  GrossTaxAmtInCoCodeCrcy,
  TaxReimbmtAmtInCoCodeCrcy
FROM I_PRATaxRptgHistoryTexas
;

Learn More