I_LocationValueHelp

DDL: I_LOCATIONVALUEHELP SQL: ILOCVH Type: view COMPOSITE Package: VDM_LOCATION

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. It is exposed through 1 OData service (UI_MANAGELOCATION). Part of development package VDM_LOCATION.

1 data source(s) Exposed by 1 service(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

OData Services (1)

ServiceBindingVersionContractRelease
UI_MANAGELOCATION UI_MANAGELOCATION_04 V4 C1 NOT_RELEASED

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.8
       @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 = '1003' or  /* Shipping Point                   */
      LocationType = '1021' or  /* Business Partner                 */
      LocationType = '1100' or  /* Port                             */
      LocationType = '1110' or  /* Airport                          */
      LocationType = '1120' or  /* Railway Station                  */
      LocationType = '1190' or  /* Rail Junction                    */
      LocationType = '1200'     /* Loading Point                    */

Learn More