I_ChemicalTypeNameText

DDL: I_CHEMICALTYPENAMETEXT SQL: ICHMTYPENAMET Type: view BASIC
4 Fields 1 Data Sources 1 Associations

Chemical Type Name

I_ChemicalTypeNameText is a Basic CDS View that provides data about "Chemical Type Name" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 4 fields with key fields ChemicalType, Language. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ChemicalType _ChemicalType $projection.ChemicalType = _ChemicalType.ChemicalType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICHMTYPENAMET view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey ChemicalType view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Chemical Type Name view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #META view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ChemicalType dd07t domvalue_l Lower Value
_ChemicalType _ChemicalType
KEY Language dd07t ddlanguage Lang.
ChemicalTypeName dd07t ddtext Short text

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_ChemicalTypeNameText.
-- 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: ICHMTYPENAMET

CREATE VIEW I_ChemicalTypeNameText AS
SELECT
  dd07t.domvalue_l AS ChemicalType,
  dd07t.ddlanguage AS Language,
  dd07t.ddtext AS ChemicalTypeName
FROM dd07t
LEFT OUTER JOIN I_ChemicalType AS _ChemicalType ON ChemicalType = _ChemicalType.ChemicalType  -- association [0..1]
;

Learn More