I_LocationAnalyticsText

DDL: I_LOCATIONANALYTICSTEXT Type: view COMPOSITE

Location - Text

I_LocationAnalyticsText is a Composite CDS View that provides data about "Location - Text" in SAP S/4HANA. It reads from 1 data source (I_LocationText) and exposes 6 fields with key fields Location, Language. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_LocationText I_LocationText from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_LocationAnalytics _Location $projection.LocationUUID = _Location.LocationUUID and $projection.Location = _Location.Location

Annotations (17)

NameValueLevelField
EndUserText.label Location - Text view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.sqlViewName ILOCANATEXT 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
ObjectModel.dataCategory #TEXT view
VDM.viewType #COMPOSITE view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Location _Location Location
KEY Language Language
LocationDescription LocationDescription
LocationUUID LocationUUID
_Language _Language
_Location _Location 
@EndUserText.label:                              'Location - Text'

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

@Metadata:          {ignorePropagatedAnnotations: true}

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

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

@VDM:               {viewType:                    #COMPOSITE}

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

define view I_LocationAnalyticsText
  as select from I_LocationText
  association [0..1] to I_Language          as _Language on $projection.Language = _Language.Language
  association [1..1] to I_LocationAnalytics as _Location on $projection.LocationUUID = _Location.LocationUUID
                                                        and $projection.Location     = _Location.Location
{
  key _Location.Location as Location,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key Language,
      @Semantics.text: true
      LocationDescription,
      LocationUUID,

      /* Associations */
      _Language,
      _Location
}

Learn More