I_LISTEDSUBSTANCEVARIANT

CDS View
4 Fields 3 CDS Views

Listed Substance Variant View

I_LISTEDSUBSTANCEVARIANT is a CDS View in S/4HANA. Listed Substance Variant View. It contains 4 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_ListedSubstanceVariantVH view from CONSUMPTION Listed Substance Variant Value Help
C_SubstanceVarAssgmtDraft view from CONSUMPTION Assigned listed substance variants incl. drafts
P_SubstanceVariantsCt view from CONSUMPTION

Fields (4)

KeyField CDS FieldsUsed in Views
KEY ListedSubstanceUUID ListedSubstanceUUID 1
KEY ListedSubstanceVariantUUID ListedSubstanceVariantUUID 1
ListedSubstanceCndn ListedSubstanceCndn 1
ListedSubstanceReference ListedSubstanceReference 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.

-- Listed Substance Variant View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LISTEDSUBSTANCEVARIANT (
    LISTEDSUBSTANCEUUID,
    LISTEDSUBSTANCEVARIANTUUID,
    LISTEDSUBSTANCECNDN,
    LISTEDSUBSTANCEREFERENCE,
    PRIMARY KEY (LISTEDSUBSTANCEUUID, LISTEDSUBSTANCEVARIANTUUID)
);

Learn More