I_LISTINGDETAIL

CDS View
26 Fields 3 CDS Views

Product Listing Detail

I_LISTINGDETAIL is a CDS View in S/4HANA. Product Listing Detail. It contains 26 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_AssortmentDetailUnion view_entity inner COMPOSITE Assortment Listing
I_ListingDetailUnion view_entity from COMPOSITE Product Listing Union
I_VersionDetailUnion view_entity inner COMPOSITE Product Listing with Version

Fields (26)

KeyField CDS FieldsUsed in Views
KEY ListingConditionEndDate ListingConditionEndDate 3
KEY ListingSource ListingSource 3
KEY Product Product 2
KEY SalesUnit SalesUnit 3
KEY SequenceNumber SequenceNumber 3
KEY Site Site 3
AllocationTable AllocationTable 3
AllocationTableDescription AllocationTableDescription 3
CityName CityName 3
CountryName CountryName 2
DistributionChannel DistributionChannel 1
IsListedAsComponent IsListedAsComponent 3
ListingConditionStartDate ListingConditionStartDate 3
MerchandiseCategory MerchandiseCategory 3
MerchandiseCategoryText MerchandiseCategoryText 3
ProductName ProductName 3
ProductStandardID ProductStandardID 3
Region Region 3
RegionName RegionName 3
RetailPromotion RetailPromotion 3
SalesOrganization SalesOrganization 1
SalesOrganizationName SalesOrganizationName 3
SiteCategory SiteCategory 3
SiteCategoryName SiteCategoryName 3
SiteName SiteName 3
StructuredArticle StructuredArticle 3

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.

-- Product Listing Detail
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LISTINGDETAIL (
    LISTINGCONDITIONENDDATE,
    LISTINGSOURCE,
    PRODUCT,
    SALESUNIT,
    SEQUENCENUMBER,
    SITE,
    ALLOCATIONTABLE,
    ALLOCATIONTABLEDESCRIPTION,
    CITYNAME,
    COUNTRYNAME,
    DISTRIBUTIONCHANNEL,
    ISLISTEDASCOMPONENT,
    LISTINGCONDITIONSTARTDATE,
    MERCHANDISECATEGORY,
    MERCHANDISECATEGORYTEXT,
    PRODUCTNAME,
    PRODUCTSTANDARDID,
    REGION,
    REGIONNAME,
    RETAILPROMOTION,
    SALESORGANIZATION,
    SALESORGANIZATIONNAME,
    SITECATEGORY,
    SITECATEGORYNAME,
    SITENAME,
    STRUCTUREDARTICLE,
    PRIMARY KEY (LISTINGCONDITIONENDDATE, LISTINGSOURCE, PRODUCT, SALESUNIT, SEQUENCENUMBER, SITE)
);

Learn More