I_FuncnlLocAlternativeLabel

DDL: I_FUNCNLLOCALTERNATIVELABEL Type: view_entity COMPOSITE Package: ILOM
13 Fields 1 Data Sources 4 Associations

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.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Data CategoryDimension
StatusReleased
Data Extraction TypeDelta-enabled, the extraction is based on field LastChangeDateTime .
Purpose
This CDS view provides the prerequisites for answering the following business questions: What are the possible versions of a functional location label? Which is the active label version? Which is the primary label? Who created the labels? What is the creation date of the labels? Note This CDS view is modeled for usage as a DataSource in Business Warehouse. We recommend that you only use it for this purpose.

Prerequisites
You have authorization to display the relevant functional locations in transactions IL03 and IH06 . This check is based on the following fields: Cost Centers ( I_KOSTL ) Maintenance Planner Group ( I_INGRP ) Maintenance Planning Plant ( I_IWERK ) Maintenance Plant ( I_SWERK ) Authorization Group ( I_BEGRP )

Structure
Business Objects This view is built on the following business objects: Functional location Main CDS parameters and filters This CDS view does not have any input parameters. Measures and attributes Some important measures and attributes are: Functional location label versions Active label version Primary label version Creator Creation date

View on SAP Help Portal →

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 Object ID
KEY FunctionalLocLabelingSyst FunctionalLocLabelingSyst Labeling system
KEY FunctionalLocationLabelVersion FunctionalLocationLabelVersion Version
FunctionalLocLabelIsActive FunctionalLocLabelIsActive Active version
FunctionalLocationLabelName FunctionalLocationLabelName Functional Loc.
FuncnlLocLabelIsPrimaryLabel FuncnlLocLabelIsPrimaryLabel Primary
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_FunctionalLocLabelingSyst _FunctionalLocLabelingSyst
_FunctionalLocation _FunctionalLocation
_IsActive _IsActive
_IsPrimaryLabel _IsPrimaryLabel

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_FuncnlLocAlternativeLabel.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_FuncnlLocAlternativeLabel AS
SELECT
  FunctionalLocation,
  FunctionalLocLabelingSyst,
  FunctionalLocationLabelVersion,
  FunctionalLocLabelIsActive,
  FunctionalLocationLabelName,
  FuncnlLocLabelIsPrimaryLabel,
  CreationDate,
  CreatedByUser,
  LastChangeDateTime
FROM I_FunclocationLabelInternal
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsPrimaryLabel ON FuncnlLocLabelIsPrimaryLabel = _IsPrimaryLabel.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsActive ON FunctionalLocLabelIsActive = _IsActive.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN E_FunctionalLocation AS _FunctionalLocationExtension ON _FunctionalLocationExtension.FunctionalLocation = FunctionalLocation  -- association [0..1]
;

Learn More