SAP ABAP Table ROXALN0067 (Structure for Position Currency Upload of Market Data)

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	ROXALN0067	Table Relationship Diagram
Short Description	Structure for Position Currency Upload of Market Data

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	LOTGEN_DEALNR	FTI_LOTGENERATION_DEALNR	T_RFHA	CHAR	13	0	Lot-Generating Transaction Number	*
2	LOTPOS_ORG_DATE	FTI_LOTPOSITION_ORG_DATE	TPM_POSITION_DATE	DATS	8	0	Original Position Acquisition Date of a Lot
3	LOTPOS_INIT_DATE	FTI_LOTPOSITION_INIT_DATE	TPM_POSITION_DATE	DATS	8	0	Position Acquisition Date of a Lot
4	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
5	TR_ACC_CODE	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	*
6	VALUATION_AREA	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	*
7	VALUATION_CLASS	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	*
8	GSART	VVSART	VVSART	CHAR	3	0	Product Type	*
9	PORTFOLIO	TPM_PORTFOLIO_DIFF	RPORTB	CHAR	10	0	Portfolio as Differentiation Characteristic	*
10	SECURITY_ID	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
11	LOANS_CONTRACT	RANL	RANL	CHAR	13	0	Contract Number
12	DEAL_NUMBER	FTI_POSRFHA	T_RFHA	CHAR	13	0	Financial Transaction That Creates a Position	*
13	ACCOUNT_GROUP	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	*
14	SECURITY_ACCOUNT	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
15	POSITION_ACCOUNT	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	*
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	STICHTAG	VVSTDAT	VVSTDAT	DATS	8	0	Key date
23	PEFFZINS	FTI_EFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
24	NOMINAL_AMT_O_PC	FTI_NOMINAL_OUT_PCOUT	TPM_AMOUNT	CURR	21	2	Nominal Value, Outgoing Side, in Position Crcy (Outg. Side)
25	WVERB1	FTI_WHR_SHORT	WAERS	CUKY	5	0	Nominal currency borrowing/sale/outgoing side/short	*
26	NOMINAL_AMT_I_PC	FTI_NOMINAL_IN_PCIN	TPM_AMOUNT	CURR	21	2	Nominal Value, Incoming Side, in Position Crcy (Inc. Side)
27	WFORD1	FTI_WHR_LONG	WAERS	CUKY	5	0	Nominal currency investment/purchase incoming side/long	*
28	MARKET_PC	FTI_MARKET_PC	TPM_AMOUNT	CURR	21	2	Market Value in Position Currency
29	SBWHR	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
30	NPV_PC	TV_NPV_PC	WERTV8_TR	CURR	15	2	RM Net Present Value in Position Currency
31	SBWHR001	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
32	CLEAN_PRICE_PC	TV_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
33	SBWHR002	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
34	BPVALUE_PC	TV_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Position Currency
35	SBWHR003	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
36	MAC_DURATION	TV_MAC_DURATION	DEC9_3SIGN	DEC	12	3	Macaulay Duration
37	MOD_DURATION	TV_MOD_DURATION	DEC9_3SIGN	DEC	12	3	Fisher-Weil Duration
38	S_DISAGIO_PC	FTI_S_DISAGIO_PC	TPM_AMOUNT	CURR	21	2	Cleared PD Def./Tax Compensation in Pos. Crcy: Simulation
39	SBWHR004	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
40	S_DISAGIO_LC	FTI_S_DISAGIO_LC	TPM_AMOUNT	CURR	21	2	Cleared PD Def./Tax Compensation in Local Crcy: Simulation
41	SHWHR	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
42	S_DISAGIO_VC	FTI_S_DISAGIO_VC	TPM_AMOUNT	CURR	21	2	Cleared PD Def./Tax Compensation in Val. Crcy: Simulation
43	SVWHR	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
44	S_VAL_TI_PC	FTI_S_VAL_TI_PC	TPM_AMOUNT	CURR	21	2	Security Valuation in Position Currency (Simulation)
45	SBWHR005	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
46	S_VAL_TI_LC	FTI_S_VAL_TI_LC	TPM_AMOUNT	CURR	21	2	Security Valuation in Local Currency (Simulation)
47	SHWHR011	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
48	S_VAL_TI_VC	FTI_S_VAL_TI_VC	TPM_AMOUNT	CURR	21	2	Security Valuation in Valuation Currency (Simulation)
49	SVWHR024	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
50	S_VAL_FX_LC	FTI_S_VAL_FX_LC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Local Currency (Simulation)
51	SHWHR012	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
52	S_VAL_FX_VC	FTI_S_VAL_FX_VC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Valuation Crcy (Simulation)
53	SVWHR025	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
54	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.)
55	SBWHR006	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
56	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.)
57	SHWHR013	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
58	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.)
59	SVWHR026	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
60	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.)
61	SHWHR014	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
62	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.)
63	SVWHR027	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
64	S_AMORT_PC	FTI_S_AMORT_PC	TPM_AMOUNT	CURR	21	2	Amortization in Position Currency (Simulation)
65	SBWHR007	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
66	S_AMORT_LC	FTI_S_AMORT_LC	TPM_AMOUNT	CURR	21	2	Amortization in Local Currency (Simulation)
67	SHWHR015	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
68	S_AMORT_VC	FTI_S_AMORT_VC	TPM_AMOUNT	CURR	21	2	Amortization in Valuation Currency (Simulation)
69	SVWHR028	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
70	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)
71	SBWHR008	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
72	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)
73	SHWHR016	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
74	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)
75	SVWHR029	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
76	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)
77	SHWHR017	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
78	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)
79	SVWHR030	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
80	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.)
81	SBWHR009	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
82	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.)
83	SHWHR018	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
84	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.)
85	SVWHR031	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
86	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.)
87	SHWHR019	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
88	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.)
89	SVWHR032	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
90	S_SPOTVALP_LC	FTI_S_SPOTVALP_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Purchase Currency, in Local Crcy: Simulation
91	SHWHR020	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
92	S_SPOTVALP_VC	FTI_S_SPOTVALP_VC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Purchase Currency, in Val. Crcy: Simulation
93	SVWHR033	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
94	S_SPOTVALS_LC	FTI_S_SPOTVALS_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Sale Currency, in Local Crcy: Simulation
95	SHWHR021	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
96	S_SPOTVALS_VC	FTI_S_SPOTVALS_VC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Sale Currency, in Valuation Crcy: Simulation
97	SVWHR034	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
98	S_SWAPACC_PC	FTI_S_SWAPACC_PC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Position Crcy (Simulation)
99	SBWHR010	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
100	S_SWAPACC_LC	FTI_S_SWAPACC_LC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Local Currency: Simulation
101	SHWHR022	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
102	S_SWAPACC_VC	FTI_S_SWAPACC_VC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Valuation Crcy: Simulation
103	SVWHR035	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
104	S_SWAPVAL_LC	FTI_S_SWAPVAL_LC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Local Currency: Simulation
105	SHWHR023	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
106	S_SWAPVAL_VC	FTI_S_SWAPVAL_VC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Valuation Currency: Simulation
107	SVWHR036	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
108	S_VALID_DATE	TPM_VALID_DATE	DATS	DATS	8	0	Date of Found Rate or Present Value
109	S_VALID_RATE_DAT	TPM_VALID_RATE_DATE	DATS	DATS	8	0	Date of Exchange Rate Found
110	S_MAP	TPM_MAP	VVPKTKUR	DEC	15	6	Market Price
111	S_MAR_FE	TPM_MAR_FE	UKURS	DEC	9	5	Exchange Rate - Position/Valuation Currency on Market
112	S_SPOT_RATE_P	TPM_SPOT_RATE_P	UKURS	DEC	9	5	Spot Rate Purchase Currency/Valuation Currency in the Market
113	S_SPOT_RATE_S	TPM_SPOT_RATE_S	UKURS	DEC	9	5	Spot Rate Sales Currency/Valuation Currency in the Market
114	S_SWAP_RATE_P	TPM_SWAP_RATE_P	TB_DEVSWSA	DEC	9	5	Swap Rate Purchase Currency/Valuation Currency in the Market
115	S_SWAP_RATE_S	TPM_SWAP_RATE_S	TB_DEVSWSA	DEC	9	5	Swap Rate Sales Currency/Valuation Currency in the Market
116	PARAM_P_ANZGW	FTI_ANZGW	WAERS	CUKY	5	0	Display Currency	*
117	PARAM_P_AUSWT	FTI_EVALTYPE	JBREVAL	CHAR	4	0	Evaluation Type (Risk Management)	*
118	PARAM_P_DAT	SYDATUM	SYDATS	DATS	8	0	System Date
119	PARAM_P_HISTKR	FTI_LDB_FLG_HISTORIC_ACCASSREF	XFELD	CHAR	1	0	Indicator: Historical Account Assignment Reference
120	PARAM_P_KURSA	VVKURSAUSW	VVSKURSART	CHAR	2	0	Price type for evaluations	*
121	PARAM_P_LOGSAV	FTI_FLG_BALLOG_DB_SAVE_CFM	XFELD	CHAR	1	0	Save Application Log (CFM)? - Yes/No
122	PARAM_P_RSTICH	RSTICH	RSTICH	CHAR	1	0	Key date reference
123	PARAM_P_RST_PB	FTI_RSTICH_PB	RSTICH_PB	CHAR	1	0	Key Date Reference for Parallel Books
124	PARAM_P_SACCCP	FTI_LDB_FLG_COUPLING_SECACCGRP	XFELD	CHAR	1	0	Interpret Assignment of Sec. Account to Sec. Account Group
125	SELECT_S_ACCGRP	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	*
126	SELECT_S_BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
127	SELECT_S_GSART	VVSART	VVSART	CHAR	3	0	Product Type	*
128	SELECT_S_PERIOD	VVSTDAT	VVSTDAT	DATS	8	0	Key date
129	SELECT_S_POSACC	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	*
130	SELECT_S_RANL	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
131	SELECT_S_RANLOF	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
132	SELECT_S_RANLSE	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
133	SELECT_S_RANLVD	RANL	RANL	CHAR	13	0	Contract Number
134	SELECT_S_RFHA	FTI_POSRFHA	T_RFHA	CHAR	13	0	Financial Transaction That Creates a Position	*
135	SELECT_S_RLDEPO	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
136	SELECT_S_RPORTB	TPM_PORTFOLIO_DIFF	RPORTB	CHAR	10	0	Portfolio as Differentiation Characteristic	*
137	SELECT_S_TRAC	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	*
138	SELECT_S_VALCLS	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	*
139	SELECT_S_VLAREA	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	*
140	PARAM_P_CALCCY	AFW_EVAL_CURRENCY	WAERS	CUKY	5	0	Evaluation Currency	*
141	PARAM_P_CDENSE	FTI_CONDENSE	XFELD	CHAR	1	0	Summarize Results (for Query)
142	PARAM_P_EXPLAN	FTI_EXCL_PLAN	XFELD	CHAR	1	0	Exclude Plan Data (for Query)
143	PARAM_P_ISTYPE	BU_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System	*
144	PARAM_P_LCYINT	FTI_LEAD_FOLLOW_CCY_LOGIC	XFELD	CHAR	1	0	Interpret. Leading/Following Currency for Exchange Transact.
145	PARAM_P_NONULL	FTI_NO_NULL	XFELD	CHAR	1	0	Hide Zero Records
146	SELECT_S_PARTNR	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
147	SELECT_S_POSCCY	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
148	PARAM_P_KURSB	FTI_RKURSBER	RKURSBER	CHAR	2	0	Rate Calculation	*
149	PARAM_P_MARKET	FTI_MARKETDATA_BUFFER_CTRL	FTI_MARKETDATA_BUFFER_CTRL	CHAR	1	0	Control Risk Mgmt Buffer for Logical Database Reporting
150	PARAM_P_NOFLOW	FTI_FLG_ONLY_POS_WITH_FLOWS	XFELD	CHAR	1	0	Indicator: Only Positions With Flows in Selection Period
151	PARAM_P_REVFLW	FTI_REVERSED_FLOWS	XFELD	CHAR	1	0	Process Reversed Flows (for Query)
152	SELECT_S_FINPRO	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
153	SELECT_S_MERKM	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
154	SELECT_S_PORTTM	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
155	SELECT_S_REFER	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
156	SELECT_S_RMAID	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	*
157	SELECT_S_SFHART	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
158	SELECT_S_ZUOND	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
159	PARAM_P_CFSIGN	FTI_LDB_FLG_CF_SIGN	XFELD	CHAR	1	0	Indicator: Plus/Minus Sign for Payment Amount
160	SELECT_S_ACCTYP	TPM_SECACC_TYPE	TPM_SECACC_TYPE	CHAR	3	0	Securities Account Type	*