P_RAIntegEBRRWBSElement

DDL: P_RAINTEGEBRRWBSELEMENT SQL: P_RAEBRRWBSINTG Type: view COMPOSITE
7 Fields 3 Data Sources

RAR Integration EBRR WBS

P_RAIntegEBRRWBSElement is a Composite CDS View that provides data about "RAR Integration EBRR WBS" in SAP S/4HANA. It reads from 3 data sources (I_RAPerformanceObligation, I_ResultsAnalysisKey, I_WBSElementBasicData) and exposes 7 fields with key field PerformanceObligation.

Data Sources (3)

SourceAliasJoin Type
I_RAPerformanceObligation pob from
I_ResultsAnalysisKey tkkaa inner
I_WBSElementBasicData wbs inner

Annotations (8)

NameValueLevelField
EndUserText.label RAR Integration EBRR WBS view
AbapCatalog.sqlViewName P_RAEBRRWBSINTG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation I_RAPerformanceObligation PerformanceObligation Performance Obligation
RevenueAccountingContract I_RAPerformanceObligation RevenueAccountingContract Revenue Contract
WBSElementInternalID I_WBSElementBasicData WBSElementInternalID WBS Internal ID
WBSElement I_WBSElementBasicData WBSElement WBS Internal ID
WBSDescription I_WBSElementBasicData WBSDescription WBS Element Name
ResultAnalysisInternalID I_WBSElementBasicData ResultAnalysisInternalID Results Analysis Key
AccountingPrinciple I_RAPerformanceObligation AccountingPrinciple AP Ledger/CoCode

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 P_RAIntegEBRRWBSElement.
-- 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: P_RAEBRRWBSINTG

CREATE VIEW P_RAIntegEBRRWBSElement AS
SELECT
  pob.PerformanceObligation AS PerformanceObligation,
  pob.RevenueAccountingContract AS RevenueAccountingContract,
  wbs.WBSElementInternalID AS WBSElementInternalID,
  wbs.WBSElement AS WBSElement,
  wbs.WBSDescription AS WBSDescription,
  wbs.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  pob.AccountingPrinciple AS AccountingPrinciple
FROM I_RAPerformanceObligation AS pob
INNER JOIN I_WBSElementBasicData AS wbs ON /* join condition not captured in parsed metadata */
INNER JOIN I_ResultsAnalysisKey AS tkkaa ON /* join condition not captured in parsed metadata */
;

Learn More