I_FunctionalLocationCategory

DDL: I_FUNCTIONALLOCATIONCATEGORY SQL: IFLOCCATTXT Type: view BASIC Package: ILOM
5 Fields 1 Data Sources 2 Associations

Functional Location Category

I_FunctionalLocationCategory is a Basic CDS View (Dimension) that provides data about "Functional Location Category" in SAP S/4HANA. It reads from 1 data source (t370f) and exposes 5 fields with key field FunctionalLocationCategory. It has 2 associations to related views. Part of development package ILOM.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Data CategoryDIMENSION
Purpose
This CDS view is designed to provide a structured representation of functional location categories within a system. It integrates data from various sources, including the T370F table, and associates it with relevant text descriptions and inspection levels. The view facilitates the extraction and analysis of data related to functional location categories, enabling efficient data management and reporting. This CDS view provides the data to answer the following business questions: What are the different functional location categories available in the system? How can functional location categories be associated with specific text descriptions for better understanding? What inspection levels are linked to each functional location category? How can the unique identifiers (OIDs) for functional location categories be generated and utilized for data management purposes? How does the system handle context-specific configurations for functional location categories? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Structure
Important Fields Important fields in this view include the following: Field Name Description FUNCTIONALLOCATIONCATEGORY Functional location category FUNCTIONALLOCATIONCATEGORYOID Object Instance ID of Functional Location Category TECHOBJINSPECTIONLEVELCODE Level at Which the Object is Represented

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture.

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
t370f t370f from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_FlocCategoryText _Text _Text.FunctionalLocationCategory = $projection.FunctionalLocationCategory
[0..*] I_TechObjInspectionLevelText _InspectionLevelText _InspectionLevelText.TechObjInspectionLevelCode = $projection.TechObjInspectionLevelCode

Annotations (17)

NameValueLevelField
EndUserText.label Functional Location Category view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFLOCCATTXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey FunctionalLocationCategory view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.sapObjectNodeType.name FunctionalLocationCategory view
ObjectModel.objectIdentifier.oidElement FunctionalLocationCategoryOID view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocationCategory t370f fltyp FunctLocCat.
TechObjInspectionLevelCode t370f idms_type Inspection Level
FunctionalLocationCategoryOID
_Text _Text
_InspectionLevelText _InspectionLevelText

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_FunctionalLocationCategory.
-- 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: IFLOCCATTXT

CREATE VIEW I_FunctionalLocationCategory AS
SELECT
  t370f.fltyp AS FunctionalLocationCategory,
  t370f.idms_type AS TechObjInspectionLevelCode,
  cast( t370f.fltyp as functionallocationcategory_oid ) AS FunctionalLocationCategoryOID
FROM t370f
LEFT OUTER JOIN I_FlocCategoryText AS _Text ON _Text.FunctionalLocationCategory = FunctionalLocationCategory  -- association [0..*]
LEFT OUTER JOIN I_TechObjInspectionLevelText AS _InspectionLevelText ON _InspectionLevelText.TechObjInspectionLevelCode = TechObjInspectionLevelCode  -- association [0..*]
;

Learn More