R_ListingConditionTP

DDL: R_LISTINGCONDITIONTP Type: view_entity TRANSACTIONAL
14 Fields 1 Data Sources

Listing condition read only

R_ListingConditionTP is a Transactional CDS View that provides data about "Listing condition read only" in SAP S/4HANA. It reads from 1 data source (I_ListingCondition) and exposes 14 fields with key fields Assortment, Product, ListingConditionEndDate, SequenceNumber.

Data Sources (1)

SourceAliasJoin Type
I_ListingCondition Listing from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Listing condition read only view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name ListingCondition view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Assortment I_ListingCondition Assortment Assortment
KEY Product
KEY ListingConditionEndDate I_ListingCondition ListingConditionEndDate Validity period
KEY SequenceNumber I_ListingCondition SequenceNumber Sort sequence
ListingConditionStartDate I_ListingCondition ListingConditionStartDate Validity period
LastChangeDate I_ListingCondition LastChangeDate Time Stamp
IsExcludingListingCondition I_ListingCondition IsExcludingListingCondition Negative Stock
ListingSource I_ListingCondition ListingSource Listing Source
IsListedAsComponent I_ListingCondition IsListedAsComponent List as compon.
ProductOfSuprordLstgCondition I_ListingCondition ProductOfSuprordLstgCondition Structured matl
AssortmentStatus I_ListingCondition AssortmentStatus RunIDs Sub Status
_AssortmentVH I_ListingCondition _Assortment
_ProductVH I_ListingCondition _Product
_ListingSourceVH I_ListingCondition _ListingSource

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_ListingConditionTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_ListingConditionTP AS
SELECT
  Listing.Assortment AS Assortment,
  cast (Listing.Product as productnumber preserving type ) AS Product,
  Listing.ListingConditionEndDate AS ListingConditionEndDate,
  Listing.SequenceNumber AS SequenceNumber,
  Listing.ListingConditionStartDate AS ListingConditionStartDate,
  Listing.LastChangeDate AS LastChangeDate,
  Listing.IsExcludingListingCondition AS IsExcludingListingCondition,
  Listing.ListingSource AS ListingSource,
  Listing.IsListedAsComponent AS IsListedAsComponent,
  Listing.ProductOfSuprordLstgCondition AS ProductOfSuprordLstgCondition,
  Listing.AssortmentStatus AS AssortmentStatus,
  Listing._Assortment AS _AssortmentVH,
  Listing._Product AS _ProductVH,
  Listing._ListingSource AS _ListingSourceVH
FROM I_ListingCondition AS Listing
;

Learn More