I_LISTINGCONDITION

CDS View

Listing conditions

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ListingConditionTP view_entity from TRANSACTIONAL Listing condition read only
R_ListingConditionTP view_entity from TRANSACTIONAL Listing condition read only

Fields (13)

KeyField CDS FieldsUsed in Views
KEY Assortment Assortment 2
KEY ListingConditionEndDate ListingConditionEndDate 2
KEY SequenceNumber SequenceNumber 2
_Assortment _AssortmentVH 2
_ListingSource _ListingSourceVH 2
_Product _ProductVH 2
AssortmentStatus AssortmentStatus 2
IsExcludingListingCondition IsExcludingListingCondition 2
IsListedAsComponent IsListedAsComponent 2
LastChangeDate LastChangeDate 2
ListingConditionStartDate ListingConditionStartDate 2
ListingSource ListingSource 2
ProductOfSuprordLstgCondition ProductOfSuprordLstgCondition 2

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,
    SEQUENCENUMBER,
    _ASSORTMENT,
    _LISTINGSOURCE,
    _PRODUCT,
    ASSORTMENTSTATUS,
    ISEXCLUDINGLISTINGCONDITION,
    ISLISTEDASCOMPONENT,
    LASTCHANGEDATE,
    LISTINGCONDITIONSTARTDATE,
    LISTINGSOURCE,
    PRODUCTOFSUPRORDLSTGCONDITION,
    PRIMARY KEY (ASSORTMENT, LISTINGCONDITIONENDDATE, SEQUENCENUMBER)
);