I_PRODUCTSTRUCTURENODEVARIANT

CDS View

Product Structure Node Variant

I_PRODUCTSTRUCTURENODEVARIANT is a CDS View in S/4HANA. Product Structure Node Variant. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_PlanningScopeHeader view left_outer COMPOSITE
P_PlanningScopeHeader view union_all COMPOSITE

Fields (8)

KeyField CDS FieldsUsed in Views
KEY Material SourceMaterial 1
Class Class 1
ClassType ClassType 1
Plant SourcePlant 1
ProductStructureNodeName ProductStructureNodeName 1
ProductStructureNodeType ProductStructureNodeType 1
ProductStructureNodeUUID ProductStructureNodeUUID 1
ProductStructureUsage ProductStructureUsage 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 Node Variant
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODUCTSTRUCTURENODEVARIANT (
    MATERIAL,
    CLASS,
    CLASSTYPE,
    PLANT,
    PRODUCTSTRUCTURENODENAME,
    PRODUCTSTRUCTURENODETYPE,
    PRODUCTSTRUCTURENODEUUID,
    PRODUCTSTRUCTUREUSAGE,
    PRIMARY KEY (MATERIAL)
);