Csn_Orphaned_Components

DDL: CSN_ORPHANED_COMPONENTS Type: view_entity
5 Fields 2 Data Sources

CSN OM: Orphaned Components

Csn_Orphaned_Components is a CDS View that provides data about "CSN OM: Orphaned Components" in SAP S/4HANA. It reads from 2 data sources (csn_components, csn_relations) and exposes 5 fields with key field Id.

Data Sources (2)

SourceAliasJoin Type
csn_components c from
csn_relations r left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label CSN OM: Orphaned Components view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Id csn_components id WorklistID
ModelProviderId csn_components model_provider_id Model Provider
ModelVersionId csn_components model_version_id CSN Model Version ID
CsnVersion csn_components csn_version CSN Version
Name csn_components name Zone name

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 Csn_Orphaned_Components.
-- 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 Csn_Orphaned_Components AS
SELECT
  c.id AS Id,
  c.model_provider_id AS ModelProviderId,
  c.model_version_id AS ModelVersionId,
  c.csn_version AS CsnVersion,
  c.name AS Name
FROM csn_components AS c
LEFT OUTER JOIN csn_relations AS r ON /* join condition not captured in parsed metadata */
;

Learn More