I_FinancialInstrProdTypeText

DDL: I_FINANCIALINSTRPRODTYPETEXT SQL: IFININSPRODTPT Type: view BASIC Package: FTTR_CORE
5 Fields 1 Data Sources 2 Associations 18 OData Services

Product Type - Text

I_FinancialInstrProdTypeText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

FinInstrProductTypeText · Financial Operations

I_FinancialInstrProdTypeText is a Basic CDS View that provides data about "Product Type - Text" in SAP S/4HANA. It reads from 1 data source (tzpat) and exposes 5 fields with key fields Language, FinancialInstrumentProductType. It has 2 associations to related views. It is exposed through 18 OData services (ASQL_F0735, ASQL_F1754, ASQL_F1755, ...). Part of development package FTTR_CORE.

SAP Help Documentation

CategoryProduct Type
Data CategoryText
StatusReleased
Purpose
This CDS view provides access to the names of the product types in different languages. This CDS view provides the prerequisites for answering the following business questions: Which name does a product type 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 type Name of the product type

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM-2CL
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Association Target for Defining CDS Entities,Language-Dependent Text,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageFinancial Operations for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides access to the names of the product types in different languages.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>Which name does a product type have in a specific language?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
tzpat FinancialInstrProdTypeText from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_FinancialinstrProductType _FinancialInstrProductType $projection.FinancialInstrumentProductType = _FinancialInstrProductType.FinancialInstrumentProductType
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (19)

NameValueLevelField
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IFININSPRODTPT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Product Type - Text view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey FinancialInstrumentProductType 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 FinInstrProductTypeText view

OData Services (18)

ServiceBindingVersionContractRelease
ASQL_F0735 ASQL_F0735 C2 NOT_RELEASED
ASQL_F1754 ASQL_F1754 C2 NOT_RELEASED
ASQL_F1755 ASQL_F1755 C2 NOT_RELEASED
ASQL_F1867 ASQL_F1867 C2 NOT_RELEASED
ASQL_F2331 ASQL_F2331 C2 NOT_RELEASED
ASQL_F3098 ASQL_F3098 C2 NOT_RELEASED
ASQL_F3130 ASQL_F3130 C2 NOT_RELEASED
ASQL_F3450 ASQL_F3450 C2 NOT_RELEASED
ASQL_F3966 ASQL_F3966 C2 NOT_RELEASED
ASQL_F4763 ASQL_F4763 C2 NOT_RELEASED
ASQL_F4979 ASQL_F4979 C2 NOT_RELEASED
ASQL_F4980 ASQL_F4980 C2 NOT_RELEASED
ASQL_F4981 ASQL_F4981 C2 NOT_RELEASED
ASQL_F4982 ASQL_F4982 C2 NOT_RELEASED
ASQL_F4983 ASQL_F4983 C2 NOT_RELEASED
ASQL_F4984 ASQL_F4984 C2 NOT_RELEASED
ASQL_F6157 ASQL_F6157 C2 NOT_RELEASED
ASQL_F7601 ASQL_F7601 C2 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language tzpat spras Off. Language
KEY FinancialInstrumentProductType tzpat gsart Product Type
FinancialInstrProdTypeName Name of the Product Type
_FinancialInstrProductType _FinancialInstrProductType
_Language _Language

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_FinancialInstrProdTypeText.
-- 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: IFININSPRODTPT

CREATE VIEW I_FinancialInstrProdTypeText AS
SELECT
  FinancialInstrProdTypeText.spras AS Language,
  FinancialInstrProdTypeText.gsart AS FinancialInstrumentProductType,
  cast(FinancialInstrProdTypeText.ltx as ftr_gen_product_type_name preserving type) AS FinancialInstrProdTypeName
FROM tzpat AS FinancialInstrProdTypeText
LEFT OUTER JOIN I_FinancialinstrProductType AS _FinancialInstrProductType ON FinancialInstrumentProductType = _FinancialInstrProductType.FinancialInstrumentProductType  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More