FTI_LDB_TR_PERIOD_FLOWS_2 SAP (Treasury: Flow Information) Structure details
Description: Treasury: Flow Information
Related tables to FTI_LDB_TR_PERIOD_FLOWS_2
Access table FTI_LDB_TR_PERIOD_FLOWS_2
Structure field list including key, data, relationships and ABAP select examples
FTI_LDB_TR_PERIOD_FLOWS_2 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" 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_2 TYPE FTI_LDB_TR_PERIOD_FLOWS_2.
The FTI_LDB_TR_PERIOD_FLOWS_2 table consists of various fields, each holding specific information or linking keys about Treasury: Flow Information 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_2 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 | |
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_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_PURCH_PC | Delta Purchase Value in Position Currency | FTI_D_PURCH_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_PURCH_VC | Delta Purchase Value in Valuation Currency | FTI_D_PURCH_VC | 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_VC | Delta Acquisition Value in Valuation Currency | FTI_D_AQU_VAL_VC | 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_VC | Delta Book Value in Valuation Currency | FTI_D_BOOK_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CHARGE_PC | Delta Costs in Position Currency | FTI_D_CHARGE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CHARGE_VC | Delta Costs in Valuation Currency | FTI_D_CHARGE_VC | 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_VC | Delta Book Value Excl. Costs in Valuation Currency | FTI_D_BOOK_VAL_EX_VC | 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_VC | Delta Security Valuation in Valuation Currency | FTI_D_VAL_TI_VC | 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_VC | Delta Valuation of Capitalized Costs, Security, in VC | FTI_D_VAL_CH_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_FX_VC | Delta Valuation of Capitalized Costs, FX, in Valuation Crcy | FTI_D_VAL_CH_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_FX_AMAQU_VAL_VC | Delta Valuation of FX, Amort. Acquisition Value in VC | FTI_D_VAL_FX_AMAQU_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMORT_PC | Delta Amortization in Position Currency | FTI_D_AMORT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMORT_VC | Delta Amortization in Valuation Currency | FTI_D_AMORT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_IMPMNT_PC | Delta Impairment in Position Currency | FTI_D_IMPMNT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_IMPMNT_VC | Delta Impairment in Valuation Currency | FTI_D_IMPMNT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_IMPMNT_FX_VC | Delta FX Impairment in Valuation Currency | FTI_D_IMPMNT_FX_VC | 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_VC | Delta: Cumulative Repayment in Valuation Currency | FTI_D_REPAYMENT_VC | 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_VC | Delta Amortized Acquisition Value in Valuation Currency | FTI_D_AMAQU_VAL_VC | 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_VC | Delta Cleared PD Def./Tax Compensation in Valuation Currency | FTI_D_DISAGIO_VC | 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_VC | Delta Security Valuation, Not Affecting P/L, in Val. Crcy | FTI_D_VAL_TI_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_FX_NPL_VC | Delta Foreign Currency Valuation, Not Affecting P/L, in VC | FTI_D_VAL_FX_NPL_VC | 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_VC | Delta Val. of Costs, Sec., Not Aff. P/L in Valuation Crcy | FTI_D_VAL_CH_TI_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_FX_NPL_VC | Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Val. Crcy | FTI_D_VAL_CH_FX_NPL_VC | 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_VC | Delta Variation Margin in Valuation Currency | FTI_D_VARMAR_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SPOTVALP_VC | Delta Spot Valuation of Purchase Crcy in Valuation Currency | FTI_D_SPOTVALP_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SPOTVALS_VC | Delta Spot Valuation of Sale Currency in Valuation Currency | FTI_D_SPOTVALS_VC | 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_VC | Delta Swap/Margin Accrual/Deferral in Valuation Currency | FTI_D_SWAPACC_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SWAPVAL_VC | Delta Swap Valuation in Valuation Currency | FTI_D_SWAPVAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
CF_CC | Payment amount in payment currency | FTI_PAYAMOUNT_PYC | CURR | 21(2) | TPM_AMOUNT | ||||
PL_PC | Profit/loss amount in profit/loss currency | FTI_PLAMOUNT_PLC | CURR | 21(2) | TPM_AMOUNT | ||||
PABGERF_PC | Revenue Accrued/Deferred in Profit/Loss Currency | FTI_PERACC_PLC | CURR | 21(2) | TPM_AMOUNT | ||||
PABGERF_VC | Period-Based Revenue Accrued/Deferred in Valuation Currency | FTI_PERACC_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMOUNT_PC | Flow Amount in Position Currency | FTI_D_AMOUNT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMOUNT_VC | Flow Amount in Valuation Currency | FTI_D_AMOUNT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CONS_GAINS_FX_VC | Delta Consolidated FX Gains in Valuation Currency | FTI_D_CONS_GAINS_FX_VC | 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_GAINS_TI_VC | Delta Consolidated Security Gains in Valuation Currency | FTI_D_CONS_GAINS_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CONS_LOSSES_FX_VC | Delta Consolidated FX Losses in Valuation Currency | FTI_D_CONS_LOSSES_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CONS_LOSSES_TI_PC | Delta Consolidated Security Losses in Position Currency | FTI_D_CONS_LOSSES_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CONS_LOSSES_TI_VC | Delta Consolidated Security Losses in Valuation Currency | FTI_D_CONS_LOSSES_TI_VC | CURR | 21(2) | TPM_AMOUNT |
Key field | Non-key field |
How do I retrieve data from SAP structure FTI_LDB_TR_PERIOD_FLOWS_2 using ABAP code?
As FTI_LDB_TR_PERIOD_FLOWS_2 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_2 as there is no data to select.How to access SAP table FTI_LDB_TR_PERIOD_FLOWS_2
Within an ECC or HANA version of SAP you can also view further information about FTI_LDB_TR_PERIOD_FLOWS_2 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