I_SecurityExchange

DDL: I_SECURITYEXCHANGE SQL: ISECEXCHANGE Type: view BASIC
4 Fields 1 Data Sources

Security Exchange

I_SecurityExchange (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Securities Exchange · Financial Operations

I_SecurityExchange is a Basic CDS View (Dimension) that provides data about "Security Exchange" in SAP S/4HANA. It reads from 1 data source (twh01) and exposes 4 fields with key field SecurityExchange.

SAP Help Documentation

CategoryCDS Views for Configuration Data
Data CategoryDimension
StatusReleased
Data Extraction TypeFull (physical deletions are possible in source tables) The data extracted relates to system settings that can be changed only when the product version or release is changed.
Corresponding DataSourceISECEXCHANGE
Purpose
This CDS view provides the prerequisites for answering the following business questions: Where is the security class exchanged and what is the name of the exchange? What is the currency and country of the security exchange?

Structure
Main CDS parameters and filters The main filters are: Security Exchange Currency Country Measures and attributes Some important measures and attributes are: Security Exchange Currency Country

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM
CapabilitiesAnalytical Dimension, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source for Data Extraction
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Where is the security class exchanged and what is the name of the exchange?</p></li> <li><p>What is the currency and country of the security exchange?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
twh01 Exchange from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ISECEXCHANGE view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey SecurityExchange view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Security Exchange view
ObjectModel.sapObjectNodeType.name SecuritiesExchange view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SecurityExchange Security exchange
Currency twh01 waers Transaction Currency
CountryISOCode twh01 land1 Country/Region Key
SecurityExchangeShortName Security exchange description

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 I_SecurityExchange.
-- 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: ISECEXCHANGE

CREATE VIEW I_SecurityExchange AS
SELECT
  cast(Exchange.rhandpl as ftr_sec_exchange preserving type ) AS SecurityExchange,
  Exchange.waers AS Currency,
  Exchange.land1 AS CountryISOCode,
  cast(Exchange.xkurzbez as ftr_sec_exchange_desc) AS SecurityExchangeShortName
FROM twh01 AS Exchange
;

Learn More