What is C_RAPostingItemQuery in SAP S/4HANA?

C_RAPostingItemQuery is a consumption CDS view in SAP S/4HANA. Disaggregation of Revenue It contains 41 fields.

Which tables does C_RAPostingItemQuery read from?

C_RAPostingItemQuery reads data from: I_RAPostingItemCube.

What VDM layer is C_RAPostingItemQuery?

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

C_RAPostingItemQuery

DDL: C_RAPOSTINGITEMQUERY Type: view_entity CONSUMPTION

41 Fields 1 Data Sources

Disaggregation of Revenue

C_RAPostingItemQuery (Consumption)

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

Accounting and Financial Close

C_RAPostingItemQuery is a Consumption CDS View that provides data about "Disaggregation of Revenue" in SAP S/4HANA. It reads from 1 data source (I_RAPostingItemCube) and exposes 41 fields.

SAP API Hub

State	Deprecated
Line of Business	Accounting and Financial Close
Application Component	FI-RA
Capabilities	Analytical Query
Package	Accounting and Financial Close 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_RAPostingItemCube	RAPICube	from

Annotations (10)

Name	Value	Level
AbapCatalog.entityBuffer.definitionAllowed	false	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
Analytics.query	true	view
Analytics.technicalName	CRAPOSTITEMQUERY	view
EndUserText.label	Disaggregation of Revenue	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#CONSUMPTION	view

Fields (41)

Field	Source Table	Source Field	Description
PerformanceObligation	I_RAPostingItemCube	PerformanceObligation	Performance Obligation
RevenueAccountingContract	I_RAPostingItemCube	RevenueAccountingContract	Revenue Contract
CompanyCode	I_RAPostingItemCube	CompanyCode	Receiver Company Code
CompanyCodeName			Name of Company Code or Company
AccountingPrinciple	I_RAPostingItemCube	AccountingPrinciple	Accounting Principle
AccountingPrincipleName			Name of Accounting Principle
FiscalYear	I_RAPostingItemCube	FiscalYear	G/L Fiscal Year
FiscalPeriod	I_RAPostingItemCube	FiscalPeriod	Fiscal Period
GLAccount	I_RAPostingItemCube	GLAccount	G/L Account Number
FunctionalArea	I_RAPostingItemCube	FunctionalArea	Sendr Fctl Area
FunctionalAreaName			Name of the Functional Area
BusinessArea	I_RAPostingItemCube	BusinessArea	Business Area
BusinessAreaName			Business Area Name
Segment	I_RAPostingItemCube	Segment	Segment for Segmental Reporting
SegmentName			Segment Name
ProfitCenter	I_RAPostingItemCube	ProfitCenter	Profit Center
ProfitCenterName			Description of Profit Center
CostCenter	I_RAPostingItemCube	CostCenter	Cost Center
CostCenterName			Cost Center Name
OrderID	I_RAPostingItemCube	OrderID	Order Number
SalesOrder	I_RAPostingItemCube	SalesOrder	Sales Order Number
WBSElementExternalID	I_RAPostingItemCube	WBSElementExternalID	Work Breakdown Structure Element (WBS Element) Edited
RevnAcctgContractCreationDate		RevnAcctgContractCreationDate	Created On
BusinessPartner	I_RAPostingItemCube	BusinessPartner	Business Partner Number
BusinessPartnerName
Customer	I_RAPostingItemCube	Customer	Customer Number
CustomerName			Name of Customer
PerfOblgnFulfillmentType	I_RAPostingItemCube	PerfOblgnFulfillmentType	Fulfillment Type
RAPerformanceObligationType	I_RAPostingItemCube	RAPerformanceObligationType	Revenue Accounting Performance Obligation Type
RevnAcctgSalesOrganization	I_RAPostingItemCube	RevnAcctgSalesOrganization	Sales Organization for Revenue Accounting
SalesDocumentCurrency			Document Currency
AdditionalCurrency1	I_RAPostingItemCube	AdditionalCurrency1	Currency Key of Second Local Currency
AdditionalCurrency2	I_RAPostingItemCube	AdditionalCurrency2	Currency Key of Third Local Currency
RevnAcctgPostgAmtInSlsDocCrcy		RevnAcctgPostgAmtInSlsDocCrcy	Posting Revenue in Document Currency
RevnAcctgPostgAmtInCoCodeCrcy		RevnAcctgPostgAmtInCoCodeCrcy	Posting Revenue in Company Code Currency
RevnAcctgPostgAmtInAddlCrcy1		RevnAcctgPostgAmtInAddlCrcy1	Posting Revenue in Local Currency 2
RevnAcctgPostgAmtInAddlCrcy2		RevnAcctgPostgAmtInAddlCrcy2	Posting Revenue in Local Currency 3
RAPostedCostInSlsDocCrcy		RAPostedCostInSlsDocCrcy	Posting Cost in Document Currency
RAPostedCostAmountInCoCodeCrcy		RAPostedCostAmountInCoCodeCrcy	Posting Cost in Company Code Currency
RAPostedCostAmountInAddlCrcy1		RAPostedCostAmountInAddlCrcy1	Posting Cost in Local Currency 2
RAPostedCostAmountInAddlCrcy2		RAPostedCostAmountInAddlCrcy2	Posting Cost in Local Currency 3

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_RAPostingItemQuery.
-- 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.

