FTI_LDB_TR_DEAL_FLOWS SAP (Treasury: Transaction Reporting, Flow Data (-> LDB)) Structure details
Description: Treasury: Transaction Reporting, Flow Data (-> LDB)
Related tables to FTI_LDB_TR_DEAL_FLOWS
Access table FTI_LDB_TR_DEAL_FLOWS
Structure field list including key, data, relationships and ABAP select examples
FTI_LDB_TR_DEAL_FLOWS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Treasury: Transaction Reporting, Flow Data (-> LDB)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_FTI_LDB_TR_DEAL_FLOWS TYPE FTI_LDB_TR_DEAL_FLOWS.
The FTI_LDB_TR_DEAL_FLOWS table consists of various fields, each holding specific information or linking keys about Treasury: Transaction Reporting, Flow Data (-> LDB) data available in SAP. These include DEAL_NUMBER (Position-Generating Financial Transaction), FLOWUUID (Transaction Flow UUID), RFHAZU (Transaction activity), DCRDAT (Entered On).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FTI_LDB_TR_DEAL_FLOWS structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
COMPANYCODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
DEAL_NUMBER | Position-Generating Financial Transaction | FTI_POSRFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
FLOWUUID | Transaction Flow UUID | TB_FLOWUUID | RAW | 16 | UUID | ||||
RFHAZU | Transaction activity | TB_RFHAZU | NUMC | 5 | T_RFHAZU | FAS | |||
DCRDAT | Entered On | TB_CRDAT | DATS | 8 | DATUM | ||||
TCRTIM | Entry Time | TB_TCRTIM | TIMS | 6 | UZEIT | ||||
FLOW_NO | Transaction flow | TB_RFHAZB | NUMC | 4 | T_RFHAZB | ||||
FLOWTYPE | Flow Type | TB_SFHAZBA | CHAR | 4 | TZB0A | SBEWART | |||
FLOWCLASS | Classification of flows and conditions | TB_SBKKLAS | CHAR | 1 | T_SBKKLAS | ||||
FLOWCATEGORY | Category of Flows and Conditions | TB_SBKTYP | CHAR | 2 | Assigned to domain | T_SBKTYP | |||
FLOW_DIRECTION | Direction of flow | TB_SSIGN | CHAR | 1 | T_SSIGN | ||||
DIRECTION_TRANS | Direction of Transaction | TB_RKONDGR | NUMC | 1 | T_RKONDGR | ||||
HOUSEBANK | Short key for own house bank | TB_RHABKI | CHAR | 5 | Assigned to domain | HBKID | |||
HOUSEBANK_ACC | Short key for house bank account | TB_RHKTID | CHAR | 5 | Assigned to domain | HKTID | |||
PAYER_PAYEE | Payer/payee | TB_RPZAHL_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
PBANK | Partner bank details | TB_RPBANK | CHAR | 4 | BVTYP | ||||
PAYMT_TRANS | Payment transaction | TB_SZART | CHAR | 1 | XFELD | ||||
PAYMT_METH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
PAYMT_METH_SUPP | Payment Method Supplement | UZAWE | CHAR | 2 | Assigned to domain | UZAWE | |||
PAYMENT_DATE | Payment or Delivery Date | TB_DZTERM | DATS | 8 | DATUM | T33 | |||
PAYMENT_AMOUNT | Payment amount in payment currency | TB_BZBETR | CURR | 13(2) | WERTV7 | ||||
PAYMENT_CURR | Payment Currency | TB_WZBETR | CUKY | 5 | Assigned to domain | WAERS | |||
POSTING_STATE | Posting Status of Flow | TB_SBEWEBE | CHAR | 1 | T_SBEWEBE | ||||
BLOCK_REASON | Reason Why Flow Is Blocked for Posting | TB_SSPRGRD | NUMC | 1 | T_SSPRGRD | ||||
FLG_RELEASED | Release Given for Flow to Be Posted? | TB_SBFREI | CHAR | 1 | XFELD | ||||
FLG_REVERSAL | Flow reversal in Treasury | TB_SBWGSTO | CHAR | 1 | XFELD | ||||
LOC_AMOUNT | Payment Amount in Local Currency | TB_HWBETR | CURR | 13(2) | WERTV7 | ||||
LOC_CURR | Local Currency | FTI_LOCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
LOC_RATE | Local currency rate | TB_KHWKURS | DEC | 9(5) | EXCRT | UKURS | |||
DUEDATE | Due date | TB_DFAELL | DATS | 8 | DATUM | ||||
SEC_ACCT | Securities Account | RLDEPO | CHAR | 10 | Assigned to domain | RLDEPO | DEP | ACC_CCD_CORE | |
SECPRICE_UNIT | Security Price Without Currency Ref. with Unit Quotation | TB_BUPRC | DEC | 15(6) | VVPKTKUR | ||||
SECPRICE_PERC | Security Price for Percentage Quotation | TB_BPPRC | DEC | 15(6) | VVPKTKUR | ||||
CURR_POSITION | Currency of Position Amount | TB_WBBETR | CUKY | 5 | Assigned to domain | WAERS | |||
CHNG_AMT_POS | Amount that Changes the Position | TB_BBBETR | CURR | 13(2) | WERTV7 | ||||
CURRUNIT_RATE | Currency Unit of the Rate | TB_RUNIT | CHAR | 5 | Assigned to domain | VVSRUNIT | |||
POS_VALUEDATE | Position Value Date | TB_DBESTAND | DATS | 8 | DATUM | ||||
ACCRINT_METHOD | Accrued interest method | SSTCKKZ | CHAR | 1 | SSTCKKZ | ||||
ACCRINT_DAYMETH | Accrued interest: Daily method | SSTCKTG | CHAR | 1 | SZBMETH | ||||
FLG_FLAT_IND | Indicator 'Traded flat',i.e.no accrued interest calculation | VVSFLAT | CHAR | 1 | XFELD | ||||
FLG_COUP_ID | Coupon ID for interest and accrued interest calculation | VVSCOUPON | CHAR | 1 | VVSCOUPON | ||||
COUP_DATE | Coupon date of next delivered coupon | VVDCOUPON | DATS | 8 | DATUM | ||||
INDEX_VALUE | Index Value (Independent of Basis) | TIDX_INDEX_VALUE_NO_RATIO | DEC | 18(12) | TIDX_INDEX_VALUE_NO_RATIO | ||||
CTY_QUANTITY | Quantity | FTR_QUAN | QUAN | 13(3) | FTR_QUAN | ||||
CTY_UOM | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CTY_PRICE_SETTL | Commodity Spot Price | FTR_COMSPOT | DEC | 13(5) | FTR_COMPRICE | ||||
COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | ||
QUOTATION_NAME | Quotation Name | FTI_QUOTNAME | CHAR | 18 | FTI_QUOTNAME | ||||
QUOTATION_SOURCE | Quotation Source | TCR_CTY_QUOTSRC | CHAR | 2 | Assigned to domain | TCR_CTY_QUOTSRC | |||
QUOTATION_TYPE | Commodity Quotation Type | TCR_CTY_QUOTTYPE | CHAR | 5 | Assigned to domain | TCR_CTY_QUOTTYPE | |||
CONTRACT_PRICE | Commodity Contract Price | FTI_CTY_PRICE | DEC | 13(5) | FTR_COMPRICE | ||||
SPREAD | Commodity Spread | FTR_COMSPREAD | DEC | 13(5) | FTR_COMPRICE | ||||
PRICE_CURR_UNIT | Currency Unit of the Rate | TB_RUNIT | CHAR | 5 | Assigned to domain | VVSRUNIT | |||
PRICE_UOM | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
STATUS_INTADJ | Status of Interest Rate Adjustment | TB_IRA_REGISTRATION_STATE | CHAR | 2 | T_IRA_REGISTRATION_STATE | ||||
REP_CODE | Repetitive Code | RPCODE | CHAR | 20 | Assigned to domain | ALPHA | RPCODE | FIBL_RPCODE | |
REFTEXT_REPCODE | Reference Text for Repetitive Code | RPCODE_TEXT | CHAR | 50 | XTEXT50 | ||||
HEDGE_ID | Identification for Hedging Relationship | TPM_HEDGE_ID | CHAR | 10 | |||||
CALC_DATE | Calculation Date | DVALUT | DATS | 8 | DATUM | ||||
INCL_VAL | Inclusive indicator for value date | VVSVINCL | NUMC | 1 | VVSINCL | ||||
MTHEND_VAL | Month-End Indicator for Value Date | VVSVULT | CHAR | 1 | VVSULT | ||||
NO_UNITS | Traded Number of Units for Unit-Quoted Securities/Futures | FTI_NUMBER_TRADED | DEC | 15(5) | ASTUECK | ||||
UNIT_CURR | Price currency | TB_WPRICE | CUKY | 5 | Assigned to domain | WAERS | |||
OPTION_PREMIUM | Currency option premium with price in points | TI_PRKUR | DEC | 13(9) | TB_KKURS | ||||
ASS_NO | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
BPRC_SPOT1 | Current Spot Rate in Percentage | TB_BPPRC_SPOT1 | DEC | 15(6) | VVPKTKUR | ||||
BPRC_SPOT2 | Spot Rate at Maturity in Percentage | TB_BPPRC_SPOT_MAT | DEC | 15(6) | VVPKTKUR | ||||
COST_FWD | Forward Rate Cost | TB_COSTFWD | DEC | 15(6) | VVPKTKUR | ||||
INTEREST_FWD | Forward Rate Interest | TB_INTERESTFWD | DEC | 15(6) | DECV9_6 | ||||
DIV_PCTC_OTC | Percentage of Dividend agreed for Payment in OTC Instruments | TB_DIV_PCTC_OTC | DEC | 7(4) | T_DIV_PCTC_OTC | ||||
ORIGIN | Display Area of Flow or Condition | TB_SHERK | CHAR | 4 | T_XFELD04 | ||||
DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 6 | Assigned to domain | TBA_DCSID | TBA_DCSID | TBAH_DCS | |
MIC | Market Identifier Code | TBA_MIC | CHAR | 4 | Assigned to domain | TBA_MIC | TBA_MIC | TBAH_MIC | |
PRICE_TYPE | Type of Price Quotation | TBA_PRICETYPE | CHAR | 2 | Assigned to domain | VVSKURSART | RATETYPE_F4 | ||
TIME_TO_MATURITY | Time to Maturity | TBA_TENOR | CHAR | 10 | Assigned to domain | TBA_TENOR | TBAH_TENOR | ||
EXCH_RATE_TYPE | Exchange Rate Type | KURST_CURR | CHAR | 4 | Assigned to domain | KURST | |||
PRICE_PAYM_CURR | Commodity Price | FTR_COMPRICE | DEC | 13(5) | FTR_COMPRICE | ||||
FX_TRANSLATION | Defines when quotation crcy is converted into payment crcy | FTR_CURRENCY_CONV_POINT_IN_TIM | CHAR | 1 | FTR_CURRENCY_CONV_POINT_IN_TIM |
Key field | Non-key field |
How do I retrieve data from SAP structure FTI_LDB_TR_DEAL_FLOWS using ABAP code?
As FTI_LDB_TR_DEAL_FLOWS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FTI_LDB_TR_DEAL_FLOWS as there is no data to select.How to access SAP table FTI_LDB_TR_DEAL_FLOWS
Within an ECC or HANA version of SAP you can also view further information about FTI_LDB_TR_DEAL_FLOWS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects