CsnImportedComponents

DDL: CSNIMPORTEDCOMPONENTS Type: view_entity

CSN Importer: Imported Components

CsnImportedComponents is a CDS View that provides data about "CSN Importer: Imported Components" in SAP S/4HANA. It reads from 2 data sources (csn_imported_c, csn_imported) and exposes 9 fields with key fields CsnId, ComponentId.

Data Sources (2)

SourceAliasJoin Type
csn_imported_c c inner
csn_imported i from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CSN Importer: Imported Components view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CsnId csn_imported_c csn_id UUID
KEY ComponentId csn_imported_c component_id Pointer Itemiz.
ModelProvider csn_imported model_provider Model Provider
ModelVersion csn_imported model_version Model Version
CsnVersion csn_imported csn_version CSN Version
CsnImportFlavor csn_imported csn_import_flavor Flavor Value in CSN
ComponentType csn_imported_c component_type Rbl Comp Typ
ComponentName csn_imported_c component_name Material
ArrayIndex csn_imported_c array_index

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 CsnImportedComponents.
-- 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 CsnImportedComponents AS
SELECT
  c.csn_id AS CsnId,
  c.component_id AS ComponentId,
  i.model_provider AS ModelProvider,
  i.model_version AS ModelVersion,
  i.csn_version AS CsnVersion,
  i.csn_import_flavor AS CsnImportFlavor,
  c.component_type AS ComponentType,
  c.component_name AS ComponentName,
  c.array_index AS ArrayIndex
FROM csn_imported AS i
INNER JOIN csn_imported_c AS c ON /* join condition not captured in parsed metadata */
;