What is I_RAPostingItemCube_2 in SAP S/4HANA?

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

Which tables does I_RAPostingItemCube_2 read from?

I_RAPostingItemCube_2 reads data from: P_RAPostingItemWthRecgdAmt.

What VDM layer is I_RAPostingItemCube_2?

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

I_RAPostingItemCube_2

DDL: I_RAPOSTINGITEMCUBE_2 Type: view_entity COMPOSITE Package: FARR_CDS_ANALYTICS

62 Fields 1 Data Sources 4 Associations

Posting Item - Cube

I_RAPostingItemCube_2 (Composite)

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

Accounting and Financial Close

I_RAPostingItemCube_2 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 62 fields with key fields CompanyCode, AccountingPrinciple, RevnAcctgReconciliationKey, PerformanceObligation, ConditionType. It has 4 associations to related views. Part of development package FARR_CDS_ANALYTICS.

SAP API Hub

Category	Composite
State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-RA-2CL
Capabilities	Data Provider for Analytical Queries,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)	Yes
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Not Released
Package	Accounting and Financial Close for SAP S/4HANA Cloud Public 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 Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_RAPostingItemWthRecgdAmt	RevenueAccountingPosting	from

Associations (4)

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`
[1..1]	I_RevenueAccountingContract	_I_RevenueAccountingContract	`RevenueAccountingPosting.RevenueAccountingContract = _I_RevenueAccountingContract.RevenueAccountingContract`

Annotations (14)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
Analytics.dataCategory	#CUBE	view
Analytics.technicalName	IRAPOSTITEMCUBE2	view
Analytics.internalName	#LOCAL	view
EndUserText.label	Posting Item - Cube	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#COMPOSITE	view

Fields (62)

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			Created On
	BusinessPartner			Business Partner Number
	Customer			Customer Number
	PerfOblgnFulfillmentType			Fulfillment Type
	RAPerformanceObligationType			Revenue Accounting Performance Obligation Type
	RevnAcctgSalesOrganization			Sales Organization for Revenue Accounting
	CompanyCodeCurrency	P_RAPostingItemWthRecgdAmt	CompanyCodeCurrency	Local Currency
	SalesDocumentCurrency	P_RAPostingItemWthRecgdAmt	SalesDocumentCurrency	SD Document Currency
	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	P_RAPostingItemWthRecgdAmt	RevnAcctgRecnclnKeyStatus	Status of Revenue Reconciliation Key
	ControllingArea	P_RAPostingItemWthRecgdAmt	ControllingArea	Controlling Area
	RAContractIsUniversal	_I_RevenueAccountingContract	RAContractIsUniversal	Universal Revenue Recognition Contract
	_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	P_RAPostingItemWthRecgdAmt	_RevnAcctgReconciliationKey
	_RAPerformanceObligation	P_RAPostingItemWthRecgdAmt	_RAPerformanceObligation
	_FiscalYear	P_RAPostingItemWthRecgdAmt	_FiscalYear
	_GLAccountInCompanyCode	P_RAPostingItemWthRecgdAmt	_GLAccountInCompanyCode
	_BusinessArea	P_RAPostingItemWthRecgdAmt	_BusinessArea
	_FunctionalArea	P_RAPostingItemWthRecgdAmt	_FunctionalArea
	_Order	P_RAPostingItemWthRecgdAmt	_Order
	_SalesOrder	P_RAPostingItemWthRecgdAmt	_SalesOrder
	_RAPostingCategory	P_RAPostingItemWthRecgdAmt	_RAPostingCategory
	_DebitCreditCode	P_RAPostingItemWthRecgdAmt	_DebitCreditCode
	_RAReconciliationKeyStatus	P_RAPostingItemWthRecgdAmt	_RAReconciliationKeyStatus
	_FiscalYearVariant		_FiscalYearVariant
	_BusinessPartner
	_Customer
	_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_2.
-- 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 I_RAPostingItemCube_2 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 preserving type) 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,
  RevenueAccountingPosting._RevenueAccountingContract.RevnAcctgContractCreationDate AS RevnAcctgContractCreationDate,
  RevenueAccountingPosting._RAPerformanceObligation.BusinessPartner AS BusinessPartner,
  RevenueAccountingPosting._RAPerformanceObligation.Customer AS Customer,
  RevenueAccountingPosting._RAPerformanceObligation.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  RevenueAccountingPosting._RAPerformanceObligation.RAPerformanceObligationType AS RAPerformanceObligationType,
  RevenueAccountingPosting._RAPerformanceObligation.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  RevenueAccountingPosting.CompanyCodeCurrency AS CompanyCodeCurrency,
  RevenueAccountingPosting.SalesDocumentCurrency AS SalesDocumentCurrency,
  RevenueAccountingPosting.AdditionalCurrency1 AS AdditionalCurrency1,
  RevenueAccountingPosting.AdditionalCurrency2 AS AdditionalCurrency2,
  RevenueAccountingPosting.ConditionIsForStatistics AS ConditionIsForStatistics,
  RevenueAccountingPosting.RevnAcctgRecnclnKeyStatus AS RevnAcctgRecnclnKeyStatus,
  RevenueAccountingPosting.ControllingArea AS ControllingArea,
  _I_RevenueAccountingContract.RAContractIsUniversal AS RAContractIsUniversal,
  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,
  RevenueAccountingPosting._RevnAcctgReconciliationKey AS _RevnAcctgReconciliationKey,
  RevenueAccountingPosting._RAPerformanceObligation AS _RAPerformanceObligation,
  RevenueAccountingPosting._FiscalYear AS _FiscalYear,
  RevenueAccountingPosting._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  RevenueAccountingPosting._BusinessArea AS _BusinessArea,
  RevenueAccountingPosting._FunctionalArea AS _FunctionalArea,
  RevenueAccountingPosting._Order AS _Order,
  RevenueAccountingPosting._SalesOrder AS _SalesOrder,
  RevenueAccountingPosting._RAPostingCategory AS _RAPostingCategory,
  RevenueAccountingPosting._DebitCreditCode AS _DebitCreditCode,
  RevenueAccountingPosting._RAReconciliationKeyStatus AS _RAReconciliationKeyStatus,
  RevenueAccountingPosting._RAPerformanceObligation._BusinessPartner AS _BusinessPartner,
  RevenueAccountingPosting._RAPerformanceObligation._Customer AS _Customer,
  RevenueAccountingPosting._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]
LEFT OUTER JOIN I_RevenueAccountingContract AS _I_RevenueAccountingContract ON RevenueAccountingPosting.RevenueAccountingContract = _I_RevenueAccountingContract.RevenueAccountingContract  -- association [1..1]
;

Depth:

I_RAPostingItemCube_2 view_entity

P_RAPostingItemWthRecgdAmt view_entity