P_NmbrOfChmlCompInCmpst

DDL: P_NMBROFCHMLCOMPINCMPST Type: view BASIC Package: EHFND_BO_CCI
5 Fields 2 Data Sources

Returns the number of components in a Chemical Composition

P_NmbrOfChmlCompInCmpst is a Basic CDS View that provides data about "Returns the number of components in a Chemical Composition" in SAP S/4HANA. It reads from 2 data sources (I_ChmlComponent, I_ChmlComposition) and exposes 5 fields. Part of development package EHFND_BO_CCI.

Data Sources (2)

SourceAliasJoin Type
I_ChmlComponent _Component inner
I_ChmlComposition _Composition from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PNCHMCMPIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
ChmlCmplncInfoUUID I_ChmlComponent ChmlCmplncInfoUUID Chemical Compliance Information PP
ChmlCompositionUUID I_ChmlComponent ChmlCompositionUUID Chemical Composition
ChmlCompositionType I_ChmlComposition ChmlCompositionType Legal Area
ChmlCompositionStatus I_ChmlComposition ChmlCompositionStatus Processing Status
NmbrOfChmlComps

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_NmbrOfChmlCompInCmpst.
-- 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 P_NmbrOfChmlCompInCmpst AS
SELECT
  _Component.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  _Component.ChmlCompositionUUID AS ChmlCompositionUUID,
  _Composition.ChmlCompositionType AS ChmlCompositionType,
  _Composition.ChmlCompositionStatus AS ChmlCompositionStatus,
  count(distinct _Component.ChmlCompUUID) AS NmbrOfChmlComps
FROM I_ChmlComposition AS _Composition
INNER JOIN I_ChmlComponent AS _Component ON /* join condition not captured in parsed metadata */
;

Learn More