I_FuncLocationLabelSearch

DDL: I_FUNCLOCATIONLABELSEARCH SQL: IFUNCLOCSEARCH Type: view BASIC Package: ILOM

Functional Location Search

I_FuncLocationLabelSearch is a Basic CDS View that provides data about "Functional Location Search" in SAP S/4HANA. It reads from 2 data sources (iflos, iflot) and exposes 7 fields with key fields FunctionalLocation, FunctionalLocLabelingSyst, FunctionalLocationLabelName, FunctionalLocLabelingSyst, FunctionalLocationLabelName. Part of development package ILOM.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
iflos iflos from
iflot iflot union_all

Annotations (9)

NameValueLevelField
EndUserText.label Functional Location Search view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IFUNCLOCSEARCH view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation iflos tplnr
KEY FunctionalLocLabelingSyst iflos alkey
KEY FunctionalLocationLabelName iflos strno
tplnrasFunctionalLocation
KEY FunctionalLocLabelingSyst
KEY FunctionalLocationLabelName iflot tplnr
FunctionalLocLabelIsActive 
@EndUserText.label: 'Functional Location Search' //same as DDL description

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'IFUNCLOCSEARCH' //must start with "I"


@ClientHandling.algorithm: #SESSION_VARIABLE

@Search.searchable: true


@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L


// Helper view to enable searching on the Functional Location Label field (HANA contains())


define view I_FuncLocationLabelSearch
  as select from iflos
{

  key    iflos.tplnr as FunctionalLocation,

  key    iflos.alkey as FunctionalLocLabelingSyst,

         @Search.defaultSearchElement: true
  key    iflos.strno as FunctionalLocationLabelName,
      
         iflos.actvs as FunctionalLocLabelIsActive            //3146870


} 
union all

select from iflot
{
  key    iflot.tplnr             as FunctionalLocation,

  key    cast('' as ilom_alkey ) as FunctionalLocLabelingSyst,

         @Search.defaultSearchElement: true
  key    iflot.tplnr             as FunctionalLocationLabelName,
  
         cast('' as ilom_actvs ) as FunctionalLocLabelIsActive     //3146870


}

Learn More