P_CHMLCOMPOSITIONMIGRATIONCAST

CDS View

P_CHMLCOMPOSITIONMIGRATIONCAST is a CDS View in S/4HANA. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_ChmlCompositionMigration view from COMPOSITE
P_ChmlCompositionMigrationDpl view from COMPOSITE

Fields (18)

KeyField CDS FieldsUsed in Views
KEY ChmlCompositionUUID ChmlCompositionUUID 1
ChmlCmplncInfoUUID ChmlCmplncInfoUUID 2
ChmlCompositionStatus ChmlCompositionStatus 2
ChmlCompositionType ChmlCompositionType 2
ChmlSuplrMatlUUID ChmlSuplrMatlUUID 2
CreatedByUser CreatedByUser 1
CreationUTCDateTime CreationUTCDateTime 1
LastChangedByUser LastChangedByUser 1
LastChangeUTCDateTime LastChangeUTCDateTime 1
PolymerCompositionIntID PolymerCompositionIntID 2
PolymerCompositionName PolymerCompositionName 1
ProdCmplncLegalArea ProdCmplncLegalArea 2
ProdCmplncLegalAreaRef ProdCmplncLegalAreaRef 1
ReleaseDateTime ReleaseDateTime 1
ReleasedByUser ReleasedByUser 1
SubstanceUUID SubstanceUUID 2
ValidityEndDateTime ValidityEndDateTime 1
ValidityStartDateTime ValidityStartDateTime 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CHMLCOMPOSITIONMIGRATIONCAST (
    CHMLCOMPOSITIONUUID,
    CHMLCMPLNCINFOUUID,
    CHMLCOMPOSITIONSTATUS,
    CHMLCOMPOSITIONTYPE,
    CHMLSUPLRMATLUUID,
    CREATEDBYUSER,
    CREATIONUTCDATETIME,
    LASTCHANGEDBYUSER,
    LASTCHANGEUTCDATETIME,
    POLYMERCOMPOSITIONINTID,
    POLYMERCOMPOSITIONNAME,
    PRODCMPLNCLEGALAREA,
    PRODCMPLNCLEGALAREAREF,
    RELEASEDATETIME,
    RELEASEDBYUSER,
    SUBSTANCEUUID,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATETIME,
    PRIMARY KEY (CHMLCOMPOSITIONUUID)
);