FAC_CDS_SET_PRFTCENTERNODE

DDL: FAC_CDS_SET_PRFTCENTERNODE SQL: FACV_SET_CEPCEDG Type: view Package: FINS_FI_UH

Universal Hierarchy Cost Center Node

FAC_CDS_SET_PRFTCENTERNODE is a CDS View that provides data about "Universal Hierarchy Cost Center Node" in SAP S/4HANA. It reads from 2 data sources (setheader, setheadert) and exposes 4 fields. Part of development package FINS_FI_UH.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
setheader header from
setheadert text left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FACV_SET_CEPCEDG view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Universal Hierarchy Cost Center Node view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view

Fields (4)

KeyFieldSource TableSource FieldDescription
nodevalue setheader setname
nodetxt setheadert descript
descriptasnltxtendasNodeValueText
nodeid 
@AbapCatalog.sqlViewName: 'FACV_SET_CEPCEDG'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Universal Hierarchy Cost Center Node'
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #C,
  sizeCategory: #S
}
define view FAC_CDS_SET_PRFTCENTERNODE as select from setheader as header
left outer 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
{
  cast(header.subclass as cctrl) as controllingarea,
  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
}
where header.setclass = '0106'

Learn More