P_FundedProgramSetNode

DDL: P_FUNDEDPROGRAMSETNODE SQL: PFPSETNODE Type: view BASIC
6 Fields 1 Data Sources

P_FundedProgramSetNode is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (setheader) and exposes 6 fields with key field FinancialManagementArea.

Data Sources (1)

SourceAliasJoin Type
setheader header from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PFPSETNODE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.private true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea
nodevalue setheader setname Set Name
nodetxt text descript Title
descriptasnltxtendasNodeValueText
nodeid
FinancialManagementAreaName FMAreaText fitxt Name of FM Area

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_FundedProgramSetNode.
-- 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: PFPSETNODE

CREATE VIEW P_FundedProgramSetNode AS
SELECT
  cast(header.subclass as fikrs ) AS FinancialManagementArea,
  header.setname AS nodevalue,
  text.descript AS nodetxt,
  case when text.descript is null or text.descript = '' then cast( header.setname as nltxt ) else cast( concat( header.setname, concat('(',concat( text.descript, ')' ) ) ) as nltxt ) end as NodeValueText AS descriptasnltxtendasNodeValueText,
  cast( concat( concat(header.subclass,'/'),header.setname) as nodid ) AS nodeid,
  FMAreaText.fitxt AS FinancialManagementAreaName
FROM setheader AS header
;

Learn More