What is I_RAPostingItemCube in SAP S/4HANA?

I_RAPostingItemCube is a composite CDS view in SAP S/4HANA. Posting Item - Cube It contains 61 fields.

Which tables does I_RAPostingItemCube read from?

I_RAPostingItemCube reads data from: P_RAPostingItemWthRecgdAmt.

What VDM layer is I_RAPostingItemCube?

I_RAPostingItemCube is classified as a Composite view that combines data from multiple basic views.

I_RAPostingItemCube

DDL: I_RAPOSTINGITEMCUBE SQL: IRAPOSTITEMCUBE Type: view COMPOSITE

61 Fields 1 Data Sources 3 Associations

Posting Item - Cube

I_RAPostingItemCube (Composite)

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

I_RAPostingItemCube is a Composite CDS View (Cube) that provides data about "Posting Item - Cube" in SAP S/4HANA. It reads from 1 data source (P_RAPostingItemWthRecgdAmt) and exposes 61 fields with key fields CompanyCode, AccountingPrinciple, RevnAcctgReconciliationKey, PerformanceObligation, ConditionType. It has 3 associations to related views.

SAP API Hub

State	Deprecated
Line of Business	Accounting and Financial Close
Application Component	FI-RA
Capabilities	Data Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What amount is transferred for a different posting category in the document currency and company code currency? For example, recognized revenue, contract asset, and contract liability </p></li> <li><p>What amount is transferred for each condition type of each performance obligation in both the document currency and the company code currency?</p></li> <li><p>What amount is posted for each G/L account?</p></li> <li><p>What proportion of the transferred amount is for each business unit?</p></li> </ul>

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
P_RAPostingItemWthRecgdAmt	RevenueAccountingPosting	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_FiscalYearVariant	_FiscalYearVariant	`$projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant`
[1..1]	E_RAPerformanceObligation	_E_RAPerformanceObligation	`$projection.PerformanceObligation = _E_RAPerformanceObligation.PerformanceObligation`
[1..1]	E_RevenueAccountingContract	_E_RevenueAccountingContract	`RevenueAccountingPosting.RevenueAccountingContract = _E_RevenueAccountingContract.RevenueAccountingContract`

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	IRAPOSTITEMCUBE	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
Analytics.dataCategory	#CUBE	view
Analytics.internalName	#LOCAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
EndUserText.label	Posting Item - Cube	view

