I_EXPLICITASSORTMENTMODULE

CDS View
8 Fields 11 CDS Views

Assortment Module

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

CDS Views using this table (11)

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_entity 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
I_VersionDetail view_entity inner COMPOSITE Version Listing

Fields (8)

KeyField CDS FieldsUsed in Views
KEY AssortmentModuleName AssortmentModuleName 3
KEY AssortmentModuleUUID AssortmentModuleUUID 7
_MaxVersionValidityEnd _MaxVersionValidityEnd 1
_NrOfAssortmentUsers _NrOfAssortmentUsers 1
_NrOfFutureVersions _NrOfFutureVersions 1
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,
    _MAXVERSIONVALIDITYEND,
    _NROFASSORTMENTUSERS,
    _NROFFUTUREVERSIONS,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSERNAME,
    PRIMARY KEY (ASSORTMENTMODULENAME, ASSORTMENTMODULEUUID)
);

Learn More