I_TrsyFinStsCountryGeoPoint

DDL: I_TRSYFINSTSCOUNTRYGEOPOINT Type: view_entity BASIC
4 Fields 1 Data Sources 2 Associations

Geographical Center of a Country/Region

I_TrsyFinStsCountryGeoPoint (Basic)

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

Financial Operations

I_TrsyFinStsCountryGeoPoint is a Basic CDS View (Dimension) that provides data about "Geographical Center of a Country/Region" in SAP S/4HANA. It reads from 1 data source (ftrl_fs_geot005) and exposes 4 fields with key field Country. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Configuration Data
Data CategoryDimension
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business questions: Where is the geographical center of a country/region?

Structure
Main CDS parameters and filters The main CDS parameters are: Country/Region Measures and attributes Country/Region Two-character country/region key Central geo point of a country/region (hexadecimal representation) The central geo point of a country/region is the geographical center of a country/region. The geo point is not represented by latitude and longitude, but in its hexadecimal representation.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM
CapabilitiesAnalytical Dimension, Data Source for Defining CDS Entities, Data Source in SQL Select, Association Target for Defining CDS Entities
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 geographical center of a country/region?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
ftrl_fs_geot005 ftrl_fs_geot005 from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Country _Country $projection.Country = _Country.Country
[0..*] I_CountryText _Text $projection.Country = _Text.Country

Annotations (16)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.internalName #LOCAL view
Analytics.dataCategory #DIMENSION view
Analytics.technicalName ICOUNTGEOPOINT view
Analytics.dataExtraction.enabled false view
EndUserText.label Geographical Center of a Country/Region view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey Country view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.compositionRoot true view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #BASIC view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Country country Country/Region Key
CountryCenterGeoPoint geo_location GEOM_EWKB
_Text _Text
_Country _Country

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_TrsyFinStsCountryGeoPoint.
-- 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 I_TrsyFinStsCountryGeoPoint AS
SELECT
  Country,
  geo_location AS CountryCenterGeoPoint
FROM ftrl_fs_geot005
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [1..1]
LEFT OUTER JOIN I_CountryText AS _Text ON Country = _Text.Country  -- association [0..*]
;

Learn More