Fields (61)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	P_RAPostingItemWthRecgdAmt	CompanyCode	Receiver Company Code
KEY	AccountingPrinciple	P_RAPostingItemWthRecgdAmt	AccountingPrinciple	Accounting Principle
KEY	RevnAcctgReconciliationKey	P_RAPostingItemWthRecgdAmt	RevnAcctgReconciliationKey	Reconciliation Key for a Contract in a Revenue Acctg. Period
KEY	PerformanceObligation	P_RAPostingItemWthRecgdAmt	PerformanceObligation	Performance Obligation
KEY	ConditionType	P_RAPostingItemWthRecgdAmt	ConditionType	Condition type
KEY	RevnAcctgPostingCategory	P_RAPostingItemWthRecgdAmt	RevnAcctgPostingCategory	Category for Posting Document
KEY	DebitCreditCode	P_RAPostingItemWthRecgdAmt	DebitCreditCode	Debit/Credit Indicator
KEY	RevenueAccountingContract	P_RAPostingItemWthRecgdAmt	RevenueAccountingContract	Revenue Contract
	FiscalYear	P_RAPostingItemWthRecgdAmt	FiscalYear	G/L Fiscal Year
	FiscalPeriod			Fiscal Period
	FiscalYearVariant	_RAFiscalYearVariant	FiscalYearVariant	Fiscal Year Variant
	FiscalYearPeriod	P_RAPostingItemWthRecgdAmt	FiscalYearPeriod	Fiscal Year Period
	Segment	P_RAPostingItemWthRecgdAmt	Segment	Segment for Segmental Reporting
	GLAccount	P_RAPostingItemWthRecgdAmt	GLAccount	G/L Account Number
	FunctionalArea	P_RAPostingItemWthRecgdAmt	FunctionalArea	Sendr Fctl Area
	BusinessArea	P_RAPostingItemWthRecgdAmt	BusinessArea	Business Area
	ProfitCenter	P_RAPostingItemWthRecgdAmt	ProfitCenter	Profit Center
	CostCenter	P_RAPostingItemWthRecgdAmt	CostCenter	Cost Center
	OrderID	P_RAPostingItemWthRecgdAmt	OrderID	Order Number
	SalesOrder	P_RAPostingItemWthRecgdAmt	SalesOrder	Sales Order Number
	WBSElementExternalID	P_RAPostingItemWthRecgdAmt	WBSElementExternalID	Work Breakdown Structure Element (WBS Element) Edited
	RevnAcctgContractCreationDate	_RevenueAccountingContract	RevnAcctgContractCreationDate	Created On
	BusinessPartner	_RAPerformanceObligation	BusinessPartner	Business Partner Number
	Customer	_RAPerformanceObligation	Customer	Customer Number
	PerfOblgnFulfillmentType	_RAPerformanceObligation	PerfOblgnFulfillmentType	Fulfillment Type
	RAPerformanceObligationType	_RAPerformanceObligation	RAPerformanceObligationType	Revenue Accounting Performance Obligation Type
	RevnAcctgSalesOrganization	_RAPerformanceObligation	RevnAcctgSalesOrganization	Sales Organization for Revenue Accounting
	CompanyCodeCurrency	P_RAPostingItemWthRecgdAmt	CompanyCodeCurrency	Local Currency
	SalesDocumentCurrency	P_RAPostingItemWthRecgdAmt	SalesDocumentCurrency	Currency Key
	AdditionalCurrency1	P_RAPostingItemWthRecgdAmt	AdditionalCurrency1	Currency Key of Second Local Currency
	AdditionalCurrency2	P_RAPostingItemWthRecgdAmt	AdditionalCurrency2	Currency Key of Third Local Currency
	ConditionIsForStatistics	P_RAPostingItemWthRecgdAmt	ConditionIsForStatistics	Condition is used for statistics
	RevnAcctgRecnclnKeyStatus		RevnAcctgRecnclnKeyStatus	Status of Revenue Reconciliation Key
	ControllingArea	P_RAPostingItemWthRecgdAmt	ControllingArea	Controlling Area
	_CompanyCode	P_RAPostingItemWthRecgdAmt	_CompanyCode
	_AccountingPrinciple	P_RAPostingItemWthRecgdAmt	_AccountingPrinciple
	_RevenueAccountingContract	P_RAPostingItemWthRecgdAmt	_RevenueAccountingContract
	_ProfitCenter	P_RAPostingItemWthRecgdAmt	_ProfitCenter
	_CurrentProfitCenter	P_RAPostingItemWthRecgdAmt	_CurrentProfitCenter
	_ControllingArea	P_RAPostingItemWthRecgdAmt	_ControllingArea
	_Segment	P_RAPostingItemWthRecgdAmt	_Segment
	_CostCenter	P_RAPostingItemWthRecgdAmt	_CostCenter
	_CurrentCostCenter	P_RAPostingItemWthRecgdAmt	_CurrentCostCenter
	_WBSElement	P_RAPostingItemWthRecgdAmt	_WBSElement
	_Currency	P_RAPostingItemWthRecgdAmt	_Currency
	_CompanyCodeCurrency	P_RAPostingItemWthRecgdAmt	_CompanyCodeCurrency
	_RevnAcctgReconciliationKey		_RevnAcctgReconciliationKey
	_RAPerformanceObligation		_RAPerformanceObligation
	_FiscalYear		_FiscalYear
	_GLAccountInCompanyCode		_GLAccountInCompanyCode
	_BusinessArea		_BusinessArea
	_FunctionalArea		_FunctionalArea
	_Order		_Order
	_SalesOrder		_SalesOrder
	_RAPostingCategory		_RAPostingCategory
	_DebitCreditCode		_DebitCreditCode
	_RAReconciliationKeyStatus		_RAReconciliationKeyStatus
	_FiscalYearVariant		_FiscalYearVariant
	_BusinessPartner	_RAPerformanceObligation	_BusinessPartner
	_Customer	_RAPerformanceObligation	_Customer
	_FulfillmentType	_RAPerformanceObligation	_FulfillmentType

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 I_RAPostingItemCube.
-- 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: IRAPOSTITEMCUBE

