C_GHOSecdryGeoLocVH

DDL: C_GHOSECDRYGEOLOCVH SQL: CGHOSECGEOGLOCVH Type: view CONSUMPTION

Secondary Geo Location

C_GHOSecdryGeoLocVH is a Consumption CDS View that provides data about "Secondary Geo Location" in SAP S/4HANA. It reads from 1 data source (I_GHOSecdryGeoLocVH) and exposes 4 fields with key fields Country, Region, SecondaryGeogrlLocation. It is exposed through 2 OData services (UI_GHO_PRODNALLOCATIONRUNLIST, UI_GHOPRIORPERIODNOTIFICATION).

Data Sources (1)

SourceAliasJoin Type
I_GHOSecdryGeoLocVH I_GHOSecdryGeoLocVH from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CGHOSECGEOGLOCVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Secondary Geo Location view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view

OData Services (2)

ServiceBindingVersionContractRelease
UI_GHO_PRODNALLOCATIONRUNLIST UI_GHO_PRODNALLOCRUN_O2 V2 C1 NOT_RELEASED
UI_GHOPRIORPERIODNOTIFICATION UI_GHOPRIORPERIODNOTIF_O2 V2 C1 NOT_RELEASED

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Country Country Venue: Ctry/Reg
KEY Region Region Venue Region
KEY SecondaryGeogrlLocation SecondaryGeogrlLocation
SecondaryGeogrlLocationName SecondaryGeogrlLocationName

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 C_GHOSecdryGeoLocVH.
-- 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: CGHOSECGEOGLOCVH

CREATE VIEW C_GHOSecdryGeoLocVH AS
SELECT
  Country,
  Region,
  SecondaryGeogrlLocation,
  SecondaryGeogrlLocationName
FROM I_GHOSecdryGeoLocVH
;