I_FinTransMainFlow

DDL: I_FINTRANSMAINFLOW SQL: IFINTRANSMAINFLW Type: view COMPOSITE
33 Fields 1 Data Sources

Financial Transaction Main Flow

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

Data Sources (1)

SourceAliasJoin Type
I_FinTransFlow Flow from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IFINTRANSMAINFLW 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 Main 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 (33)

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
FinTransFlowNomAmt I_FinTransFlow FinTransFlowNomAmt
FinTransFlowNomAmtCrcy I_FinTransFlow FinTransFlowNomAmtCrcy
AssignmentReference I_FinTransFlow AssignmentReference Assignment Reference
FinTransFlwLoclCrcyAmtCalcType I_FinTransFlow FinTransFlwLoclCrcyAmtCalcType
FinTransFlowCalculationDate I_FinTransFlow FinTransFlowCalculationDate
FlowCalcDateIsExclusive I_FinTransFlow FlowCalcDateIsExclusive
FlowCalcDateIsMonthEnd I_FinTransFlow FlowCalcDateIsMonthEnd
FinTransPaytRateInPercent I_FinTransFlow FinTransPaytRateInPercent
_CompanyCode _CompanyCode
_FinTrans _FinTrans
_Activity _Activity
_ContractType _ContractType
_FlowType _FlowType
_PaymentCurrency _PaymentCurrency
_NominalCurrency _NominalCurrency
_LocalCurrency _LocalCurrency
_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_FinTransMainFlow.
-- 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: IFINTRANSMAINFLW

CREATE VIEW I_FinTransMainFlow 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.FinTransFlowNomAmt AS FinTransFlowNomAmt,
  Flow.FinTransFlowNomAmtCrcy AS FinTransFlowNomAmtCrcy,
  Flow.AssignmentReference AS AssignmentReference,
  Flow.FinTransFlwLoclCrcyAmtCalcType AS FinTransFlwLoclCrcyAmtCalcType,
  Flow.FinTransFlowCalculationDate AS FinTransFlowCalculationDate,
  Flow.FlowCalcDateIsExclusive AS FlowCalcDateIsExclusive,
  Flow.FlowCalcDateIsMonthEnd AS FlowCalcDateIsMonthEnd,
  Flow.FinTransPaytRateInPercent AS FinTransPaytRateInPercent
FROM I_FinTransFlow AS Flow
;

Learn More