P_FundedProgramSetNode

DDL: P_FUNDEDPROGRAMSETNODE SQL: PFPSETNODE Type: view BASIC Package: FMMD_CORE_E

Funds Center Hierarchy Node via Set

P_FundedProgramSetNode is a Basic CDS View that provides data about "Funds Center Hierarchy Node via Set" in SAP S/4HANA. It reads from 1 data source (setheader) and exposes 6 fields with key field FinancialManagementArea. Part of development package FMMD_CORE_E.

1 data source(s) 6 fields

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
nodetxt text descript
descriptasnltxtendasNodeValueText
nodeid
FinancialManagementAreaName FMAreaText fitxt 
@AbapCatalog.sqlViewName: 'PFPSETNODE'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.compiler.compareFilter:true
@VDM.viewType: #BASIC
@VDM.private:true
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #A,
  sizeCategory: #S
}
define view P_FundedProgramSetNode
  as select from    setheader  as header
    left outer to one join setheadert as text       on  header.setclass = text.setclass
                                             and header.subclass = text.subclass
                                             and header.setname  = text.setname
                                             and text.langu      = $session.system_language

    left outer to one join fm01t      as FMAreaText on  header.subclass  = FMAreaText.fikrs
                                             and FMAreaText.spras = $session.system_language


{
  key 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,
      cast( concat( concat(header.subclass,'/'),header.setname) as nodid )                          as nodeid,
      FMAreaText.fitxt                                                                              as FinancialManagementAreaName

}
where
  header.setclass = '0315'

Learn More