I_FinTransAdditionalFlow

DDL: I_FINTRANSADDITIONALFLOW SQL: IFINTRANSADDFLOW Type: view COMPOSITE
39 Fields 1 Data Sources

Financial Transaction Additional Flow

I_FinTransAdditionalFlow is a Composite CDS View that provides data about "Financial Transaction Additional Flow" in SAP S/4HANA. It reads from 1 data source (I_FinTransFlow) and exposes 39 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinTransFlowCreationDate, FinTransFlowCreationTime.

Data Sources (1)

SourceAliasJoin Type
I_FinTransFlow Flow from

Annotations (13)

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

Fields (39)

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
TreasuryContractType I_FinTransFlow TreasuryContractType Treasury Contract Type
FinancialTransactionDirection I_FinTransFlow FinancialTransactionDirection
FinTransFlowType I_FinTransFlow FinTransFlowType Flow Type
FinTransFlowPaytAmtDirection I_FinTransFlow FinTransFlowPaytAmtDirection
FinTransFlowPaymentDate I_FinTransFlow FinTransFlowPaymentDate
FinTransFlowPaytAmt I_FinTransFlow FinTransFlowPaytAmt
FinTransFlowPaytAmtCrcy I_FinTransFlow FinTransFlowPaytAmtCrcy
FinTransFlowInLoclCrcyPaytAmt I_FinTransFlow FinTransFlowInLoclCrcyPaytAmt
LocalCurrency I_FinTransFlow LocalCurrency Local Currency
FinTransFlowLoclCrcyCnvrsnRate I_FinTransFlow FinTransFlowLoclCrcyCnvrsnRate
InterestCalculationMethod I_FinTransFlow InterestCalculationMethod
CalculationPeriodStartDate I_FinTransFlow CalculationPeriodStartDate
CalcPeriodStartDateIsMonthEnd I_FinTransFlow CalcPeriodStartDateIsMonthEnd
CalculationPeriodEndDate I_FinTransFlow CalculationPeriodEndDate
CalcPeriodEndDateIsMonthEnd I_FinTransFlow CalcPeriodEndDateIsMonthEnd
FinTransFlowCalcBaseAmount I_FinTransFlow FinTransFlowCalcBaseAmount
FinTransFlowCalcBaseAmountCrcy I_FinTransFlow FinTransFlowCalcBaseAmountCrcy
ConditionPercentageRate I_FinTransFlow ConditionPercentageRate
AssignmentReference I_FinTransFlow AssignmentReference Assignment Reference
FinTransFlwLoclCrcyAmtCalcType I_FinTransFlow FinTransFlwLoclCrcyAmtCalcType
IntrstCalcMethFactoryCalendar I_FinTransFlow IntrstCalcMethFactoryCalendar
InterestCalculationType I_FinTransFlow InterestCalculationType
CalcPeriodStartDateIsInclusive I_FinTransFlow CalcPeriodStartDateIsInclusive
CalcPeriodEndDateIsInclusive I_FinTransFlow CalcPeriodEndDateIsInclusive
_CompanyCode _CompanyCode
_FinTrans _FinTrans
_Activity _Activity
_ContractType _ContractType
_FlowType _FlowType
_PaymentCurrency _PaymentCurrency
_LocalCurrency _LocalCurrency
_BaseAmtCurrency _BaseAmtCurrency
_Direction _Direction

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_FinTransAdditionalFlow.
-- 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: IFINTRANSADDFLOW

CREATE VIEW I_FinTransAdditionalFlow 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.TreasuryContractType AS TreasuryContractType,
  Flow.FinancialTransactionDirection AS FinancialTransactionDirection,
  Flow.FinTransFlowType AS FinTransFlowType,
  Flow.FinTransFlowPaytAmtDirection AS FinTransFlowPaytAmtDirection,
  Flow.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  Flow.FinTransFlowPaytAmt AS FinTransFlowPaytAmt,
  Flow.FinTransFlowPaytAmtCrcy AS FinTransFlowPaytAmtCrcy,
  Flow.FinTransFlowInLoclCrcyPaytAmt AS FinTransFlowInLoclCrcyPaytAmt,
  Flow.LocalCurrency AS LocalCurrency,
  Flow.FinTransFlowLoclCrcyCnvrsnRate AS FinTransFlowLoclCrcyCnvrsnRate,
  Flow.InterestCalculationMethod AS InterestCalculationMethod,
  Flow.CalculationPeriodStartDate AS CalculationPeriodStartDate,
  Flow.CalcPeriodStartDateIsMonthEnd AS CalcPeriodStartDateIsMonthEnd,
  Flow.CalculationPeriodEndDate AS CalculationPeriodEndDate,
  Flow.CalcPeriodEndDateIsMonthEnd AS CalcPeriodEndDateIsMonthEnd,
  Flow.FinTransFlowCalcBaseAmount AS FinTransFlowCalcBaseAmount,
  Flow.FinTransFlowCalcBaseAmountCrcy AS FinTransFlowCalcBaseAmountCrcy,
  Flow.ConditionPercentageRate AS ConditionPercentageRate,
  Flow.AssignmentReference AS AssignmentReference,
  Flow.FinTransFlwLoclCrcyAmtCalcType AS FinTransFlwLoclCrcyAmtCalcType,
  Flow.IntrstCalcMethFactoryCalendar AS IntrstCalcMethFactoryCalendar,
  Flow.InterestCalculationType AS InterestCalculationType,
  Flow.CalcPeriodStartDateIsInclusive AS CalcPeriodStartDateIsInclusive,
  Flow.CalcPeriodEndDateIsInclusive AS CalcPeriodEndDateIsInclusive
FROM I_FinTransFlow AS Flow
;

Learn More