I_LISTINGCONDITION

CDS View
16 Fields 4 CDS Views

Listing conditions

I_LISTINGCONDITION is a CDS View in S/4HANA. Listing conditions. It contains 16 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_AllocationTableNumber view_entity from COMPOSITE AllocTableNo for Listing by Allocation
I_ListingConditionTP view_entity from TRANSACTIONAL Listing condition read only
I_ListingDetail view_entity from COMPOSITE Product Listing Detail
R_ListingConditionTP view_entity from TRANSACTIONAL Listing condition read only

Fields (16)

KeyField CDS FieldsUsed in Views
KEY Assortment Assortment 3
KEY ListingConditionEndDate ListingConditionEndDate 3
KEY ListingSource ListingSource 3
KEY Product Product 2
KEY SalesUnit SalesUnit 1
KEY SequenceNumber SequenceNumber 3
_Assortment _AssortmentVH 2
_ListingSource _ListingSourceVH 2
_Product _ProductVH 2
AssortmentStatus AssortmentStatus 2
IsExcludingListingCondition IsExcludingListingCondition 2
IsListedAsComponent IsListedAsComponent 3
LastChangeDate LastChangeDate 2
ListingConditionStartDate ListingConditionStartDate 3
ProductOfSuprordLstgCondition ProductOfSuprordLstgCondition,StructuredArticle 3
RetailPromotion RetailPromotion 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.

-- Listing conditions
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LISTINGCONDITION (
    ASSORTMENT,
    LISTINGCONDITIONENDDATE,
    LISTINGSOURCE,
    PRODUCT,
    SALESUNIT,
    SEQUENCENUMBER,
    _ASSORTMENT,
    _LISTINGSOURCE,
    _PRODUCT,
    ASSORTMENTSTATUS,
    ISEXCLUDINGLISTINGCONDITION,
    ISLISTEDASCOMPONENT,
    LASTCHANGEDATE,
    LISTINGCONDITIONSTARTDATE,
    PRODUCTOFSUPRORDLSTGCONDITION,
    RETAILPROMOTION,
    PRIMARY KEY (ASSORTMENT, LISTINGCONDITIONENDDATE, LISTINGSOURCE, PRODUCT, SALESUNIT, SEQUENCENUMBER)
);

Learn More