FTI_LDB_TR_EXP_POS SAP (Reporting Structure: Exposure Positions) Structure details
Description: Reporting Structure: Exposure Positions
Related tables to FTI_LDB_TR_EXP_POS
Access table FTI_LDB_TR_EXP_POS
Structure field list including key, data, relationships and ABAP select examples
FTI_LDB_TR_EXP_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 "Reporting Structure: Exposure 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_TR_EXP_POS TYPE FTI_LDB_TR_EXP_POS.
The FTI_LDB_TR_EXP_POS table consists of various fields, each holding specific information or linking keys about Reporting Structure: Exposure Positions data available in SAP. These include EXP_TYPE (Exposure Position Type), RISK_CAT (Exposure Risk Category), COUNTRY (Country Key), COMPANY_CODE (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_EXP_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_ID | Exposure Position ID | FTR_POSITION_ID | CHAR | 20 | Assigned to domain | ALPHA | FTR_POSITION_ID | TEXH_POSITION | |
EXP_TYPE | Exposure Position Type | FTR_EXPOSURE_TYPE | CHAR | 5 | TEXC_EXP_TYPE | FTR_EXPOSURE_TYPE | TEXH_F4_EXP_TYPE | ||
RISK_CAT | Exposure Risk Category | FTR_RISK_CAT | CHAR | 1 | FTR_RISK_CAT | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
TRANSACTION_CAT | Exposure Category of Raw Exposure | FTR_RAWEXPOS_TRANSCAT | CHAR | 2 | TEXC_EXP_CAT | FTR_RAWEXPOS_TRANSCAT | |||
TRANSACTIVITY | Exposure Activity | FTR_TRANSACT | NUMC | 2 | TEXC_EXP_ACT | FTR_TRANSACT | |||
ATTRIBUTE_SH01 | Value of a free attribute (Char4) | FTR_ATTRIBUTE_SHORT | CHAR | 4 | TEXC_ATTR_S | FTR_ATTRIBUTE_SHORT | |||
ATTRIBUTE_SH02 | Value of a free attribute (Char4) | FTR_ATTRIBUTE_SHORT | CHAR | 4 | TEXC_ATTR_S | FTR_ATTRIBUTE_SHORT | |||
ATTRIBUTE_LH01 | Value of a free attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 20 | TEXC_ATTR_L | FTR_ATTRIBUTE_LONG | |||
ATTRIBUTE_DH01 | Value of a free attribute (Date) | FTR_ATTRIBUTE_DATE | DATS | 8 | FTR_ATTRIBUTE_DATE | ||||
PROFIT_CENTER | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | Assigned to domain | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | |
FOREIGN_CURR | Exposure Amount Currency | FTR_EXPOSURE_CURR | CUKY | 5 | TCURC | WAERS | |||
TARGET_CURR | Target Currency of Exposure | FTR_EXPOSURE_CURRENCY_TARGET | CUKY | 5 | TCURC | WAERS | |||
ATTRIBUTE_LI01 | Value of a free attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 20 | TEXC_ATTR_L | FTR_ATTRIBUTE_LONG | |||
ATTRIBUTE_LI02 | Value of a free attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 20 | TEXC_ATTR_L | FTR_ATTRIBUTE_LONG | |||
ATTRIBUTE_LI03 | Value of a free attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 20 | TEXC_ATTR_L | FTR_ATTRIBUTE_LONG | |||
ATTRIBUTE_LI04 | Value of a free attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 20 | TEXC_ATTR_L | FTR_ATTRIBUTE_LONG | |||
ATTRIBUTE_MI01 | Value of a free attribute (Char10) | FTR_ATTRIBUTE_MEDIUM | CHAR | 10 | TEXC_ATTR_M | FTR_ATTRIBUTE_MEDIUM | |||
ATTRIBUTE_MI02 | Value of a free attribute (Char10) | FTR_ATTRIBUTE_MEDIUM | CHAR | 10 | TEXC_ATTR_M | FTR_ATTRIBUTE_MEDIUM | |||
ATTRIBUTE_SI01 | Value of a free attribute (Char4) | FTR_ATTRIBUTE_SHORT | CHAR | 4 | TEXC_ATTR_S | FTR_ATTRIBUTE_SHORT | |||
ATTRIBUTE_DI01 | Value of a free attribute (Date) | FTR_ATTRIBUTE_DATE | DATS | 8 | FTR_ATTRIBUTE_DATE | ||||
PLANNING_PERIOD | Planning Period | TEM_PLANNING_PERIOD | CHAR | 3 | TEMC_PERIOD | TEM_PLANNING_PERIOD | |||
PLANNING_YEAR | Planning Year | FTR_PLANNING_YEAR | NUMC | 4 | GJAHR | GJAHR | |||
DUE_DATE | Due Date of an Exposure Position as a Differentiating Term | FTR_DUE_DATE_DIFF | DATS | 8 | Assigned to domain | FTR_EXPOSURE_DATE | |||
EXPOSURE_ID | Raw Exposure ID | FTR_RAW_EXPOS_ID | CHAR | 13 | Assigned to domain | ALPHA | FTR_RAW_EXPOS_ID | ||
ITEM_ID | Raw Exposure Line Item ID | FTR_ITEM_ID | NUMC | 5 | Assigned to domain | FTR_ITEM_ID | |||
SUBEXPOS_ID | Sub Raw Exposure ID | FTR_SUBITEM_ID | NUMC | 4 | FTR_SUBITEM_ID | ||||
EXP_APPROACH_CAT | Commodity Exposure Approach Category | FTR_EXP_APPR_CAT | NUMC | 1 | FTR_EXP_APPR_CAT | ||||
FIXING_STATUS | Fixing Status | FTR_FIXING_STATUS | CHAR | 1 | FTR_FIXING_STATUS | ||||
VAR_PRICE_CAT | Floating Price Category | FTR_VARIABLE_PRICE_CATEGORY | CHAR | 1 | FTR_VARIABLE_PRICE_CATEGORY | ||||
PRODUCT_TYPE | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
HED_COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
HEDGE_PLAN_ID | Hedge Plan ID | THM_PLANNERID | CHAR | 13 | THMEXT_PLANNER | ALPHA | THM_PLANNERID | PLN | |
HED_EXPOSURE_ID | Exposure ID | THM_EXPOSUREID | NUMC | 5 | Assigned to domain | THM_EXPOSUREID | |||
HED_TRANS_ID | E-HA: Transaction | THM_TRANSACTION | CHAR | 11 | Assigned to domain | ALPHA | THM_TRANSACTION | ||
OBJNR | Object Number (Exposure Positions) | FTR_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | |||
DUE_DATE_ATTR | Date on Which Exposure Is Due / Expires | FTR_EXPOSURE_DATE | DATS | 8 | Assigned to domain | FTR_EXPOSURE_DATE | |||
TRANSACTION_ACT | Transaction Activity (E-HA) | THM_TRANSACT | NUMC | 2 | Assigned to domain | THM_TRANSACT | |||
REFERENCE | Reference | FTR_EXPOSURE_REFERENCE | CHAR | 16 | CHAR16 | ||||
DESCRIPTION | Description of an exposure position | FTR_EXPOSURE_TEXT | CHAR | 50 | TEXT50 | ||||
ARCHIVE_STATE | Archive Status | FTR_ARCHIVE_STATE | CHAR | 1 | FTR_ARCHIVE_STATE | ||||
LOCATION | Pricing Location | TPM_DEL_LOCATION | CHAR | 4 | Assigned to domain | TPM_DEL_LOCATION | |||
ABSTR_COMM_ID | Abstract Commodity ID (Parent) | TRCO_ABSTR_COMM_ID | CHAR | 18 | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | ||
PRODUCT_CAT | Product Category | SANLF | NUMC | 3 | Assigned to domain | VVSANLF | |||
DIRECTION | Direction of Position | FTI_DIRECTION | CHAR | 1 | CHAR1 | ||||
PRICE_TYPE | Fixed/Floating Price Indicator | FTI_FIX_FLOATING_INDICATOR | CHAR | 1 | FTI_FIX_FLOATING_INDICATOR | ||||
OBJECT | Object Number (Exposure Positions) | FTR_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | |||
QUANT | Quantity on Original/Contract Unit of Measure | FTI_QUAN | QUAN | 25(5) | FTI_CTY_QUAN | ||||
QUANT_D | Quantity in Display Unit of Measure | FTI_QUAN_DISP | QUAN | 25(5) | FTI_CTY_QUAN | ||||
UOM | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DUOM | Display UOM for Commodity | FTI_CTY_DISP_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
NPV_PC | RM Net Present Value in Position Currency | TV_NPV_PC | CURR | 15(2) | WERTV8_TR | ||||
NPV_DC | RM NPV in Display Currency from Position Currency | TV_NPV_DC | CURR | 15(2) | WERTV8_TR | ||||
PCURR | Position Currency | TPM_POSITION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
DCURR | Display Currency | FTI_ANZGW | CUKY | 5 | Assigned to domain | WAERS | FFZ | ||
CREATION_DATE | First Entered on | DERF | DATS | 8 | DATUM | ||||
CREATION_TIME | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
CREATION_USER | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
CREATION_TCODE | Transaction Code | TCODE | CHAR | 20 | Assigned to domain | TCODE | TCD | ||
LASTCHANGE_DATE | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
LASTCHANGE_TIME | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
LASTCHANGE_USER | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
LASTCHANGE_TCODE | Transaction Code | TCODE | CHAR | 20 | Assigned to domain | TCODE | TCD |
Key field | Non-key field |
How do I retrieve data from SAP structure FTI_LDB_TR_EXP_POS using ABAP code?
As FTI_LDB_TR_EXP_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_TR_EXP_POS as there is no data to select.How to access SAP table FTI_LDB_TR_EXP_POS
Within an ECC or HANA version of SAP you can also view further information about FTI_LDB_TR_EXP_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