P_SubstLstdSubstDfltNameFB

DDL: P_SUBSTLSTDSUBSTDFLTNAMEFB Type: view_entity COMPOSITE Package: EHFND_BO_SUBSTANCE

Lisu Default Name with Language Fallback

P_SubstLstdSubstDfltNameFB is a Composite CDS View that provides data about "Lisu Default Name with Language Fallback" in SAP S/4HANA. It reads from 2 data sources (P_SubstLstdSubstDfltName, P_SubstLstdSubstDfltName) and exposes 5 fields with key field ActiveSubstanceUUID. Part of development package EHFND_BO_SUBSTANCE.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
P_SubstLstdSubstDfltName _LisuNameEnglish union
P_SubstLstdSubstDfltName P_SubstLstdSubstDfltName from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ActiveSubstanceUUID ActiveSubstanceUUID
ListedSubstanceUUID ListedSubstanceUUID
ActiveSubstanceUUID
ListedSubstanceUUID P_SubstLstdSubstDfltName ListedSubstanceUUID
ListedSubstanceDefaultName P_SubstLstdSubstDfltName ListedSubstanceDefaultName 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
// This CDS View determines the default name of Listed Substances that are used as base of a company substance with Language Fallback

// P_SubstLstdSubstDfltNameFB and P_SubstLstdSubstDfltName were introduced because of Performance issues in I_SUBSTANCEENHANCED

// Please do always consider performance aspects if you have the need to adapt this two views

define view entity P_SubstLstdSubstDfltNameFB
  as select from P_SubstLstdSubstDfltName
{
  key ActiveSubstanceUUID,
      ListedSubstanceUUID,
      ListedSubstanceDefaultName
}
where
  Language = $session.system_language

union

select from              P_SubstLstdSubstDfltName as _LisuNameEnglish
  left outer to one join P_SubstLstdSubstDfltName as _LisuNameLL on  _LisuNameEnglish.ActiveSubstanceUUID = _LisuNameLL.ActiveSubstanceUUID
                                                                 and _LisuNameLL.Language                 = $session.system_language
{
  key _LisuNameEnglish.ActiveSubstanceUUID,
      _LisuNameEnglish.ListedSubstanceUUID,
      _LisuNameEnglish.ListedSubstanceDefaultName
}
where
      _LisuNameEnglish.Language        = 'E'
  and _LisuNameLL.ListedSubstanceUUID is null

Learn More