R_SiteProdGrpSupplyingSiteTP

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_SiteProdGrpSupplyingSiteTP.
-- 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_SiteProdGrpSupplyingSiteTP AS
SELECT
  _Site.Site AS Site,
  SiteCustomer,
  ProductGroup,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS ProductGroupDraftUUID,
  SupplyingSite,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS SupplyingSiteDraftUUID,
  SupplyingSite AS SupplyingSiteForEdit,
  MerchandiseCategory,
  SupplyingSitePriority,
  ValidityEndDate AS ValidityEndDateForEdit,
  ValidityStartDate AS ValidityStartDateForEdit
FROM I_SiteSupplyingSite AS supplyingsite
LEFT OUTER JOIN R_SiteMasterTP AS _SiteMaster ON Site = _SiteMaster.Site  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _ProductGroup ON ProductGroup = _ProductGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_Site AS _SupplyingSite ON SupplyingSite = _SupplyingSite.Site  -- association [1..1]
LEFT OUTER JOIN I_Site AS _SupplyingSiteForEdit ON SupplyingSiteForEdit = _SupplyingSiteForEdit.Site  -- association [1..1]
LEFT OUTER JOIN E_RtlSteMrchdsCatSupplyingSite AS _Extension ON supplyingsite.SiteCustomer = _Extension.SiteCustomer AND supplyingsite.SupplyingSite = _Extension.SupplyingSite AND supplyingsite.ValidityStartDate = _Extension.ValidityStartDate AND supplyingsite.ValidityEndDate = _Extension.ValidityEndDate AND supplyingsite.ProductGroup = _Extension.ProductGroup  -- association [1]
;