I_SubstanceTechName

DDL: I_SUBSTANCETECHNAME Type: view_entity BASIC Package: EHDGM_BO_TNAMES
10 Fields 1 Data Sources 4 Associations

Substance Technical Name

I_SubstanceTechName is a Basic CDS View that provides data about "Substance Technical Name" in SAP S/4HANA. It reads from 1 data source (ehdgmd_tname) and exposes 10 fields with key field SubstanceTechNameUUID. It has 4 associations to related views. Part of development package EHDGM_BO_TNAMES.

Data Sources (1)

SourceAliasJoin Type
ehdgmd_tname SubstanceTechName from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_SubstanceTechNameText _SubstanceTechNameText $projection.SubstanceTechNameUUID = _SubstanceTechNameText.SubstanceTechNameUUID -- Substance
[0..1] I_Substance _Substance $projection.SubstanceUUID = _Substance.SubstanceUUID -- Admin data - Created by
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID -- Admin data - Last changed by
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.technicalName ISUBSTTECHNAME view
EndUserText.label Substance Technical Name view
ObjectModel.representativeKey SubstanceTechNameUUID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SubstanceTechNameUUID ehdgmd_tname substancetechnameuuid Technical Name UUID
SubstanceUUID ehdgmd_tname substanceuuid Substance
CreationDateTime ehdgmd_tname creationdatetime Timestamp
CreatedByUser ehdgmd_tname createdbyuser User Name
LastChangeDateTime ehdgmd_tname lastchangedatetime Timestamp
LastChangedByUser ehdgmd_tname lastchangedbyuser User Name
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_Substance _Substance
_SubstanceTechNameText _SubstanceTechNameText

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_SubstanceTechName.
-- 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_SubstanceTechName AS
SELECT
  SubstanceTechName.substancetechnameuuid AS SubstanceTechNameUUID,
  SubstanceTechName.substanceuuid AS SubstanceUUID,
  SubstanceTechName.creationdatetime AS CreationDateTime,
  SubstanceTechName.createdbyuser AS CreatedByUser,
  SubstanceTechName.lastchangedatetime AS LastChangeDateTime,
  SubstanceTechName.lastchangedbyuser AS LastChangedByUser
FROM ehdgmd_tname AS SubstanceTechName
LEFT OUTER JOIN I_SubstanceTechNameText AS _SubstanceTechNameText ON SubstanceTechNameUUID = _SubstanceTechNameText.SubstanceTechNameUUID  -- association [0..*]
LEFT OUTER JOIN I_Substance AS _Substance ON SubstanceUUID = _Substance.SubstanceUUID  -- 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