FTI_LDB_TR_PERIOD_FLOWS_1 SAP (Treasury: Flow Information Projection) Structure details
Description: Treasury: Flow Information Projection
Related tables to FTI_LDB_TR_PERIOD_FLOWS_1
Access table FTI_LDB_TR_PERIOD_FLOWS_1
Structure field list including key, data, relationships and ABAP select examples
FTI_LDB_TR_PERIOD_FLOWS_1 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: Flow Information Projection" 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_PERIOD_FLOWS_1 TYPE FTI_LDB_TR_PERIOD_FLOWS_1.
The FTI_LDB_TR_PERIOD_FLOWS_1 table consists of various fields, each holding specific information or linking keys about Treasury: Flow Information Projection data available in SAP. These include VONDAT (Start Date of Evaluation), BISDAT (Date of evaluation end), BUKRS (Company Code), LAND1 (Country key of company code).. 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_PERIOD_FLOWS_1 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VONDAT | Start Date of Evaluation | DVONDAT | DATS | 8 | DATUM | ||||
BISDAT | Date of evaluation end | DBISDAT | DATS | 8 | DATUM | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
LAND1 | Country key of company code | FTI_LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
TR_ACC_CODE | Accounting Code | TPM_ACC_CODE | CHAR | 4 | TRGC_TR_ACC_CODE | TPM_ACC_CODE | TPM_TAC | TRG_ACC_CODE | |
VALUATION_AREA | Valuation Area | TPM_VAL_AREA | CHAR | 3 | TRGC_VAL_AREA | TPM_VAL_AREA | TPM_VAL_AREA | TRG_VALUATION_AREA | |
VALUATION_CLASS | Valuation Class | TPM_VAL_CLASS | NUMC | 4 | TRGC_VAL_CLASS | TPM_VAL_CLASS | |||
GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
PORTFOLIO | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
SECURITY_ID | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA | ALPHA | WP_RANL | RAN | SECURITY_F4 |
LOANS_CONTRACT | Contract Number | RANL | CHAR | 13 | VDARL | ALPHA | RANL | RAN | |
DEAL_NUMBER | Position-Generating Financial Transaction | FTI_POSRFHA | CHAR | 13 | VTBFHA | ALPHA | T_RFHA | FAN | VTBA |
HEDGE_ID | Identification Number of Hedge Item | THM_HEDGE_ID | NUMC | 10 | Assigned to domain | THM_HEDGE_ID | HEDGEID | ||
ACCOUNT_GROUP | Securities Account Group | TPM_SEC_ACCT_GRP | CHAR | 10 | TRGT_SECACCGRP | TPM_SEC_ACCT_GRP | TPM_SHPL_SEC_ACC_GRP | ||
SECURITY_ACCOUNT | Securities Account | VRLDEPO | CHAR | 10 | TWD01 | RLDEPO | DEP | ||
POSITION_ACCOUNT | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | CHAR | 10 | TRFT_POS_ACCOUNT | TPM_POS_ACCOUNT_FUT | TRF_PAC | TRFC_F4_POS_ACCOUNT | |
EXTERNAL_ACCOUNT | External Account | TPM_EXT_ACCOUNT | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | ||
DIFF_CURRENCY | Currency as Differentiation Term | TPM_DIFF_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | TPM_DIFF_CURR | ||
FLAG_LONG_SHORT | Indicator: Long or Short Position | TPM_FLAG_LONG_SHORT | CHAR | 1 | TPM_FLAG_LONG_SHORT | ||||
LOT_ID | Identifier of the Lot | TPM_LOT_ID | RAW | 16 | SYSUUID | ||||
DLOTGENERATION | Date On Which Lot Was Generated | DLOTGENERATION | DATS | 8 | DATUM | ||||
TLOTGENERATION | Lot Generation Time | TLOTGENERATION | TIMS | 6 | UZEIT | ||||
LOTGENERATION_USER | Lot Entered By | FTI_LOTGENERATIONUSER | CHAR | 12 | SYCHAR12 | ||||
LOTGENERATION_BUSTRANSCAT | Business Transaction Category Which Generated the Lot | FTI_LOTGENERATION_BUSTRANSCAT | NUMC | 4 | Assigned to domain | TPM_BUSTRANSCAT | |||
LOTPOS_INIT_DATE | Position Acquisition Date of a Lot | FTI_LOTPOSITION_INIT_DATE | DATS | 8 | TPM_POSITION_DATE | ||||
LOTPOS_ORG_DATE | Original Position Acquisition Date of a Lot | FTI_LOTPOSITION_ORG_DATE | DATS | 8 | TPM_POSITION_DATE | ||||
LOTGEN_BUKRS | Company Code of Lot-Generating Transaction | FTI_LOTGENERATION_BUKRS | CHAR | 4 | Assigned to domain | BUKRS | H_T001 | ||
LOTGEN_DEALNR | Lot-Generating Transaction Number (Listed Derivatives) | FTI_LOTGENERATION_DEALNR | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | F4_TRANS_NO | |
HREL_NUMBER | Hedging Relationship Number (External/Internal) | TPM_HREL_NUMBER | CHAR | 10 | ALPHA | TPM_HREL_NUMBER | |||
FISCAL_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
HITEM_NUMBER | Hedged Item Number | TPM_HITEM_NUMBER | CHAR | 10 | ALPHA | TPM_HITEM_NUMBER | |||
HINST_NUMBER | Hedging Instrument Number | TPM_HINST_NUMBER | CHAR | 10 | ALPHA | TPM_HINST_NUMBER | |||
FUND | Fund | FM_FUND | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
SANLF | Product Category | SANLF | NUMC | 3 | TZAF | VVSANLF | |||
RANTYP_R | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
RREFKONT_R | Acct Assignment Ref. for Operative Valn Area and Loan | TB_REFKONT | CHAR | 8 | T037S | USTRU | |||
ACC_ASS_REF | Account Assignment Reference of Position Management | TPM_AA_REF | CHAR | 12 | TRACC_AA_REF | TPM_AA_REF | TRAC_AA_REF | ||
HKONT | General ledger account | FTI_HKONT | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
RLZTG_F | Remaining Term in Days | FTI_RLZTG_F | NUMC | 5 | NUMC5 | ||||
RLZMO_F | Remaining Term in Months | FTI_RLZMO_F | NUMC | 4 | NUMC4 | ||||
RLZJA_F | Remaining Term in Years | FTI_RLZJA_F | NUMC | 3 | NUMC3 | ||||
UEBTG_F | Overdue Period in Days | FTI_UEBTG_F | NUMC | 5 | NUMC5 | ||||
UEBMO_F | Overdue Period in Months | FTI_UEBMO_F | NUMC | 3 | NUMC3 | ||||
UEBJA_F | Overdue Period in Years | FTI_UEBJA_F | NUMC | 2 | NUMC2 | ||||
PARTNR | Partner with Whom Commitment Exists | FTI_LDB_RISK_COUNTERPARTY | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
TYPE | Business Partner Category | BP_TYPE_NEW | CHAR | 1 | BU_TYPE | ||||
ISTYPE | Industry System | BU_ISTYPE | CHAR | 4 | TB038 | BU_ISTYPE | |||
IND_SECTOR | Industry | BU_IND_SECTOR | CHAR | 10 | Assigned to domain | BU_INDSECTOR | |||
CNTRY_COMP | Country of Registered Office of Business Partner | FTI_LANDBP | CHAR | 3 | Assigned to domain | LAND1 | |||
LEGAL_ENTY | Legal Form of Organization | BP_LEG_ETY_NEW | CHAR | 2 | Assigned to domain | BU_LEGENTY | |||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG_NEW | CHAR | 2 | Assigned to domain | BU_LEGAL_ORG | |||
NATION | Nationality | BP_CNTR_N | CHAR | 3 | Assigned to domain | LAND1 | |||
STATE | Citizenship | BP_CNTR_ST | CHAR | 3 | Assigned to domain | LAND1 | |||
GROUP_ID | Business Partner Grouping | BU_GRP_ID_NEW | CHAR | 4 | Assigned to domain | BU_GROUP | BPP | ||
GROUP_D | Target Group | BP_GROUP_D | CHAR | 4 | Assigned to domain | BP_GROUP_D | |||
STAFF_GRP | Employee Group | BP_STAFF_G | CHAR | 4 | Assigned to domain | BP_STAFF_G | |||
COMP_RE | Organization Relationship | BP_COMP_RE | CHAR | 1 | BP_COMP_RE | ||||
GRADE | Valuation | FTI_BP_GRADE | CHAR | 10 | TPZ22 | BP_GRADE | |||
GRADE_METHOD | Valuation Procedure | FTI_BP_GRADE_METHOD | CHAR | 10 | TPZ21 | BP_GRADE_METHOD | |||
SOLVNCY | Credit Standing | BP_SOLVNCY | CHAR | 1 | BP_SOLVNCY | ||||
SOL_INF | Status of Credit Standing Information | BP_SOL_INF | CHAR | 1 | BP_SOL_INF | ||||
SOL_I_D | Date of Credit Standing Information | BP_SOL_I_D | DATS | 8 | DATUM | ||||
RATING | Rating | FTI_BP_RATING | CHAR | 3 | Assigned to domain | BP_RATING | |||
SOL_INS | Institute providing credit standing information | FTI_BP_SOL_INS | CHAR | 4 | Assigned to domain | BP_SOL_INS | |||
SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 3 | Assigned to domain | T_SFHAART | T02 | C_AT10 | |
FINPROJ | Finance Project | TB_TFPROJ | CHAR | 13 | T_TFPROJ | ||||
RMAID | Master Agreement | TB_RMAID | CHAR | 10 | Assigned to domain | ALPHA | T_RMAID | TMA | VTMA |
RGARANT | Guarantor of Financial Transaction | TB_RGARANT_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
NORDEXT | External Reference | TB_NORDEXT | CHAR | 16 | FTI_CHAR16LOW | ||||
ZUOND | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
REFER | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
MERKM | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
PORTFOLIO_TM | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
RDPBANK | Depository Bank | RDEPOTBANK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | ||
SBILK | Balance Sheet Indicator | SBILK | CHAR | 2 | TW11 | SBILK | |||
SNOTI | Quotation Indicator | SNOTI | NUMC | 1 | SNOTI | ||||
ALWPKL | General Security Classification | ALWPKL | CHAR | 3 | Assigned to domain | ALWPKL | |||
SWERTTYP | Security Type ID | SWERTTYP | NUMC | 1 | Assigned to domain | SAKTTYP | |||
SOL_INS_RANL | Institut Supplying Credit Rating Information for Secur. ID | FTI_SOL_INS_RANL | CHAR | 4 | Assigned to domain | BP_SOL_INS | |||
RATING_RANL | Rating for Securities ID Number/OTC Transaction | BP_RATING_RANL | CHAR | 3 | Assigned to domain | BP_RATING | |||
SWPKLASS | Classification of bond | SWPKLASS | NUMC | 3 | Assigned to domain | SWPKLASS | |||
SAKAR | Stock category | SAKAR | NUMC | 1 | SAKAR | ||||
SFOART | Fund category indicator | VVSFOART | CHAR | 2 | VVSFOART | ||||
SFOTY | Fund type indicator | SFOTY | NUMC | 1 | Assigned to domain | SFOTY | |||
SARTBET | Type of shareholding | SARTBET | NUMC | 2 | Assigned to domain | SARTBET | |||
SBOERNOT | Indicator: Listed on an Exchange | SBOERNOT | CHAR | 1 | JANEI | ||||
VVRANLWX | Secondary index class data | VVRANLWXS | CHAR | 20 | CHAR20S | ||||
AAAAKTIE_E | Number of Stocks Issued: End | FTI_AAAKTIE_E | DEC | 12 | DEC12 | ||||
KBNEWE_E | Nominal Value per Stock (Independent of Currency) | FTI_VVBNEWE_E | DEC | 15(6) | VVKWKURS | ||||
KZAHLAKT_E | Pay-in rate | FTI_KZAHLAKT_E | DEC | 10(7) | DEC3_7 | ||||
PKOND_E | Interest Rate: End | FTI_PKOND_E | DEC | 10(7) | DECV3_7 | ||||
BKOND_E | Interest Rate as Amount: End | FTI_BKOND_E | CURR | 13(2) | WERTV7 | ||||
PEFFZINS_E | Effective Interest Rate at End of Period | FTI_PEFFZINS_E | DEC | 10(7) | DEC3_7 | ||||
SHWHR | Local Currency | TB_SHWHR | CUKY | 5 | TCURC | WAERS | |||
SVWHR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
SBWHR | Position Currency/Transaction Currency | TB_BWHR | CUKY | 5 | TCURC | WAERS | |||
ANZGW | Display Currency | FTI_ANZGW | CUKY | 5 | TCURC | WAERS | FFZ | ||
NOTWAERS | Quotation currency (which prices are in) | VVNOTWAERS | CUKY | 5 | TCURC | WAERS | |||
SWHRKOND | Interest Currency | TB_WHRKOND | CUKY | 5 | TCURC | WAERS | |||
WVERB1 | Nominal currency borrowing/sale/outgoing side/short | FTI_WHR_SHORT | CUKY | 5 | Assigned to domain | WAERS | |||
WFORD1 | Nominal currency investment/purchase incoming side/long | FTI_WHR_LONG | CUKY | 5 | Assigned to domain | WAERS | |||
DBEWEG | Flow Date | DBEWEG | DATS | 8 | DATUM | ||||
DBESTAND | Position value date | DBESTAND | DATS | 8 | DATUM | ||||
DORDER | Order day | DORDER | DATS | 8 | DATUM | ||||
DDISPO | Payment Date | DDISPO | DATS | 8 | DATUM | ||||
DSCHLUSS | Date of business closing | VVDSCHLUSS | DATS | 8 | DATUM | ||||
DFAELL | Due date | DFAELL | DATS | 8 | DATUM | ||||
JAHR | Calendar year | TB_JAHR | NUMC | 4 | GJAHR | GJAHR | |||
MONAT | Calendar month | TB_MONAT | NUMC | 2 | TB_MONAT | ||||
WOCHE | Calendar Week | FTI_WOCHE | NUMC | 2 | NUMC2 | ||||
MONAT_JAHR | Calendar Month/Year | FTI_MONTH_YEAR | NUMC | 6 | PERI | MCPERIOD | |||
WOCHE_JAHR | Calendar Week/Year | FTI_WEEK_YEAR | NUMC | 6 | PERI | MCPERIOD | |||
SE_DEAL_NUMBER | Securities/Futures Transaction | FTI_SE_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
RKONTRA | Reference to Counterparty | RKONTRA_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
RHANDPL | Exchange | VVRHANDPL | CHAR | 10 | Assigned to domain | VVRHANDPL | WHP | ||
JFDBUC | Relevance to CM | FTI_FDBUC | CHAR | 1 | FTI_FDBUC | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
BANKK_HB | Bank key of house bank | FTI_BANKK | CHAR | 15 | BANKK | BNK | |||
BANKN_HB | Bank account number of house bank | FTI_BANKN | CHAR | 18 | BANKN | ||||
BANKK_BP | Bank key of business partner bank | FTI_BANKKP | CHAR | 15 | BANKK | BNK | |||
BANKN_BP | Bank account number of business partner | FTI_BANKNP | CHAR | 18 | BANKN | ||||
SZART | Payment transaction | TB_SZART | CHAR | 1 | XFELD | ||||
SPAYRQ | Generate payment request | TB_SPAYRQK | CHAR | 1 | XFELD | ||||
PRKEY | Key Number for Payment Request | PRQ_KEYNO | CHAR | 10 | PAYRQ | ALPHA | PRQ_KEYNO | ||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
AWKEY | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
GL_ACCOUNT_D | Number of G/L Account: Debit | FTI_GLACC_D | CHAR | 10 | SKB1 | ALPHA | SAKNR | SAK | C_SAKNR |
GL_ACCOUNT_C | Number of G/L Account: Credit | FTI_GLACC_C | CHAR | 10 | SKB1 | ALPHA | SAKNR | SAK | C_SAKNR |
DBUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
DGJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
DMONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
PERIO | Period/year | JAHRPER | NUMC | 7 | PERI7 | JAHRPER | |||
RAHABKI | Short key for own house bank | TB_RHABKI | CHAR | 5 | T012 | HBKID | |||
RAHKTID | Short key for house bank account | TB_RHKTID | CHAR | 5 | T012K | HKTID | |||
BUCHST | Posting Status of Flow for CFM (Operative Only) | BUCHST_CFM | CHAR | 1 | BUCHST_CFM | ||||
TRL_BOOKINGSTATE | Position Status of Flow for CFM (Parallel Only) | BUCHST_CFM_PAR | CHAR | 1 | TRLBS | TPM_TRL_BOOKINGSTATE | |||
LEDGER_POSTING_STATE | Ledger Posting Status | FTR_LEDGER_POSTING_STATE | CHAR | 1 | FTR_LEDGER_POSTING_STATE | ||||
SBEWART_R | Flow Type | SBEWART | CHAR | 4 | TZB0A | SBEWART | |||
FLOW_TYPE | Update Type | TPM_DIS_FLOWTYPE | CHAR | 8 | TRDC_DFLOWTYPE | TPM_DIS_FLOWTYPE | |||
GSVGANG | TR transaction activity for securities | GSVGANG | NUMC | 3 | GSVGANG | ||||
BUSTRANSCAT | Business Transaction Category | TPM_BUSTRANSCAT | NUMC | 4 | TRDTS_BT_CAT | TPM_BUSTRANSCAT | |||
GEN_BUSTRANSCAT | Generating Business Transaction Category | FTI_GENERATING_BUSTRANSCAT | NUMC | 4 | TRDTS_BT_CAT | TPM_BUSTRANSCAT | |||
SOURCETARGET_FLG | Indicator: Source or Target of a Flow | TPM_SOURCE_TARGET_FLG | CHAR | 1 | TPM_SOURCE_TARGET_FLG | ||||
BUSTRANSID | Identifier of the Distributor Business Transaction | FTI_BUSTRANSID | RAW | 16 | SYSUUID | ||||
REFBUSTRANSID | ID of Reference Business Transaction | FTI_REFBUSTRANSID | RAW | 16 | SYSUUID | ||||
TRLFLOWNUMBER | Number of TRL Flow | TPM_TRLFLOWNR | INT4 | 10 | TPM_TRLFLOW_NR | ||||
QUANT_CAT | Position Change Category: Quantity | FTI_QTY_PM_CAT | CHAR | 4 | TPM_QTY_PM_CAT | ||||
AMOUNT_CAT | Position Change Category | FTI_AMT_PM_CAT | CHAR | 4 | TRLTS_PMCAT | TPM_PM_CAT | |||
PL_CATEGORY | P/L Type | TPM_PL_CATEGORY | CHAR | 3 | TRGC_PL_CATE | ALPHA | TPM_PL_CATEGORY | ||
KMNR | Corporate Action Number | KMNR | CHAR | 13 | VWKMKO | ALPHA | VKMNR | KMA | |
WZBETR | Payment Currency | TB_WZBETR | CUKY | 5 | TCURC | WAERS | |||
SPLWHR | Profit/loss currency | SPLWHR | CUKY | 5 | TCURC | WAERS | |||
SSIGN | Direction of flow | TB_SSIGN | CHAR | 1 | T_SSIGN | ||||
IGT_STATUS | IGT: Status of an Intragroup transaction | TPM_IGT_STATUS | CHAR | 1 | TPM_IGT_STATUS | ||||
PARTNER_COMPANY_ID | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
ORIGIN_DATE | Treasury Ledger Date | TPM_TRLDATE | DATS | 8 | DATUM | ||||
D_UNITS | Delta Number of Units | FTI_D_UNITS | DEC | 22(6) | TPM_UNITS | ||||
D_UNITS_IN_HEDGE | Delta Number of Units in Hedge | FTI_D_UNITS_IN_HEDGE | DEC | 22(6) | TPM_UNITS | ||||
D_UNITS_FREE | Delta Number of Units Freestanding | FTI_D_UNITS_FREE | DEC | 22(6) | TPM_UNITS | ||||
D_NOMINAL_AMT_PC | Delta Nominal Amount in Position Currency | FTI_D_NOMINAL_AMT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_NOMINAL_ORG_AMT_PC | Delta: Original Nominal Amount in Position Currency | FTI_D_NOMINAL_ORG_AMT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_NOMINAL_AMT_IN_HEDGE_PC | Delta Nominal Amount in in Hedge in Position Currency | FTI_D_NOMINAL_AMT_IN_HEDGE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_NOMINAL_FREE_PC | Delta Nominal Amount Freestanding in Position Currency | FTI_D_NOMINAL_AMT_FREE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_PURCH_PC | Delta Purchase Value in Position Currency | FTI_D_PURCH_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_PURCH_LC | Delta Purchase Value in Local Currency | FTI_D_PURCH_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AQU_VAL_PC | Delta Acquisition Value in Position Currency | FTI_D_AQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AQU_VAL_LC | Delta Acquisition Value in Local Currency | FTI_D_AQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_BOOK_VAL_PC | Delta Book Value in Position Currency | FTI_D_BOOK_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_BOOK_VAL_LC | Delta Book Value in Local Currency | FTI_D_BOOK_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CHARGE_PC | Delta Costs in Position Currency | FTI_D_CHARGE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CHARGE_LC | Delta Costs in Local Currency | FTI_D_CHARGE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_BOOK_VAL_EX_PC | Delta Book Value Excl. Costs in Position Currency | FTI_D_BOOK_VAL_EX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_BOOK_VAL_EX_LC | Delta Book Value Excl. Costs in Local Currency | FTI_D_BOOK_VAL_EX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_TI_PC | Delta Security Valuation in Position Currency | FTI_D_VAL_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_TI_LC | Delta Security Valuation in Local Currency | FTI_D_VAL_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_FX_LC | Delta Foreign Currency Valuation in Local Currency | FTI_D_VAL_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_FX_VC | Delta Foreign Currency Valuation in Valuation Currency | FTI_D_VAL_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_TI_PC | Delta Valuation of Capitalized Costs, Security, in PC | FTI_D_VAL_CH_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_TI_LC | Delta Valuation of Capitalized Costs, Security, in LC | FTI_D_VAL_CH_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_FX_LC | Delta Valuation of Capitalized Costs, FX, in Local Currency | FTI_D_VAL_CH_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_FX_AMAQU_VAL_LC | FX Valuation of Amort. Acquisition Value in Local Currency | FTI_D_VAL_FX_AMAQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMORT_PC | Delta Amortization in Position Currency | FTI_D_AMORT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMORT_LC | Delta Amortization in Local Currency | FTI_D_AMORT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_IMPMNT_PC | Delta Impairment in Position Currency | FTI_D_IMPMNT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_IMPMNT_LC | Delta Impairment in Local Currency | FTI_D_IMPMNT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_IMPMNT_FX_LC | Delta FX Impairment in Local Currency | FTI_D_IMPMNT_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_REPAYMENT_PC | Delta: Cumulative Repayment in Position Currency | FTI_D_REPAYMENT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_REPAYMENT_LC | Delta: Cumulative Repayment in Local Currency | FTI_D_REPAYMENT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMAQU_VAL_PC | Delta Amortized Acquisition Value in Position Currency | FTI_D_AMAQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMAQU_VAL_LC | Delta Amortized Acquisition Value in Local Currency | FTI_D_AMAQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_DISAGIO_PC | Delta Cleared PD Def./Tax Compensation in Position Currency | FTI_D_DISAGIO_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_DISAGIO_LC | Delta Cleared PD Def./Tax Compensation in Local Currency | FTI_D_DISAGIO_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_TI_NPL_PC | Delta Security Valuation, Not Affecting P/L, in Pos. Crcy | FTI_D_VAL_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_TI_NPL_LC | Delta Security Valuation, Not Affecting P/L, in Local Crcy | FTI_D_VAL_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_FX_NPL_LC | Delta Foreign Currency Valuation, Not Affecting P/L, in LC | FTI_D_VAL_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_TI_NPL_PC | Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Position Crcy | FTI_D_VAL_CH_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_TI_NPL_LC | Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Local Crcy | FTI_D_VAL_CH_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_FX_NPL_LC | Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Local Crcy | FTI_D_VAL_CH_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VARMAR_PC | Delta Variation Margin in Position Currency | FTI_D_VARMAR_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VARMAR_LC | Delta Variation Margin in Local Currency | FTI_D_VARMAR_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SPOTVALP_LC | Delta Spot Valuation of Purchase Crcy in Local Currency | FTI_D_SPOTVALP_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SPOTVALS_LC | Delta Spot Valuation of Sale Currency in Local Currency | FTI_D_SPOTVALS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SWAPACC_PC | Delta Swap/Margin Accrual/Deferral in Position Currency | FTI_D_SWAPACC_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SWAPACC_LC | Delta Swap/Margin Accrual/Deferral in Local Currency | FTI_D_SWAPACC_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SWAPVAL_LC | Delta Swap Valuation in Local Currency | FTI_D_SWAPVAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
CF_CC | Payment amount in payment currency | FTI_PAYAMOUNT_PYC | CURR | 21(2) | TPM_AMOUNT | ||||
CF_LC | Payment Amount in Local Currency | FTI_PAYAMOUNT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
PL_PC | Profit/loss amount in profit/loss currency | FTI_PLAMOUNT_PLC | CURR | 21(2) | TPM_AMOUNT | ||||
PL_LC | Profit/loss amount in local currency | FTI_PLAMOUNT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
PABGERF_PC | Revenue Accrued/Deferred in Profit/Loss Currency | FTI_PERACC_PLC | CURR | 21(2) | TPM_AMOUNT | ||||
PABGERF_LC | Revenue Accrued/Deferred in Local Currency | FTI_PERACC_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMOUNT_PC | Flow Amount in Position Currency | FTI_D_AMOUNT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CONS_GAINS_FX_LC | Delta Consolidated FX Gains in Local Currency | FTI_D_CONS_GAINS_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CONS_GAINS_TI_LC | Delta Consolidated Security Gains in Local Currency | FTI_D_CONS_GAINS_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CONS_GAINS_TI_PC | Delta Consolidated Security Gains in Position Currency | FTI_D_CONS_GAINS_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CONS_LOSSES_FX_LC | Delta Consolidated FX Losses in Local Currency | FTI_D_CONS_LOSSES_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CONS_LOSSES_TI_LC | Delta Consolidated Security Losses in Local Currency | FTI_D_CONS_LOSSES_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_ORIG_VAD_LC | Delta Original Value Adjustment in Local Currency | FTI_D_ORIG_VAD_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_ORIG_VAD_PC | Delta Original Value Adjustment in Position Currency | FTI_D_ORIG_VAD_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_ORIG_VAD_VC | Delta Original Value Adjustment in Valuation Currency | FTI_D_ORIG_VAD_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAD_GAIN_LC | Delta Value Adjustment of Gains in Local Currency | FTI_D_VAD_GAIN_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAD_GAIN_PC | Delta Value Adjustment of Gains in Position Currency | FTI_D_VAD_GAIN_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAD_GAIN_VC | Delta Value Adjustment of Gains in Valuation Currency | FTI_D_VAD_GAIN_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAD_LOSS_LC | Delta Value Adjustment of Losses in Local Currency | FTI_D_VAD_LOSS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAD_LOSS_PC | Delta Value Adjustment of Losses in Position Currency | FTI_D_VAD_LOSS_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAD_LOSS_VC | Delta Value Adjustment of Losses in Valuation Currency | FTI_D_VAD_LOSS_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_HADJ_LC | Delta Hedge Adjustment in Local Currency | FTI_D_HADJ_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_HADJ_PC | Delta Hedge Adjustment in Position Currency | FTI_D_HADJ_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_HADJ_VC | Delta Hedge Adjustment in Valuation Currency | FTI_D_HADJ_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_EFFECTIVE_LC | Delta Effective Amount in Local Currency | FTI_D_EFFECTIVE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_EFFECTIVE_PC | Delta Effective Amount in Position Currency | FTI_D_EFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_EFFECTIVE_VC | Delta Effective Amount in Valuation Currency | FTI_D_EFFECTIVE_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_EFFECTIVE_DORMANT_LC | Delta Effective Dormant Amount in Local Currency | FTI_D_EFFECTIVE_DORMANT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_EFFECTIVE_DORMANT_PC | Delta Effective Dormant Amount in Position Currency | FTI_D_EFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_EFFECTIVE_DORMANT_VC | Delta Effective Dormant Amount in Valuation Currency | FTI_D_EFFECTIVE_DORMANT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_INEFFECTIVE_LC | Delta Ineffective Amount in Local Currency | FTI_D_INEFFECTIVE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_INEFFECTIVE_PC | Delta Ineffective Amount in Position Currency | FTI_D_INEFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_INEFFECTIVE_VC | Delta Ineffective Amount in Valuation Currency | FTI_D_INEFFECTIVE_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_INEFFECTIVE_DORMANT_LC | Delta Ineffective Dormant Amount in Local Currency | FTI_D_INEFFECTIVE_DORMANT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_INEFFECTIVE_DORMANT_PC | Delta Ineffective Dormant Amount in Position Currency | FTI_D_INEFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_INEFFECTIVE_DORMANT_VC | Delta Ineffective Dormant Amount in Valuation Currency | FTI_D_INEFFECTIVE_DORMANT_VC | CURR | 21(2) | TPM_AMOUNT |
Key field | Non-key field |
How do I retrieve data from SAP structure FTI_LDB_TR_PERIOD_FLOWS_1 using ABAP code?
As FTI_LDB_TR_PERIOD_FLOWS_1 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_PERIOD_FLOWS_1 as there is no data to select.How to access SAP table FTI_LDB_TR_PERIOD_FLOWS_1
Within an ECC or HANA version of SAP you can also view further information about FTI_LDB_TR_PERIOD_FLOWS_1 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