I_FinancialInstrProdCatText

DDL: I_FINANCIALINSTRPRODCATTEXT SQL: IFININSPRODCATT Type: view BASIC
5 Fields 1 Data Sources 2 Associations

Product Category - Text

I_FinancialInstrProdCatText is a Basic CDS View that provides data about "Product Category - Text" in SAP S/4HANA. It reads from 1 data source (tzaft) and exposes 5 fields with key fields Language, FinancialInstrProductCategory. It has 2 associations to related views.

SAP Help Documentation

CategoryProduct Category
Data CategoryText
StatusReleased
Purpose
This CDS view provides access to the names of the product categories in different languages. This CDS view provides the prerequisites for answering the following business questions: Which name does a product category have in a specific language?

Structure
Main CDS parameters and filters The main filters are: Language key Measures and attributes Some important attributes are: Language key Product category Name of product category

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
tzaft tzaft from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_FinancialInstrProdCat _FinancialInstrProdCat $projection.FinancialInstrProductCategory = _FinancialInstrProdCat.FinancialInstrProductCategory

Annotations (19)

NameValueLevelField
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IFININSPRODCATT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Product Category - Text view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey FinancialInstrProductCategory view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
Search.searchable true view
Consumption.ranked true view
ObjectModel.sapObjectNodeType.name TreasuryProductCategoryText view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language spras Off. Language
KEY FinancialInstrProductCategory sanlf Prod. Category
FinInstrProductCategoryName ltx Text
_Language _Language
_FinancialInstrProdCat _FinancialInstrProdCat

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_FinancialInstrProdCatText.
-- 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: IFININSPRODCATT

CREATE VIEW I_FinancialInstrProdCatText AS
SELECT
  spras AS Language,
  sanlf AS FinancialInstrProductCategory,
  ltx AS FinInstrProductCategoryName
FROM tzaft
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrProdCat AS _FinancialInstrProdCat ON FinancialInstrProductCategory = _FinancialInstrProdCat.FinancialInstrProductCategory  -- association [0..1]
;

Learn More