I_RARevenueCatchUpCube

DDL: I_RAREVENUECATCHUPCUBE Type: view_entity COMPOSITE
41 Fields 1 Data Sources 4 Associations

Revenue Catch-Up Cube View

I_RARevenueCatchUpCube is a Composite CDS View (Cube) that provides data about "Revenue Catch-Up Cube View" in SAP S/4HANA. It reads from 1 data source (P_PerfOblgnCatchUpAllDspMode) and exposes 41 fields with key fields CompanyCode, AccountingPrinciple, PerformanceObligation, RevnAcctgReportingPeriod. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_PerfOblgnCatchUpAllDspMode P_PerfOblgnCatchUpAllDspMode from

Parameters (4)

NameTypeDefault
P_FromFiscalYear fis_gjahr
P_FromFiscalPeriod fis_poper
P_ToFiscalYear fis_gjahr
P_ToFiscalPeriod fis_poper

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCode CatchUp.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_AccountingPrinciple _AccountingPrinciple CatchUp.AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple
[1..1] I_RAPerformanceObligation _RAPerformanceObligation CatchUp.AccountingPrinciple = _RAPerformanceObligation.AccountingPrinciple
[1..1] I_RevenueAccountingContract _I_RevenueAccountingContract RAPerformanceObligation.RevenueAccountingContract = _I_RevenueAccountingContract.RevenueAccountingContract

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Analytics.technicalName IREVNCATCHUPCUBE view
EndUserText.label Revenue Catch-Up Cube View view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CatchUp CompanyCode Receiver Company Code
KEY AccountingPrinciple CatchUp AccountingPrinciple AP Ledger/CoCode
KEY PerformanceObligation CatchUp PerformanceObligation Performance Obligation
KEY RevnAcctgReportingPeriod CatchUp ReportingPeriod Single-Character Flag
DisclosureTimeIntervalType CatchUp DisclosureTimeIntervalType
SalesDocumentCurrency
RecgdCatchUpAmtInSlsDocCrcy CatchUp RecgdCatchUpAmtInSlsDocCrcy
DeltaRecognizedAmtInSlsDocCrcy CatchUp DeltaRecognizedAmtInSlsDocCrcy
PerformanceObligationClass RAPerformanceObligation PerformanceObligationClass Performance Obligation Name
BusinessPartner RAPerformanceObligation BusinessPartner Issuing Authority
Customer RAPerformanceObligation Customer Sold-to Party
PerfOblgnFulfillmentType RAPerformanceObligation PerfOblgnFulfillmentType Fulfillment Type
RAPerformanceObligationType RAPerformanceObligation RAPerformanceObligationType Performance Obligation Type
RevnAcctgSalesOrganization RAPerformanceObligation RevnAcctgSalesOrganization Sales Org.
RevenueAccountingContract RAPerformanceObligation RevenueAccountingContract Revenue Contract
RevnAcctgContractCreationDate
FunctionalArea RAPerformanceObligation FunctionalArea Sendr Fctl Area
BusinessArea RAPerformanceObligation BusinessArea Business Area
Segment RAPerformanceObligation Segment Segment number
ProfitCenter RAPerformanceObligation ProfitCenter Profit Center
CostCenter RAPerformanceObligation CostCenter Cost Center
OrderID RAPerformanceObligation OrderID Order ID
SalesOrder RAPerformanceObligation SalesOrder SD Document
WBSElementExternalID RAPerformanceObligation WBSElementExternalID WBS Element External ID
ControllingArea RAPerformanceObligation ControllingArea Controlling Area
IsBusinessPurposeCompleted Contract Blocked
RAContractIsUniversal _I_RevenueAccountingContract RAContractIsUniversal Universal Rev Contr
_CompanyCode _CompanyCode
_AccountingPrinciple _AccountingPrinciple
_RevenueAccountingContract RAPerformanceObligation _RevenueAccountingContract
_BusinessPartner RAPerformanceObligation _BusinessPartner
_BusinessArea RAPerformanceObligation _BusinessArea
_Customer RAPerformanceObligation _Customer
_FunctionalArea RAPerformanceObligation _FunctionalArea
_Order RAPerformanceObligation _Order
_Segment RAPerformanceObligation _Segment
_WBSElement RAPerformanceObligation _WBSElement
_ProfitCenter RAPerformanceObligation _ProfitCenter
_CostCenter RAPerformanceObligation _CostCenter
_ControllingArea RAPerformanceObligation _ControllingArea
_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_RARevenueCatchUpCube.
-- 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_FromFiscalYear : fis_gjahr, P_FromFiscalPeriod : fis_poper, P_ToFiscalYear : fis_gjahr, P_ToFiscalPeriod : fis_poper

