I_EXPLICITASSTMTMODULEVERSION

CDS View

Assortment Module Version

I_EXPLICITASSTMTMODULEVERSION is a CDS View in S/4HANA. Assortment Module Version. It contains 4 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_AsstmtMdlMaxVersValidityEnd view from COMPOSITE Valid-To Date of Last Assortment Module Version
I_CurrentlyValdAsstmtMdlVers view_entity from BASIC Currently Valid Asstmt Module Version
I_ExplctAsstmtMdlExclsnRatio view_entity from COMPOSITE
I_ExplicitAsstmtMdlVersionTP view_entity from TRANSACTIONAL Assortment Module Version
I_ProdToExplicitAsstmtModule view inner COMPOSITE Product Assignment to Assortment Module
P_NrOfFutrVersionsForAsstmtMdl view from COMPOSITE
P_NrOfProdsForActvASMVersion view from COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY AssortmentModuleUUID AssortmentModuleGroupUUID,AssortmentModuleUUID 3
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 Version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EXPLICITASSTMTMODULEVERSION (
    ASSORTMENTMODULEUUID,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSERNAME,
    PRIMARY KEY (ASSORTMENTMODULEUUID)
);