I_FunclocationLabelInternal

DDL: I_FUNCLOCATIONLABELINTERNAL Type: view BASIC
10 Fields 1 Data Sources 1 Associations

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.

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 Functional loc.
KEY FunctionalLocLabelingSyst iflos alkey Labeling system
KEY FunctionalLocationLabelVersion iflos versn Version
FunctionalLocLabelIsActive iflos actvs Active version
FunctionalLocationLabelName iflos strno Functional Loc.
FuncnlLocLabelIsPrimaryLabel iflos prkey Primary
CreationDate iflos erdat Entered On
CreatedByUser iflos ernam User Name
LastChangeDateTime iflos labelchangeddatetime Time Stamp
_FunctionalLocLabelingSyst _FunctionalLocLabelingSyst

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_FunclocationLabelInternal.
-- 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_FunclocationLabelInternal AS
SELECT
  iflos.tplnr AS FunctionalLocation,
  iflos.alkey AS FunctionalLocLabelingSyst,
  iflos.versn AS FunctionalLocationLabelVersion,
  iflos.actvs AS FunctionalLocLabelIsActive,
  iflos.strno AS FunctionalLocationLabelName,
  iflos.prkey AS FuncnlLocLabelIsPrimaryLabel,
  iflos.erdat AS CreationDate,
  iflos.ernam AS CreatedByUser,
  iflos.labelchangeddatetime AS LastChangeDateTime
FROM iflos
LEFT OUTER JOIN I_FunctionalLocLabelingSyst AS _FunctionalLocLabelingSyst ON FunctionalLocLabelingSyst = _FunctionalLocLabelingSyst.FunctionalLocLabelingSyst  -- association [0..1]
;

Learn More