I_FunclocationLabelInternal

DDL: I_FUNCLOCATIONLABELINTERNAL Type: view BASIC

Functional Location Label Internal

I_FunclocationLabelInternal is a Basic CDS View that provides data about "Functional Location Label Internal" in SAP S/4HANA. It reads from 1 data source (iflos) and exposes 10 fields with key fields FunctionalLocation, FunctionalLocLabelingSyst, FunctionalLocationLabelVersion. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
iflos iflos from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FunctionalLocLabelingSyst _FunctionalLocLabelingSyst $projection.FunctionalLocLabelingSyst = _FunctionalLocLabelingSyst.FunctionalLocLabelingSyst

Annotations (8)

NameValueLevelField
EndUserText.label Functional Location Label Internal view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IFLOCLABELINTERN view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation iflos tplnr
KEY FunctionalLocLabelingSyst iflos alkey
KEY FunctionalLocationLabelVersion iflos versn
FunctionalLocLabelIsActive iflos actvs
FunctionalLocationLabelName iflos strno
FuncnlLocLabelIsPrimaryLabel iflos prkey
CreationDate iflos erdat
CreatedByUser iflos ernam
LastChangeDateTime iflos labelchangeddatetime
_FunctionalLocLabelingSyst _FunctionalLocLabelingSyst 
@EndUserText.label: 'Functional Location Label Internal'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog: { sqlViewName: 'IFLOCLABELINTERN', preserveKey }

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L

define view I_FunclocationLabelInternal
  as select from iflos
  association [0..1] to I_FunctionalLocLabelingSyst as _FunctionalLocLabelingSyst on $projection.FunctionalLocLabelingSyst = _FunctionalLocLabelingSyst.FunctionalLocLabelingSyst
{

  key       iflos.tplnr                as FunctionalLocation,
            @ObjectModel.foreignKey.association: '_FunctionalLocLabelingSyst'
  key       iflos.alkey                as FunctionalLocLabelingSyst,

  key       iflos.versn                as FunctionalLocationLabelVersion,

            iflos.actvs                as FunctionalLocLabelIsActive,
            iflos.strno                as FunctionalLocationLabelName,

            iflos.prkey                as FuncnlLocLabelIsPrimaryLabel,
            iflos.erdat                as CreationDate,
            iflos.ernam                as CreatedByUser,

            @Semantics.systemDateTime.lastChangedAt: true
            iflos.labelchangeddatetime as LastChangeDateTime,

            _FunctionalLocLabelingSyst
}

Learn More