What is I_FuncnlLocAlternativeLabel in SAP S/4HANA?

I_FuncnlLocAlternativeLabel is a basic CDS view in SAP S/4HANA. Functional Location Alternative Labels It contains 13 fields.

Which tables does I_FuncnlLocAlternativeLabel read from?

I_FuncnlLocAlternativeLabel reads data from: I_FunclocationLabelInternal.

What VDM layer is I_FuncnlLocAlternativeLabel?

I_FuncnlLocAlternativeLabel is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_FuncnlLocAlternativeLabel

DDL: I_FUNCNLLOCALTERNATIVELABEL SQL: IFUNCTLOCALTLBL Type: view BASIC

13 Fields 1 Data Sources 4 Associations

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.

SAP Help Documentation

Category	CDS Views for Maintenance Management
Data Category	Dimension
Status	Released
Data Extraction Type	Delta-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)

Source	Alias	Join Type
I_FunclocationLabelInternal	I_FunclocationLabelInternal	from

Associations (4)

Cardinality	Target	Alias	Condition
[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 (14)

Name	Value	Level
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.sapObjectNodeType.name	FunctionalLocation	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)

Key	Field	Source Field	Description
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.
-- SQL view name: IFUNCTLOCALTLBL

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]
;

Depth:

I_FuncnlLocAlternativeLabel view

I_FunclocationLabelInternal view