CTE_CDS_SYSTEM

DDL: CTE_CDS_SYSTEM SQL: CTE_SYSTEM_CDS Type: view
3 Fields 1 Data Sources

CDS Help View for System Key

CTE_CDS_SYSTEM is a CDS View that provides data about "CDS Help View for System Key" in SAP S/4HANA. It reads from 1 data source (cte_c_connection) and exposes 3 fields.

Data Sources (1)

SourceAliasJoin Type
cte_c_connection cte_c_connection from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CTE_SYSTEM_CDS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS Help View for System Key view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (3)

KeyFieldSource TableSource FieldDescription
SYSTEM_KEY cte_c_connection system_key System Key
RFC_CONNECTION cte_c_connection rfc_connection Destination
RFCDOC1 LRFCDESDOCU SHORTTEXT Text

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 CTE_CDS_SYSTEM.
-- 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.
-- SQL view name: CTE_SYSTEM_CDS

CREATE VIEW CTE_CDS_SYSTEM AS
SELECT
  cte_c_connection.system_key AS SYSTEM_KEY,
  cte_c_connection.rfc_connection AS RFC_CONNECTION,
  LRFCDESDOCU.SHORTTEXT AS RFCDOC1
FROM cte_c_connection
;

Learn More