I_FunctionalLocationText

DDL: I_FUNCTIONALLOCATIONTEXT Type: view BASIC

Functional Location - Text

I_FunctionalLocationText is a Basic CDS View that provides data about "Functional Location - Text" in SAP S/4HANA. It reads from 1 data source (iflotx) and exposes 8 fields with key fields FunctionalLocation, Language. It has 3 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
iflotx iflotx from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_FunctionalLocation _FunctionalLocation _FunctionalLocation.FunctionalLocation = $projection.FunctionalLocation
[0..1] I_Language _Language _Language.Language = $projection.Language -- Extension, do not expose as association:
[0..1] E_FunctionalLocation _FunctionalLocationExtension _FunctionalLocationExtension.FunctionalLocation = $projection.FunctionalLocation

Annotations (13)

NameValueLevelField
EndUserText.label Functional Location - Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFLOCTEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey FunctionalLocation view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation iflotx tplnr
KEY Language iflotx spras
FunctionalLocationName iflotx pltxt Description
IsPrimaryLanguage iflotx kzmla
FuncnlLocHasLongText iflotx kzltx
LastChangeDateTime iflotx textchangeddatetime
_FunctionalLocation _FunctionalLocation
_Language _Language 
@EndUserText.label: 'Functional Location - Text'
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@AbapCatalog: { sqlViewName: 'IFLOCTEXT', preserveKey }
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#CHECK
@ObjectModel.representativeKey: 'FunctionalLocation'

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@Metadata.ignorePropagatedAnnotations: true

@Analytics: {
  dataExtraction: {
    enabled: true,
    delta.changeDataCapture.automatic  
    }
    }
@ObjectModel.supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]

define view I_FunctionalLocationText
  as select from iflotx
  association [0..1] to I_FunctionalLocation as _FunctionalLocation on _FunctionalLocation.FunctionalLocation = $projection.FunctionalLocation
  association [0..1] to I_Language           as _Language           on _Language.Language = $projection.Language
   -- Extension, do not expose as association:
  association [0..1] to E_FunctionalLocation as _FunctionalLocationExtension on _FunctionalLocationExtension.FunctionalLocation = $projection.FunctionalLocation
{

      @ObjectModel.foreignKey.association: '_FunctionalLocation'
  key iflotx.tplnr               as FunctionalLocation,

      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key iflotx.spras               as Language,

      @Semantics.text: true
      @EndUserText.label: 'Description'
      iflotx.pltxt               as FunctionalLocationName,

      iflotx.kzmla               as IsPrimaryLanguage,

      iflotx.kzltx               as FuncnlLocHasLongText,

      @Semantics.systemDateTime.lastChangedAt: true
      iflotx.textchangeddatetime as LastChangeDateTime,

      // Propagate association

      _FunctionalLocation,
      _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"IFLOTX"
],
"ASSOCIATED":
[
"E_FUNCTIONALLOCATION",
"I_FUNCTIONALLOCATION",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More