I_CSN_EntitiesInServices

DDL: I_CSN_ENTITIESINSERVICES Type: view_entity Package: SDDIC_CSN_EXPORT_ODATA

CSN Exposure entities in services

I_CSN_EntitiesInServices is a CDS View that provides data about "CSN Exposure entities in services" in SAP S/4HANA. It reads from 3 data sources (I_CSN_Services, DDCDS_ENTITY_HEADER, srvd_rt_entities_direct) and exposes 10 fields with key fields ExposedEntityName, ServiceDefinitionName, ServiceBindingName, ServiceNameInCsnExposure. Part of development package SDDIC_CSN_EXPORT_ODATA.

Data Sources (3)

SourceAliasJoin Type
I_CSN_Services _csn_exposure_service from
DDCDS_ENTITY_HEADER _entity_header inner
srvd_rt_entities_direct _exposed_entities inner

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CSN Exposure entities in services view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ExposedEntityName srvd_rt_entities_direct ExposedArtifact Exposed Actifact Name
KEY ServiceDefinitionName I_CSN_Services ServiceDefinitionName
KEY ServiceBindingName I_CSN_Services ServiceBindingName
KEY ServiceNameInCsnExposure I_CSN_Services ServiceName
ExposedEntityNameRaw DDCDS_ENTITY_HEADER entity_name_raw
ExposedEntityAliasRaw srvd_rt_entities_direct ExposedAliasRaw Exposed Actifact Name, Case-Sesitive
ServiceVersion I_CSN_Services ServiceVersion
ServiceDescription I_CSN_Services ServiceDescription
BindingType I_CSN_Services BindingType
BindingTypeVersion I_CSN_Services BindingTypeVersion

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_CSN_EntitiesInServices.
-- 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_CSN_EntitiesInServices AS
SELECT
  _exposed_entities.ExposedArtifact AS ExposedEntityName,
  _csn_exposure_service.ServiceDefinitionName AS ServiceDefinitionName,
  _csn_exposure_service.ServiceBindingName AS ServiceBindingName,
  _csn_exposure_service.ServiceName AS ServiceNameInCsnExposure,
  _entity_header.entity_name_raw AS ExposedEntityNameRaw,
  _exposed_entities.ExposedAliasRaw AS ExposedEntityAliasRaw,
  _csn_exposure_service.ServiceVersion AS ServiceVersion,
  _csn_exposure_service.ServiceDescription AS ServiceDescription,
  _csn_exposure_service.BindingType AS BindingType,
  _csn_exposure_service.BindingTypeVersion AS BindingTypeVersion
FROM I_CSN_Services AS _csn_exposure_service
INNER JOIN srvd_rt_entities_direct AS _exposed_entities ON /* join condition not captured in parsed metadata */
INNER JOIN DDCDS_ENTITY_HEADER AS _entity_header ON /* join condition not captured in parsed metadata */
;