I_SubstanceLstdSubst

DDL: I_SUBSTANCELSTDSUBST Type: view COMPOSITE Package: EHFND_BO_SUBSTANCE
14 Fields 1 Data Sources 4 Associations

Company Substance and related listed sub

I_SubstanceLstdSubst is a Composite CDS View that provides data about "Company Substance and related listed sub" in SAP S/4HANA. It reads from 1 data source (I_Substance) and exposes 14 fields. It has 4 associations to related views. Part of development package EHFND_BO_SUBSTANCE.

Data Sources (1)

SourceAliasJoin Type
I_Substance Substance from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_ListedSubstanceCust _LisuCustRoot Substance.ListedSubstanceUUID = _LisuCustRoot.ListedSubstanceUUID
[0..1] I_ListedSubstanceSAP _LisuContRoot Substance.ListedSubstanceUUID = _LisuContRoot.ListedSubstanceUUID
[0..1] I_ListedSubstanceDefNameCust _LisuCustName Substance.ListedSubstanceUUID = _LisuCustName.ListedSubstanceUUID and _LisuCustName.Language = $session.system_language
[0..1] I_ListedSubstanceDefNameSAP _LisuContName Substance.ListedSubstanceUUID = _LisuContName.ListedSubstanceUUID and _LisuContName.Language = $session.system_language

Annotations (11)

NameValueLevelField
EndUserText.label Company Substance and related listed sub view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey SubstanceUUID view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ILISULSTDSUB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (14)

KeyFieldSource TableSource FieldDescription
SubstanceUUIDasSubstanceUUID
ActiveSubstanceUUID I_Substance ListedSubstanceUUID Listed Substance
ListedSubstanceUUID I_Substance ListedSubstanceUUID Listed Substance
ResponsibleUnit I_Substance ResponsibleUnit Responsible Unit
CustListedSubstanceDfltName _LisuCustName ListedSubstanceName Listed Subst. Name
CntntListedSubstanceDfltName _LisuContName ListedSubstanceName Listed Subst. Name
CustListedSubstance _LisuCustRoot ListedSubstance Listed Substance
CntntListedSubstance _LisuContRoot ListedSubstance Listed Substance
CustCASNumber _LisuCustRoot CASNumber CAS Number
CntntCASNumber _LisuContRoot CASNumber CAS Number
CustECNumber _LisuCustRoot ECNumber EC Number
CntntECNumber _LisuContRoot ECNumber EC Number
CustMolecularFormula _LisuCustRoot MolecularFormula
CntntMolecularFormula _LisuContRoot MolecularFormula

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_SubstanceLstdSubst.
-- 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.

CREATE VIEW I_SubstanceLstdSubst AS
SELECT
  Substance.ListedSubstanceUUID AS ActiveSubstanceUUID,
  Substance.ListedSubstanceUUID AS ListedSubstanceUUID,
  Substance.ResponsibleUnit AS ResponsibleUnit,
  _LisuCustName.ListedSubstanceName AS CustListedSubstanceDfltName,
  _LisuContName.ListedSubstanceName AS CntntListedSubstanceDfltName,
  _LisuCustRoot.ListedSubstance AS CustListedSubstance,
  _LisuContRoot.ListedSubstance AS CntntListedSubstance,
  _LisuCustRoot.CASNumber AS CustCASNumber,
  _LisuContRoot.CASNumber AS CntntCASNumber,
  _LisuCustRoot.ECNumber AS CustECNumber,
  _LisuContRoot.ECNumber AS CntntECNumber,
  _LisuCustRoot.MolecularFormula AS CustMolecularFormula,
  _LisuContRoot.MolecularFormula AS CntntMolecularFormula
FROM I_Substance AS Substance
LEFT OUTER JOIN I_ListedSubstanceCust AS _LisuCustRoot ON Substance.ListedSubstanceUUID = _LisuCustRoot.ListedSubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_ListedSubstanceSAP AS _LisuContRoot ON Substance.ListedSubstanceUUID = _LisuContRoot.ListedSubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_ListedSubstanceDefNameCust AS _LisuCustName ON Substance.ListedSubstanceUUID = _LisuCustName.ListedSubstanceUUID AND _LisuCustName.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ListedSubstanceDefNameSAP AS _LisuContName ON Substance.ListedSubstanceUUID = _LisuContName.ListedSubstanceUUID AND _LisuContName.Language = $session.system_language  -- association [0..1]
;

Learn More