I_USERTOEXPLICITASSTMTMODULE_2

CDS View
12 Fields 1 CDS Views

Assortment User Assignment to Assortment Module

I_USERTOEXPLICITASSTMTMODULE_2 is a CDS View in S/4HANA. Assortment User Assignment to Assortment Module. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AssMdlUserToExplctAssMdlTP_2 view_entity from TRANSACTIONAL Asstmt User Assignment to Asstmt Module

Fields (12)

KeyField CDS FieldsUsed in Views
KEY AssortmentModuleUser AssortmentModuleUser 1
KEY AssortmentModuleUUID AssortmentModuleUUID 1
KEY ValidityStartDate ValidityStartDate 1
_ExclusionRatio _ExclusionRatio 1
_Site _Site 1
AssortmentModuleName AssortmentModuleName 1
DistributionChannel DistributionChannel 1
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUserName LastChangedByUserName 1
SalesOrganization SalesOrganization 1
ValidityEndDate ValidityEndDate 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 User Assignment to Assortment Module
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_USERTOEXPLICITASSTMTMODULE_2 (
    ASSORTMENTMODULEUSER,
    ASSORTMENTMODULEUUID,
    VALIDITYSTARTDATE,
    _EXCLUSIONRATIO,
    _SITE,
    ASSORTMENTMODULENAME,
    DISTRIBUTIONCHANNEL,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSERNAME,
    SALESORGANIZATION,
    VALIDITYENDDATE,
    PRIMARY KEY (ASSORTMENTMODULEUSER, ASSORTMENTMODULEUUID, VALIDITYSTARTDATE)
);

Learn More