Which tables does DDCDS_ENTITY_PARAMETERS_INTERN use?

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

How many fields does DDCDS_ENTITY_PARAMETERS_INTERN have?

DDCDS_ENTITY_PARAMETERS_INTERN has 8 fields. Key fields: entity_name, entity_state.

DDCDS_ENTITY_PARAMETERS_INTERN

DDL: DDCDS_ENTITY_PARAMETERS_INTERN Type: view_entity

Metadata of CDS Entities: Parameters

DDCDS_ENTITY_PARAMETERS_INTERN 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 8 fields with key fields entity_name, entity_state. It has 4 associations to related views.

Data Sources (3)

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

Associations (4)

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 -- Annotation 'ENVIRONMENT'`
[0..1]	ddparameteranno	_environment	`_environment.strucobjn = stob.strucobjn and _environment.parametername = parameters.parametername and _environment.name = 'ENVIRONMENT'`

Annotations (2)

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

Fields (8)

Key	Field	Source Table	Source Field	Description
KEY	entity_name	dd02b	strucobjn	Entity Name Upper Case
KEY	entity_state	dd02b	as4local	Entity State
	data_type_d	dd10b	datatype	Data Type short
	length	dd10b	leng	Length
	decimals	dd10b	decimals	Decimals
	abap_type	dd10b	abaptype	ABAP Type
	data_element	dd10b	rollname	Data Element
	_environment		_environment

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

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

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

define view entity DDCDS_ENTITY_PARAMETERS_INTERN
  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
  -- Annotation 'ENVIRONMENT'
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to ddparameteranno as _environment       on  _environment.strucobjn     = stob.strucobjn
                                                              and _environment.parametername = parameters.parametername
                                                              and _environment.name          = 'ENVIRONMENT'

{
      @EndUserText.label: 'Entity Name Upper Case'
  key stob.strucobjn                                                                                               as entity_name,
      @EndUserText.label: 'Entity State'
  key stob.as4local                                                                                                as entity_state,
      @EndUserText.label: 'Parameter Name'
  key parameters.parametername                                                                                     as parameter_name,
      @EndUserText.label: 'Entity Name Raw'
      stob.strucobjn_raw                                                                                           as entity_name_raw,
      @EndUserText.label: 'Parameter Name Raw'
      parameters.parametername_raw                                                                                 as parameter_name_raw,
      @EndUserText.label: 'Parameter Position'
      parameters.posnr                                                                                             as parameter_position,
      /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
      @EndUserText.label: 'Parameter Label'
      coalesce( coalesce( _label_active.ddtext, _label_active_en.ddtext ), _label_active_orig.ddtext )             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 short'
      parameters.datatype                                                                                          as data_type_d,
      @EndUserText.label: 'Length'
      parameters.leng                                                                                              as length,
      @EndUserText.label: 'Decimals'
      parameters.decimals                                                                                          as decimals,
      @EndUserText.label: 'ABAP Type'
      parameters.abaptype                                                                                          as abap_type,
      @EndUserText.label: 'Data Element'
      parameters.rollname                                                                                          as data_element,
      // Association to check whether a parameter is bound with system field or not

      _environment
}
where
  stob.as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD02B",
"DD10B",
"DDDDLSRC10BT",
"TADIR"
],
"ASSOCIATED":
[
"DDPARAMETERANNO"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

DDCDS_ENTITY_PARAMETERS_INTERN view_entity

DBC2ABAP_CDS_PARAMETERS view_entity