CREATE VIEW C_RAPostingItemQuery AS
SELECT
  RAPICube.PerformanceObligation AS PerformanceObligation,
  RAPICube.RevenueAccountingContract AS RevenueAccountingContract,
  RAPICube.CompanyCode AS CompanyCode,
  RAPICube._CompanyCode.CompanyCodeName AS CompanyCodeName,
  RAPICube.AccountingPrinciple AS AccountingPrinciple,
  RAPICube._AccountingPrinciple._Text[1:Language = $session.system_language].AccountingPrincipleName AS AccountingPrincipleName,
  RAPICube.FiscalYear AS FiscalYear,
  RAPICube.FiscalPeriod AS FiscalPeriod,
  RAPICube.GLAccount AS GLAccount,
  RAPICube.FunctionalArea AS FunctionalArea,
  RAPICube._FunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  RAPICube.BusinessArea AS BusinessArea,
  RAPICube._BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  RAPICube.Segment AS Segment,
  RAPICube._Segment._Text[1:Language = $session.system_language].SegmentName AS SegmentName,
  RAPICube.ProfitCenter AS ProfitCenter,
  RAPICube._ProfitCenter[1:ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date]._Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  RAPICube.CostCenter AS CostCenter,
  RAPICube._CostCenter[1:ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date ]._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  RAPICube.OrderID AS OrderID,
  RAPICube.SalesOrder AS SalesOrder,
  RAPICube.WBSElementExternalID AS WBSElementExternalID,
  RevnAcctgContractCreationDate,
  RAPICube.BusinessPartner AS BusinessPartner,
  RAPICube._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  RAPICube.Customer AS Customer,
  RAPICube._Customer.CustomerName AS CustomerName,
  RAPICube.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  RAPICube.RAPerformanceObligationType AS RAPerformanceObligationType,
  RAPICube.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  cast(RAPICube.SalesDocumentCurrency as farp_document_currency preserving type) AS SalesDocumentCurrency,
  RAPICube.AdditionalCurrency1 AS AdditionalCurrency1,
  RAPICube.AdditionalCurrency2 AS AdditionalCurrency2,
  RevnAcctgPostgAmtInSlsDocCrcy,
  RevnAcctgPostgAmtInCoCodeCrcy,
  RevnAcctgPostgAmtInAddlCrcy1,
  RevnAcctgPostgAmtInAddlCrcy2,
  RAPostedCostInSlsDocCrcy,
  RAPostedCostAmountInCoCodeCrcy,
  RAPostedCostAmountInAddlCrcy1,
  RAPostedCostAmountInAddlCrcy2
FROM I_RAPostingItemCube AS RAPICube
;

Depth:

C_RAPostingItemQuery view_entity

I_RAPostingItemCube view