CREATE VIEW I_RARevenueCatchUpCube AS
SELECT
  CatchUp.CompanyCode AS CompanyCode,
  CatchUp.AccountingPrinciple AS AccountingPrinciple,
  CatchUp.PerformanceObligation AS PerformanceObligation,
  CatchUp.ReportingPeriod AS RevnAcctgReportingPeriod,
  CatchUp.DisclosureTimeIntervalType AS DisclosureTimeIntervalType,
  cast(CatchUp.SalesDocumentCurrency as farr_ra_doc_currency preserving type) AS SalesDocumentCurrency,
  CatchUp.RecgdCatchUpAmtInSlsDocCrcy AS RecgdCatchUpAmtInSlsDocCrcy,
  CatchUp.DeltaRecognizedAmtInSlsDocCrcy AS DeltaRecognizedAmtInSlsDocCrcy,
  RAPerformanceObligation.PerformanceObligationClass AS PerformanceObligationClass,
  RAPerformanceObligation.BusinessPartner AS BusinessPartner,
  RAPerformanceObligation.Customer AS Customer,
  RAPerformanceObligation.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  RAPerformanceObligation.RAPerformanceObligationType AS RAPerformanceObligationType,
  RAPerformanceObligation.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  RAPerformanceObligation.RevenueAccountingContract AS RevenueAccountingContract,
  RAPerformanceObligation._RevenueAccountingContract.RevnAcctgContractCreationDate AS RevnAcctgContractCreationDate,
  RAPerformanceObligation.FunctionalArea AS FunctionalArea,
  RAPerformanceObligation.BusinessArea AS BusinessArea,
  RAPerformanceObligation.Segment AS Segment,
  RAPerformanceObligation.ProfitCenter AS ProfitCenter,
  RAPerformanceObligation.CostCenter AS CostCenter,
  RAPerformanceObligation.OrderID AS OrderID,
  RAPerformanceObligation.SalesOrder AS SalesOrder,
  RAPerformanceObligation.WBSElementExternalID AS WBSElementExternalID,
  RAPerformanceObligation.ControllingArea AS ControllingArea,
  RAPerformanceObligation._RevenueAccountingContract.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _I_RevenueAccountingContract.RAContractIsUniversal AS RAContractIsUniversal,
  RAPerformanceObligation._RevenueAccountingContract AS _RevenueAccountingContract,
  RAPerformanceObligation._BusinessPartner AS _BusinessPartner,
  RAPerformanceObligation._BusinessArea AS _BusinessArea,
  RAPerformanceObligation._Customer AS _Customer,
  RAPerformanceObligation._FunctionalArea AS _FunctionalArea,
  RAPerformanceObligation._Order AS _Order,
  RAPerformanceObligation._Segment AS _Segment,
  RAPerformanceObligation._WBSElement AS _WBSElement,
  RAPerformanceObligation._ProfitCenter AS _ProfitCenter,
  RAPerformanceObligation._CostCenter AS _CostCenter,
  RAPerformanceObligation._ControllingArea AS _ControllingArea,
  RAPerformanceObligation._FulfillmentType AS _FulfillmentType
FROM P_PerfOblgnCatchUpAllDspMode
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CatchUp.CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON CatchUp.AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [1..1]
LEFT OUTER JOIN I_RAPerformanceObligation AS _RAPerformanceObligation ON CatchUp.AccountingPrinciple = _RAPerformanceObligation.AccountingPrinciple  -- association [1..1]
LEFT OUTER JOIN I_RevenueAccountingContract AS _I_RevenueAccountingContract ON RAPerformanceObligation.RevenueAccountingContract = _I_RevenueAccountingContract.RevenueAccountingContract  -- association [1..1]
;

Learn More