I_AddressGeoloc

DDL: I_ADDRESSGEOLOC Type: view_entity COMPOSITE Package: S_ADDRESS_RAP_BO

Geolocation for Organization and Person

I_AddressGeoloc is a Composite CDS View that provides data about "Geolocation for Organization and Person" in SAP S/4HANA. It reads from 2 data sources (I_AddressGeolocation, adcp) and exposes 7 fields with key field GeolocationID. Part of development package S_ADDRESS_RAP_BO.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_AddressGeolocation a from
adcp p left_outer

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Geolocation for Organization and Person view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY GeolocationID I_AddressGeolocation GeolocationID
AddressID I_AddressGeolocation AddressID
AddressPersonID
Latitude I_AddressGeolocation Latitude
Longitude I_AddressGeolocation Longitude
Altitude I_AddressGeolocation Altitude
AddressGeoPoint I_AddressGeolocation AddressGeoPoint 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Geolocation for Organization and Person'
@Metadata.allowExtensions: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@ObjectModel.semanticKey: [ 'GeolocationID' ]

define view entity I_AddressGeoloc
  as select from    I_AddressGeolocation as a
    left outer join adcp                 as p on  a.AddressID = p.addrnumber
                                              and p.comp_pers = 'P'
{
  key a.GeolocationID,
      a.AddressID                   as AddressID,
      coalesce( p.persnumber, ' ' ) as AddressPersonID,
      a.Latitude                    as Latitude,
      a.Longitude                   as Longitude,
      a.Altitude                    as Altitude,
      a.AddressGeoPoint             as AddressGeoPoint

}

Learn More