What is C_RAPostingItemQuery in SAP S/4HANA?

C_RAPostingItemQuery is a consumption CDS view in SAP S/4HANA. Disaggregation of Revenue It contains 39 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 SQL: CRAPOSTITEMQUERY Type: view CONSUMPTION

39 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 39 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 (13)

Name	Value	Level
AbapCatalog.sqlViewName	CRAPOSTITEMQUERY	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
VDM.viewType	#CONSUMPTION	view
Analytics.query	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
EndUserText.label	Disaggregation of Revenue	view

Fields (39)

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
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.
-- SQL view name: CRAPOSTITEMQUERY

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,
  RevnAcctgPostgAmtInSlsDocCrcy,
  RevnAcctgPostgAmtInCoCodeCrcy,
  RevnAcctgPostgAmtInAddlCrcy1,
  RevnAcctgPostgAmtInAddlCrcy2,
  RAPostedCostInSlsDocCrcy,
  RAPostedCostAmountInCoCodeCrcy,
  RAPostedCostAmountInAddlCrcy1,
  RAPostedCostAmountInAddlCrcy2
FROM I_RAPostingItemCube AS RAPICube
;

Depth:

C_RAPostingItemQuery view

I_RAPostingItemCube view