C_VARIANTLIST

CDS View
13 Fields 1 CDS Views

Variant Data in List

C_VARIANTLIST is a CDS View in S/4HANA. Variant Data in List. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ListFilterBar view from CONSUMPTION Other Filters

Fields (13)

KeyField CDS FieldsUsed in Views
KEY ProdStrucVariantChgStateIntID ProdStrucVariantChgStateIntID 1
KEY ProductStructureVariantUUID ProductStructureVariantUUID 1
Class Class 1
Material Material 1
ProdStrucVariantChangeNumber ProdStrucVariantChangeNumber 1
ProductStrucLastChangedByUser ProductStrucLastChangedByUser 1
ProductStrucLastChangedDate ProductStrucLastChangedDate 1
ProductStructureCreatedByUser ProductStructureCreatedByUser 1
ProductStructureCreationDate ProductStructureCreationDate 1
ProductStructureNodeName ProductStructureNodeName 1
ProductStructureNodeType ProductStructureNodeType 1
ProductStructureVariantName ProductStructureVariantName 1
ProductStructureVariantType ProductStructureVariantType 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.

-- Variant Data in List
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE C_VARIANTLIST (
    PRODSTRUCVARIANTCHGSTATEINTID,
    PRODUCTSTRUCTUREVARIANTUUID,
    CLASS,
    MATERIAL,
    PRODSTRUCVARIANTCHANGENUMBER,
    PRODUCTSTRUCLASTCHANGEDBYUSER,
    PRODUCTSTRUCLASTCHANGEDDATE,
    PRODUCTSTRUCTURECREATEDBYUSER,
    PRODUCTSTRUCTURECREATIONDATE,
    PRODUCTSTRUCTURENODENAME,
    PRODUCTSTRUCTURENODETYPE,
    PRODUCTSTRUCTUREVARIANTNAME,
    PRODUCTSTRUCTUREVARIANTTYPE,
    PRIMARY KEY (PRODSTRUCVARIANTCHGSTATEINTID, PRODUCTSTRUCTUREVARIANTUUID)
);

Learn More