FTI_LDB_TR_POSITION_PROJ_VALUE SAP (Differentiations and Position Values) Structure details
Description: Differentiations and Position Values
Related tables to FTI_LDB_TR_POSITION_PROJ_VALUE
Access table FTI_LDB_TR_POSITION_PROJ_VALUE
Structure field list including key, data, relationships and ABAP select examples
FTI_LDB_TR_POSITION_PROJ_VALUE 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 "Differentiations and Position Values" 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_POSITION_PROJ_VALUE TYPE FTI_LDB_TR_POSITION_PROJ_VALUE.
The FTI_LDB_TR_POSITION_PROJ_VALUE table consists of various fields, each holding specific information or linking keys about Differentiations and Position Values data available in SAP. These include TR_ACC_CODE (Accounting Code), VALUATION_AREA (Valuation Area), VALUATION_CLASS (Valuation Class), GSART (Product Type).. 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_POSITION_PROJ_VALUE 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 |
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
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 as Differentiation Characteristic | TPM_PORTFOLIO_DIFF | CHAR | 10 | TWPOB | RPORTB | |||
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 |
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 | RLDEPO | CHAR | 10 | TWD01 | RLDEPO | DEP | ACC_CCD_CORE | |
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 | |
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 | TRDTS_BT_CAT | TPM_BUSTRANSCAT | |||
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 | |
POSITION_OID | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID | ||||
UNITS | Number of units | FTI_UNITS | DEC | 22(6) | TPM_UNITS | ||||
NOMINAL_AMT_PC | Nominal Amount in Position Currency | FTI_NOMINAL_AMT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_ORG_AMT_PC | Original Nominal Amount in Position Currency | TPM_NOMINAL_ORG_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
SHWHR | 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 | ||||
EFFECTIVE_DORMANT_LC | Effective Dormant Amount in Local Currency | FTI_EFFECTIVE_DORMANT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFECTIVE_DORMANT_PC | Effective Amount (Dormant) in Position Currency | FTI_EFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFECTIVE_LC | Effective Amount in Local Currency | FTI_EFFECTIVE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFECTIVE_PC | Effective Amount in Position Currency | FTI_EFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
FISCAL_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
HADJ_LC | Hedge Adjustment in Local Currency | FTI_HADJ_LC | CURR | 21(2) | TPM_AMOUNT | ||||
HADJ_PC | Hedge Adjustment in Position Currency | FTI_HADJ_PC | CURR | 21(2) | TPM_AMOUNT | ||||
HINST_NUMBER | Hedging Instrument Number | TPM_HINST_NUMBER | CHAR | 10 | ALPHA | TPM_HINST_NUMBER | |||
HITEM_NUMBER | Hedged Item Number | TPM_HITEM_NUMBER | CHAR | 10 | ALPHA | TPM_HITEM_NUMBER | |||
HREL_NUMBER | Hedging Relationship Number (External/Internal) | TPM_HREL_NUMBER | CHAR | 10 | ALPHA | TPM_HREL_NUMBER | |||
INEFFECTIVE_DORMANT_LC | Ineffective Dormant Amount in Local Currency | FTI_INEFFECTIVE_DORMANT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFECTIVE_DORMANT_PC | Ineffective Amount (Dormant) in Position Currency | FTI_INEFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFECTIVE_LC | Ineffective Amount in Local Currency | FTI_INEFFECTIVE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFECTIVE_PC | Ineffective Amount in Position Currency | FTI_INEFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
ORIG_VAD_LC | Original Value Adjustment in Local Currency | FTI_ORIG_VAD_LC | CURR | 21(2) | TPM_AMOUNT | ||||
ORIG_VAD_PC | Original Value Adjustment in Position Currency | FTI_ORIG_VAD_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_GAIN_LC | Value Adjustment of Gains in Local Currency | FTI_VAD_GAIN_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_GAIN_PC | Value Adjustment of Gains in Position Currency | FTI_VAD_GAIN_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_LOSS_LC | Value Adjustment of Losses in Local Currency | FTI_VAD_LOSS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_LOSS_PC | Value Adjustment of Losses in Position Currency | FTI_VAD_LOSS_PC | CURR | 21(2) | TPM_AMOUNT |
Key field | Non-key field |
How do I retrieve data from SAP structure FTI_LDB_TR_POSITION_PROJ_VALUE using ABAP code?
As FTI_LDB_TR_POSITION_PROJ_VALUE 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_POSITION_PROJ_VALUE as there is no data to select.How to access SAP table FTI_LDB_TR_POSITION_PROJ_VALUE
Within an ECC or HANA version of SAP you can also view further information about FTI_LDB_TR_POSITION_PROJ_VALUE 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