SAP ABAP Table FTI_LDB_BW_CFM_VALUES (Structure for LDB as Generic Data Source for Market Data)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ FTI_LDB (Package) Logical Databases for the R/3 CFM Information System

Basic Data

Table Category	INTTAB	Structure
Structure	FTI_LDB_BW_CFM_VALUES	Table Relationship Diagram
Short Description	Structure for LDB as Generic Data Source for Market Data

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	.INCLUDE	☐				0	0	CFM: Market Values & Simulated Values of Position Management
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	TR_ACC_CODE	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	TRGC_TR_ACC_CODE
5	VALUATION_AREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	TRGC_VAL_AREA
6	VALUATION_CLASS	☐	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	TRGC_VAL_CLASS
7	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
8	PORTFOLIO	☐	TPM_PORTFOLIO_DIFF	RPORTB	CHAR	10	0	Portfolio as Differentiation Characteristic	TWPOB
9	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
10	LOANS_CONTRACT	☐	RANL	RANL	CHAR	13	0	Contract Number	VDARL
11	DEAL_NUMBER	☐	FTI_POSRFHA	T_RFHA	CHAR	13	0	Financial Transaction That Creates a Position	VTBFHA
12	ACCOUNT_GROUP	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	TRGT_SECACCGRP
13	SECURITY_ACCOUNT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
14	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
15	SECACC_TYPE	☐	TPM_SECACC_TYPE	TPM_SECACC_TYPE	CHAR	3	0	Securities Account Type	TRSC_SECACC_TYPE
16	FLAG_LONG_SHORT	☐	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position
17	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
18	DLOTGENERATION	☐	DLOTGENERATION	DATUM	DATS	8	0	Date On Which Lot Was Generated
19	TLOTGENERATION	☐	TLOTGENERATION	UZEIT	TIMS	6	0	Lot Generation Time
20	LOTGENERATION_US	☐	FTI_LOTGENERATIONUSER	SYCHAR12	CHAR	12	0	Lot Entered By
21	LOTGENERATION_CT	☐	FTI_LOTGENERATION_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category Which Generated the Lot	*
22	LOTPOS_INIT_DATE	☐	FTI_LOTPOSITION_INIT_DATE	TPM_POSITION_DATE	DATS	8	0	Position Acquisition Date of a Lot
23	LOTPOS_ORG_DATE	☐	FTI_LOTPOSITION_ORG_DATE	TPM_POSITION_DATE	DATS	8	0	Original Position Acquisition Date of a Lot
24	LOTGEN_DEALNR	☐	FTI_LOTGENERATION_DEALNR	T_RFHA	CHAR	13	0	Lot-Generating Transaction Number	*
25	STICHTAG	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
26	PEFFZINS	☐	FTI_EFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
27	SHWHR	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	TCURC
28	SVWHR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
29	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
30	WVERB1	☐	FTI_WHR_SHORT	WAERS	CUKY	5	0	Nominal currency borrowing/sale/outgoing side/short	TCURC
31	WFORD1	☐	FTI_WHR_LONG	WAERS	CUKY	5	0	Nominal currency investment/purchase incoming side/long	TCURC
32	NOMINAL_AMT_O_PC	☐	FTI_NOMINAL_OUT_PCOUT	TPM_AMOUNT	CURR	21	2	Nominal Value, Outgoing Side, in Position Crcy (Outg. Side)
33	NOMINAL_AMT_I_PC	☐	FTI_NOMINAL_IN_PCIN	TPM_AMOUNT	CURR	21	2	Nominal Value, Incoming Side, in Position Crcy (Inc. Side)
34	MARKET_PC	☐	FTI_MARKET_PC	TPM_AMOUNT	CURR	21	2	Market Value in Position Currency
35	NPV_PC	☐	TV_NPV_PC	WERTV8_TR	CURR	15	2	RM Net Present Value in Position Currency
36	CLEAN_PRICE_PC	☐	TV_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
37	BPVALUE_PC	☐	TV_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Position Currency
38	MAC_DURATION	☐	TV_MAC_DURATION	DEC9_3SIGN	DEC	12	3	Macaulay Duration
39	MOD_DURATION	☐	TV_MOD_DURATION	DEC9_3SIGN	DEC	12	3	Fisher-Weil Duration
40	S_VAL_TI_PC	☐	FTI_S_VAL_TI_PC	TPM_AMOUNT	CURR	21	2	Security Valuation in Position Currency (Simulation)
41	S_VAL_TI_LC	☐	FTI_S_VAL_TI_LC	TPM_AMOUNT	CURR	21	2	Security Valuation in Local Currency (Simulation)
42	S_VAL_TI_VC	☐	FTI_S_VAL_TI_VC	TPM_AMOUNT	CURR	21	2	Security Valuation in Valuation Currency (Simulation)
43	S_VAL_FX_LC	☐	FTI_S_VAL_FX_LC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Local Currency (Simulation)
44	S_VAL_FX_VC	☐	FTI_S_VAL_FX_VC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Valuation Crcy (Simulation)
45	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.)
46	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.)
47	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.)
48	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.)
49	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.)
50	S_AMORT_PC	☐	FTI_S_AMORT_PC	TPM_AMOUNT	CURR	21	2	Amortization in Position Currency (Simulation)
51	S_AMORT_LC	☐	FTI_S_AMORT_LC	TPM_AMOUNT	CURR	21	2	Amortization in Local Currency (Simulation)
52	S_AMORT_VC	☐	FTI_S_AMORT_VC	TPM_AMOUNT	CURR	21	2	Amortization in Valuation Currency (Simulation)
53	S_DISAGIO_PC	☐	FTI_S_DISAGIO_PC	TPM_AMOUNT	CURR	21	2	Cleared PD Def./Tax Compensation in Pos. Crcy: Simulation
54	S_DISAGIO_LC	☐	FTI_S_DISAGIO_LC	TPM_AMOUNT	CURR	21	2	Cleared PD Def./Tax Compensation in Local Crcy: Simulation
55	S_DISAGIO_VC	☐	FTI_S_DISAGIO_VC	TPM_AMOUNT	CURR	21	2	Cleared PD Def./Tax Compensation in Val. Crcy: Simulation
56	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)
57	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)
58	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)
59	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)
60	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)
61	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.)
62	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.)
63	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.)
64	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.)
65	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.)
66	S_SPOTVALP_LC	☐	FTI_S_SPOTVALP_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Purchase Currency, in Local Crcy: Simulation
67	S_SPOTVALP_VC	☐	FTI_S_SPOTVALP_VC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Purchase Currency, in Val. Crcy: Simulation
68	S_SPOTVALS_LC	☐	FTI_S_SPOTVALS_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Sale Currency, in Local Crcy: Simulation
69	S_SPOTVALS_VC	☐	FTI_S_SPOTVALS_VC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Sale Currency, in Valuation Crcy: Simulation
70	S_SWAPACC_PC	☐	FTI_S_SWAPACC_PC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Position Crcy (Simulation)
71	S_SWAPACC_LC	☐	FTI_S_SWAPACC_LC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Local Currency: Simulation
72	S_SWAPACC_VC	☐	FTI_S_SWAPACC_VC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Valuation Crcy: Simulation
73	S_SWAPVAL_LC	☐	FTI_S_SWAPVAL_LC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Local Currency: Simulation
74	S_SWAPVAL_VC	☐	FTI_S_SWAPVAL_VC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Valuation Currency: Simulation
75	S_VALID_DATE	☐	TPM_VALID_DATE	DATS	DATS	8	0	Date of Found Rate or Present Value
76	S_VALID_RATE_DAT	☐	TPM_VALID_RATE_DATE	DATS	DATS	8	0	Date of Exchange Rate Found
77	S_MAP	☐	TPM_MAP	VVPKTKUR	DEC	15	6	Market Price
78	S_MAR_FE	☐	TPM_MAR_FE	UKURS	DEC	9	5	Exchange Rate - Position/Valuation Currency on Market
79	S_SPOT_RATE_P	☐	TPM_SPOT_RATE_P	UKURS	DEC	9	5	Spot Rate Purchase Currency/Valuation Currency in the Market
80	S_SPOT_RATE_S	☐	TPM_SPOT_RATE_S	UKURS	DEC	9	5	Spot Rate Sales Currency/Valuation Currency in the Market
81	S_SWAP_RATE_P	☐	TPM_SWAP_RATE_P	TB_DEVSWSA	DEC	9	5	Swap Rate Purchase Currency/Valuation Currency in the Market
82	S_SWAP_RATE_S	☐	TPM_SWAP_RATE_S	TB_DEVSWSA	DEC	9	5	Swap Rate Sales Currency/Valuation Currency in the Market
83	.INCLUDE	☐				0	0	Include for Transaction Attributes Rel. for Position (->LDB)
84	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
85	FINPROJ	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
86	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
87	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
88	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
89	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
90	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
91	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
92	PORTFOLIO_TM	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in