FTI_LDB_TRL_OTC_POS SAP (TRL Data for OTC Positions) Structure details
Dictionary Type: Structure
Description: TRL Data for OTC Positions
Description: TRL Data for OTC Positions
ABAP Code to SELECT data from FTI_LDB_TRL_OTC_POS
Related tables to FTI_LDB_TRL_OTC_POS
Access table FTI_LDB_TRL_OTC_POS
Related tables to FTI_LDB_TRL_OTC_POS
Access table FTI_LDB_TRL_OTC_POS
Structure field list including key, data, relationships and ABAP select examples
FTI_LDB_TRL_OTC_POS 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 "TRL Data for OTC Positions" 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_TRL_OTC_POS TYPE FTI_LDB_TRL_OTC_POS.
The FTI_LDB_TRL_OTC_POS table consists of various fields, each holding specific information or linking keys about TRL Data for OTC Positions data available in SAP. These include LOCAL_CCY (Local Currency), AQU_VAL_PC (Acquisition Value in Position Currency), AQU_VAL_LC (Acquisition Value in Local Currency), AMAQU_VAL_PC (Amortized Acquisition Value in Position Currency).. 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: Cannot Be Enhanced
SAP FTI_LDB_TRL_OTC_POS 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 |
| POSITION_CCY | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
| LOCAL_CCY | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
| AQU_VAL_PC | Acquisition Value in Position Currency | FTI_AQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| AQU_VAL_LC | Acquisition Value in Local Currency | FTI_AQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| AMAQU_VAL_PC | Amortized Acquisition Value in Position Currency | FTI_AMAQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| AMAQU_VAL_LC | Amortized Acquisition Value in Local Currency | FTI_AMAQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| IMPMNT_PC | Impairment in Position Currency | FTI_IMPMNT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| IMPMNT_LC | Impairment in Local Currency | FTI_IMPMNT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| IMPMNT_FX_LC | FX Impairment in Local Currency | FTI_IMPMNT_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| PURCH_PC | Purchase Value in Position Currency | FTI_PURCH_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| PURCH_LC | Purchase Value in Local Currency | FTI_PURCH_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| VAL_TI_NPL_PC | Security Valuation, Not Affecting P/L, in Position Currency | FTI_VAL_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| VAL_TI_NPL_LC | Security Valuation, Not Affecting P/L, in Local Currency | FTI_VAL_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| VAL_FX_NPL_LC | Foreign Currency Valuation, Not Affecting P/L, in Local Crcy | FTI_VAL_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| VAL_FX_AMAQU_VAL_LC | FX Valuation of Amort. Acquisition Value in Local Currency | FTI_VAL_FX_AMAQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| CHARGE_PC | Costs in position currency | FTI_CHARGE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| CHARGE_LC | Costs in Local Currency | FTI_CHARGE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| VAL_CH_TI_PC | Valuation of Cap. Costs, Security, in Position Currency | FTI_VAL_CH_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| VAL_CH_TI_LC | Valuation of Cap. Costs, Security, in Local Currency | FTI_VAL_CH_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| VAL_CH_TI_NPL_PC | Valuation of Cap. Costs, Sec., Not Aff. P/L in Position Crcy | FTI_VAL_CH_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| VAL_CH_TI_NPL_LC | Valuation of Cap. Costs, Sec., Not Aff. P/L in Local Crcy | FTI_VAL_CH_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| VAL_CH_FX_LC | Valuation of Capitalized Costs, FX, in Local Currency | FTI_VAL_CH_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| AMORT_PC | Amortization in Position Currency | FTI_AMORT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| AMORT_LC | Amortization in Local Currency | FTI_AMORT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| VAL_TI_PC | Security Valuation in Position Currency | FTI_VAL_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| VAL_TI_LC | Security Valuation in Local Currency | FTI_VAL_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| VAL_FX_LC | Foreign Currency Valuation in Local Currency | FTI_VAL_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| VARMAR_PC | Variation Margin in Position Currency | FTI_VARMAR_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| VARMAR_LC | Variation Margin in Local Currency | FTI_VARMAR_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| DISAGIO_PC | Cleared PD Deferral/Tax Compensation in Position Currency | FTI_DISAGIO_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| DISAGIO_LC | Cleared PD Deferral/Tax Compensation in Local Currency | FTI_DISAGIO_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| SWAPACC_PC | Swap/Margin Accrual/Deferral in Position Currency | FTI_SWAPACC_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| SWAPACC_LC | Swap or Margin Accrual/Deferral in Local Currency | FTI_SWAPACC_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| REPAYMENT_PC | Cumulative Repayment in Position Currency | TPM_REPAYMENT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| REPAYMENT_LC | Cumulative Repayment in Local Currency | TPM_REPAYMENT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| BOOK_VAL_PC | Book Value in Position Currency | FTI_BOOK_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| BOOK_VAL_LC | Book Value in Local Currency | FTI_BOOK_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| BOOK_VAL_EX_PC | Book Value Excluding Costs in Position Currency | FTI_BOOK_VAL_EX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
| BOOK_VAL_EX_LC | Book Value Excluding Costs in Local Currency | FTI_BOOK_VAL_EX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| SPOTVALP_LC | Spot Valuation of Purchase Currency in Local Currency | FTI_SPOTVALP_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| SPOTVALS_LC | Spot Valuation of Sale Currency in Local Currency | FTI_SPOTVALS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
| SWAPVAL_LC | Swap Valuation in Local Currency | FTI_SWAPVAL_LC | CURR | 21(2) | TPM_AMOUNT |
| Key field | Non-key field |
How do I retrieve data from SAP structure FTI_LDB_TRL_OTC_POS using ABAP code?
As FTI_LDB_TRL_OTC_POS 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_TRL_OTC_POS as there is no data to select.How to access SAP table FTI_LDB_TRL_OTC_POS
Within an ECC or HANA version of SAP you can also view further information about FTI_LDB_TRL_OTC_POS 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