SAP ABAP Table VALS_CALC_BASIS (Calculation Basis for a Valuation Step)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-AC (Application Component) Transfer to Financial Accounting
     ⤷ FTR_VALUATION (Package) Treasury: General Valuation

Basic Data

Table Category	INTTAB	Structure
Structure	VALS_CALC_BASIS	Table Relationship Diagram
Short Description	Calculation Basis for a Valuation Step

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	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
2	SP_VAL_SEC_CAT	☐	TPM_SP_VAL_SEC_CAT	TPM_SP_VAL_SEC_CAT	CHAR	1	0	Special Valuation Category
3	LOANS_CONTRACT	☐	RANL	RANL	CHAR	13	0	Contract Number
4	DEAL_NUMBER	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
5	FLG_ACT_PASS	☐	TPM_ACTIVE_PASSIVE	TPM_ACTIVE_PASSIVE	CHAR	1	0	Indicator: Assets/Liabilities Position
6	OPEN_DATE	☐	TPM_OPEN_DATE	DATS	DATS	8	0	Open Date
7	OPEN_SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
8	CLOSE_DATE	☐	TPM_CLOSE_DATE	DATS	DATS	8	0	Close Date
9	CLOSE_SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
10	PURCHASE_CURR	☐	TPM_PURCHASE_CURR	WAERS	CUKY	5	0	Purchase Currency	*
11	SALE_CURR	☐	TPM_SALE_CURR	WAERS	CUKY	5	0	Sale Currency	*
12	LEAD_CURR	☐	TPM_LEAD_CURR	WAERS	CUKY	5	0	Leading Currency in Purchase/Sale Currency Pair	*
13	FOLL_CURR	☐	TPM_FOLL_CURR	WAERS	CUKY	5	0	Following Currency in Purchase/Sale Currency Pair	*
14	UNITS	☐	TPM_UNITS	TPM_UNITS	DEC	22	6	Units
15	NOMINAL_AMT	☐	TPM_NOMINAL_AMT	TPM_AMOUNT	CURR	21	2	Nominal Amount
16	NOMINAL_ORG_AMT	☐	TPM_NOMINAL_ORG_AMT	TPM_AMOUNT	CURR	21	2	Original Nominal Amount in Position Currency
17	NOMINAL_CURR	☐	TPM_NOMINAL_CURR	WAERS	CUKY	5	0	Nominal Currency	*
18	AM_VALUE_PC	☐	TPM_AMORTIZATION_VALUE_PC	TPM_AMOUNT	CURR	21	2	LAC/SAC Value
19	COMP_AM_VALUE_PC	☐	TPM_COMP_AM_VALUE_PC	TPM_AMOUNT	CURR	21	2	SAC Value Calculated with Previous Effective Interest Rate
20	AM_PRICE	☐	TPM_AMORTIZATION_PRICE	VVPKTKUR	DEC	15	6	LAC/SAC Rate
21	ACCRUE_VALUE_PC	☐	TPM_ACCRUE_VALUE_PC	TPM_AMOUNT	CURR	21	2	Target Value of Deferral Item for Purchase Value
22	OAM_VALUE_CL	☐	TPM_OAM_VALUE_CL	TPM_AMOUNT	CURR	21	2	Old Amortized Acquisition Value - Clean
23	OAM_VALUE_PC	☐	TPM_OAM_VALUE_PC	TPM_AMOUNT	CURR	21	2	Old Amortized Acquisition Value in Position Currency
24	OAM_VALUE_VC	☐	TPM_OAM_VALUE_VC	TPM_AMOUNT	CURR	21	2	Old Amortized Acquisition Value in Valuation Currency
25	OAV_CL	☐	TPM_OAV_CL	TPM_AMOUNT	CURR	21	2	Previous Amortization - Clean
26	OAV_PC	☐	TPM_OAV_PC	TPM_AMOUNT	CURR	21	2	Previous Amortization in Position Currency
27	OAV_VC	☐	TPM_OAV_VC	TPM_AMOUNT	CURR	21	2	Previous Amortization in Valuation Currency
28	OACV_CL	☐	TPM_OACV_CL	TPM_AMOUNT	CURR	21	2	Value of Deferral Item for Purchase Value to Date, Clean
29	OACV_PC	☐	TPM_OACV_PC	TPM_AMOUNT	CURR	21	2	Current Value of Deferral Item for Purchase Value in PC
30	OACV_VC	☐	TPM_OACV_VC	TPM_AMOUNT	CURR	21	2	Current Value of Deferral Item for Purchase Value in VC
31	ODISAGIO_CL	☐	TPM_DISAGIO_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Index-Clean Discount/Premium in Position Currency
32	ODISAGIO_PC	☐	TPM_DISAGIO_PC	TPM_AMOUNT	CURR	21	2	Discount/Premium in Position Currency
33	ODISAGIO_VC	☐	TPM_DISAGIO_VC	TPM_AMOUNT	CURR	21	2	Discount/Premium in Valuation Currency
34	EFF_RATE	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
35	EFF_RATE_NEW	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
36	SCHED_EFF_RATE	☐	RDPT_SCHEDULE_KEY_EFF_RATE		INT4	10	0	Key for Redemption Schedule that Explains Effect. Int. Rate
37	SCHED_FIX	☐	RDPT_SCHEDULE_KEY_FIX		INT4	10	0	Key for Fixed Redemption Schedule
38	ACV_EC_CL	☐	TPM_ACV_EC_CL	TPM_AMOUNT	CURR	21	2	Purchase Value Clean
39	ACV_EC_PC	☐	TPM_ACV_EC_PC	TPM_AMOUNT	CURR	21	2	Purchase Value in Position Currency
40	ACV_EC_VC	☐	TPM_ACV_EC_VC	TPM_AMOUNT	CURR	21	2	Purchase Value in Valuation Currency
41	ACV_CO_PC	☐	TPM_ACV_CO_PC	TPM_AMOUNT	CURR	21	2	Costs in Position Currency
42	ACV_CO_VC	☐	TPM_ACV_CO_VC	TPM_AMOUNT	CURR	21	2	Costs in Valuation Currency
43	ACP_EC	☐	TPM_ACP_EC	VVPKTKUR	DEC	15	6	Purchase Rate
44	ACR_FE	☐	TPM_ACR_FE	UKURS	DEC	9	5	Purchase Exchange Rate
45	ACR_FE_F	☐	TPM_INT_CURR_RATE	FLOATING	FLTP	16	16	Exchange Rate (Internal Display)
46	OAAV_EC_CL	☐	TPM_OAAV_EC_CL	TPM_AMOUNT	CURR	21	2	Purchase Value + Amortization to Date + Repayments, Clean
47	OAAV_EC_PC	☐	TPM_OAAV_EC_PC	TPM_AMOUNT	CURR	21	2	Purch. Value + Amort. to Date + Repayments in Position Crcy
48	OAAV_EC_VC	☐	TPM_OAAV_EC_VC	TPM_AMOUNT	CURR	21	2	Purch. Value + Amort. to Date + Repayments in Valuation Crcy
49	OAAP_EC	☐	TPM_OAAP_EC	VVPKTKUR	DEC	15	6	Price from Purchase Value + Amortization to Date
50	OAAR_FE	☐	TPM_OAAR_FE	UKURS	DEC	9	5	Exchange Rate from Purchase Value + Amortization to Date
51	OAAR_FE_F	☐	TPM_INT_CURR_RATE	FLOATING	FLTP	16	16	Exchange Rate (Internal Display)
52	FLG_COMP_COSTS	☐	TPM_COMP_COSTS	XFELD	CHAR	1	0	Indicator: if Components are Managed for Costs
53	PRICE_DATE	☐	TPM_VALID_DATE	DATS	DATS	8	0	Date of Found Rate or Present Value
54	RATE_DATE	☐	TPM_VALID_RATE_DATE	DATS	DATS	8	0	Date of Exchange Rate Found
55	OBV_EC_CL	☐	TPM_OBV_EC_IDX_CLEAN_PC	TPM_AMOUNT	CURR	21	2	Old Book Value Excluding Costs - Clean
56	OBV_EC_PC	☐	TPM_OBV_EC_PC	TPM_AMOUNT	CURR	21	2	Old Book Value Excluding Costs in Position Currency
57	OBV_EC_VC	☐	TPM_OBV_EC_VC	TPM_AMOUNT	CURR	21	2	Old Book Value Exclusive of Costs in Valuation Currency
58	OBV_CO_PC	☐	TPM_OBV_CO_PC	TPM_AMOUNT	CURR	21	2	Old Book Value of Costs in Position Currency
59	OBV_CO_VC	☐	TPM_OBV_CO_VC	TPM_AMOUNT	CURR	21	2	Old Book Value of Costs in Valuation Currency
60	OBP_EC	☐	TPM_OBP_EC	VVPKTKUR	DEC	15	6	Old Book Rate Excluding Costs
61	OBR_FE	☐	TPM_OBR_FE	UKURS	DEC	9	5	Old Foreign Exchange Book Rate
62	OBR_FE_F	☐	TPM_INT_CURR_RATE	FLOATING	FLTP	16	16	Exchange Rate (Internal Display)
63	MAV_PC	☐	TPM_MAV_PC	TPM_AMOUNT	CURR	21	2	Market Value in Position Currency
64	MAV_VC	☐	TPM_MAV_VC	TPM_AMOUNT	CURR	21	2	Market Value in Valuation Currency
65	MAP	☐	TPM_MAP	VVPKTKUR	DEC	15	6	Market Price
66	MAR_FE	☐	TPM_MAR_FE	UKURS	DEC	9	5	Exchange Rate - Position/Valuation Currency on Market
67	MAR_FE_F	☐	TPM_INT_CURR_RATE	FLOATING	FLTP	16	16	Exchange Rate (Internal Display)
68	MAR_FE_CAT	☐	TPM_TLV_MAR_CAT	KURST	CHAR	4	0	Rate Type of Market Exchange Rate for PC/VC	*
69	MAR_SPOTP	☐	TPM_SPOT_RATE_P	UKURS	DEC	9	5	Spot Rate Purchase Currency/Valuation Currency in the Market
70	MAR_SPOTS	☐	TPM_SPOT_RATE_S	UKURS	DEC	9	5	Spot Rate Sales Currency/Valuation Currency in the Market
71	MAR_SWAPP	☐	TPM_SWAP_RATE_P	TB_DEVSWSA	DEC	9	5	Swap Rate Purchase Currency/Valuation Currency in the Market
72	MAR_SWAPS	☐	TPM_SWAP_RATE_S	TB_DEVSWSA	DEC	9	5	Swap Rate Sales Currency/Valuation Currency in the Market
73	MAR_SWAPPS	☐	TPM_SWAP_RATE_PS	TB_DEVSWSA	DEC	9	5	Swap Rate Purc./Sale Curr. (Leading/Following Curr.) Market
74	MAR_SWAP_FC	☐	TPM_MAR_SWAP_FC	TPM_AMOUNT	CURR	21	2	Market Swap Based on Transaction in Following Currency
75	MAR_SWAP_VC	☐	TPM_MAR_SWAP_VC	TPM_AMOUNT	CURR	21	2	Market Swap Price for Transaction in Valuation Crcy
76	OVV_EC_TI_PC	☐	TPM_OVV_EC_TI_PC	TPM_AMOUNT	CURR	21	2	Security Valuation to Date in Position Currency
77	OVV_EC_TI_CL	☐	TPM_POSITION_AMT_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Amount in Position Currency Index-Clean
78	OVV_EC_TI_VC	☐	TPM_OVV_EC_TI_VC	TPM_AMOUNT	CURR	21	2	Security Valuation to Date in Valuation Currency
79	OVV_EC_FE_VC	☐	TPM_OVV_EC_FE_VC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation to Date in Valuation Currency
80	OVV_CO_TI_PC	☐	TPM_OVV_CO_TI_PC	TPM_AMOUNT	CURR	21	2	Costs, Security: Valuation to Date in Position Currency
81	OVV_CO_TI_VC	☐	TPM_OVV_CO_TI_VC	TPM_AMOUNT	CURR	21	2	Costs, Security: Valuation to Date in Valuation Currency
82	OVV_CO_FE_VC	☐	TPM_OVV_CO_FE_VC	TPM_AMOUNT	CURR	21	2	Costs, FX: Valuation to Date in Valuation Currency
83	OPV_VC	☐	TPM_OPV_VC	TPM_AMOUNT	CURR	21	2	Valuation to Date for Purchase Currency in Valuation Crcy
84	OSV_VC	☐	TPM_OSV_VC	TPM_AMOUNT	CURR	21	2	Valuation to Date for Sale Currency in Valuation Currency
85	OSAV_PC	☐	TPM_OSAV_PC	TPM_AMOUNT	CURR	21	2	Margin Accrual/Deferral to Date in Position Currency
86	OSAV_VC	☐	TPM_OSAV_VC	TPM_AMOUNT	CURR	21	2	Margin/Swap Accrual/Deferral to Date in Valuation Currency
87	OSVV_PC	☐	TPM_OSVV_PC	TPM_AMOUNT	CURR	21	2	Swap Valuation to Date in Position Currency
88	OSVV_VC	☐	TPM_OSVV_VC	TPM_AMOUNT	CURR	21	2	Swap Valuation to Date in Valuation Currency
89	SPV_PC	☐	TPM_SPV_PC	TPM_AMOUNT	CURR	21	2	Amount in Purchase Currency Based on Spot Prices
90	SPV_SC	☐	TPM_SPV_SC	TPM_AMOUNT	CURR	21	2	Amount in Sale Currency Based on Spot Prices
91	SPV_VC	☐	TPM_SPV_VC	TPM_AMOUNT	CURR	21	2	Amount in Valuation Currency Based on Spot Prices
92	FOV_PC	☐	TPM_FOV_PC	TPM_AMOUNT	CURR	21	2	Purchase Amount in Purchase Currency
93	FOV_SC	☐	TPM_FOV_SC	TPM_AMOUNT	CURR	21	2	Sale Amount in Sale Currency
94	FOV_VC	☐	TPM_FOV_VC	TPM_AMOUNT	CURR	21	2	Amount in Valuation Currency Resulting from Forward Rates
95	MARGIN_SWAP_FC	☐	TPM_MARGIN_SWAP_FC	TPM_AMOUNT	CURR	21	2	Total Swap from Transaction in Following Currency
96	MARGIN_SWAP_PC	☐	TPM_MARGIN_SWAP_PC	TPM_AMOUNT	CURR	21	2	Total Margin from Transaction in Position Currency
97	MARGIN_SWAP_VC	☐	TPM_MARGIN_SWAP_VC	TPM_AMOUNT	CURR	21	2	Total Margin/Swap from Transaction in Valuation Currency
98	OANSV_CL	☐	TPM_OANSV_CL	TPM_AMOUNT	CURR	21	2	Existing Negotion Spread Amortization Clean
99	OANSV_PC	☐	TPM_OANSV_PC	TPM_AMOUNT	CURR	21	2	Existing Negotion Spread Amortization in Postion Currency
100	OANSV_VC	☐	TPM_OANSV_VC	TPM_AMOUNT	CURR	21	2	Existing Negotion Spread Amortization in Valuation Currency
101	.INCLUDE	☐				0	0	Treasury: Calculation Basis of the Price Index Valuation
102	PRICE_INDEX	☐	TIDX_INDEX_NAME	TIDX_INDEX_NAME	CHAR	15	0	Name of Price Index	*
103	VALUE_DATE_ORIGINAL	☐	TIDX_VALUE_DATE		DATS	8	0	Effective From
104	VALUE_DATE_ADJUSTED	☐	TIDX_VALUE_DATE		DATS	8	0	Effective From
105	INTERPOLATION_DAYS	☐	TIDX_INTERPOLATION_DAYS		INT4	10	0	Interpolation Days
106	INTERPOLATION_DAYS_LOW_2_HIGH	☐	TIDX_INTERPOLATION_DAYS		INT4	10	0	Interpolation Days
107	INDEX_FACTOR_IN_RATIO	☐	TIDX_INDEX_VALUE	TIDX_INDEX_VALUE	DEC	12	6	Index Value
108	INDEX_FACTOR_NO_RATIO	☐	TIDX_INDEX_VALUE_NO_RATIO	TIDX_INDEX_VALUE_NO_RATIO	DEC	18	12	Index Value (Independent of Basis)
109	VALUE_DATE_LOW	☐	TIDX_VALUE_DATE		DATS	8	0	Effective From
110	VALUE_DATE_HIGH	☐	TIDX_VALUE_DATE		DATS	8	0	Effective From
111	INDEX_FACTOR_LOW_IN_RATIO	☐	TIDX_INDEX_VALUE	TIDX_INDEX_VALUE	DEC	12	6	Index Value
112	INDEX_FACTOR_HIGH_IN_RATIO	☐	TIDX_INDEX_VALUE	TIDX_INDEX_VALUE	DEC	12	6	Index Value
113	IMP_PC	☐	TPM_IM_PC	TPM_AMOUNT	CURR	21	2	Impairment Amount in Position Currency
114	IMP_VC	☐	TPM_IM_VC	TPM_AMOUNT	CURR	21	2	Impairment Amount in Valuation Currency
115	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
116	OVM_PC	☐	TPM_OVM_PC	TPM_AMOUNT	CURR	21	2	Old Variation Margin in Position Currency
117	OVM_VC	☐	TPM_OVM_VC	TPM_AMOUNT	CURR	21	2	Old Variation Margin in Valuation Currency
118	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
119	MAV_P_VC	☐	TPM_MAV_P_VC	TPM_AMOUNT	CURR	21	2	Fair Value of Purchase Side in Valuation Currency
120	MAV_S_VC	☐	TPM_MAV_S_VC	TPM_AMOUNT	CURR	21	2	Fair Value of Sale Side in Valuation Currency
121	QUOTATION	☐	SNOTI	SNOTI	NUMC	1	0	Quotation Indicator

History

Last changed by/on	SAP	20110901
SAP Release Created in	462_10