I_FuncnlLocAlternativeLabel

DDL: I_FUNCNLLOCALTERNATIVELABEL Type: view_entity COMPOSITE Package: ILOM

Functional Location Alternative Labels

I_FuncnlLocAlternativeLabel is a Composite 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. Part of development package ILOM.

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 (12)

NameValueLevelField
EndUserText.label Functional Location Alternative Labels view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK 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
Analytics.technicalName IFUNCTLOCALTLBL view
ObjectModel.sapObjectNodeType.name FunctionalLocation 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: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: {
  representativeKey: 'FunctionalLocationLabelVersion',
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #L
  }
}

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

@ObjectModel.sapObjectNodeType.name: 'FunctionalLocation'

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

define view entity 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
}

Learn More