I_LocationValueHelp

DDL: I_LOCATIONVALUEHELP SQL: ILOCVH Type: view COMPOSITE

Location

I_LocationValueHelp 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 9 fields with key field LocationUUID.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_LocationBasic I_LocationBasic from

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName ILOCVH view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.representativeKey LocationUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #COMPOSITE view
Consumption.ranked true view
EndUserText.label Location view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY LocationUUID LocationUUID
Location Location
LocationDescription
CollaborationPartner CollaborationPartner
BusinessPartnerUUID BusinessPartnerUUID
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
AuthorizationGroup AuthorizationGroup
_CollaborationPartner _CollaborationPartner
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName:               'ILOCVH'
@Analytics.dataCategory:                #DIMENSION
@Analytics.internalName:                #LOCAL
@AbapCatalog.compiler.compareFilter:    true
@AbapCatalog.preserveKey:               true
@AccessControl: { authorizationCheck:             #MANDATORY,
                  personalData.blocking:          #REQUIRED,
                  personalData.blockingIndicator: [ 'IsBusinessPurposeCompleted', '_BusinessPartner.IsBusinessPurposeCompleted', '_CollaborationPartner.IsBusinessPurposeCompleted' ]}
@ClientHandling.algorithm:              #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:  true
@Metadata.allowExtensions:              true
@ObjectModel.representativeKey:         'LocationUUID'
@ObjectModel.semanticKey:               [ 'LocationUUID' ]
@ObjectModel.usageType.serviceQuality:  #C
@ObjectModel.usageType.sizeCategory:    #XL
@ObjectModel.usageType.dataClass:       #MASTER
@ObjectModel.dataCategory:              #VALUE_HELP 
@Search.searchable:                     true
@VDM.lifecycle.contract.type:           #NONE
@VDM.viewType:                          #COMPOSITE
@Consumption.ranked:                    true 
@EndUserText.label:                     'Location'

define view I_LocationValueHelp 
  as select from I_LocationBasic 
{
       
       @UI.hidden: true
       @Consumption.filter.hidden: true
  key  LocationUUID,

       @Search.defaultSearchElement: true
       @Search.ranking: #HIGH
       @Search.fuzzinessThreshold : 0.9
       @ObjectModel.text.element: ['LocationDescription']
       Location,
       
       @Search.defaultSearchElement: true
       @Semantics.text: true
       @Search.ranking: #MEDIUM
       @Search.fuzzinessThreshold : 0.9
       _Text[1:Language = $session.system_language].LocationDescription,

       @UI.hidden: true
       @Consumption.filter.hidden: true
       CollaborationPartner,
       @UI.hidden: true
       @Consumption.filter.hidden: true
       BusinessPartnerUUID,
       @UI.hidden: true
       @Consumption.filter.hidden: true
       @Semantics.booleanIndicator: true 
       IsBusinessPurposeCompleted,
       @UI.hidden: true
       @Consumption.filter.hidden: true
       AuthorizationGroup,
       
       /* Associations */
       _CollaborationPartner,
       _BusinessPartner
      
}
where LocationType = '1001' or
      LocationType = '1002' or
      LocationType = '1003' or
      LocationType = '1020' or
      LocationType = '1021' or
      LocationType = '1030' or
      LocationType = '1040' or
      LocationType = '1100' or
      LocationType = '1110' or
      LocationType = '1120' or
      LocationType = '1130' or
      LocationType = '1140' or
      LocationType = '1150' or
      LocationType = '1160' or
      LocationType = '1170' or
      LocationType = '1180' or
      LocationType = '1190' or
      LocationType = '1191' or
      LocationType = '1200'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOCATIONBASIC",
"I_LOCATIONTEXT"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_TMBUSINESSPARTNERBYINTKEY"
],
"BASE":
[
"I_LOCATIONBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More