Which tables does DDCDS_ENTITY_PARAMETERS use?

DDCDS_ENTITY_PARAMETERS reads from 3 data source(s): dd10b, dd02b, tadir.

How many fields does DDCDS_ENTITY_PARAMETERS have?

DDCDS_ENTITY_PARAMETERS has 7 fields. Key fields: entity_name, entity_state.

DDCDS_ENTITY_PARAMETERS

DDL: DDCDS_ENTITY_PARAMETERS Type: view_entity Package: SD_CDS_INFO_PROVIDER

Metadata of CDS Entities: Parameters

DDCDS_ENTITY_PARAMETERS is a CDS View that provides data about "Metadata of CDS Entities: Parameters" in SAP S/4HANA. It reads from 3 data sources (dd10b, dd02b, tadir) and exposes 7 fields with key fields entity_name, entity_state. It has 3 associations to related views. Part of development package SD_CDS_INFO_PROVIDER.

Data Sources (3)

Source	Alias	Join Type
dd10b	parameters	inner
dd02b	stob	from
tadir	tadir	inner

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	ddddlsrc10bt	_label_active	`_label_active.strucobjn = stob.strucobjn and _label_active.as4local = stob.as4local and _label_active.parametername = parameters.parametername and _label_active.nodename = parameters.nodename and _label_active.ddlanguage = $session.system_language -- Parameter Label - English`
[0..1]	ddddlsrc10bt	_label_active_en	`_label_active_en.strucobjn = stob.strucobjn and _label_active_en.as4local = stob.as4local and _label_active_en.parametername = parameters.parametername and _label_active_en.nodename = parameters.nodename and _label_active_en.ddlanguage = 'E' -- Parameter Label - original language`
[0..1]	ddddlsrc10bt	_label_active_orig	`_label_active_orig.strucobjn = stob.strucobjn and _label_active_orig.as4local = stob.as4local and _label_active_orig.parametername = parameters.parametername and _label_active_orig.ddlanguage = tadir.masterlang and _label_active_orig.nodename = parameters.nodename`

Annotations (2)

Name	Value	Level	Field
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Metadata of CDS Entities: Parameters	view

Fields (7)

Key	Field	Description
KEY	entity_name	Entity Name Upper Case
KEY	entity_state	Entity State
	length	Length
	decimals	Decimals
	abap_type	ABAP Type
	data_element	Data Element
	simple_type	Simple Type

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Metadata of CDS Entities: Parameters'
// **********************************************************************************************************************************************************//

// This view provides parameters metadata of CDS Entities.                                                                                                   //

// Parameter Label texts are retrieved in the System Language. Fallback: First preference is English, the last preference is in original Language            //

// **********************************************************************************************************************************************************//

define view entity DDCDS_ENTITY_PARAMETERS
  as select from dd02b as stob
    inner join   dd10b as parameters on  parameters.strucobjn = stob.strucobjn
                                     and parameters.as4local  = stob.as4local
                                     and parameters.nodename  = '.NODE1'
  -- tadir
    inner join   tadir as tadir      on  tadir.pgmid    = 'R3TR'
                                     and tadir.object   = 'STOB'
                                     and tadir.obj_name = stob.strucobjn

  -- Parameter Label - Current Language
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to ddddlsrc10bt as _label_active      on  _label_active.strucobjn     = stob.strucobjn
                                                           and _label_active.as4local      = stob.as4local
                                                           and _label_active.parametername = parameters.parametername
                                                           and _label_active.nodename      = parameters.nodename
                                                           and _label_active.ddlanguage    = $session.system_language
  -- Parameter Label - English
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to ddddlsrc10bt as _label_active_en   on  _label_active_en.strucobjn     = stob.strucobjn
                                                           and _label_active_en.as4local      = stob.as4local
                                                           and _label_active_en.parametername = parameters.parametername
                                                           and _label_active_en.nodename      = parameters.nodename
                                                           and _label_active_en.ddlanguage    = 'E'
  -- Parameter Label - original language
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to ddddlsrc10bt as _label_active_orig on  _label_active_orig.strucobjn     = stob.strucobjn
                                                           and _label_active_orig.as4local      = stob.as4local
                                                           and _label_active_orig.parametername = parameters.parametername
                                                           and _label_active_orig.ddlanguage    = tadir.masterlang
                                                           and _label_active_orig.nodename      = parameters.nodename
{
      @EndUserText.label: 'Entity Name Upper Case'
  key cast(stob.strucobjn               as abap.char(30))                                                                      as entity_name,
      @EndUserText.label: 'Entity State'
  key cast(stob.as4local                as abap.char(1))                                                                       as entity_state,
      @EndUserText.label: 'Parameter Name'
  key cast(parameters.parametername           as abap.char(30))                                                                as parameter_name,
      @EndUserText.label: 'Entity Name Raw'
      cast(stob.strucobjn_raw           as abap.char(30))                                                                      as entity_name_raw,
      @EndUserText.label: 'Parameter Name Raw'
      cast(parameters.parametername_raw       as abap.char(30))                                                                as parameter_name_raw,
      @EndUserText.label: 'Parameter Position'
      cast(parameters.posnr            as abap.int4)                                                                           as parameter_position,
      /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
      @EndUserText.label: 'Parameter Label'
      cast(coalesce( coalesce( _label_active.ddtext, _label_active_en.ddtext ), _label_active_orig.ddtext ) as abap.char(250)) as parameter_label, // it is not inherited and not aligned with Metadata Extension aligned

      @EndUserText.label: 'Language of Parameter Label'
      coalesce( coalesce( _label_active.ddlanguage, _label_active_en.ddlanguage ), _label_active_orig.ddlanguage )             as parameter_label_language,
      @EndUserText.label: 'Data Type'
      cast( case when  parameters.datatype = 'D16D' then  'DF16_DEC'
                 when  parameters.datatype = 'D16R' then  'DF16_RAW'
                 when  parameters.datatype = 'D16S' then  'DF16_SCL'
                 when  parameters.datatype = 'D34D' then  'DF34_DEC'
                 when  parameters.datatype = 'D34R' then  'DF34_RAW'
                 when  parameters.datatype = 'D16S' then  'DF34_SCL'
                 when  parameters.datatype = 'D16N' then  'DECFLOAT16'
                 when  parameters.datatype = 'D34N' then  'DECFLOAT34'
                 when  parameters.datatype = 'UTCL' then  'UTCLONG'
                 when  parameters.datatype = 'RSTR' then  'RAWSTRING'
                 when  parameters.datatype = 'SSTR' then  'SSTRING'
                 when  parameters.datatype = 'STRG' then  'STRING'
                 when  parameters.datatype = 'GGM1' then  'GEOM_EWKB'
                 else  parameters.datatype    end as abap.char(10))                                                            as data_type,
      @EndUserText.label: 'Length'
      cast(parameters.leng                as abap.numc(6) )                                                                    as length,
      @EndUserText.label: 'Decimals'
      cast(parameters.decimals            as abap.numc(6) )                                                                    as decimals,
      @EndUserText.label: 'ABAP Type'
      cast(parameters.abaptype             as abap.char(1))                                                                    as abap_type,
      @EndUserText.label: 'Data Element'
      cast(parameters.rollname            as abap.char(30))                                                                    as data_element,
      @EndUserText.label: 'Simple Type'
      cast(parameters.simple_type        as abap.char(30))                                                                     as simple_type
}
where
  stob.as4local = 'A'

Depth:

DDCDS_ENTITY_PARAMETERS view_entity