aps_sec_csp_read_ts

DDL: APS_SEC_CSP_READ_TS Type: view_entity Package: SR_APS_SEC_PUB_ODATA_CSP_READ

Trusted Sites

aps_sec_csp_read_ts is a CDS View that provides data about "Trusted Sites" in SAP S/4HANA. It reads from 1 data source (http_trust_sites) and exposes 3 fields with key field ListName. It has 1 association to related views. It is exposed through 1 OData service (APS_SEC_API_CSP_READ). Part of development package SR_APS_SEC_PUB_ODATA_CSP_READ.

Data Sources (1)

SourceAliasJoin Type
http_trust_sites trusted_sites from

Associations (1)

CardinalityTargetAliasCondition
[0..*] aps_sec_csp_read_ts_cont TrustedContent trusted_sites.trusted_site_list = TrustedContent.ListName

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Trusted Sites view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
APS_SEC_API_CSP_READ APS_SEC_API_CSP_READ V4 C2 C1

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ListName http_trust_sites trusted_site_list Trusted Site List
TrustedContentCount
TrustedContent TrustedContent

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 aps_sec_csp_read_ts.
-- 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 aps_sec_csp_read_ts AS
SELECT
  trusted_sites.trusted_site_list AS ListName,
  cast(0 as abap.int4) AS TrustedContentCount,
  TrustedContent
FROM http_trust_sites AS trusted_sites
LEFT OUTER JOIN aps_sec_csp_read_ts_cont AS TrustedContent ON trusted_sites.trusted_site_list = TrustedContent.ListName  -- association [0..*]
;