P_ChmlCompositionMigrationCast

DDL: P_CHMLCOMPOSITIONMIGRATIONCAST SQL: PCHMLCMPSMIGC Type: view COMPOSITE
18 Fields 1 Data Sources

P_ChmlCompositionMigrationCast is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ChmlComposition) and exposes 18 fields.

Data Sources (1)

SourceAliasJoin Type
I_ChmlComposition ChmlComposition from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCHMLCMPSMIGC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (18)

KeyFieldSource TableSource FieldDescription
ChmlCompositionUUID I_ChmlComposition ChmlCompositionUUID Chemical Composition
ChmlCmplncInfoUUID I_ChmlComposition ChmlCmplncInfoUUID Chemical Compliance Information PP
ChmlSuplrMatlUUID I_ChmlComposition ChmlSuplrMatlUUID Supplier Raw Material
Otherwise
ChmlCompositionType I_ChmlComposition ChmlCompositionType Legal Area
ProdCmplncLegalArea I_ChmlComposition ProdCmplncLegalArea Legal Area
ChmlCompositionStatus I_ChmlComposition ChmlCompositionStatus Processing Status
PolymerCompositionIntID I_ChmlComposition PolymerCompositionIntID Internal Number
ReleaseDateTime I_ChmlComposition ReleaseDateTime Composition Released On
ReleasedByUser I_ChmlComposition ReleasedByUser Released By
ValidityStartDateTime I_ChmlComposition ValidityStartDateTime Valid From Timestamp
ValidityEndDateTime I_ChmlComposition ValidityEndDateTime Valid To Timestamp
ProdCmplncLegalAreaRef I_ChmlComposition ProdCmplncLegalAreaRef Legal Area Reference
PolymerCompositionName I_ChmlComposition PolymerCompositionName Name
CreationUTCDateTime I_ChmlComposition CreationUTCDateTime Time Stamp
CreatedByUser I_ChmlComposition CreatedByUser User Name
LastChangeUTCDateTime I_ChmlComposition LastChangeUTCDateTime Time Stamp
LastChangedByUser I_ChmlComposition LastChangedByUser User 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 P_ChmlCompositionMigrationCast.
-- 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: PCHMLCMPSMIGC

CREATE VIEW P_ChmlCompositionMigrationCast AS
SELECT
  ChmlComposition.ChmlCompositionUUID AS ChmlCompositionUUID,
  ChmlComposition.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  ChmlComposition.ChmlSuplrMatlUUID AS ChmlSuplrMatlUUID,
  ChmlComposition.ChmlCompositionType AS ChmlCompositionType,
  ChmlComposition.ProdCmplncLegalArea AS ProdCmplncLegalArea,
  ChmlComposition.ChmlCompositionStatus AS ChmlCompositionStatus,
  ChmlComposition.PolymerCompositionIntID AS PolymerCompositionIntID,
  ChmlComposition.ReleaseDateTime AS ReleaseDateTime,
  ChmlComposition.ReleasedByUser AS ReleasedByUser,
  ChmlComposition.ValidityStartDateTime AS ValidityStartDateTime,
  ChmlComposition.ValidityEndDateTime AS ValidityEndDateTime,
  ChmlComposition.ProdCmplncLegalAreaRef AS ProdCmplncLegalAreaRef,
  ChmlComposition.PolymerCompositionName AS PolymerCompositionName,
  ChmlComposition.CreationUTCDateTime AS CreationUTCDateTime,
  ChmlComposition.CreatedByUser AS CreatedByUser,
  ChmlComposition.LastChangeUTCDateTime AS LastChangeUTCDateTime,
  ChmlComposition.LastChangedByUser AS LastChangedByUser
FROM I_ChmlComposition AS ChmlComposition
;

Learn More