C_CSPRStore

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_CSPRStore.
-- 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.
-- SQL view name: CCSPRSTORE

CREATE VIEW C_CSPRStore 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_CSPRSettings AS _Settings ON Store = _Settings.Store  -- association [0..1]
LEFT OUTER JOIN C_CSPRStorageLocation AS _StorageLocation ON Store = _StorageLocation.Store  -- association [0..*]
LEFT OUTER JOIN C_CSPRCountSubmitAuthorization AS _RFIDCountSubmitAuthorization ON Store = _RFIDCountSubmitAuthorization.Store  -- association [0..1]
LEFT OUTER JOIN C_CSPRCountForceSubmitAuthzn AS _RFIDCountForceSubmitAuthzn ON Store = _RFIDCountForceSubmitAuthzn.Store  -- association [0..1]
LEFT OUTER JOIN C_CSPRCountDeleteAuthorization AS _RFIDCountDeleteAuthorization ON Store = _RFIDCountDeleteAuthorization.Store  -- association [0..1]
;