SAP ABAP Table FTI_BIW_CFM_VALUES (CFM: Market Values & Simulated Values of Position Management)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ CFM_TR_BIW (Package) CFM: Connection to BW

Basic Data

Table Category	INTTAB	Structure
Structure	FTI_BIW_CFM_VALUES	Table Relationship Diagram
Short Description	CFM: Market Values & Simulated Values of Position Management

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	TR_ACC_CODE	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	TRGC_TR_ACC_CODE
4	VALUATION_AREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	TRGC_VAL_AREA
5	VALUATION_CLASS	☐	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	TRGC_VAL_CLASS
6	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
7	PORTFOLIO	☐	TPM_PORTFOLIO_DIFF	RPORTB	CHAR	10	0	Portfolio as Differentiation Characteristic	TWPOB
8	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
9	LOANS_CONTRACT	☐	RANL	RANL	CHAR	13	0	Contract Number	VDARL
10	DEAL_NUMBER	☐	FTI_POSRFHA	T_RFHA	CHAR	13	0	Financial Transaction That Creates a Position	VTBFHA
11	ACCOUNT_GROUP	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	TRGT_SECACCGRP
12	SECURITY_ACCOUNT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
13	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
14	SECACC_TYPE	☐	TPM_SECACC_TYPE	TPM_SECACC_TYPE	CHAR	3	0	Securities Account Type	TRSC_SECACC_TYPE
15	FLAG_LONG_SHORT	☐	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position
16	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
17	DLOTGENERATION	☐	DLOTGENERATION	DATUM	DATS	8	0	Date On Which Lot Was Generated
18	TLOTGENERATION	☐	TLOTGENERATION	UZEIT	TIMS	6	0	Lot Generation Time
19	LOTGENERATION_US	☐	FTI_LOTGENERATIONUSER	SYCHAR12	CHAR	12	0	Lot Entered By
20	LOTGENERATION_CT	☐	FTI_LOTGENERATION_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category Which Generated the Lot	*
21	LOTPOS_INIT_DATE	☐	FTI_LOTPOSITION_INIT_DATE	TPM_POSITION_DATE	DATS	8	0	Position Acquisition Date of a Lot
22	LOTPOS_ORG_DATE	☐	FTI_LOTPOSITION_ORG_DATE	TPM_POSITION_DATE	DATS	8	0	Original Position Acquisition Date of a Lot
23	LOTGEN_DEALNR	☐	FTI_LOTGENERATION_DEALNR	T_RFHA	CHAR	13	0	Lot-Generating Transaction Number	*
24	STICHTAG	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
25	PEFFZINS	☐	FTI_EFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
26	SHWHR	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	TCURC
27	SVWHR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
28	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
29	WVERB1	☐	FTI_WHR_SHORT	WAERS	CUKY	5	0	Nominal currency borrowing/sale/outgoing side/short	TCURC
30	WFORD1	☐	FTI_WHR_LONG	WAERS	CUKY	5	0	Nominal currency investment/purchase incoming side/long	TCURC
31	NOMINAL_AMT_O_PC	☐	FTI_NOMINAL_OUT_PCOUT	TPM_AMOUNT	CURR	21	2	Nominal Value, Outgoing Side, in Position Crcy (Outg. Side)
32	NOMINAL_AMT_I_PC	☐	FTI_NOMINAL_IN_PCIN	TPM_AMOUNT	CURR	21	2	Nominal Value, Incoming Side, in Position Crcy (Inc. Side)
33	MARKET_PC	☐	FTI_MARKET_PC	TPM_AMOUNT	CURR	21	2	Market Value in Position Currency
34	NPV_PC	☐	TV_NPV_PC	WERTV8_TR	CURR	15	2	RM Net Present Value in Position Currency
35	CLEAN_PRICE_PC	☐	TV_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
36	BPVALUE_PC	☐	TV_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Position Currency
37	MAC_DURATION	☐	TV_MAC_DURATION	DEC9_3SIGN	DEC	12	3	Macaulay Duration
38	MOD_DURATION	☐	TV_MOD_DURATION	DEC9_3SIGN	DEC	12	3	Fisher-Weil Duration
39	S_VAL_TI_PC	☐	FTI_S_VAL_TI_PC	TPM_AMOUNT	CURR	21	2	Security Valuation in Position Currency (Simulation)
40	S_VAL_TI_LC	☐	FTI_S_VAL_TI_LC	TPM_AMOUNT	CURR	21	2	Security Valuation in Local Currency (Simulation)
41	S_VAL_TI_VC	☐	FTI_S_VAL_TI_VC	TPM_AMOUNT	CURR	21	2	Security Valuation in Valuation Currency (Simulation)
42	S_VAL_FX_LC	☐	FTI_S_VAL_FX_LC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Local Currency (Simulation)
43	S_VAL_FX_VC	☐	FTI_S_VAL_FX_VC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Valuation Crcy (Simulation)
44	S_VAL_CH_TI_PC	☐	FTI_S_VAL_CH_TI_PC	TPM_AMOUNT	CURR	21	2	Valuation of Capitalized Costs, Sec., in Pos. Crcy (Simul.)
45	S_VAL_CH_TI_LC	☐	FTI_S_VAL_CH_TI_LC	TPM_AMOUNT	CURR	21	2	Valuation of Capitalized Costs, Sec., in Local Crcy (Simul.)
46	S_VAL_CH_TI_VC	☐	FTI_S_VAL_CH_TI_VC	TPM_AMOUNT	CURR	21	2	Valuation of Capitalized Costs, Sec., in Val. Crcy (Simul.)
47	S_VAL_CH_FX_LC	☐	FTI_S_VAL_CH_FX_LC	TPM_AMOUNT	CURR	21	2	Valuation of Capitalized Costs, FX, in Local Crcy (Simul.)
48	S_VAL_CH_FX_VC	☐	FTI_S_VAL_CH_FX_VC	TPM_AMOUNT	CURR	21	2	Valuation of Capitalized Costs, FX, in Val. Crcy (Simul.)
49	S_AMORT_PC	☐	FTI_S_AMORT_PC	TPM_AMOUNT	CURR	21	2	Amortization in Position Currency (Simulation)
50	S_AMORT_LC	☐	FTI_S_AMORT_LC	TPM_AMOUNT	CURR	21	2	Amortization in Local Currency (Simulation)
51	S_AMORT_VC	☐	FTI_S_AMORT_VC	TPM_AMOUNT	CURR	21	2	Amortization in Valuation Currency (Simulation)
52	S_DISAGIO_PC	☐	FTI_S_DISAGIO_PC	TPM_AMOUNT	CURR	21	2	Cleared PD Def./Tax Compensation in Pos. Crcy: Simulation
53	S_DISAGIO_LC	☐	FTI_S_DISAGIO_LC	TPM_AMOUNT	CURR	21	2	Cleared PD Def./Tax Compensation in Local Crcy: Simulation
54	S_DISAGIO_VC	☐	FTI_S_DISAGIO_VC	TPM_AMOUNT	CURR	21	2	Cleared PD Def./Tax Compensation in Val. Crcy: Simulation
55	S_VAL_TI_NPL_PC	☐	FTI_S_VAL_TI_NPL_PC	TPM_AMOUNT	CURR	21	2	Security Valuation, Not Affecting P/L, in PC (Simulation)
56	S_VAL_TI_NPL_LC	☐	FTI_S_VAL_TI_NPL_LC	TPM_AMOUNT	CURR	21	2	Security Valuation, Not Affecting P/L, in LC (Simulation)
57	S_VAL_TI_NPL_VC	☐	FTI_S_VAL_TI_NPL_VC	TPM_AMOUNT	CURR	21	2	Security Valuation, Not Affecting P/L, in VC (Simulation)
58	S_VAL_FX_NPL_LC	☐	FTI_S_VAL_FX_NPL_LC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation, Not Aff. P/L, in LC (Simulation)
59	S_VAL_FX_NPL_VC	☐	FTI_S_VAL_FX_NPL_VC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation, Not Aff. P/L, in VC (Simulation)
60	S_VAL_CH_TI_N_PC	☐	FTI_S_VAL_CH_TI_NPL_PC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Sec., Not Aff. P/L, in PC (Sim.)
61	S_VAL_CH_TI_N_LC	☐	FTI_S_VAL_CH_TI_NPL_LC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Sec., Not Aff. P/L, in LC (Sim.)
62	S_VAL_CH_TI_N_VC	☐	FTI_S_VAL_CH_TI_NPL_VC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Sec., Not Aff. P/L, in VC (Sim.)
63	S_VAL_CH_FX_N_LC	☐	FTI_S_VAL_CH_FX_NPL_LC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, FX, Not Affecting P/L, in LC (Sim.)
64	S_VAL_CH_FX_N_VC	☐	FTI_S_VAL_CH_FX_NPL_VC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, FX, Not Affecting P/L, in VC (Sim.)
65	S_SPOTVALP_LC	☐	FTI_S_SPOTVALP_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Purchase Currency, in Local Crcy: Simulation
66	S_SPOTVALP_VC	☐	FTI_S_SPOTVALP_VC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Purchase Currency, in Val. Crcy: Simulation
67	S_SPOTVALS_LC	☐	FTI_S_SPOTVALS_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Sale Currency, in Local Crcy: Simulation
68	S_SPOTVALS_VC	☐	FTI_S_SPOTVALS_VC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Sale Currency, in Valuation Crcy: Simulation
69	S_SWAPACC_PC	☐	FTI_S_SWAPACC_PC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Position Crcy (Simulation)
70	S_SWAPACC_LC	☐	FTI_S_SWAPACC_LC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Local Currency: Simulation
71	S_SWAPACC_VC	☐	FTI_S_SWAPACC_VC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Valuation Crcy: Simulation
72	S_SWAPVAL_LC	☐	FTI_S_SWAPVAL_LC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Local Currency: Simulation
73	S_SWAPVAL_VC	☐	FTI_S_SWAPVAL_VC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Valuation Currency: Simulation
74	S_VALID_DATE	☐	TPM_VALID_DATE	DATS	DATS	8	0	Date of Found Rate or Present Value
75	S_VALID_RATE_DAT	☐	TPM_VALID_RATE_DATE	DATS	DATS	8	0	Date of Exchange Rate Found
76	S_MAP	☐	TPM_MAP	VVPKTKUR	DEC	15	6	Market Price
77	S_MAR_FE	☐	TPM_MAR_FE	UKURS	DEC	9	5	Exchange Rate - Position/Valuation Currency on Market
78	S_SPOT_RATE_P	☐	TPM_SPOT_RATE_P	UKURS	DEC	9	5	Spot Rate Purchase Currency/Valuation Currency in the Market
79	S_SPOT_RATE_S	☐	TPM_SPOT_RATE_S	UKURS	DEC	9	5	Spot Rate Sales Currency/Valuation Currency in the Market
80	S_SWAP_RATE_P	☐	TPM_SWAP_RATE_P	TB_DEVSWSA	DEC	9	5	Swap Rate Purchase Currency/Valuation Currency in the Market
81	S_SWAP_RATE_S	☐	TPM_SWAP_RATE_S	TB_DEVSWSA	DEC	9	5	Swap Rate Sales Currency/Valuation Currency in the Market

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTI_BIW_CFM_VALUES	ACCOUNT_GROUP	TRGT_SECACCGRP	SEC_ACCT_GRP
2	FTI_BIW_CFM_VALUES	BUKRS	T001	BUKRS
3	FTI_BIW_CFM_VALUES	DEAL_NUMBER	VTBFHA	RFHA
4	FTI_BIW_CFM_VALUES	GSART	TZPA	GSART
5	FTI_BIW_CFM_VALUES	LOANS_CONTRACT	VDARL	RANL
6	FTI_BIW_CFM_VALUES	MANDT	T000	MANDT
7	FTI_BIW_CFM_VALUES	PORTFOLIO	TWPOB	RPORTB
8	FTI_BIW_CFM_VALUES	POSITION_ACCOUNT	TRFT_POS_ACCOUNT	POS_ACCOUNT
9	FTI_BIW_CFM_VALUES	SBWHR	TCURC	WAERS
10	FTI_BIW_CFM_VALUES	SECACC_TYPE	TRSC_SECACC_TYPE	SECACC_TYPE
11	FTI_BIW_CFM_VALUES	SECURITY_ACCOUNT	TWD01	RLDEPO
12	FTI_BIW_CFM_VALUES	SECURITY_ID	VWPANLA	RANL
13	FTI_BIW_CFM_VALUES	SHWHR	TCURC	WAERS
14	FTI_BIW_CFM_VALUES	TR_ACC_CODE	TRGC_TR_ACC_CODE	TR_ACC_CODE
15	FTI_BIW_CFM_VALUES	VALUATION_AREA	TRGC_VAL_AREA	VALUATION_AREA
16	FTI_BIW_CFM_VALUES	VALUATION_CLASS	TRGC_VAL_CLASS	VALUATION_CLASS
17	FTI_BIW_CFM_VALUES	WFORD1	TCURC	WAERS
18	FTI_BIW_CFM_VALUES	WVERB1	TCURC	WAERS

History

Last changed by/on	SAP	20110901
SAP Release Created in	110