I_SubstanceEnhanced

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

Substance Enhanced with Substance Name Logic

I_SubstanceEnhanced is a Composite CDS View that provides data about "Substance Enhanced with Substance Name Logic" in SAP S/4HANA. It reads from 1 data source (I_Substance) and exposes 14 fields with key field SubstanceUUID. 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_ListedSubstance _ListedSubstance $projection.ListedSubstanceUUID = _ListedSubstance.ListedSubstanceUUID
[0..1] P_SubstLstdSubstDfltNameFB _ListedSubstanceDfltName $projection.SubstanceUUID = _ListedSubstanceDfltName.ActiveSubstanceUUID
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (10)

NameValueLevelField
EndUserText.label Substance Enhanced with Substance Name Logic view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISUBENH view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey SubstanceUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SubstanceUUID SubstanceUUID Substance
CreationUTCDateTime CreationUTCDateTime Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeUTCDateTime LastChangeUTCDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
ListedSubstanceUUID ListedSubstanceUUID Listed Substance
SubstanceInternalName SubstanceInternalName Internal Name
ResponsibleUnit ResponsibleUnit Responsible Unit
Specification Specification Specification
SpecificationInternalID SpecificationInternalID Specification
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_SubstanceText _SubstanceText
_ListedSubstance _ListedSubstance

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_SubstanceEnhanced.
-- 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_SubstanceEnhanced AS
SELECT
  SubstanceUUID,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  ListedSubstanceUUID,
  SubstanceInternalName,
  ResponsibleUnit,
  Specification,
  SpecificationInternalID
FROM I_Substance AS Substance
LEFT OUTER JOIN I_ListedSubstance AS _ListedSubstance ON ListedSubstanceUUID = _ListedSubstance.ListedSubstanceUUID  -- association [0..1]
LEFT OUTER JOIN P_SubstLstdSubstDfltNameFB AS _ListedSubstanceDfltName ON SubstanceUUID = _ListedSubstanceDfltName.ActiveSubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;

Learn More