C_SubstanceTechNameSubstText

DDL: C_SUBSTANCETECHNAMESUBSTTEXT SQL: CSUBTNSTXT Type: view CONSUMPTION Package: EHDGM_CNS_TNAMES
5 Fields 1 Data Sources 2 OData Services 1 Fiori Apps

Company Names for the related Substance

C_SubstanceTechNameSubstText is a Consumption CDS View that provides data about "Company Names for the related Substance" in SAP S/4HANA. It reads from 1 data source (I_SubstanceText) and exposes 5 fields with key fields SubstanceUUID, Language. It is exposed through 2 OData services (ASQL_F5261, EHDGM_UI_SUBSTANCETECHNAME). It is used in 1 Fiori application: Manage Technical Names for Substance. Part of development package EHDGM_CNS_TNAMES.

Data Sources (1)

SourceAliasJoin Type
I_SubstanceText text from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CSUBTNSTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Company Names for the related Substance view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey SubstanceUUID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
UI.headerInfo.typeName Substance Name view
UI.headerInfo.typeNamePlural Substance Names view
UI.headerInfo.title.label Company-Specific Names for Substance view
UI.headerInfo.title.value SubstanceName view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F5261 ASQL_F5261 C2 NOT_RELEASED
EHDGM_UI_SUBSTANCETECHNAME EHDGM_UI_SUBSTANCETECHNAME V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5261 Manage Technical Names for Substance Transactional An Application to manage Technical Names for substnaces that have to be shown in the Dangerous Goods Description of product classified as a Dangerous Good

Manage Technical Names for Substance

Business Role: Dangerous Goods Specialist - Product Compliance

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SubstanceUUID I_SubstanceText SubstanceUUID Substance
KEY Language
SubstanceName I_SubstanceText SubstanceName Substance Name
_Substance _Substance
_Language _Language

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 C_SubstanceTechNameSubstText.
-- 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.
-- SQL view name: CSUBTNSTXT

CREATE VIEW C_SubstanceTechNameSubstText AS
SELECT
  text.SubstanceUUID AS SubstanceUUID,
  cast(text.Language as ehfnd_sub_substance_name_langu preserving type ) AS Language,
  text.SubstanceName AS SubstanceName
FROM I_SubstanceText AS text
;

Learn More