I_RATotalOpenRevenueCube_2

DDL: I_RATOTALOPENREVENUECUBE_2 Type: view_entity COMPOSITE
50 Fields 1 Data Sources 4 Associations

Remaining Performance Obligation - Cube

I_RATotalOpenRevenueCube_2 (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_RATotalOpenRevenueCube_2 is a Composite CDS View (Cube) that provides data about "Remaining Performance Obligation - Cube" in SAP S/4HANA. It reads from 1 data source (P_RATotalOpenAmount) and exposes 50 fields with key fields CompanyCode, AccountingPrinciple, PerformanceObligation, RevnAcctgConditionCategory. It has 4 associations to related views.

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-RA
CapabilitiesData Provider for Analytical Queries
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition
Description <p>This CDS views disclose the aggregate amount of the transaction price allocated to the performance obligations that are unsatisfied (or partially unsatisfied) at end of the reporting period.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is the total open revenue at the end of the reporting period in the document currency?</p></li> <li><p>What is the total open revenue of time-based performance obligations at the end of the reporting period in the document currency?</p></li> <li><p>What is the total open revenue of event-based performance obligations at the end of the reporting period in the document currency?</p></li> <li><p>What is the total open revenue for each account assignment, for example, by profit centre?</p></li> <li><p>What is the total open revenue for each performance obligation type? </p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_RATotalOpenAmount P_RATotalOpenAmount from

Parameters (2)

NameTypeDefault
P_FiscalYear fis_gjahr
P_FiscalPeriod fins_fiscalperiod

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_RAPerfOblgnFlfmtType _FulfillmentType $projection.PerfOblgnFulfillmentType = _FulfillmentType.PerfOblgnFulfillmentType
[1..1] E_RAPerformanceObligation _E_RAPerformanceObligation TotalOpenRevenue.PerformanceObligation = _E_RAPerformanceObligation.PerformanceObligation
[1..1] E_RevenueAccountingContract _E_RevenueAccountingContract TotalOpenRevenue.RevenueAccountingContract = _E_RevenueAccountingContract.RevenueAccountingContract
[1..1] I_RevenueAccountingContract _I_RevenueAccountingContract TotalOpenRevenue.RevenueAccountingContract = _I_RevenueAccountingContract.RevenueAccountingContract

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY 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
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
EndUserText.label Remaining Performance Obligation - Cube view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingPrinciple AccountingPrinciple Accounting Principle
KEY PerformanceObligation PerformanceObligation Performance Obligation
KEY RevnAcctgConditionCategory RevnAcctgConditionCategory Price or Cost Condition
RAPerformanceObligationType RAPerformanceObligationType Revenue Accounting Performance Obligation Type
SalesDocumentCurrency Document Currency
RevenueAccountingContract TotalOpenRevenue RevenueAccountingContract Revenue Contract
RevnAcctgContractCreationDate _RevenueAccountingContract RevnAcctgContractCreationDate Created On
BusinessPartner BusinessPartner Business Partner Number
Customer Customer Customer Number
PerfOblgnEventType PerfOblgnEventType Event Type
RevnAcctgSalesOrganization RevnAcctgSalesOrganization Sales Organization for Revenue Accounting
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
Segment Segment Segment for Segmental Reporting
ProfitCenter ProfitCenter Profit Center
ProfitabilitySegment ProfitabilitySegment_2 Profitability Segment
CostCenter CostCenter Cost Center
OrderID OrderID Order Number
SalesOrder SalesOrder Sales Order Number
WBSElementExternalID WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited
RevnAcctgPerfOblgnStatus RevnAcctgPerfOblgnStatus Performance Obligation Status
ControllingArea ControllingArea Controlling Area
PerformanceObligationClass PerformanceObligationClass Performance Obligation Name
RAInitialEffectiveDate RAInitialEffectiveDate Initial effect. date when POB is created & becomes effective
IsBusinessPurposeCompleted Is Blocked
RATotalOpenRevnInSlsDocCrcy TotalOpenRevenue RATotalOpenRevnInSlsDocCrcy Open Revenue up to the Current Period
RATimeBsdOpenRevnInSlsDocCrcy TotalOpenRevenue RATimeBsdOpenRevnInSlsDocCrcy Open Revenue up to the Current Period
RAEventBsdOpenRevnInSlsDocCrcy TotalOpenRevenue RAEventBsdOpenRevnInSlsDocCrcy Open Revenue up to the Current Period
RAOpenCostInCoCodeCrcy TotalOpenRevenue RAOpenCostInCoCodeCrcy Open Revenue up to the Current Period
RATimeBsdOpenCostInSlsDocCrcy TotalOpenRevenue RATimeBsdOpenCostInSlsDocCrcy Open Revenue up to the Current Period
RAEventBsdOpenCostInSlsDocCrcy TotalOpenRevenue RAEventBsdOpenCostInSlsDocCrcy Open Revenue up to the Current Period
RAContractIsUniversal _I_RevenueAccountingContract RAContractIsUniversal Universal Revenue Recognition Contract
_AccountingPrinciple _AccountingPrinciple
_BusinessArea _BusinessArea
_BusinessPartner _BusinessPartner
_CompanyCode _CompanyCode
_Customer _Customer
_FulfillmentType _FulfillmentType
_FunctionalArea _FunctionalArea
_Order _Order
_PerfObligationEventType _PerfObligationEventType
_RAPerfOblgnStatus _RAPerfOblgnStatus
_SalesOrder _SalesOrder
_Segment _Segment
_WBSElement _WBSElement
_CostCenter _CostCenter
_ProfitCenter _ProfitCenter
_SalesOrganization _SalesOrganization
_ControllingArea _ControllingArea

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_RATotalOpenRevenueCube_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.
-- Parameters: P_FiscalYear : fis_gjahr, P_FiscalPeriod : fins_fiscalperiod

CREATE VIEW I_RATotalOpenRevenueCube_2 AS
SELECT
  CompanyCode,
  AccountingPrinciple,
  PerformanceObligation,
  RevnAcctgConditionCategory,
  RAPerformanceObligationType,
  cast(SalesDocumentCurrency as farp_document_currency) AS SalesDocumentCurrency,
  TotalOpenRevenue.RevenueAccountingContract AS RevenueAccountingContract,
  _RevenueAccountingContract.RevnAcctgContractCreationDate AS RevnAcctgContractCreationDate,
  BusinessPartner,
  Customer,
  PerfOblgnEventType,
  RevnAcctgSalesOrganization,
  FunctionalArea,
  BusinessArea,
  Segment,
  ProfitCenter,
  ProfitabilitySegment_2 AS ProfitabilitySegment,
  CostCenter,
  OrderID,
  SalesOrder,
  WBSElementExternalID,
  RevnAcctgPerfOblgnStatus,
  ControllingArea,
  PerformanceObligationClass,
  RAInitialEffectiveDate,
  TotalOpenRevenue._RevenueAccountingContract.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  TotalOpenRevenue.RATotalOpenRevnInSlsDocCrcy AS RATotalOpenRevnInSlsDocCrcy,
  TotalOpenRevenue.RATimeBsdOpenRevnInSlsDocCrcy AS RATimeBsdOpenRevnInSlsDocCrcy,
  TotalOpenRevenue.RAEventBsdOpenRevnInSlsDocCrcy AS RAEventBsdOpenRevnInSlsDocCrcy,
  TotalOpenRevenue.RAOpenCostInCoCodeCrcy AS RAOpenCostInCoCodeCrcy,
  TotalOpenRevenue.RATimeBsdOpenCostInSlsDocCrcy AS RATimeBsdOpenCostInSlsDocCrcy,
  TotalOpenRevenue.RAEventBsdOpenCostInSlsDocCrcy AS RAEventBsdOpenCostInSlsDocCrcy,
  _I_RevenueAccountingContract.RAContractIsUniversal AS RAContractIsUniversal
FROM P_RATotalOpenAmount
LEFT OUTER JOIN I_RAPerfOblgnFlfmtType AS _FulfillmentType ON PerfOblgnFulfillmentType = _FulfillmentType.PerfOblgnFulfillmentType  -- association [1..1]
LEFT OUTER JOIN E_RAPerformanceObligation AS _E_RAPerformanceObligation ON TotalOpenRevenue.PerformanceObligation = _E_RAPerformanceObligation.PerformanceObligation  -- association [1..1]
LEFT OUTER JOIN E_RevenueAccountingContract AS _E_RevenueAccountingContract ON TotalOpenRevenue.RevenueAccountingContract = _E_RevenueAccountingContract.RevenueAccountingContract  -- association [1..1]
LEFT OUTER JOIN I_RevenueAccountingContract AS _I_RevenueAccountingContract ON TotalOpenRevenue.RevenueAccountingContract = _I_RevenueAccountingContract.RevenueAccountingContract  -- association [1..1]
;

Learn More