Ehfnd_Control_Name

DDL: EHFND_CONTROL_NAME SQL: EHFND_CTRL_NAME Type: view

Determines the name of a control

Ehfnd_Control_Name is a CDS View that provides data about "Determines the name of a control" in SAP S/4HANA. It reads from 3 data sources (ehfndd_ctrl_root, ehfndd_ctrl_text, ehfndd_ctrl_text) and exposes 2 fields.

3 data source(s) 2 fields

Data Sources (3)

SourceAliasJoin Type
ehfndd_ctrl_root ehfndd_ctrl_root from
ehfndd_ctrl_text ehfndd_ctrl_text_def_langu left_outer
ehfndd_ctrl_text ehfndd_ctrl_text_sy_langu left_outer

Parameters (2)

NameTypeDefault
p_def_langu lang
p_sy_langu lang

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName EHFND_CTRL_NAME view
EndUserText.label Determines the name of a control view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (2)

KeyFieldSource TableSource FieldDescription
name
language 
@AbapCatalog.sqlViewName: 'EHFND_CTRL_NAME'
@EndUserText.label: 'Determines the name of a control'

// Client handling by session 

@ClientHandling.algorithm: #SESSION_VARIABLE

// Name lookup should always be possible 

@AccessControl.authorizationCheck: #NOT_ALLOWED

// used for BOBF Master Data Object

@ObjectModel.usageType:{ serviceQuality: #C,        // < 15 msec

                         sizeCategory:  #M,         // < 100.000

                         dataClass: #MASTER }
                         
define view Ehfnd_Control_Name 
  with parameters  p_def_langu:lang,
                   p_sy_langu:lang

// IMPORTANT: ensure that parameters are alphabetically sorted in order for the View to work on HANA prior to SP10    

                 
as select from ehfndd_ctrl_root

  // join the listed substance name in sy-langu

  left outer join ehfndd_ctrl_text as ehfndd_ctrl_text_sy_langu 
    on ehfndd_ctrl_text_sy_langu.language = $parameters.p_sy_langu and
       ehfndd_ctrl_text_sy_langu.parent_key =  ehfndd_ctrl_root.db_key    

  // join the listed substance name in default language

  left outer join ehfndd_ctrl_text as ehfndd_ctrl_text_def_langu 
    on ehfndd_ctrl_text_def_langu.language = $parameters.p_def_langu and
       ehfndd_ctrl_text_def_langu.parent_key =  ehfndd_ctrl_root.db_key
{
  ehfndd_ctrl_root.db_key as ctrl_root_key,
  COALESCE( ehfndd_ctrl_text_sy_langu.text, ehfndd_ctrl_text_def_langu.text ) as name,
  COALESCE( ehfndd_ctrl_text_sy_langu.language, ehfndd_ctrl_text_def_langu.language ) as language
}

Learn More