C_CSN_EntitiesInServices

DDL: C_CSN_ENTITIESINSERVICES Type: view_entity
4 Fields 1 Data Sources 2 Associations

CSN Entity to Service relation

C_CSN_EntitiesInServices is a CDS View that provides data about "CSN Entity to Service relation" in SAP S/4HANA. It reads from 1 data source (I_CSN_EntitiesInServices) and exposes 4 fields with key fields EntityName, ServiceName. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CSN_EntitiesInServices I_CSN_EntitiesInServices from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_CSN_Services _Service _Service.ServiceName = $projection.ServiceName
[1..1] C_CSN_Entities_CE _Entity _Entity.EntityName = $projection.EntityName

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CSN Entity to Service relation view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY EntityName ExposedEntityNameRaw Entity Name
KEY ServiceName ServiceNameInCsnExposure Service Name
_Service _Service
_Entity _Entity

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_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 C_CSN_EntitiesInServices AS
SELECT
  ExposedEntityNameRaw AS EntityName,
  ServiceNameInCsnExposure AS ServiceName
FROM I_CSN_EntitiesInServices
LEFT OUTER JOIN C_CSN_Services AS _Service ON _Service.ServiceName = ServiceName  -- association [1..1]
LEFT OUTER JOIN C_CSN_Entities_CE AS _Entity ON _Entity.EntityName = EntityName  -- association [1..1]
;

Learn More