I_SUBSTANCEACTIVEDRAFT

CDS View
4 Fields 2 CDS Views

Active and draft substances

I_SUBSTANCEACTIVEDRAFT is a CDS View in S/4HANA. Active and draft substances. It contains 4 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_SubstanceListedSubstanceTxt view from CONSUMPTION Listed substance names for a substance
I_SubstActiveDraftLstdSubst view from COMPOSITE Company Substance and related listed sub

Fields (4)

KeyField CDS FieldsUsed in Views
KEY ActiveSubstanceUUID ActiveSubstanceUUID 1
KEY SubstanceUUID SubstanceUUID 2
ListedSubstanceUUID ListedSubstanceUUID 1
ResponsibleUnit ResponsibleUnit 2

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.

-- Active and draft substances
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUBSTANCEACTIVEDRAFT (
    ACTIVESUBSTANCEUUID,
    SUBSTANCEUUID,
    LISTEDSUBSTANCEUUID,
    RESPONSIBLEUNIT,
    PRIMARY KEY (ACTIVESUBSTANCEUUID, SUBSTANCEUUID)
);

Learn More