I_FinInstrProductGroup

DDL: I_FININSTRPRODUCTGROUP SQL: IFININSTRPRODGRP Type: view BASIC

Product Group Group

I_FinInstrProductGroup is a Basic CDS View (Dimension) that provides data about "Product Group Group" in SAP S/4HANA. It reads from 2 data sources (tzaf, tzpa) and exposes 4 fields with key field FinancialInstrumentProductType. It has 2 associations to related views.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
tzaf tzaf inner
tzpa tzpa from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_FinancialinstrProductType _FinancialInstrProductType $projection.FinancialInstrumentProductType = _FinancialInstrProductType.FinancialInstrumentProductType and $projection.FinancialInstrProductCategory = _FinancialInstrProductType.FinancialInstrProductCategory
[0..*] I_FinInstrProductGroupText _FinInstrProductGroupText $projection.FinInstrProductGroup = _FinInstrProductGroupText.FinInstrProductGroup

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey FinInstrProductGroup view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IFININSTRPRODGRP view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Product Group Group view
Metadata.ignorePropagatedAnnotations true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY FinancialInstrumentProductType tzpa gsart
FinancialInstrProductCategory tzaf sanlf
_FinancialInstrProductType _FinancialInstrProductType
_FinInstrProductGroupText _FinInstrProductGroupText 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'FinInstrProductGroup'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M 
@AbapCatalog.preserveKey:true 
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.sqlViewName: 'IFININSTRPRODGRP'
@VDM.viewType: #BASIC
@Analytics.dataCategory: #DIMENSION 
@Analytics.dataExtraction.enabled:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Product Group Group'
@Metadata.ignorePropagatedAnnotations: true // For C1-Release

define view I_FinInstrProductGroup as select from tzpa 
 inner join tzaf on tzpa.sanlf = tzaf.sanlf 
 
 association [0..1] to I_FinancialinstrProductType as _FinancialInstrProductType on $projection.FinancialInstrumentProductType = _FinancialInstrProductType.FinancialInstrumentProductType
                                                                          and $projection.FinancialInstrProductCategory = _FinancialInstrProductType.FinancialInstrProductCategory
                                                                          
association [0..*] to I_FinInstrProductGroupText as _FinInstrProductGroupText on $projection.FinInstrProductGroup = _FinInstrProductGroupText.FinInstrProductGroup
                                                                                                                            
 
{  
  key cast(case when tzaf.rantyp = '1' then 'L'  // Loans map 1:1

       when tzaf.rantyp = '2' then 'S'  // Security map 1:1

       when tzaf.rantyp = '4' or tzaf.rantyp = '5' or tzaf.rantyp = 'T' then 'O' // OTC is rantyp 4,5,T,6 with exception of Futures and Listed Derivatives        

       when tzaf.rantyp = '6' and  ( tzaf.sanlf <> '750' and tzaf.sanlf <> '700' ) then 'O' // OTC is rantyp 4,5,6 with exception of Futures and Listed Derivatives       

       when tzaf.sanlf = '750' or tzaf.sanlf = '700' then 'D' // Listed Derivatives are 750 and 700

       when tzaf.rantyp = 'X' then 'E'  // External Account

       when tzaf.sanlf = '990' or tzaf.sanlf = '991' then 'X' // Exposure Items

       else ' ' end  
  as ftr_gen_fin_instr_prod_group preserving type) as FinInstrProductGroup,
  key tzpa.gsart as FinancialInstrumentProductType, 
  tzaf.sanlf as FinancialInstrProductCategory,
  
  _FinancialInstrProductType,
  _FinInstrProductGroupText
  
} where tzaf.rantyp <> '3' 
    and tzaf.rantyp <> 'H'
    and tzaf.rantyp <> '7' 
    and tzaf.sanlf <> '710'  // Exclude rantyp 3 (leasing) and Hedging (--> Commodity) 

    and tzaf.sanlf <> '712'  // Exclude Underlying

                
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"TZAF",
"TZPA"
],
"ASSOCIATED":
[
"I_FINANCIALINSTRPRODUCTTYPE",
"I_FININSTRPRODUCTGROUPTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More