C_MSPRStore

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 C_MSPRStore.
-- 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 C_MSPRStore AS
SELECT
  Site AS Store,
  SiteName AS StoreName,
  AddressID,
  cast('' as char200) AS FormattedAddress
FROM I_Site
LEFT OUTER JOIN I_RetailStoreUserAssignment AS _RetailStoreUserAssignment ON Store = _RetailStoreUserAssignment.Store AND _RetailStoreUserAssignment.AssignedUser = $session.user  -- association [0..1]
LEFT OUTER JOIN I_RetailStoreApplicationStore AS _RetailStoreApplicationStore ON Store = _RetailStoreApplicationStore.Store AND _RetailStoreApplicationStore.RetailStoreApplicationCategory = '2'  -- association [0..*]
LEFT OUTER JOIN C_MSPRMovement AS _Movement ON _Movement.Store = Store  -- association [0..*]
LEFT OUTER JOIN C_MSPRSettings AS _Settings ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN C_MSPRStorageLocation AS _StorageLocation ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_MSPRUserDefaultValues AS _UserDefaultValues ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN C_MSPRAssignedStore AS _AssignedStore ON /* condition not available in parsed metadata */  -- association [0..1]
;