P_UpaDaGdsClfnTechName

DDL: P_UPADAGDSCLFNTECHNAME SQL: PDGTECHNAM Type: view CONSUMPTION Package: EHDGM_CNS_COMN
7 Fields 1 Data Sources

Technical Names - Analytical Composition

P_UpaDaGdsClfnTechName is a Consumption CDS View that provides data about "Technical Names - Analytical Composition" in SAP S/4HANA. It reads from 1 data source (I_ChmlComposition) and exposes 7 fields with key fields ChmlCompositionUUID, SubstanceUUID. Part of development package EHDGM_CNS_COMN.

Data Sources (1)

SourceAliasJoin Type
I_ChmlComposition ChemicalComposition from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PDGTECHNAM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ChmlCompositionUUID I_ChmlComposition ChmlCompositionUUID Chemical Composition
KEY SubstanceUUID _ChmlComponent SubstanceUUID Substance
ChmlCmplncInfoUUID _ChmlComponent ChmlCmplncInfoUUID Chemical Compliance Information PP
ECNumber
CASNumber
_Substance _ChmlComponent _Substance
_ChmlCmplncInfo _ChmlComponent _ChmlCmplncInfo

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 P_UpaDaGdsClfnTechName.
-- 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: PDGTECHNAM

CREATE VIEW P_UpaDaGdsClfnTechName AS
SELECT
  ChemicalComposition.ChmlCompositionUUID AS ChmlCompositionUUID,
  _ChmlComponent.SubstanceUUID AS SubstanceUUID,
  _ChmlComponent.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  _ChmlComponent._Substance._ListedSubstance.ECNumber AS ECNumber,
  _ChmlComponent._Substance._ListedSubstance.CASNumber AS CASNumber,
  _ChmlComponent._Substance AS _Substance,
  _ChmlComponent._ChmlCmplncInfo AS _ChmlCmplncInfo
FROM I_ChmlComposition AS ChemicalComposition
;

Learn More