I_VersionDetailUnion

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_VersionDetailUnion.
-- 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_VersionDetailUnion 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,
  cast( bintohex ( _version.AssortmentModuleUUID ) as assort_uuid preserving type ) AS LstgAsstmtMdlUUID,
  cast( bintohex ( _version.AssortmentModuleVersionUUID ) as assort_ver_uuid preserving type ) AS LstgAsstmtMdlVersUUID,
  _assortment.AssortmentModuleName AS AssortmentModuleName,
  _assortment.SiteValidityStartDate AS SiteValidityStartDate,
  _assortment.SiteValidityEndDate AS SiteValidityEndDate,
  _assortment.SalesOrganization AS SalesOrganization,
  _assortment.DistributionChannel AS DistributionChannel,
  _version.AssortmentModuleVersionName AS AssortmentModuleVersionName,
  _version.ValidityStartDate AS VersionValidityStartDate,
  _version.ValidityEndDate AS VersionValidityEndDate,
  _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.CountryName AS CountryName,
  _listing.Region AS Region,
  _listing.RegionName AS RegionName,
  cast ( _listing.Country as rfm_asm_country preserving type ) AS Country,
  _listing.ProductStandardID AS ProductStandardID,
  _listing.RetailPromotion AS RetailPromotion,
  _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 _listing.ListingConditionEndDate < $session.system_date then 'X' else '' end as boolean preserving type ) AS ExpiredListingCondition
INNER JOIN I_AssortmentDetail AS _assortment ON /* join condition not captured in parsed metadata */
INNER JOIN I_ListingDetail AS _listing ON /* join condition not captured in parsed metadata */
;