I_ListedSubstanceDefaultName

DDL: I_LISTEDSUBSTANCEDEFAULTNAME SQL: ILISUDEFNAM Type: view BASIC
11 Fields 2 Data Sources 5 Associations

Listed Substance Default Name

I_ListedSubstanceDefaultName is a Basic CDS View that provides data about "Listed Substance Default Name" in SAP S/4HANA. It reads from 2 data sources (ehfndi_lisu_rt, ehfndd_lisu_rt) and exposes 11 fields with key field ListedSubstance. It has 5 associations to related views.

Data Sources (2)

SourceAliasJoin Type
ehfndi_lisu_rt LisuContRoot from
ehfndd_lisu_rt LisuCustRoot union_all

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_ListedSubstanceDefNameCust _LisuCustName LisuContRoot.db_key = _LisuCustName.ListedSubstanceUUID and LisuContRoot.listsub_id = _LisuCustName.ListedSubstance and _LisuCustName.Language = $session.system_language
[0..1] I_ListedSubstanceDefNameSAP _LisuContName LisuContRoot.db_key = _LisuContName.ListedSubstanceUUID and LisuContRoot.listsub_id = _LisuContName.ListedSubstance and _LisuContName.Language = $session.system_language
[0..1] I_ListedSubstanceDefNameCust _LisuCustEngl LisuContRoot.db_key = _LisuCustEngl.ListedSubstanceUUID and _LisuCustEngl.Language = 'E' and LisuContRoot.listsub_id = _LisuCustEngl.ListedSubstance
[0..1] I_ListedSubstanceDefNameSAP _LisuContEngl LisuContRoot.db_key = _LisuContEngl.ListedSubstanceUUID and _LisuContEngl.Language = 'E' and LisuContRoot.listsub_id = _LisuContEngl.ListedSubstance

Annotations (13)

NameValueLevelField
EndUserText.label Listed Substance Default Name view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
ObjectModel.representativeKey ListedSubstance view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ILISUDEFNAM view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #TEXT view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ListedSubstance ehfndi_lisu_rt listsub_id Pollutant Container
LanguageendasLanguage
_Language _Language
ListedSubstanceUUID
SequenceendasSequence
listsub_idasListedSubstance
LanguageendasLanguage
_Language _Language
ListedSubstanceUUID
SequenceendasSequence
listsub_idendasListedSubstanceName

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ListedSubstanceDefaultName.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ILISUDEFNAM

CREATE VIEW I_ListedSubstanceDefaultName AS
SELECT
  LisuContRoot.listsub_id AS ListedSubstance,
  case when _LisuCustName.Language is not null then _LisuCustName.Language when _LisuContName.Language is not null then _LisuContName.Language when _LisuCustEngl.Language is not null then _LisuCustEngl.Language when _LisuContEngl.Language is not null then _LisuContEngl.Language end as Language AS LanguageendasLanguage,
  cast( LisuContRoot.db_key as ehfnd_lisu_key_nce preserving type ) AS ListedSubstanceUUID,
  case when _LisuCustName.Language is not null then _LisuCustName.Sequence when _LisuContName.Language is not null then _LisuContName.Sequence when _LisuCustEngl.Language is not null then _LisuCustEngl.Sequence when _LisuContEngl.Language is not null then _LisuContEngl.Sequence end as Sequence AS SequenceendasSequence,
  case when _LisuCustName.Language is not null then _LisuCustName.ListedSubstanceName when _LisuContName.Language is not null then _LisuContName.ListedSubstanceName when _LisuCustEngl.Language is not null then _LisuCustEngl.ListedSubstanceName when _LisuContEngl.Language is not null then _LisuContEngl.ListedSubstanceName else LisuContRoot.listsub_id end as ListedSubstanceName AS listsub_idasListedSubstance,
  case when _LisuCustName.Language is not null then _LisuCustName.ListedSubstanceName when _LisuCustEngl.Language is not null then _LisuCustEngl.ListedSubstanceName else LisuCustRoot.listsub_id end as ListedSubstanceName AS listsub_idendasListedSubstanceName
FROM ehfndi_lisu_rt AS LisuContRoot
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_ListedSubstanceDefNameCust AS _LisuCustName ON LisuContRoot.db_key = _LisuCustName.ListedSubstanceUUID AND LisuContRoot.listsub_id = _LisuCustName.ListedSubstance AND _LisuCustName.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ListedSubstanceDefNameSAP AS _LisuContName ON LisuContRoot.db_key = _LisuContName.ListedSubstanceUUID AND LisuContRoot.listsub_id = _LisuContName.ListedSubstance AND _LisuContName.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ListedSubstanceDefNameCust AS _LisuCustEngl ON LisuContRoot.db_key = _LisuCustEngl.ListedSubstanceUUID AND _LisuCustEngl.Language = 'E' AND LisuContRoot.listsub_id = _LisuCustEngl.ListedSubstance  -- association [0..1]
LEFT OUTER JOIN I_ListedSubstanceDefNameSAP AS _LisuContEngl ON LisuContRoot.db_key = _LisuContEngl.ListedSubstanceUUID AND _LisuContEngl.Language = 'E' AND LisuContRoot.listsub_id = _LisuContEngl.ListedSubstance  -- association [0..1]
-- UNION ALL with additional select branch(es): ehfndd_lisu_rt
;

Learn More