I_Site

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_Site.
-- 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_Site AS
SELECT
  Plant AS Site,
  cast(PlantName as sitename preserving type) AS SiteName,
  PlantCustomer AS SiteCustomer,
  PlantSupplier AS SiteSupplier,
  AddressID,
  cast(PlantCategory as sitecategory preserving type) AS SiteCategory,
  cast(SalesOrganization as w_vkorg_header preserving type) AS SalesOrganization,
  cast(DistributionChannel as w_vtweg_header preserving type) AS DistributionChannel,
  cast(DefaultPurchasingOrganization as ekorg_ll preserving type) AS DefaultPurchasingOrganization,
  FactoryCalendar,
  ValuationArea,
  IsMarkedForArchiving,
  Division
FROM I_Plant
LEFT OUTER JOIN I_SiteOpeningHours AS _SiteOpeningHours ON SiteCustomer = _SiteOpeningHours.SiteCustomer  -- association [0..1]
LEFT OUTER JOIN I_SitePointOfSale AS _SitePointOfSale ON SiteCustomer = _SitePointOfSale.SiteCustomer  -- association [0..1]
LEFT OUTER JOIN I_SiteBlocking AS _SiteBlocking ON SiteCustomer = _SiteBlocking.SiteCustomer  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [1..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _DefaultPurchasingOrganization ON DefaultPurchasingOrganization = _DefaultPurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_AddressEmailAddress AS _AddressEmailAddress ON AddressID = _AddressEmailAddress.AddressID AND _AddressEmailAddress.Person = ' ' AND _AddressEmailAddress.IsDefaultEmailAddress = 'X'  -- association [0..1]
LEFT OUTER JOIN I_SiteProductGroup AS _SiteProductGroup ON SiteCustomer = _SiteProductGroup.SiteCustomer  -- association [0..*]
LEFT OUTER JOIN I_SiteSupplyingSite AS _SiteSupplyingSite ON SiteCustomer = _SiteSupplyingSite.SiteCustomer  -- association [0..*]
LEFT OUTER JOIN I_AssortmentUser AS _AssortmentUser ON SiteCustomer = _AssortmentUser.SiteCustomer  -- association [0..*]
LEFT OUTER JOIN I_SiteReferenceSite AS _SiteReferenceSite ON Site = _SiteReferenceSite.Site  -- association [1..1]
LEFT OUTER JOIN I_SiteCategory AS _SiteCategory ON SiteCategory = _SiteCategory.SiteCategory  -- association [1..1]
LEFT OUTER JOIN I_SiteMasterAdministrativeData AS _SiteMasterAdminFields ON SiteCustomer = _SiteMasterAdminFields.SiteCustomer  -- association [0..1]
LEFT OUTER JOIN I_SiteValnAndInvtryManagement AS _SiteInventory ON SiteCustomer = _SiteInventory.SiteCustomer  -- association [0..1]
;