I_LocationAnalytics

DDL: I_LOCATIONANALYTICS Type: view COMPOSITE

Location

I_LocationAnalytics is a Composite CDS View (Dimension) that provides data about "Location" in SAP S/4HANA. It reads from 1 data source (I_LocationBasic) and exposes 18 fields with key field Location. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LocationBasic _Location from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_BusinessPartner _CollaborationPartner $projection.CollaborationPartner = _CollaborationPartner.BusinessPartner
[0..1] I_UnitOfMeasure _GeoCoordinatesUnit $projection.GeoCoordinatesUnit = _GeoCoordinatesUnit.UnitOfMeasure
[0..*] I_LocationAnalyticsText _Text $projection.Location = _Text.Location
[0..1] I_LocationType _LocationType $projection.LocationType = _LocationType.LocationType

Annotations (18)

NameValueLevelField
EndUserText.label Location view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.sqlViewName ILOCATIONANA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey Location view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Location Location
LocationUUID LocationUUID
LocationType LocationType
LocationAdditionalUUID LocationAdditionalUUID
AddressID AddressID
CollaborationPartner CollaborationPartner
BusinessPartnerUUID BusinessPartnerUUID
BusinessPartner
AuthorizationGroup I_LocationBasic AuthorizationGroup
IsBusinessPurposeCompleted I_LocationBasic IsBusinessPurposeCompleted
Latitude Latitude
Longitude Longitude
GeoCoordinatesUnit
_BusinessPartner _BusinessPartner
_CollaborationPartner _CollaborationPartner
_GeoCoordinatesUnit _GeoCoordinatesUnit
_LocationType _LocationType
_Text _Text
@EndUserText.label:                             'Location'

@AccessControl: {authorizationCheck:             #CHECK,
                 personalData.blocking:          #REQUIRED,
                 personalData.blockingIndicator: [ 'IsBusinessPurposeCompleted', '_BusinessPartner.IsBusinessPurposeCompleted', '_CollaborationPartner.IsBusinessPurposeCompleted' ]}

@ClientHandling.algorithm:                       #SESSION_VARIABLE

@Metadata:          {allowExtensions:             true,
                     ignorePropagatedAnnotations: true}

@AbapCatalog:       {sqlViewName:                 'ILOCATIONANA',
                     compiler.compareFilter:      true,
                     buffering:                   {status: #NOT_ALLOWED},
                     preserveKey:                 true}

@ObjectModel:       {representativeKey:           'Location',
                     semanticKey:                  [ 'Location' ],
                     usageType:                   {serviceQuality: #C,
                                                   sizeCategory:   #L,
                                                   dataClass:      #MASTER},
                     supportedCapabilities:        [ #ANALYTICAL_DIMENSION,
                                                     #CDS_MODELING_ASSOCIATION_TARGET,
                                                     #SQL_DATA_SOURCE,
                                                     #CDS_MODELING_DATA_SOURCE,
                                                     #EXTRACTION_DATA_SOURCE] }

@VDM:               {viewType:                    #COMPOSITE}

@Analytics:         {dataCategory:                #DIMENSION,
                     dataExtraction:              {enabled: true},
                     internalName:                #LOCAL}

define view I_LocationAnalytics
  as select from I_LocationBasic as _Location
  association [0..1] to I_BusinessPartner       as _BusinessPartner      on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [0..1] to I_BusinessPartner       as _CollaborationPartner on $projection.CollaborationPartner = _CollaborationPartner.BusinessPartner
  association [0..1] to I_UnitOfMeasure         as _GeoCoordinatesUnit   on $projection.GeoCoordinatesUnit = _GeoCoordinatesUnit.UnitOfMeasure
  association [0..*] to I_LocationAnalyticsText as _Text                 on $projection.Location = _Text.Location
  association [0..1] to I_LocationType          as _LocationType         on $projection.LocationType = _LocationType.LocationType

{
      @ObjectModel.text.association: '_Text'
  key Location,
      @Semantics.uuid:true
      LocationUUID,
      @ObjectModel.foreignKey.association: '_LocationType'
      LocationType,
      @Semantics.uuid:true
      LocationAdditionalUUID,
      AddressID,
      @ObjectModel.foreignKey.association: '_CollaborationPartner'
      CollaborationPartner,
      @Semantics.uuid:true
      BusinessPartnerUUID,
      @ObjectModel.foreignKey.association: '_BusinessPartner'
      _Location._BusinessPartner.BusinessPartner  as BusinessPartner,
      _Location.AuthorizationGroup                as AuthorizationGroup,
      @Semantics.booleanIndicator
      _Location.IsBusinessPurposeCompleted        as IsBusinessPurposeCompleted,

      @Semantics.geoLocation.latitude: true
      @Semantics.quantity.unitOfMeasure: 'GeoCoordinatesUnit'
      Latitude,
      @Semantics.geoLocation.longitude: true
      @Semantics.quantity.unitOfMeasure: 'GeoCoordinatesUnit'
      Longitude,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_GeoCoordinatesUnit'
      cast ( 'DEG' as /scmtms/vdm_geocoord_unit ) as GeoCoordinatesUnit, // /scmtms/vdm_geocoord_unit C1 released


      /* Associations */
      _BusinessPartner,
      _CollaborationPartner,
      _GeoCoordinatesUnit,
      _LocationType,
      _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOCATIONBASIC",
"I_TMBUSINESSPARTNERBYINTKEY"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_LOCATIONANALYTICSTEXT",
"I_LOCATIONTYPE",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/