FTI_BIW_CFM_VALUES SAP (CFM: Market Values & Simulated Values of Position Management) Structure details
Description: CFM: Market Values & Simulated Values of Position Management
Related tables to FTI_BIW_CFM_VALUES
Access table FTI_BIW_CFM_VALUES
Structure field list including key, data, relationships and ABAP select examples
FTI_BIW_CFM_VALUES 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 "CFM: Market Values & Simulated Values of Position Management" 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_BIW_CFM_VALUES TYPE FTI_BIW_CFM_VALUES.
The FTI_BIW_CFM_VALUES table consists of various fields, each holding specific information or linking keys about CFM: Market Values & Simulated Values of Position Management data available in SAP. These include BUKRS (Company Code), TR_ACC_CODE (Accounting Code), VALUATION_AREA (Valuation Area), VALUATION_CLASS (Valuation Class).. 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_BIW_CFM_VALUES 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 | |||
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 | |
SECACC_TYPE | Securities Account Type | TPM_SECACC_TYPE | CHAR | 3 | TRSC_SECACC_TYPE | TPM_SECACC_TYPE | |||
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_US | Lot Entered By | FTI_LOTGENERATIONUSER | CHAR | 12 | SYCHAR12 | ||||
LOTGENERATION_CT | 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_DEALNR | Lot-Generating Transaction Number (Listed Derivatives) | FTI_LOTGENERATION_DEALNR | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | F4_TRANS_NO | |
STICHTAG | Key date | VVSTDAT | DATS | 8 | VVSTDAT | KEYDATE | |||
PEFFZINS | Effective Interest Rate | FTI_EFFZINS | 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 (Currency of Position Amount) | SBWHR | CUKY | 5 | TCURC | WAERS | |||
WVERB1 | Nominal currency borrowing/sale/outgoing side/short | FTI_WHR_SHORT | CUKY | 5 | TCURC | WAERS | |||
WFORD1 | Nominal currency investment/purchase incoming side/long | FTI_WHR_LONG | CUKY | 5 | TCURC | WAERS | |||
NOMINAL_AMT_O_PC | Nominal Value, Outgoing Side, in Position Crcy (Outg. Side) | FTI_NOMINAL_OUT_PCOUT | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_AMT_I_PC | Nominal Value, Incoming Side, in Position Crcy (Inc. Side) | FTI_NOMINAL_IN_PCIN | CURR | 21(2) | TPM_AMOUNT | ||||
MARKET_PC | Market Value in Position Currency | FTI_MARKET_PC | CURR | 21(2) | TPM_AMOUNT | ||||
NPV_PC | RM Net Present Value in Position Currency | TV_NPV_PC | CURR | 15(2) | WERTV8_TR | ||||
NPV_LONG_PC | RM NPV of Incoming Side in Currency of Incoming Side | TV_NPV_LONG_PC | CURR | 15(2) | WERTV8_TR | ||||
NPV_SHORT_PC | RM NPV of Outgoing Side in Currency of Outgoing Side | TV_NPV_SHORT_PC | CURR | 15(2) | WERTV8_TR | ||||
CLEAN_PRICE_PC | Clean Price in Position Currency | TV_CLEAN_PRICE_PC | CURR | 17(2) | T_PRESVAL | ||||
BPVALUE_PC | Basis Point Value in Position Currency | TV_VALBP_PC | CURR | 17(2) | T_PRESVAL | ||||
MAC_DURATION | Macaulay Duration | TV_MAC_DURATION | DEC | 12(3) | DEC9_3SIGN | ||||
MOD_DURATION | Modified Duration | TV_MOD_DURATION | DEC | 12(3) | DEC9_3SIGN | ||||
YTM | Yield to Maturity | TV_YTM | DEC | 12(5) | DEC7_5SIGN | ||||
FW_DURATION | Fisher/Weil Duration | TV_FISHER_WEIL_DURATION | DEC | 12(3) | DEC9_3SIGN | ||||
CONVEXITY | Convexity with 5 Decimal Places | TV_CONVEXITY_MORE_ACCURATE | DEC | 11(5) | DEC6_5SIGN | ||||
DELTA | Delta, 1st derivation of premium based on underlying rate | TV_DELTA | DEC | 15(10) | T_SENSI | ||||
GAMMA | Gamma, 2nd derivation of premium based on underlying rate | TV_GAMMA | DEC | 14(8) | T_GAMMA | ||||
THETA | Theta, 1st derivation of premium according to time | TV_THETA | DEC | 15(10) | T_SENSI | ||||
VEGA | Vega, 1st Volatility Derivative | TV_VEGA | DEC | 15(10) | T_SENSI | ||||
S_VAL_TI_PC | Security Valuation in Position Currency (Simulation) | FTI_S_VAL_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_TI_LC | Security Valuation in Local Currency (Simulation) | FTI_S_VAL_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_TI_VC | Security Valuation in Valuation Currency (Simulation) | FTI_S_VAL_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_FX_LC | Foreign Currency Valuation in Local Currency (Simulation) | FTI_S_VAL_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_FX_VC | Foreign Currency Valuation in Valuation Crcy (Simulation) | FTI_S_VAL_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VALFXAAQUVL_LC | FX Valuation of Amort. Acquisition Val. in LC (Simulation) | FTI_S_VAL_FX_AMAQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VALFXAAQUVL_VC | FX Valuation of Amort. Acquisition Val. in VC (Simulation) | FTI_S_VAL_FX_AMAQU_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_PC | Valuation of Capitalized Costs, Sec., in Pos. Crcy (Simul.) | FTI_S_VAL_CH_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_LC | Valuation of Capitalized Costs, Sec., in Local Crcy (Simul.) | FTI_S_VAL_CH_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_VC | Valuation of Capitalized Costs, Sec., in Val. Crcy (Simul.) | FTI_S_VAL_CH_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_FX_LC | Valuation of Capitalized Costs, FX, in Local Crcy (Simul.) | FTI_S_VAL_CH_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_FX_VC | Valuation of Capitalized Costs, FX, in Val. Crcy (Simul.) | FTI_S_VAL_CH_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_AMORT_PC | Amortization in Position Currency (Simulation) | FTI_S_AMORT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_AMORT_LC | Amortization in Local Currency (Simulation) | FTI_S_AMORT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_AMORT_VC | Amortization in Valuation Currency (Simulation) | FTI_S_AMORT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_DISAGIO_PC | Cleared PD Def./Tax Compensation in Pos. Crcy: Simulation | FTI_S_DISAGIO_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_DISAGIO_LC | Cleared PD Def./Tax Compensation in Local Crcy: Simulation | FTI_S_DISAGIO_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_DISAGIO_VC | Cleared PD Def./Tax Compensation in Val. Crcy: Simulation | FTI_S_DISAGIO_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_TI_NPL_PC | Security Valuation, Not Affecting P/L, in PC (Simulation) | FTI_S_VAL_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_TI_NPL_LC | Security Valuation, Not Affecting P/L, in LC (Simulation) | FTI_S_VAL_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_TI_NPL_VC | Security Valuation, Not Affecting P/L, in VC (Simulation) | FTI_S_VAL_TI_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_FX_NPL_LC | Foreign Currency Valuation, Not Aff. P/L, in LC (Simulation) | FTI_S_VAL_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_FX_NPL_VC | Foreign Currency Valuation, Not Aff. P/L, in VC (Simulation) | FTI_S_VAL_FX_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_N_PC | Valuation of Cap. Costs, Sec., Not Aff. P/L, in PC (Sim.) | FTI_S_VAL_CH_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_N_LC | Valuation of Cap. Costs, Sec., Not Aff. P/L, in LC (Sim.) | FTI_S_VAL_CH_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_N_VC | Valuation of Cap. Costs, Sec., Not Aff. P/L, in VC (Sim.) | FTI_S_VAL_CH_TI_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_FX_N_LC | Valuation of Cap. Costs, FX, Not Affecting P/L, in LC (Sim.) | FTI_S_VAL_CH_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_FX_N_VC | Valuation of Cap. Costs, FX, Not Affecting P/L, in VC (Sim.) | FTI_S_VAL_CH_FX_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SPOTVALP_LC | Spot Valuation, Purchase Currency, in Local Crcy: Simulation | FTI_S_SPOTVALP_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SPOTVALP_VC | Spot Valuation, Purchase Currency, in Val. Crcy: Simulation | FTI_S_SPOTVALP_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SPOTVALS_LC | Spot Valuation, Sale Currency, in Local Crcy: Simulation | FTI_S_SPOTVALS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SPOTVALS_VC | Spot Valuation, Sale Currency, in Valuation Crcy: Simulation | FTI_S_SPOTVALS_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SWAPACC_PC | Swap/Margin Accrual/Deferral in Position Crcy (Simulation) | FTI_S_SWAPACC_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SWAPACC_LC | Swap/Margin Accrual/Deferral in Local Currency: Simulation | FTI_S_SWAPACC_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SWAPACC_VC | Swap/Margin Accrual/Deferral in Valuation Crcy: Simulation | FTI_S_SWAPACC_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SWAPVAL_LC | Swap Valuation in Local Currency: Simulation | FTI_S_SWAPVAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SWAPVAL_VC | Swap Valuation in Valuation Currency: Simulation | FTI_S_SWAPVAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VALID_DATE | Date of Found Rate or Present Value | TPM_VALID_DATE | DATS | 8 | DATS | ||||
S_VALID_RATE_DAT | Date of Exchange Rate Found | TPM_VALID_RATE_DATE | DATS | 8 | DATS | ||||
S_MAP | Market Price | TPM_MAP | DEC | 15(6) | VVPKTKUR | ||||
S_MAR_FE | Exchange Rate - Position/Valuation Currency on Market | TPM_MAR_FE | DEC | 9(5) | EXCRT | UKURS | |||
S_SPOT_RATE_P | Spot Rate Purchase Currency/Valuation Currency in the Market | TPM_SPOT_RATE_P | DEC | 9(5) | EXCRT | UKURS | |||
S_SPOT_RATE_S | Spot Rate Sales Currency/Valuation Currency in the Market | TPM_SPOT_RATE_S | DEC | 9(5) | EXCRT | UKURS | |||
S_SWAP_RATE_P | Swap Rate Purchase Currency/Valuation Currency in the Market | TPM_SWAP_RATE_P | DEC | 9(5) | TB_DEVSWSA | ||||
S_SWAP_RATE_S | Swap Rate Sales Currency/Valuation Currency in the Market | TPM_SWAP_RATE_S | DEC | 9(5) | TB_DEVSWSA |
Key field | Non-key field |
How do I retrieve data from SAP structure FTI_BIW_CFM_VALUES using ABAP code?
As FTI_BIW_CFM_VALUES 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_BIW_CFM_VALUES as there is no data to select.How to access SAP table FTI_BIW_CFM_VALUES
Within an ECC or HANA version of SAP you can also view further information about FTI_BIW_CFM_VALUES 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