C_PRODSTRUCVARIANT

CDS View

Product Structure Variant List

C_PRODSTRUCVARIANT is a CDS View in S/4HANA. Product Structure Variant List. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ProdStrucFilterBar view from CONSUMPTION Product Structure Filter Bar

Fields (11)

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
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.

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