I_EXPLICITASSTMTMODULEVERSION

CDS View
8 Fields 8 CDS Views

Assortment Module Version

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

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_AssortmentDetail view_entity inner COMPOSITE Assortment Listing
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 (8)

KeyField CDS FieldsUsed in Views
KEY AssortmentModuleUUID AssortmentModuleGroupUUID,AssortmentModuleUUID 3
KEY AssortmentModuleVersionUUID AssortmentModuleVersionUUID 1
AssortmentModuleName AssortmentModuleName 1
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUserName LastChangedByUserName 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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,
    ASSORTMENTMODULEVERSIONUUID,
    ASSORTMENTMODULENAME,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSERNAME,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (ASSORTMENTMODULEUUID, ASSORTMENTMODULEVERSIONUUID)
);

Learn More