I_PRODSTRUCVARIANTBASIC

CDS View
10 Fields 3 CDS Views

Product Structure Variant Basic

I_PRODSTRUCVARIANTBASIC is a CDS View in S/4HANA. Product Structure Variant Basic. It contains 10 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ProductStructureVariant view from COMPOSITE Product Structure Variant
I_ProductStructureVariant_2 view from COMPOSITE Product Structure Variant
I_ProductStructureVariantVH view from BASIC Product Structure Variant Value Help

Fields (10)

KeyField CDS FieldsUsed in Views
KEY ProductStructureVariantUUID ProductStructureVariantUUID 2
ProdStructureVariantParentUUID ProdStructureVariantParentUUID 1
ProdStrucVariantUniqueID ProdStrucVariantUniqueID 3
ProductStrucLastChangedByUser ProductStrucLastChangedByUser 1
ProductStrucLastChangedDate ProductStrucLastChangedDate 1
ProductStructureCreatedByUser ProductStructureCreatedByUser 1
ProductStructureCreationDate ProductStructureCreationDate 1
ProductStructureGnrcObjType ProductStructureGnrcObjType 1
ProductStructureVariantName ProductStructureVariantName 1
ProductStructureVariantType ProductStructureVariantType 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.

-- Product Structure Variant Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODSTRUCVARIANTBASIC (
    PRODUCTSTRUCTUREVARIANTUUID,
    PRODSTRUCTUREVARIANTPARENTUUID,
    PRODSTRUCVARIANTUNIQUEID,
    PRODUCTSTRUCLASTCHANGEDBYUSER,
    PRODUCTSTRUCLASTCHANGEDDATE,
    PRODUCTSTRUCTURECREATEDBYUSER,
    PRODUCTSTRUCTURECREATIONDATE,
    PRODUCTSTRUCTUREGNRCOBJTYPE,
    PRODUCTSTRUCTUREVARIANTNAME,
    PRODUCTSTRUCTUREVARIANTTYPE,
    PRIMARY KEY (PRODUCTSTRUCTUREVARIANTUUID)
);

Learn More