C_SubstanceNameText

DDL: C_SUBSTANCENAMETEXT Type: view CONSUMPTION
5 Fields 1 Data Sources 1 OData Services 2 Fiori Apps

Substance Names with Listed Substance Names

C_SubstanceNameText is a Consumption CDS View that provides data about "Substance Names with Listed Substance Names" in SAP S/4HANA. It reads from 1 data source (I_SubstanceName) and exposes 5 fields. It is exposed through 1 OData service (UI_EHS_FND_CRR_DYN_MAN). It is used in 2 Fiori applications: Manage Water Hazard Class, Assess Regulatory Data.

Data Sources (1)

SourceAliasJoin Type
I_SubstanceName I_SubstanceName from

Annotations (12)

NameValueLevelField
EndUserText.label Substance Names with Listed Substance Names view
AbapCatalog.sqlViewName CSUBNAMTXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey SubstanceUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
UI.headerInfo.typeNamePlural Substances view
Consumption.semanticObject CompanySubstance view

OData Services (1)

ServiceBindingVersionContractRelease
UI_EHS_FND_CRR_DYN_MAN UI_EHS_FND_CRR_DYN_MAN V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F5756 Manage Water Hazard Class Transactional Manage Water Hazard Class
F7081 Assess Regulatory Data Transactional, Reuse Component The app serves only as the technical basis for app variants of the apps for assessing products against compliance requirements based on the "Regulatory Data Assessment" compliance pattern (see related apps).

Manage Water Hazard Class

Business Role: Product Stewardship Specialist - Product Compliance

With this feature, you can assess products, raw materials and substances according to the applicable water hazard class regulations and manage the compliance assessments.

Assess Regulatory Data

Business Role: Product Stewardship Specialist - Product Compliance

Fields (5)

KeyFieldSource TableSource FieldDescription
UUIDofsubstancekeySubstanceUUID
ResponsibleUnit ResponsibleUnit Responsible Unit
UUIDoflistedsubstanceListedSubstanceUUID
SpecificationCASNumberSpecification
SubstanceName SubstanceName Substance Name

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_SubstanceNameText.
-- 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 C_SubstanceNameText AS
SELECT
  ResponsibleUnit,
  SubstanceName
FROM I_SubstanceName
;

Learn More