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
C_ListingCondition_2 view_entity from CONSUMPTION Retail Listing Condition
I_AllocationTableNumber view_entity from COMPOSITE AllocTableNo for Listing by Allocation
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 2
KEY ListingConditionEndDate ListingConditionEndDate 2
KEY ListingSource ListingSource 3
KEY Product Product 2
KEY SalesUnit SalesUnit 1
KEY SequenceNumber SequenceNumber 3
_Assortment _AssortmentVH 1
_ListingSource _ListingSourceVH 1
_Product _ProductVH 1
AssortmentStatus AssortmentStatus 1
IsExcludingListingCondition IsExcludingListingCondition 1
IsListedAsComponent IsListedAsComponent 2
LastChangeDate LastChangeDate 1
ListingConditionStartDate ListingConditionStartDate 2
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