I_FinTransFeeFlow

DDL: I_FINTRANSFEEFLOW SQL: IFINTRANSFEE Type: view COMPOSITE
25 Fields 2 Data Sources 4 Associations

Fin Trans Flows Relevant For Fee

I_FinTransFeeFlow is a Composite CDS View that provides data about "Fin Trans Flows Relevant For Fee" in SAP S/4HANA. It reads from 2 data sources (I_CalendarDate, I_FinTransFlow) and exposes 25 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinTransFlowCreationDate, FinTransFlowCreationTime. It has 4 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_CalendarDate Calendar inner
I_FinTransFlow Flow from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_FinancialTransaction _FinTrans $projection.CompanyCode = _FinTrans.CompanyCode and $projection.FinancialTransaction = _FinTrans.FinancialTransaction
[1..1] I_FinTransFlowType _FlowType $projection.TreasuryContractType = _FlowType.TreasuryContractType and $projection.FinTransFlowType = _FlowType.FinTransFlowType
[1..1] I_Currency _TransactionCurrency $projection.TransactionCurrency = _TransactionCurrency.Currency

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFINTRANSFEE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Fin Trans Flows Relevant For Fee view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinTransFlow CompanyCode Receiver Company Code
KEY FinancialTransaction I_FinTransFlow FinancialTransaction Transaction
KEY FinancialInstrumentActivity I_FinTransFlow FinancialInstrumentActivity
KEY FinTransFlowCreationDate I_FinTransFlow FinTransFlowCreationDate
KEY FinTransFlowCreationTime I_FinTransFlow FinTransFlowCreationTime
KEY FinTransFlowNumber I_FinTransFlow FinTransFlowNumber
FinTransFlowPaymentDate I_FinTransFlow FinTransFlowPaymentDate
FinTransFlowType I_FinTransFlow FinTransFlowType Flow Type
TreasuryContractType I_FinTransFlow TreasuryContractType Treasury Contract Type
FinTransFlowPostingStatus I_FinTransFlow FinTransFlowPostingStatus
FinTransFlowPaytAmt I_FinTransFlow FinTransFlowPaytAmt
FinTransFlowPaytAmtCrcy I_FinTransFlow FinTransFlowPaytAmtCrcy
TransactionCurrency _FinTrans TransactionCurrency Transaction Currency
Counterparty _FinTrans Counterparty Supplier
FinancialInstrumentProductType _FinTrans FinancialInstrumentProductType
Portfolio _FinTrans Portfolio Portfolio
SecurityAccount _FinTrans SecurityAccount
FinancialInstrTransactionType _FinTrans FinancialInstrTransactionType
YearMonth I_CalendarDate YearMonth Year Month
YearQuarter I_CalendarDate YearQuarter Year Quarter
CalendarYear I_CalendarDate CalendarYear Year
_FlowType _FlowType
_CompanyCode _CompanyCode
_FinTrans _FinTrans
_TransactionCurrency _TransactionCurrency

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_FinTransFeeFlow.
-- 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: IFINTRANSFEE

CREATE VIEW I_FinTransFeeFlow AS
SELECT
  Flow.CompanyCode AS CompanyCode,
  Flow.FinancialTransaction AS FinancialTransaction,
  Flow.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  Flow.FinTransFlowCreationDate AS FinTransFlowCreationDate,
  Flow.FinTransFlowCreationTime AS FinTransFlowCreationTime,
  Flow.FinTransFlowNumber AS FinTransFlowNumber,
  Flow.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  Flow.FinTransFlowType AS FinTransFlowType,
  Flow.TreasuryContractType AS TreasuryContractType,
  Flow.FinTransFlowPostingStatus AS FinTransFlowPostingStatus,
  Flow.FinTransFlowPaytAmt AS FinTransFlowPaytAmt,
  Flow.FinTransFlowPaytAmtCrcy AS FinTransFlowPaytAmtCrcy,
  _FinTrans.TransactionCurrency AS TransactionCurrency,
  _FinTrans.Counterparty AS Counterparty,
  _FinTrans.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  _FinTrans.Portfolio AS Portfolio,
  _FinTrans.SecurityAccount AS SecurityAccount,
  _FinTrans.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  Calendar.YearMonth AS YearMonth,
  Calendar.YearQuarter AS YearQuarter,
  Calendar.CalendarYear AS CalendarYear
FROM I_FinTransFlow AS Flow
INNER JOIN I_CalendarDate AS Calendar ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FinancialTransaction AS _FinTrans ON CompanyCode = _FinTrans.CompanyCode AND FinancialTransaction = _FinTrans.FinancialTransaction  -- association [0..1]
LEFT OUTER JOIN I_FinTransFlowType AS _FlowType ON TreasuryContractType = _FlowType.TreasuryContractType AND FinTransFlowType = _FlowType.FinTransFlowType  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [1..1]
;

Learn More