I_FuncnlLocAlternativeLabel

DDL: I_FUNCNLLOCALTERNATIVELABEL SQL: IFUNCTLOCALTLBL Type: view BASIC

Functional Location Alternative Labels

I_FuncnlLocAlternativeLabel is a Basic CDS View (Dimension) that provides data about "Functional Location Alternative Labels" in SAP S/4HANA. It reads from 1 data source (I_FunclocationLabelInternal) and exposes 13 fields with key fields FunctionalLocation, FunctionalLocLabelingSyst, FunctionalLocationLabelVersion. It has 4 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_FunclocationLabelInternal I_FunclocationLabelInternal from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_FunctionalLocation _FunctionalLocation $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation
[0..1] I_Indicator _IsPrimaryLabel $projection.FuncnlLocLabelIsPrimaryLabel = _IsPrimaryLabel.IndicatorValue
[0..1] I_Indicator _IsActive $projection.FunctionalLocLabelIsActive = _IsActive.IndicatorValue -- Extension, do not expose as association:
[0..1] E_FunctionalLocation _FunctionalLocationExtension _FunctionalLocationExtension.FunctionalLocation = $projection.FunctionalLocation

Annotations (13)

NameValueLevelField
EndUserText.label Functional Location Alternative Labels view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IFUNCTLOCALTLBL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey FunctionalLocationLabelVersion view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.byElement.name LastChangeDateTime view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation FunctionalLocation
KEY FunctionalLocLabelingSyst FunctionalLocLabelingSyst
KEY FunctionalLocationLabelVersion FunctionalLocationLabelVersion
FunctionalLocLabelIsActive FunctionalLocLabelIsActive
FunctionalLocationLabelName FunctionalLocationLabelName
FuncnlLocLabelIsPrimaryLabel FuncnlLocLabelIsPrimaryLabel
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
_FunctionalLocLabelingSyst _FunctionalLocLabelingSyst
_FunctionalLocation _FunctionalLocation
_IsActive _IsActive
_IsPrimaryLabel _IsPrimaryLabel 
@EndUserText.label: 'Functional Location Alternative Labels'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.sqlViewName: 'IFUNCTLOCALTLBL'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true

@ObjectModel: {
  representativeKey: 'FunctionalLocationLabelVersion',
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #L
  }
}

@Analytics: {
  dataCategory: #DIMENSION,
  dataExtraction: {
    enabled: true,
    delta.byElement : {
      name: 'LastChangeDateTime'
    }
  }
}

@Metadata: {
  ignorePropagatedAnnotations,
  allowExtensions
}
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]

define view I_FuncnlLocAlternativeLabel
  as select from I_FunclocationLabelInternal
  association [0..1] to I_FunctionalLocation as _FunctionalLocation on $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation
  association [0..1] to I_Indicator          as _IsPrimaryLabel     on $projection.FuncnlLocLabelIsPrimaryLabel = _IsPrimaryLabel.IndicatorValue
  association [0..1] to I_Indicator          as _IsActive           on $projection.FunctionalLocLabelIsActive = _IsActive.IndicatorValue
   -- Extension, do not expose as association:
  association [0..1] to E_FunctionalLocation as _FunctionalLocationExtension on _FunctionalLocationExtension.FunctionalLocation = $projection.FunctionalLocation
{
      //I_FunclocationLabelInternal

      @ObjectModel.foreignKey.association: '_FunctionalLocation'
  key FunctionalLocation,
      @ObjectModel.foreignKey.association: '_FunctionalLocLabelingSyst'
  key FunctionalLocLabelingSyst,
  key FunctionalLocationLabelVersion,

      @ObjectModel.foreignKey.association: '_IsActive'
      FunctionalLocLabelIsActive,

      FunctionalLocationLabelName,

      @ObjectModel.foreignKey.association: '_IsPrimaryLabel'
      FuncnlLocLabelIsPrimaryLabel,

      @Semantics.systemDate.createdAt: true
      CreationDate,

      @Semantics.user.createdBy: true
      CreatedByUser,

      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime,

      /* Associations */
      //I_FunclocationLabelInternal

      _FunctionalLocLabelingSyst,

      _FunctionalLocation,
      _IsActive,
      _IsPrimaryLabel
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FUNCLOCATIONLABELINTERNAL"
],
"ASSOCIATED":
[
"E_FUNCTIONALLOCATION",
"I_FUNCTIONALLOCATION",
"I_FUNCTIONALLOCLABELINGSYST",
"I_INDICATOR"
],
"BASE":
[
"I_FUNCLOCATIONLABELINTERNAL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More