CREATE VIEW I_RAPostingItemCube AS
SELECT
  RevenueAccountingPosting.CompanyCode AS CompanyCode,
  RevenueAccountingPosting.AccountingPrinciple AS AccountingPrinciple,
  RevenueAccountingPosting.RevnAcctgReconciliationKey AS RevnAcctgReconciliationKey,
  RevenueAccountingPosting.PerformanceObligation AS PerformanceObligation,
  RevenueAccountingPosting.ConditionType AS ConditionType,
  RevenueAccountingPosting.RevnAcctgPostingCategory AS RevnAcctgPostingCategory,
  RevenueAccountingPosting.DebitCreditCode AS DebitCreditCode,
  RevenueAccountingPosting.RevenueAccountingContract AS RevenueAccountingContract,
  RevenueAccountingPosting.FiscalYear AS FiscalYear,
  cast(RevenueAccountingPosting.FiscalPeriod as fins_fiscalperiod) AS FiscalPeriod,
  _RAFiscalYearVariant.FiscalYearVariant AS FiscalYearVariant,
  RevenueAccountingPosting.FiscalYearPeriod AS FiscalYearPeriod,
  RevenueAccountingPosting.Segment AS Segment,
  RevenueAccountingPosting.GLAccount AS GLAccount,
  RevenueAccountingPosting.FunctionalArea AS FunctionalArea,
  RevenueAccountingPosting.BusinessArea AS BusinessArea,
  RevenueAccountingPosting.ProfitCenter AS ProfitCenter,
  RevenueAccountingPosting.CostCenter AS CostCenter,
  RevenueAccountingPosting.OrderID AS OrderID,
  RevenueAccountingPosting.SalesOrder AS SalesOrder,
  RevenueAccountingPosting.WBSElementExternalID AS WBSElementExternalID,
  _RevenueAccountingContract.RevnAcctgContractCreationDate AS RevnAcctgContractCreationDate,
  _RAPerformanceObligation.BusinessPartner AS BusinessPartner,
  _RAPerformanceObligation.Customer AS Customer,
  _RAPerformanceObligation.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  _RAPerformanceObligation.RAPerformanceObligationType AS RAPerformanceObligationType,
  _RAPerformanceObligation.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  RevenueAccountingPosting.CompanyCodeCurrency AS CompanyCodeCurrency,
  RevenueAccountingPosting.SalesDocumentCurrency AS SalesDocumentCurrency,
  RevenueAccountingPosting.AdditionalCurrency1 AS AdditionalCurrency1,
  RevenueAccountingPosting.AdditionalCurrency2 AS AdditionalCurrency2,
  RevenueAccountingPosting.ConditionIsForStatistics AS ConditionIsForStatistics,
  RevnAcctgRecnclnKeyStatus,
  RevenueAccountingPosting.ControllingArea AS ControllingArea,
  RevenueAccountingPosting._CompanyCode AS _CompanyCode,
  RevenueAccountingPosting._AccountingPrinciple AS _AccountingPrinciple,
  RevenueAccountingPosting._RevenueAccountingContract AS _RevenueAccountingContract,
  RevenueAccountingPosting._ProfitCenter AS _ProfitCenter,
  RevenueAccountingPosting._CurrentProfitCenter AS _CurrentProfitCenter,
  RevenueAccountingPosting._ControllingArea AS _ControllingArea,
  RevenueAccountingPosting._Segment AS _Segment,
  RevenueAccountingPosting._CostCenter AS _CostCenter,
  RevenueAccountingPosting._CurrentCostCenter AS _CurrentCostCenter,
  RevenueAccountingPosting._WBSElement AS _WBSElement,
  RevenueAccountingPosting._Currency AS _Currency,
  RevenueAccountingPosting._CompanyCodeCurrency AS _CompanyCodeCurrency,
  _RAPerformanceObligation._BusinessPartner AS _BusinessPartner,
  _RAPerformanceObligation._Customer AS _Customer,
  _RAPerformanceObligation._FulfillmentType AS _FulfillmentType
FROM P_RAPostingItemWthRecgdAmt AS RevenueAccountingPosting
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN E_RAPerformanceObligation AS _E_RAPerformanceObligation ON PerformanceObligation = _E_RAPerformanceObligation.PerformanceObligation  -- association [1..1]
LEFT OUTER JOIN E_RevenueAccountingContract AS _E_RevenueAccountingContract ON RevenueAccountingPosting.RevenueAccountingContract = _E_RevenueAccountingContract.RevenueAccountingContract  -- association [1..1]
;

Depth:

I_RAPostingItemCube view

P_RAPostingItemWthRecgdAmt view

C_RAPostingItemQuery view