P_MRFinalResultsNonAdditiveKF

DDL: P_MRFINALRESULTSNONADDITIVEKF SQL: PMRFNLRSLTNADDKF Type: view COMPOSITE
7 Fields 1 Data Sources

P_MRFinalResultsNonAdditiveKF is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (rdbra_nsum_gen) and exposes 7 fields with key fields KeyDate, PortfolioHierarchyCategory, PortfolioHierarchName, PortfolioHierarchNode, RiskAnalyzerKeyFigure.

Data Sources (1)

SourceAliasJoin Type
rdbra_nsum_gen FinalResultsNonAdd from

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Annotations (7)

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

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY KeyDate rdbra_nsum_gen keydate Maturity Key Date
KEY PortfolioHierarchyCategory rdbra_nsum_gen phtype Portf.hier.cat.
KEY PortfolioHierarchName rdbra_nsum_gen phname Portf.hier name
KEY PortfolioHierarchNode rdbra_nsum_gen phnode PH Node
KEY RiskAnalyzerKeyFigure
KEY FinalResultStatus rdbra_nsum_gen sumstate Status
RiskAnalyzerKeyFigureValue rdbra_nsum_gen value Value from table

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_MRFinalResultsNonAdditiveKF.
-- 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: PMRFNLRSLTNADDKF
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW P_MRFinalResultsNonAdditiveKF AS
SELECT
  FinalResultsNonAdd.keydate AS KeyDate,
  FinalResultsNonAdd.phtype AS PortfolioHierarchyCategory,
  FinalResultsNonAdd.phname AS PortfolioHierarchName,
  FinalResultsNonAdd.phnode AS PortfolioHierarchNode,
  cast(FinalResultsNonAdd.keyfigure as afwkf_definition_new) AS RiskAnalyzerKeyFigure,
  FinalResultsNonAdd.sumstate AS FinalResultStatus,
  FinalResultsNonAdd.value AS RiskAnalyzerKeyFigureValue
FROM rdbra_nsum_gen AS FinalResultsNonAdd
;

Learn More