I_ChmlCompositionActiveDraft

DDL: I_CHMLCOMPOSITIONACTIVEDRAFT Type: view COMPOSITE
15 Fields 1 Data Sources

Chemical Composition with active and draft data

I_ChmlCompositionActiveDraft is a Composite CDS View that provides data about "Chemical Composition with active and draft data" in SAP S/4HANA. It reads from 1 data source (I_ChmlComposition) and exposes 15 fields.

Data Sources (1)

SourceAliasJoin Type
I_ChmlComposition ChemicalComposition from

Annotations (9)

NameValueLevelField
EndUserText.label Chemical Composition with active and draft data view
AbapCatalog.sqlViewName ICCOMPOSITIONADR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (15)

KeyFieldSource TableSource FieldDescription
ChmlCompositionUUID
ChmlCmplncInfoUUID
ChmlSuplrMatlUUID I_ChmlComposition ChmlSuplrMatlUUID Supplier Raw Material
SubstanceUUID I_ChmlComposition SubstanceUUID Substance
ChmlCompositionType
ProdCmplncLegalArea
PolymerCompositionIntID
PolymerCompositionName
ChmlCompositionStatus
LastChangeUTCDateTime
ValidityStartDateTime
_CompositionStatus I_ChmlComposition _CompositionStatus
_ChmlCmplncInfo I_ChmlComposition _ChmlCmplncInfo
_Substance I_ChmlComposition _Substance
_CompositionType I_ChmlComposition _CompositionType

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_ChmlCompositionActiveDraft.
-- 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 I_ChmlCompositionActiveDraft AS
SELECT
  ChemicalComposition.ChmlSuplrMatlUUID AS ChmlSuplrMatlUUID,
  ChemicalComposition.SubstanceUUID AS SubstanceUUID,
  ChemicalComposition._CompositionStatus AS _CompositionStatus,
  ChemicalComposition._ChmlCmplncInfo AS _ChmlCmplncInfo,
  ChemicalComposition._Substance AS _Substance,
  ChemicalComposition._CompositionType AS _CompositionType
FROM I_ChmlComposition AS ChemicalComposition
;

Learn More