I_SecondaryGeogrlLocationT

DDL: I_SECONDARYGEOGRLLOCATIONT SQL: IPVSGEOGRLLOCTXT Type: view BASIC Package: OIU_VDM_CDS
7 Fields 1 Data Sources 2 Associations

Secondary Geographical Location Name - Text

I_SecondaryGeogrlLocationT (Basic)

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

Cross Applications

I_SecondaryGeogrlLocationT is a Basic CDS View that provides data about "Secondary Geographical Location Name - Text" in SAP S/4HANA. It reads from 1 data source (oiu_cm_lxsgl_tx) and exposes 7 fields with key fields Country, PrimaryGeogrlLocation, SecondaryGeogrlLocation, Language. It has 2 associations to related views. Part of development package OIU_VDM_CDS.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessCross Applications
Application ComponentIS-OIL-PRA
CapabilitiesData Source for Data Extraction,Language-Dependent Text,Data Source for Defining CDS Entities,Data Source in SQL Select,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
oiu_cm_lxsgl_tx oiu_cm_lxsgl_tx from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Country _Country $projection.Country = _Country.Country
[0..1] I_PrimaryGeogrlLocation _PrimaryGeogrlLocation $projection.Country = _PrimaryGeogrlLocation.Country and $projection.PrimaryGeogrlLocation = _PrimaryGeogrlLocation.PrimaryGeogrlLocation

Annotations (13)

NameValueLevelField
EndUserText.label Secondary Geographical Location Name - Text view
ObjectModel.dataCategory #TEXT view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IPVSGEOGRLLOCTXT view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey SecondaryGeogrlLocation view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Country Country/Region Key
KEY PrimaryGeogrlLocation pri_geo_loc Primary Geographical Location
KEY SecondaryGeogrlLocation sec_geo_loc Secondary geographic location
KEY Language spras Off. Language
SecondaryGeogrlLocationName sec_geo_desc Secondary Geographical Location Description
_Country _Country
_PrimaryGeogrlLocation _PrimaryGeogrlLocation

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_SecondaryGeogrlLocationT.
-- 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: IPVSGEOGRLLOCTXT

CREATE VIEW I_SecondaryGeogrlLocationT AS
SELECT
  cast( land1 as land1_gp ) AS Country,
  pri_geo_loc AS PrimaryGeogrlLocation,
  sec_geo_loc AS SecondaryGeogrlLocation,
  spras AS Language,
  sec_geo_desc AS SecondaryGeogrlLocationName
FROM oiu_cm_lxsgl_tx
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_PrimaryGeogrlLocation AS _PrimaryGeogrlLocation ON Country = _PrimaryGeogrlLocation.Country AND PrimaryGeogrlLocation = _PrimaryGeogrlLocation.PrimaryGeogrlLocation  -- association [0..1]
;

Learn More