I_ListingDetailUnion

DDL: I_LISTINGDETAILUNION Type: view_entity COMPOSITE Package: RFM_ASSORTMENT_RAP_LSTG_OVW
31 Fields 1 Data Sources

Product Listing Union

I_ListingDetailUnion is a Composite CDS View that provides data about "Product Listing Union" in SAP S/4HANA. It reads from 1 data source (I_ListingDetail) and exposes 31 fields with key fields Product, Site, SalesUnit, ListingConditionEndDate, ListingSource. Part of development package RFM_ASSORTMENT_RAP_LSTG_OVW.

Data Sources (1)

SourceAliasJoin Type
I_ListingDetail _listing from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Product Listing Union view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY Product I_ListingDetail Product Product Sold
KEY Site I_ListingDetail Site Plant
KEY SalesUnit I_ListingDetail SalesUnit Unit
KEY ListingConditionEndDate I_ListingDetail ListingConditionEndDate
KEY ListingSource I_ListingDetail ListingSource
KEY SequenceNumber I_ListingDetail SequenceNumber Sort sequence
ProductName I_ListingDetail ProductName Description
ListingConditionStartDate I_ListingDetail ListingConditionStartDate
StructuredArticle I_ListingDetail StructuredArticle
IsListedAsComponent I_ListingDetail IsListedAsComponent
MerchandiseCategory I_ListingDetail MerchandiseCategory
MerchandiseCategoryText I_ListingDetail MerchandiseCategoryText
SiteName I_ListingDetail SiteName
CityName I_ListingDetail CityName Name
RegionName I_ListingDetail RegionName Description
Region I_ListingDetail Region Venue Region
SalesOrganization I_ListingDetail SalesOrganization Sales Organization
DistributionChannel I_ListingDetail DistributionChannel RefDistCh-Cust/Mat.
RetailPromotion I_ListingDetail RetailPromotion Promotion
Country
CountryName CountryName Country
ProductStandardID I_ListingDetail ProductStandardID GTIN
AllocationTable I_ListingDetail AllocationTable Alloc. Table
AllocationTableDescription I_ListingDetail AllocationTableDescription
SalesOrganizationName I_ListingDetail SalesOrganizationName Sales Organization Description
SiteCategory I_ListingDetail SiteCategory
SiteCategoryName I_ListingDetail SiteCategoryName
GlobalTradeItemNumber
ListingOriginText
ListingValidOnDate
ExpiredListingCondition

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 I_ListingDetailUnion.
-- 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 I_ListingDetailUnion AS
SELECT
  _listing.Product AS Product,
  _listing.Site AS Site,
  _listing.SalesUnit AS SalesUnit,
  _listing.ListingConditionEndDate AS ListingConditionEndDate,
  _listing.ListingSource AS ListingSource,
  _listing.SequenceNumber AS SequenceNumber,
  _listing.ProductName AS ProductName,
  _listing.ListingConditionStartDate AS ListingConditionStartDate,
  _listing.StructuredArticle AS StructuredArticle,
  _listing.IsListedAsComponent AS IsListedAsComponent,
  _listing.MerchandiseCategory AS MerchandiseCategory,
  _listing.MerchandiseCategoryText AS MerchandiseCategoryText,
  _listing.SiteName AS SiteName,
  _listing.CityName AS CityName,
  _listing.RegionName AS RegionName,
  _listing.Region AS Region,
  _listing.SalesOrganization AS SalesOrganization,
  _listing.DistributionChannel AS DistributionChannel,
  _listing.RetailPromotion AS RetailPromotion,
  cast ( _listing.Country as rfm_asm_country preserving type ) AS Country,
  CountryName,
  _listing.ProductStandardID AS ProductStandardID,
  _listing.AllocationTable AS AllocationTable,
  _listing.AllocationTableDescription AS AllocationTableDescription,
  _listing.SalesOrganizationName AS SalesOrganizationName,
  _listing.SiteCategory AS SiteCategory,
  _listing.SiteCategoryName AS SiteCategoryName,
  cast( '' as ean11 ) AS GlobalTradeItemNumber,
  cast('' as abap.char(20)) AS ListingOriginText,
  cast('00000000' as psttr ) AS ListingValidOnDate,
  cast(case when ListingConditionEndDate < $session.system_date then 'X' else '' end as boolean ) AS ExpiredListingCondition
FROM I_ListingDetail AS _listing
;

Learn More