C_PRASmmryFedPyblQry

DDL: C_PRASMMRYFEDPYBLQRY SQL: CPVSUMFEDPBLQ Type: view CONSUMPTION
25 Fields 1 Data Sources

PRA Summary Federal Payable Query

C_PRASmmryFedPyblQry (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_PRASmmryFedPyblQry is a Consumption CDS View that provides data about "PRA Summary Federal Payable Query" in SAP S/4HANA. It reads from 1 data source (I_PRAAcctgDocSmmryFedPybl) and exposes 25 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_PRAAcctgDocSmmryFedPybl I_PRAAcctgDocSmmryFedPybl from

Annotations (9)

NameValueLevelField
EndUserText.label PRA Summary Federal Payable Query view
Analytics.query true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName CPVSUMFEDPBLQ view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (25)

KeyFieldSource TableSource FieldDescription
SalesDate SalesDate Sales Date / Month
CompanyCode CompanyCode Receiver Company Code
JointVenture JointVenture Joint venture
DivisionOfInterest DivisionOfInterest Division of Interest (DOI)
Well Well Well ID number
WellCompletion WellCompletion Well Completion Number
PRAContract PRAContract Contract Number
VolumeType VolumeType Volume Type Code
Product Product Full three char. product code (Major and Detail Products)
PRAOwner PRAOwner Owner Number
GLAccount GLAccount G/L Account Number
CostCenter CostCenter Cost Center
PriorPeriodAdjustmentReason PriorPeriodAdjustmentReason Prior Period Adjustment Reason Code
DeliveryNetwork DeliveryNetwork Delivery network number
ProcessingException ProcessingException ONRR-2014 - Disposition Code
ExceptionReason ExceptionReason
VolumeUnit VolumeUnit Volume Unit
EnergyUnit EnergyUnit Energy Unit
GrossVolInVolUnit GrossVolInVolUnit Total Gross Volume
GrossEnergyInEnergyUnit GrossEnergyInEnergyUnit Gross Energy
GrossAmount GrossAmount Gross value
OwnerNetVolInVolUnit OwnerNetVolInVolUnit Owner Net Volume
OwnerEnergyInEnergyUnit OwnerEnergyInEnergyUnit Owner Energy
OwnerGrossAmount OwnerGrossAmount Owner Gross Value
OwnerNetAmount OwnerNetAmount Owner Net Value

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_PRASmmryFedPyblQry.
-- 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: CPVSUMFEDPBLQ

CREATE VIEW C_PRASmmryFedPyblQry AS
SELECT
  SalesDate,
  CompanyCode,
  JointVenture,
  DivisionOfInterest,
  Well,
  WellCompletion,
  PRAContract,
  VolumeType,
  Product,
  PRAOwner,
  GLAccount,
  CostCenter,
  PriorPeriodAdjustmentReason,
  DeliveryNetwork,
  ProcessingException,
  ExceptionReason,
  VolumeUnit,
  EnergyUnit,
  GrossVolInVolUnit,
  GrossEnergyInEnergyUnit,
  GrossAmount,
  OwnerNetVolInVolUnit,
  OwnerEnergyInEnergyUnit,
  OwnerGrossAmount,
  OwnerNetAmount
FROM I_PRAAcctgDocSmmryFedPybl
;

Learn More