I_FinTransAttribute

DDL: I_FINTRANSATTRIBUTE SQL: IFINTRANSATTR Type: view COMPOSITE Package: FTTR_CORE
16 Fields 2 Data Sources 2 Associations

Financial Transaction Attribute

I_FinTransAttribute is a Composite CDS View that provides data about "Financial Transaction Attribute" in SAP S/4HANA. It reads from 2 data sources (I_FinTransActivity, I_FinancialTransaction) and exposes 16 fields with key fields CompanyCode, FinancialTransaction. It has 2 associations to related views. Part of development package FTTR_CORE.

Data Sources (2)

SourceAliasJoin Type
I_FinTransActivity CurrentActivity inner
I_FinancialTransaction FinancialTransaction from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FinTransOverallView _FinancialTransaction $projection.CompanyCode = _FinancialTransaction.CompanyCode and $projection.FinancialTransaction = _FinancialTransaction.FinancialTransaction
[1..1] I_FinTransAdditionalAttribute _AdditionalAttribute $projection.CompanyCode = _AdditionalAttribute.CompanyCode and $projection.FinancialTransaction = _AdditionalAttribute.FinancialTransaction

Annotations (11)

NameValueLevelField
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IFINTRANSATTR view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Financial Transaction Attribute view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinancialTransaction CompanyCode Receiver Company Code
KEY FinancialTransaction I_FinancialTransaction FinancialTransaction Transaction
FinancialInstrProductCategory I_FinancialTransaction FinancialInstrProductCategory Prod. Category
FinTransTermCategory I_FinTransActivity FinTransTermCategory
TermStartDate I_FinancialTransaction TermStartDate Term Start
FinTransNoticeDate I_FinTransActivity FinTransNoticeDate Notice Date
FinTransRolloverDate I_FinTransActivity FinTransRolloverDate
TermEndDate I_FinTransActivity TermEndDate Term End
FinTransTermStartEndInclusive I_FinTransActivity FinTransTermStartEndInclusive
FinTransNoticePeriod I_FinancialTransaction FinTransNoticePeriod Notice Period
FinTransNoticePeriodUnit I_FinancialTransaction FinTransNoticePeriodUnit Unit
FinTransRoundingCategory I_FinancialTransaction FinTransRoundingCategory Round
FinTransIntrstHndlgAtRollover I_FinTransActivity FinTransIntrstHndlgAtRollover Int./Rollover
RolloverDfrrdIntrstPyoutDte I_FinTransActivity RolloverDfrrdIntrstPyoutDte Def.int.pmnt.dt
_FinancialTransaction _FinancialTransaction
_AdditionalAttribute _AdditionalAttribute

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_FinTransAttribute.
-- 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: IFINTRANSATTR

CREATE VIEW I_FinTransAttribute AS
SELECT
  FinancialTransaction.CompanyCode AS CompanyCode,
  FinancialTransaction.FinancialTransaction AS FinancialTransaction,
  FinancialTransaction.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  CurrentActivity.FinTransTermCategory AS FinTransTermCategory,
  FinancialTransaction.TermStartDate AS TermStartDate,
  CurrentActivity.FinTransNoticeDate AS FinTransNoticeDate,
  CurrentActivity.FinTransRolloverDate AS FinTransRolloverDate,
  CurrentActivity.TermEndDate AS TermEndDate,
  CurrentActivity.FinTransTermStartEndInclusive AS FinTransTermStartEndInclusive,
  FinancialTransaction.FinTransNoticePeriod AS FinTransNoticePeriod,
  FinancialTransaction.FinTransNoticePeriodUnit AS FinTransNoticePeriodUnit,
  FinancialTransaction.FinTransRoundingCategory AS FinTransRoundingCategory,
  CurrentActivity.FinTransIntrstHndlgAtRollover AS FinTransIntrstHndlgAtRollover,
  CurrentActivity.RolloverDfrrdIntrstPyoutDte AS RolloverDfrrdIntrstPyoutDte
FROM I_FinancialTransaction AS FinancialTransaction
INNER JOIN I_FinTransActivity AS CurrentActivity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinTransOverallView AS _FinancialTransaction ON CompanyCode = _FinancialTransaction.CompanyCode AND FinancialTransaction = _FinancialTransaction.FinancialTransaction  -- association [1..1]
LEFT OUTER JOIN I_FinTransAdditionalAttribute AS _AdditionalAttribute ON CompanyCode = _AdditionalAttribute.CompanyCode AND FinancialTransaction = _AdditionalAttribute.FinancialTransaction  -- association [1..1]
;

Learn More