I_ASSORTMENTDETAIL

CDS View
5 Fields 1 CDS Views

Assortment Listing

I_ASSORTMENTDETAIL is a CDS View in S/4HANA. Assortment Listing. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_VersionDetailUnion view_entity inner COMPOSITE Product Listing with Version

Fields (5)

KeyField CDS FieldsUsed in Views
AssortmentModuleName AssortmentModuleName 1
DistributionChannel DistributionChannel 1
SalesOrganization SalesOrganization 1
SiteValidityEndDate SiteValidityEndDate 1
SiteValidityStartDate SiteValidityStartDate 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 Listing
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ASSORTMENTDETAIL (
    ASSORTMENTMODULENAME,
    DISTRIBUTIONCHANNEL,
    SALESORGANIZATION,
    SITEVALIDITYENDDATE,
    SITEVALIDITYSTARTDATE
);

Learn More