How many fields does I_FinTransActivityCategory have?

I_FinTransActivityCategory has 10 fields. Key fields: CompanyCode, FinancialTransaction, FinancialInstrActivityCategory.

I_FinTransActivityCategory

Q: Which tables does I_FinTransActivityCategory use?

I_FinTransActivityCategory reads from 2 data source(s): I_FinInstrActivityCategory, I_FinancialTransaction.

DDL: I_FINTRANSACTIVITYCATEGORY SQL: IFINTRANSACTCAT Type: view BASIC

Financial Transaction Activity Category

I_FinTransActivityCategory is a Basic CDS View (Dimension) that provides data about "Financial Transaction Activity Category" in SAP S/4HANA. It reads from 2 data sources (I_FinInstrActivityCategory, I_FinancialTransaction) and exposes 10 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrActivityCategory. It has 5 associations to related views.

Data Sources (2)

Source	Alias	Join Type
I_FinInstrActivityCategory	ActivityCategory	inner
I_FinancialTransaction	FinancialTransaction	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[0..1]	I_FinancialTransaction	_FinTrans	`$projection.CompanyCode = _FinTrans.CompanyCode and $projection.FinancialTransaction = _FinTrans.FinancialTransaction`
[0..*]	I_FinInstrActivityCategoryText	_ActivityCategoryText	`$projection.FinancialInstrProductCategory = _ActivityCategoryText.FinancialInstrProductCategory and $projection.FinInstrTransactionCategory = _ActivityCategoryText.FinInstrTransactionCategory and $projection.FinancialInstrActivityCategory = _ActivityCategoryText.FinancialInstrActivityCategory`
[0..1]	I_FinancialInstrProdCat	_ProductCategory	`$projection.FinancialInstrProductCategory = _ProductCategory.FinancialInstrProductCategory`
[0..1]	I_FinInstrTransCat	_TransactionCategory	`$projection.FinancialInstrProductCategory = _TransactionCategory.FinancialInstrProductCategory and $projection.FinInstrTransactionCategory = _TransactionCategory.FinInstrTransactionCategory`

Annotations (17)

Name	Value	Level
AbapCatalog.buffering.status	#NOT_ALLOWED	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AbapCatalog.sqlViewName	IFINTRANSACTCAT	view
AccessControl.authorizationCheck	#CHECK	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
Analytics.internalName	#LOCAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Financial Transaction Activity Category	view
ObjectModel.representativeKey	FinancialInstrActivityCategory	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#S	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#BASIC	view

Fields (10)

Key	Field	Source Table	Source Field
KEY	CompanyCode	I_FinancialTransaction	CompanyCode
KEY	FinancialTransaction	I_FinancialTransaction	FinancialTransaction
KEY	FinancialInstrActivityCategory	I_FinInstrActivityCategory	FinancialInstrActivityCategory
	FinancialInstrProductCategory	I_FinInstrActivityCategory	FinancialInstrProductCategory
	FinInstrTransactionCategory	I_FinInstrActivityCategory	FinInstrTransactionCategory
	_CompanyCode		_CompanyCode
	_FinTrans		_FinTrans
	_ActivityCategoryText		_ActivityCategoryText
	_ProductCategory		_ProductCategory
	_TransactionCategory		_TransactionCategory

@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IFINTRANSACTCAT'
@AccessControl.authorizationCheck: #CHECK
@Analytics.dataCategory: #DIMENSION 
@Analytics.dataExtraction.enabled: true
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE ]
@ObjectModel.modelingPattern: [ #ANALYTICAL_DIMENSION ]
@Analytics.internalName: #LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Financial Transaction Activity Category'
@ObjectModel.representativeKey: 'FinancialInstrActivityCategory'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #S
@Metadata.allowExtensions:true  
@Metadata.ignorePropagatedAnnotations: true 
@VDM.viewType: #BASIC 
define view I_FinTransActivityCategory 
  as select from I_FinancialTransaction as FinancialTransaction
  inner join I_FinInstrActivityCategory as ActivityCategory on  FinancialTransaction.FinancialInstrProductCategory  = ActivityCategory.FinancialInstrProductCategory
                                                            and FinancialTransaction.FinInstrTransactionCategory    = ActivityCategory.FinInstrTransactionCategory
  
  association [0..1] to I_CompanyCode                  as _CompanyCode          on  $projection.CompanyCode                    = _CompanyCode.CompanyCode
  association [0..1] to I_FinancialTransaction         as _FinTrans             on  $projection.CompanyCode                    = _FinTrans.CompanyCode
                                                                                and $projection.FinancialTransaction           = _FinTrans.FinancialTransaction
  association [0..*] to I_FinInstrActivityCategoryText as _ActivityCategoryText on  $projection.FinancialInstrProductCategory  = _ActivityCategoryText.FinancialInstrProductCategory
                                                                                and $projection.FinInstrTransactionCategory    = _ActivityCategoryText.FinInstrTransactionCategory
                                                                                and $projection.FinancialInstrActivityCategory = _ActivityCategoryText.FinancialInstrActivityCategory
  association [0..1] to I_FinancialInstrProdCat        as _ProductCategory      on  $projection.FinancialInstrProductCategory  = _ProductCategory.FinancialInstrProductCategory
  association [0..1] to I_FinInstrTransCat             as _TransactionCategory  on  $projection.FinancialInstrProductCategory  = _TransactionCategory.FinancialInstrProductCategory
                                                                                and $projection.FinInstrTransactionCategory    = _TransactionCategory.FinInstrTransactionCategory

{
  @ObjectModel.foreignKey.association: '_CompanyCode'
  key FinancialTransaction.CompanyCode                 as CompanyCode,
  @ObjectModel.foreignKey.association: '_FinTrans'
  key FinancialTransaction.FinancialTransaction        as FinancialTransaction,
  @ObjectModel.text.association: '_ActivityCategoryText'
  key ActivityCategory.FinancialInstrActivityCategory  as FinancialInstrActivityCategory,

  @ObjectModel.foreignKey.association: '_ProductCategory'
  ActivityCategory.FinancialInstrProductCategory   as FinancialInstrProductCategory,
  @ObjectModel.foreignKey.association: '_TransactionCategory'
  ActivityCategory.FinInstrTransactionCategory     as FinInstrTransactionCategory,
 
  _CompanyCode,
  _FinTrans,
  _ActivityCategoryText,
  _ProductCategory,
  _TransactionCategory
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINANCIALTRANSACTION",
"I_FININSTRACTIVITYCATEGORY"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_FINANCIALINSTRPRODCAT",
"I_FINANCIALTRANSACTION",
"I_FININSTRACTIVITYCATEGORYTEXT",
"I_FININSTRTRANSCAT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_FinTransActivityCategory view

I_FinancialTransaction view
I_FinInstrActivityCategory view