I_EXPLICITASSORTMENTMODULE

CDS View
5 Fields 10 CDS Views

Assortment Module

I_EXPLICITASSORTMENTMODULE is a CDS View in S/4HANA. Assortment Module. It contains 5 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
I_AsstmtMdlUsrProdExclsnTP_2 view_entity inner TRANSACTIONAL Product Exclusion from Assortment Module for Assortment User
I_ExplctAssMdlUsrProdExclsnTP view_entity inner TRANSACTIONAL Product Exclusion from Assortment Module for Assortment User
I_ExplicitAssortmentModuleTP view_entity from TRANSACTIONAL Assortment Module
I_ExplicitAssortmentModuleTTP view_entity inner TRANSACTIONAL Assortment Module - Text
I_ExplicitAssortmentModuleVH view from COMPOSITE Assortment Module
I_NrOfAsstmtUsersForAsstmtMdl view from COMPOSITE Number of Currently Valid Assortment Users in Asstmt Module
I_NrOfFutrVersionsForAsstmtMdl view from COMPOSITE Number of Planned Assortment Module Versions
I_ProdToExplicitAsstmtModule view from COMPOSITE Product Assignment to Assortment Module
I_UserToExplicitAsstmtModule view inner COMPOSITE Assortment User Assignment to Assortment Module
I_UserToExplicitAsstmtModule_2 view inner COMPOSITE Assortment User Assignment to Assortment Module

Fields (5)

KeyField CDS FieldsUsed in Views
KEY AssortmentModuleName AssortmentModuleName 1
KEY AssortmentModuleUUID AssortmentModuleUUID 6
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUserName LastChangedByUserName 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.

-- Assortment Module
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EXPLICITASSORTMENTMODULE (
    ASSORTMENTMODULENAME,
    ASSORTMENTMODULEUUID,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSERNAME,
    PRIMARY KEY (ASSORTMENTMODULENAME, ASSORTMENTMODULEUUID)
);

Learn More