What is C_PRAPostedAcctgItmQry in SAP S/4HANA?

C_PRAPostedAcctgItmQry is a consumption CDS view in SAP S/4HANA. PRA Posted Accounting Item Query It contains 109 fields.

Which tables does C_PRAPostedAcctgItmQry read from?

C_PRAPostedAcctgItmQry reads data from: I_PRAAcctgDocDetail.

What VDM layer is C_PRAPostedAcctgItmQry?

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

C_PRAPostedAcctgItmQry

DDL: C_PRAPOSTEDACCTGITMQRY SQL: CPVPOSTEDAIQ Type: view CONSUMPTION

109 Fields 1 Data Sources

PRA Posted Accounting Item Query

C_PRAPostedAcctgItmQry (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_PRAPostedAcctgItmQry is a Consumption CDS View that provides data about "PRA Posted Accounting Item Query" in SAP S/4HANA. It reads from 1 data source (I_PRAAcctgDocDetail) and exposes 109 fields with key fields CompanyCode, FiscalPeriod, AccountingDocument, AccountingDocumentItem.

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_PRAAcctgDocDetail	I_PRAAcctgDocDetail	from

Annotations (9)

Name	Value	Level
EndUserText.label	PRA Posted Accounting Item Query	view
Analytics.query	true	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
AbapCatalog.sqlViewName	CPVPOSTEDAIQ	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (109)

Key	Field	Source Field	Description
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	FiscalPeriod	FiscalPeriod	Fiscal Period
KEY	AccountingDocument	AccountingDocument	Revenue Accounting Document Number
KEY	AccountingDocumentItem	AccountingDocumentItem	Accounting Document Line Number
	BookingReversalType	BookingReversalType	Booking/Reversal Indicator
	MajorProduct	MajorProduct	Major product code
	MinorProduct	MinorProduct	Minor Product Code
	ItemIsRejected	ItemIsRejected	Accounting Document rejection flag
	GLAccount	GLAccount	G/L Account Number
	GLAccountType	GLAccountType	G/L Account Type
	AcctDeterminationCategory	AcctDeterminationCategory	Account category code
	JointVenture	JointVenture	Joint venture
	DivisionOfInterest	DivisionOfInterest	Division of Interest (DOI)
	UnitJointVenture	UnitJointVenture	Unit Venture
	Product	Product	Full three char. product code (Major and Detail Products)
	Material	Material	Material Number
	DocumentItemText	DocumentItemText	PRA Account Documnet Line Item's Description
	Well	Well	Well ID number
	WellCompletion	WellCompletion	Well Completion Number
	MeasurementPoint	MeasurementPoint	Measurement point number
	PRAContract	PRAContract	Contract Number
	VolumeType	VolumeType	Volume Type Code
	SalesDate	SalesDate	Sales Date / Month
	DeliveryNetwork	DeliveryNetwork	Delivery network number
	CostCenter	CostCenter	Cost Center
	Country	Country	Country/Region Key
	PrimaryGeogrlLocation	PrimaryGeogrlLocation	Primary Geographical Location
	ProcessingCompanyCode	ProcessingCompanyCode	Processing Company Code
	Purchaser	Purchaser	Purchaser Number
	PressureBaseQty	PressureBaseQty	Pressure Base
	ItemIsSummarizedByProduct	ItemIsSummarizedByProduct	PRA Product Code Summarize Indicator
	ItemIsWriteOff	ItemIsWriteOff	Accounting Document Writeoff flag
	ItemIsCleared	ItemIsCleared	Accounting Document Clearing
	OriginatingMeasurementPt	OriginatingMeasurementPt	Originating Measurement Point Number
	AffiliatedCompanyCode	AffiliatedCompanyCode	Affiliated Company
	TaxClassification	TaxClassification	Tax class.
	PriorPeriodAdjustmentReason	PriorPeriodAdjustmentReason	Adjustment Reason Code
	County	County	Wyoming County
	Region	Region	Region (State, Province, County)
	RelatedPRAContract	RelatedPRAContract	Related contract number
	ProductBalancingAgreement	ProductBalancingAgreement	PBA Number
	GasPlantJointVenture	GasPlantJointVenture	Gas Plant Venture
	GasPlantDivisionOfInterest	GasPlantDivisionOfInterest	Gasplant DOI No
	PRAContractType	PRAContractType	Contract Type
	Transporter	Transporter	Transporter number
	PartnerCompany	PartnerCompany	Trading Partner
	Remitter	Remitter	Remitter (Customer)
	AcctsRblMeasurementPt	AcctsRblMeasurementPt	AR MP
	AccountsReceivableJointVenture	AccountsReceivableJointVenture	AR Venture
	AcctsRblDivisionOfInterest	AcctsRblDivisionOfInterest	AR DOI
	AlternateProperty	AlternateProperty	Remitter Property
	AlternateProduct	AlternateProduct	Remitter Product
	PaymentReference	PaymentReference	Payment Reference
	PaymentDate	PaymentDate	Payment Date
	CashReceiptDate	CashReceiptDate	Cash Receipt Date
	SeveranceTaxType	SeveranceTaxType	Severance Tax Type
	MarketingType	MarketingType	Marketing type code
	ExpenseJointVenture	ExpenseJointVenture	Expense Property number
	ExpenseDivisionOfInterest	ExpenseDivisionOfInterest	Expense DOI Number
	VolumeUnit	VolumeUnit	Volume Base Unit of Measure
	EnergyUnit	EnergyUnit	Energy Base Unit Of Measure
	HeatingValUnit	HeatingValUnit	Heating Unit Of Measure
	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	HeatingValue	HeatingValue	Heat.val.factor
	APIGravityRatio	APIGravityRatio	Oil/gas density at standard/base conditions
	DisbursementDecimalRatio	DisbursementDecimalRatio	Disbursement Decimal
	NetRevenueInterestRatio	NetRevenueInterestRatio	Net Revenue Interest Percent
	GrossVolInVolUnit	GrossVolInVolUnit	Total Gross Volume
	OwnerNetVolInVolUnit	OwnerNetVolInVolUnit	Owner Net Volume
	GrossEnergyInEnergyUnit	GrossEnergyInEnergyUnit	Gross Energy
	OwnerEnergyInEnergyUnit	OwnerEnergyInEnergyUnit	Owner Energy
	GrossVolReducnInVolUnit	GrossVolReducnInVolUnit	Gross PVR
	OwnrVolReducnInVolUnit	OwnrVolReducnInVolUnit	Owner PVR
	GrossEngyReductionInEngyUnit	GrossEngyReductionInEngyUnit	Gross PTR
	OwnerEnergyReducnInEnergyUnit	OwnerEnergyReducnInEnergyUnit	Owner PTR
	GrossAmount	GrossAmount	Gross value
	OwnerGrossAmount	OwnerGrossAmount	Owner Gross Value
	OwnerNetAmount	OwnerNetAmount	Owner Net Value
	PRAOwner	PRAOwner	Owner Number
	OwnerInterestType	OwnerInterestType	Participant Interest Type
	OwnerInterestSequence	OwnerInterestSequence	Owner Interest Sequence Number
	SuspenseReason	SuspenseReason	Suspense Reason Code
	CalculationBasis	CalculationBasis	Actual / Entitled / Settlement Code
	OwnerPaymentStatus	OwnerPaymentStatus	Pay Code
	OwnerIsJntIntrstBilgEnabled	OwnerIsJntIntrstBilgEnabled	Joint Interest Billing Offset Flag
	JntIntrstBilgPartner	JntIntrstBilgPartner	JIB Partner
	PRALegalForm	PRALegalForm	Entity Type
	TaxBasis	TaxBasis	Tax Free Code
	ItemIsReallocated	ItemIsReallocated	Reallocated flag - results reallocated thru chain-of-title
	RefValnDocYear	RefValnDocYear	Reference VL Document Year
	RefValnDoc	RefValnDoc	Reference VL Document Number
	RefValnDocItem	RefValnDocItem	Reference VL Document Accounting Line Item
	CreatedByUser	CreatedByUser	Created By
	CreationDateTime	CreationDateTime	Created On Timestamp
	NetTaxAmount	NetTaxAmount	Line Item Net Tax Amount
	NetTaxReimbmtAmt	NetTaxReimbmtAmt	Line Item Net Tax Reimbursement Amount
	OtherDeductionAmount	OtherDeductionAmount	Line Other deducts amount
	NetInternalMarketingAmt	NetInternalMarketingAmt	Line Net Marketing Cost - Internal
	NetExternalMarketingAmt	NetExternalMarketingAmt	Line Net Marketing Cost - External
	NetReimbmtMarketingAmt	NetReimbmtMarketingAmt	Line Net Marketing Cost Reimbursement
	NumberOfItems	NumberOfItems	Number of Items
	JntIntrstBilgVenture	JntIntrstBilgVenture	JIB Venture
	JointVentureEquityType	JointVentureEquityType	Joint Venture Equity Type
	JointVentureEquityGroup	JointVentureEquityGroup	Joint Venture Equity Group
	RefFiscalPeriod	RefFiscalPeriod	Fiscal Period
	RefAccountingDocument	RefAccountingDocument	Revenue Accounting Trace Document Number
	RefAccountingDocumentItem	RefAccountingDocumentItem	Accounting document trace line number
	LastChangedByUser	LastChangedByUser	Changed By
	ChangedDateTime	ChangedDateTime	Changed On Timestamp

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_PRAPostedAcctgItmQry.
-- 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: CPVPOSTEDAIQ

CREATE VIEW C_PRAPostedAcctgItmQry AS
SELECT
  CompanyCode,
  FiscalPeriod,
  AccountingDocument,
  AccountingDocumentItem,
  BookingReversalType,
  MajorProduct,
  MinorProduct,
  ItemIsRejected,
  GLAccount,
  GLAccountType,
  AcctDeterminationCategory,
  JointVenture,
  DivisionOfInterest,
  UnitJointVenture,
  Product,
  Material,
  DocumentItemText,
  Well,
  WellCompletion,
  MeasurementPoint,
  PRAContract,
  VolumeType,
  SalesDate,
  DeliveryNetwork,
  CostCenter,
  Country,
  PrimaryGeogrlLocation,
  ProcessingCompanyCode,
  Purchaser,
  PressureBaseQty,
  ItemIsSummarizedByProduct,
  ItemIsWriteOff,
  ItemIsCleared,
  OriginatingMeasurementPt,
  AffiliatedCompanyCode,
  TaxClassification,
  PriorPeriodAdjustmentReason,
  County,
  Region,
  RelatedPRAContract,
  ProductBalancingAgreement,
  GasPlantJointVenture,
  GasPlantDivisionOfInterest,
  PRAContractType,
  Transporter,
  PartnerCompany,
  Remitter,
  AcctsRblMeasurementPt,
  AccountsReceivableJointVenture,
  AcctsRblDivisionOfInterest,
  AlternateProperty,
  AlternateProduct,
  PaymentReference,
  PaymentDate,
  CashReceiptDate,
  SeveranceTaxType,
  MarketingType,
  ExpenseJointVenture,
  ExpenseDivisionOfInterest,
  VolumeUnit,
  EnergyUnit,
  HeatingValUnit,
  CompanyCodeCurrency,
  HeatingValue,
  APIGravityRatio,
  DisbursementDecimalRatio,
  NetRevenueInterestRatio,
  GrossVolInVolUnit,
  OwnerNetVolInVolUnit,
  GrossEnergyInEnergyUnit,
  OwnerEnergyInEnergyUnit,
  GrossVolReducnInVolUnit,
  OwnrVolReducnInVolUnit,
  GrossEngyReductionInEngyUnit,
  OwnerEnergyReducnInEnergyUnit,
  GrossAmount,
  OwnerGrossAmount,
  OwnerNetAmount,
  PRAOwner,
  OwnerInterestType,
  OwnerInterestSequence,
  SuspenseReason,
  CalculationBasis,
  OwnerPaymentStatus,
  OwnerIsJntIntrstBilgEnabled,
  JntIntrstBilgPartner,
  PRALegalForm,
  TaxBasis,
  ItemIsReallocated,
  RefValnDocYear,
  RefValnDoc,
  RefValnDocItem,
  CreatedByUser,
  CreationDateTime,
  NetTaxAmount,
  NetTaxReimbmtAmt,
  OtherDeductionAmount,
  NetInternalMarketingAmt,
  NetExternalMarketingAmt,
  NetReimbmtMarketingAmt,
  NumberOfItems,
  JntIntrstBilgVenture,
  JointVentureEquityType,
  JointVentureEquityGroup,
  RefFiscalPeriod,
  RefAccountingDocument,
  RefAccountingDocumentItem,
  LastChangedByUser,
  ChangedDateTime
FROM I_PRAAcctgDocDetail
;

Depth:

C_PRAPostedAcctgItmQry view

I_PRAAcctgDocDetail view