I_SUBSTANCEVARASSGMT

CDS View

Substance Variant Assignment

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_SubstanceVarAssgmtAnlyts1 view from COMPOSITE Substance Variant Assignment for Anlys
I_SubstanceVarAssgmtTP view from TRANSACTIONAL Substance Variant Assignment
P_SubstanceVarAssgmtCt view from CONSUMPTION
R_CompanySubstanceVarAssgmtTP view_entity from TRANSACTIONAL Company Substance Variant Assigmt - TP

Fields (3)

KeyField CDS FieldsUsed in Views
KEY SubstanceUUID SubstanceUUID 2
KEY SubstanceVarAssgmtUUID SubstanceVarAssgmtUUID 1
ListedSubstanceVariantUUID ListedSubstanceVariantUUID 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.

-- Substance Variant Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUBSTANCEVARASSGMT (
    SUBSTANCEUUID,
    SUBSTANCEVARASSGMTUUID,
    LISTEDSUBSTANCEVARIANTUUID,
    PRIMARY KEY (SUBSTANCEUUID, SUBSTANCEVARASSGMTUUID)
);