I_SubstActiveDraftLstdSubst

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

Company Substance and related listed sub

I_SubstActiveDraftLstdSubst 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_SubstanceActiveDraft) and exposes 14 fields. It has 4 associations to related views. Part of development package EHFND_BO_SUBSTANCE.

Data Sources (1)

SourceAliasJoin Type
I_SubstanceActiveDraft 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 ActiveSubstanceUUID view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISUBACTDRFTDLISU 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
ActiveSubstanceUUIDasActiveSubstanceUUID
SubstanceUUID I_SubstanceActiveDraft SubstanceUUID Substance
ListedSubstanceUUID I_SubstanceActiveDraft ListedSubstanceUUID Listed Substance
ResponsibleUnit I_SubstanceActiveDraft 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_SubstActiveDraftLstdSubst.
-- 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_SubstActiveDraftLstdSubst AS
SELECT
  Substance.SubstanceUUID AS SubstanceUUID,
  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_SubstanceActiveDraft 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