P_RAIntegEBRRServiceDocument

DDL: P_RAINTEGEBRRSERVICEDOCUMENT SQL: P_RAINTEBRRSVD Type: view COMPOSITE
6 Fields 3 Data Sources

RAR integration EBRR Service Document

P_RAIntegEBRRServiceDocument is a Composite CDS View that provides data about "RAR integration EBRR Service Document" in SAP S/4HANA. It reads from 3 data sources (I_AcctgSrvcDocumentItemBasic, I_RevenueAccountingMapping, I_ResultsAnalysisKey) and exposes 6 fields with key field PerformanceObligation.

Data Sources (3)

SourceAliasJoin Type
I_AcctgSrvcDocumentItemBasic fco inner
I_RevenueAccountingMapping map from
I_ResultsAnalysisKey tkkaa inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName P_RAINTEBRRSVD 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
EndUserText.label RAR integration EBRR Service Document view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation I_RevenueAccountingMapping PerformanceObligation Performance Obligation
RevenueAccountingContract I_RevenueAccountingMapping RevenueAccountingContract Revenue Contract
ServiceDocumentType I_AcctgSrvcDocumentItemBasic ServiceDocumentType Transaction Type
ServiceDocument I_AcctgSrvcDocumentItemBasic ServiceDocument Transaction ID
ServiceDocumentItem I_AcctgSrvcDocumentItemBasic ServiceDocumentItem Service Document
ResultAnalysisInternalID I_AcctgSrvcDocumentItemBasic ResultAnalysisInternalID Results Analysis Key

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_RAIntegEBRRServiceDocument.
-- 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_RAINTEBRRSVD

CREATE VIEW P_RAIntegEBRRServiceDocument AS
SELECT
  map.PerformanceObligation AS PerformanceObligation,
  map.RevenueAccountingContract AS RevenueAccountingContract,
  fco.ServiceDocumentType AS ServiceDocumentType,
  fco.ServiceDocument AS ServiceDocument,
  fco.ServiceDocumentItem AS ServiceDocumentItem,
  fco.ResultAnalysisInternalID AS ResultAnalysisInternalID
FROM I_RevenueAccountingMapping AS map
INNER JOIN I_AcctgSrvcDocumentItemBasic AS fco ON /* join condition not captured in parsed metadata */
INNER JOIN I_ResultsAnalysisKey AS tkkaa ON /* join condition not captured in parsed metadata */
;

Learn More