CsnImportedCompDependencies

DDL: CSNIMPORTEDCOMPDEPENDENCIES Type: view_entity
10 Fields 3 Data Sources

CSN Importer: Imported CSN Dependencies

CsnImportedCompDependencies is a CDS View that provides data about "CSN Importer: Imported CSN Dependencies" in SAP S/4HANA. It reads from 3 data sources (CsnImportedComponents, CsnImportedComponents, csn_imported_r) and exposes 10 fields with key fields ComponentId, RequiredComponentId.

Data Sources (3)

SourceAliasJoin Type
CsnImportedComponents c inner
CsnImportedComponents r inner
csn_imported_r relations from

Annotations (6)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ComponentId CsnImportedComponents ComponentId Pointer Itemiz.
KEY RequiredComponentId CsnImportedComponents ComponentId Pointer Itemiz.
ModelProvider CsnImportedComponents ModelProvider Model Provider
ModelVersion CsnImportedComponents ModelVersion Model Version
CsnVersion CsnImportedComponents CsnVersion CSN Version
CsnImportFlavor CsnImportedComponents CsnImportFlavor Flavor Value in CSN
ComponentType CsnImportedComponents ComponentType Rbl Comp Typ
ComponentName CsnImportedComponents ComponentName Material
RequiredComponentType CsnImportedComponents ComponentType Rbl Comp Typ
RequiredComponentName CsnImportedComponents ComponentName Material

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 CsnImportedCompDependencies.
-- 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 CsnImportedCompDependencies AS
SELECT
  c.ComponentId AS ComponentId,
  r.ComponentId AS RequiredComponentId,
  c.ModelProvider AS ModelProvider,
  c.ModelVersion AS ModelVersion,
  c.CsnVersion AS CsnVersion,
  c.CsnImportFlavor AS CsnImportFlavor,
  c.ComponentType AS ComponentType,
  c.ComponentName AS ComponentName,
  r.ComponentType AS RequiredComponentType,
  r.ComponentName AS RequiredComponentName
FROM csn_imported_r AS relations
INNER JOIN CsnImportedComponents AS c ON /* join condition not captured in parsed metadata */
INNER JOIN CsnImportedComponents AS r ON /* join condition not captured in parsed metadata */
;

Learn More