I_PRODUCTSTRUCTUREVARIANT_2

CDS View
12 Fields 5 CDS Views

Product Structure Variant

I_PRODUCTSTRUCTUREVARIANT_2 is a CDS View in S/4HANA. Product Structure Variant. It contains 12 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
A_ProductStructureVariant_2 view from COMPOSITE Read Variants
C_ProdStrucVariant view from CONSUMPTION Product Structure Variant List
C_ProductStructureVariantVH view from CONSUMPTION Value Help for Product Structure Variant
I_ProductStructureNodeVariant view left_outer COMPOSITE Product Structure Node Variant
I_ProductStructureVariantNode view from COMPOSITE Product Structure Variant Node

Fields (12)

KeyField CDS FieldsUsed in Views
KEY ProdStrucVariantChangeNumber ProdStrucVariantChangeNumber 3
KEY ProdStrucVariantChgStateIntID ProdStrucVariantChgStateIntID 2
KEY ProductStructureVariantName ProductStructureVariantName 3
KEY ProductStructureVariantUUID ProductStructureVariantUUID 2
AuthorizationGroup AuthorizationGroup 1
Material Material 3
MaterialAuthorizationGroup MaterialAuthorizationGroup 2
ProdStructureVariantParentUUID ProdStructureVariantParentUUID 1
ProdStrucVarChgNmbrDescription ProdStrucVarChgNmbrDescription 2
ProdStrucVariantUniqueID ProdStrucVariantUniqueID 1
ProductStructureGnrcObjType ProductStructureGnrcObjType 3
ProductStructureVariantType ProductStructureVariantType 3

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODUCTSTRUCTUREVARIANT_2 (
    PRODSTRUCVARIANTCHANGENUMBER,
    PRODSTRUCVARIANTCHGSTATEINTID,
    PRODUCTSTRUCTUREVARIANTNAME,
    PRODUCTSTRUCTUREVARIANTUUID,
    AUTHORIZATIONGROUP,
    MATERIAL,
    MATERIALAUTHORIZATIONGROUP,
    PRODSTRUCTUREVARIANTPARENTUUID,
    PRODSTRUCVARCHGNMBRDESCRIPTION,
    PRODSTRUCVARIANTUNIQUEID,
    PRODUCTSTRUCTUREGNRCOBJTYPE,
    PRODUCTSTRUCTUREVARIANTTYPE,
    PRIMARY KEY (PRODSTRUCVARIANTCHANGENUMBER, PRODSTRUCVARIANTCHGSTATEINTID, PRODUCTSTRUCTUREVARIANTNAME, PRODUCTSTRUCTUREVARIANTUUID)
);

Learn More