P_RADeltaValuePerRecnclnKeyGrp

DDL: P_RADELTAVALUEPERRECNCLNKEYGRP SQL: PRADELTAVPERGRP Type: view COMPOSITE
10 Fields 2 Data Sources

P_RADeltaValuePerRecnclnKeyGrp is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_RAFulfilledQtyPerKeyGrp, P_RAHighLvlRevnAmtPerKeyGroup) and exposes 10 fields with key fields PerformanceObligation, RecnclnKeyGroupId.

Data Sources (2)

SourceAliasJoin Type
P_RAFulfilledQtyPerKeyGrp FulfilledQtyPerGroup left_outer
P_RAHighLvlRevnAmtPerKeyGroup RevAmtPerGroup from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRADELTAVPERGRP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation P_RAHighLvlRevnAmtPerKeyGroup RAHigherLevelPerfOblgn Higher-Level POB
KEY RecnclnKeyGroupId P_RAHighLvlRevnAmtPerKeyGroup RecnclnKeyGroupId
FiscalYearPeriod P_RAHighLvlRevnAmtPerKeyGroup FiscalYearPeriod Period/Year
RevenueAccountingContract P_RAHighLvlRevnAmtPerKeyGroup RevenueAccountingContract Revenue Contract
TolRecgdRevenuePerGroup TolRecgdRevenuePerGroup
TolRecgdCatchupPerGroup TolRecgdCatchupPerGroup
TolContractualAmtPerGroup TolContractualAmtPerGroup
SalesDocumentCurrency P_RAHighLvlRevnAmtPerKeyGroup SalesDocumentCurrency Currency
TotalFulfilledQtyPerGroup
TotalFulfilledAmountPerGroup

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_RADeltaValuePerRecnclnKeyGrp.
-- 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: PRADELTAVPERGRP

CREATE VIEW P_RADeltaValuePerRecnclnKeyGrp AS
SELECT
  RevAmtPerGroup.RAHigherLevelPerfOblgn AS PerformanceObligation,
  RevAmtPerGroup.RecnclnKeyGroupId AS RecnclnKeyGroupId,
  RevAmtPerGroup.FiscalYearPeriod AS FiscalYearPeriod,
  RevAmtPerGroup.RevenueAccountingContract AS RevenueAccountingContract,
  TolRecgdRevenuePerGroup,
  TolRecgdCatchupPerGroup,
  TolContractualAmtPerGroup,
  RevAmtPerGroup.SalesDocumentCurrency AS SalesDocumentCurrency,
  coalesce(TotalFulfilledQtyPerGroup, 0) AS TotalFulfilledQtyPerGroup,
  coalesce(TotalFulfilledAmountPerGroup, 0) AS TotalFulfilledAmountPerGroup
FROM P_RAHighLvlRevnAmtPerKeyGroup AS RevAmtPerGroup
LEFT OUTER JOIN P_RAFulfilledQtyPerKeyGrp AS FulfilledQtyPerGroup ON /* join condition not captured in parsed metadata */
;

Learn More