SAP ABAP Table ROXPLN0004 (ROXPLN0004)

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	ROXPLN0004	Table Relationship Diagram
Short Description

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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	TR_ACC_CODE	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	*
3	VALUATION_AREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	*
4	VALUATION_CLASS	☐	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	*
5	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	*
6	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
7	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
8	LOANS_CONTRACT	☐	RANL	RANL	CHAR	13	0	Contract Number
9	DEAL_NUMBER	☐	FTI_POSRFHA	T_RFHA	CHAR	13	0	Financial Transaction That Creates a Position	*
10	ACCOUNT_GROUP	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	*
11	SECURITY_ACCOUNT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
12	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	*
13	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
14	DLOTGENERATION	☐	DLOTGENERATION	DATUM	DATS	8	0	Date On Which Lot Was Generated
15	TLOTGENERATION	☐	TLOTGENERATION	UZEIT	TIMS	6	0	Lot Generation Time
16	LOTGENERATION_US	☐	FTI_LOTGENERATIONUSER	SYCHAR12	CHAR	12	0	Lot Entered By
17	LOTGENERATION_CT	☐	FTI_LOTGENERATION_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category Which Generated the Lot	*
18	STICHTAG	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
19	PEFFZINS	☐	FTI_EFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
20	NOMINAL_AMT_O_PC	☐	FTI_NOMINAL_OUT_PCOUT	TPM_AMOUNT	CURR	21	2	Nominal Value, Outgoing Side, in Position Crcy (Outg. Side)
21	WVERB1	☐	FTI_WHR_SHORT	WAERS	CUKY	5	0	Nominal currency borrowing/sale/outgoing side/short	*
22	NOMINAL_AMT_I_PC	☐	FTI_NOMINAL_IN_PCIN	TPM_AMOUNT	CURR	21	2	Nominal Value, Incoming Side, in Position Crcy (Inc. Side)
23	WFORD1	☐	FTI_WHR_LONG	WAERS	CUKY	5	0	Nominal currency investment/purchase incoming side/long	*
24	MARKET_PC	☐	FTI_MARKET_PC	TPM_AMOUNT	CURR	21	2	Market Value in Position Currency
25	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
26	NPV_PC	☐	TV_NPV_PC	WERTV8_TR	CURR	15	2	RM Net Present Value in Position Currency
27	SBWHR001	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
28	CLEAN_PRICE_PC	☐	TV_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
29	SBWHR002	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
30	BPVALUE_PC	☐	TV_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Position Currency
31	SBWHR003	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
32	MAC_DURATION	☐	TV_MAC_DURATION	DEC9_3SIGN	DEC	12	3	Macaulay Duration
33	MOD_DURATION	☐	TV_MOD_DURATION	DEC9_3SIGN	DEC	12	3	Fisher-Weil Duration
34	S_VAL_TI_PC	☐	FTI_S_VAL_TI_PC	TPM_AMOUNT	CURR	21	2	Security Valuation in Position Currency (Simulation)
35	SBWHR004	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
36	S_VAL_TI_LC	☐	FTI_S_VAL_TI_LC	TPM_AMOUNT	CURR	21	2	Security Valuation in Local Currency (Simulation)
37	SHWHR	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
38	S_VAL_TI_VC	☐	FTI_S_VAL_TI_VC	TPM_AMOUNT	CURR	21	2	Security Valuation in Valuation Currency (Simulation)
39	SVWHR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
40	S_VAL_FX_LC	☐	FTI_S_VAL_FX_LC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Local Currency (Simulation)
41	SHWHR001	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
42	S_VAL_FX_VC	☐	FTI_S_VAL_FX_VC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Valuation Crcy (Simulation)
43	SVWHR001	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
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	SBWHR005	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
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	SHWHR002	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
48	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.)
49	SVWHR002	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
50	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.)
51	SHWHR003	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
52	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.)
53	SVWHR003	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
54	S_AMORT_PC	☐	FTI_S_AMORT_PC	TPM_AMOUNT	CURR	21	2	Amortization in Position Currency (Simulation)
55	SBWHR006	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
56	S_AMORT_LC	☐	FTI_S_AMORT_LC	TPM_AMOUNT	CURR	21	2	Amortization in Local Currency (Simulation)
57	SHWHR004	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
58	S_AMORT_VC	☐	FTI_S_AMORT_VC	TPM_AMOUNT	CURR	21	2	Amortization in Valuation Currency (Simulation)
59	SVWHR004	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
60	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)
61	SBWHR007	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
62	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)
63	SHWHR005	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
64	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)
65	SVWHR005	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
66	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)
67	SHWHR006	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
68	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)
69	SVWHR006	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
70	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.)
71	SBWHR008	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
72	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.)
73	SHWHR007	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
74	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.)
75	SVWHR007	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
76	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.)
77	SHWHR008	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
78	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.)
79	SVWHR008	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
80	S_SPOTVALP_LC	☐	FTI_S_SPOTVALP_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Purchase Currency, in Local Crcy: Simulation
81	SHWHR009	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
82	S_SPOTVALP_VC	☐	FTI_S_SPOTVALP_VC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Purchase Currency, in Val. Crcy: Simulation
83	SVWHR009	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
84	S_SPOTVALS_LC	☐	FTI_S_SPOTVALS_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Sale Currency, in Local Crcy: Simulation
85	SHWHR010	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
86	S_SPOTVALS_VC	☐	FTI_S_SPOTVALS_VC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Sale Currency, in Valuation Crcy: Simulation
87	SVWHR010	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
88	S_SWAPACC_LC	☐	FTI_S_SWAPACC_LC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Local Currency: Simulation
89	SHWHR011	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
90	S_SWAPACC_VC	☐	FTI_S_SWAPACC_VC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Valuation Crcy: Simulation
91	SVWHR011	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
92	S_SWAPVAL_LC	☐	FTI_S_SWAPVAL_LC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Local Currency: Simulation
93	SHWHR012	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
94	S_SWAPVAL_VC	☐	FTI_S_SWAPVAL_VC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Valuation Currency: Simulation
95	SVWHR012	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
96	S_VALID_DATE	☐	TPM_VALID_DATE	DATS	DATS	8	0	Date of Found Rate or Present Value
97	S_VALID_RATE_DAT	☐	TPM_VALID_RATE_DATE	DATS	DATS	8	0	Date of Exchange Rate Found
98	S_MAP	☐	TPM_MAP	VVPKTKUR	DEC	15	6	Market Price
99	S_MAR_FE	☐	TPM_MAR_FE	UKURS	DEC	9	5	Exchange Rate - Position/Valuation Currency on Market
100	S_SPOT_RATE_P	☐	TPM_SPOT_RATE_P	UKURS	DEC	9	5	Spot Rate Purchase Currency/Valuation Currency in the Market
101	S_SPOT_RATE_S	☐	TPM_SPOT_RATE_S	UKURS	DEC	9	5	Spot Rate Sales Currency/Valuation Currency in the Market
102	S_SWAP_RATE_P	☐	TPM_SWAP_RATE_P	TB_DEVSWSA	DEC	9	5	Swap Rate Purchase Currency/Valuation Currency in the Market
103	S_SWAP_RATE_S	☐	TPM_SWAP_RATE_S	TB_DEVSWSA	DEC	9	5	Swap Rate Sales Currency/Valuation Currency in the Market
104	PARAM_P_ANZGW	☐	FTI_ANZGW	WAERS	CUKY	5	0	Display Currency	*
105	PARAM_P_AUSWT	☐	FTI_EVALTYPE	JBREVAL	CHAR	4	0	Evaluation Type (Risk Management)	*
106	PARAM_P_DAT	☐	SYDATUM	SYDATS	DATS	8	0	System Date
107	PARAM_P_HISTKR	☐	FTI_LDB_FLG_HISTORIC_ACCASSREF	XFELD	CHAR	1	0	Indicator: Historical Account Assignment Reference
108	PARAM_P_KURSA	☐	VVKURSAUSW	VVSKURSART	CHAR	2	0	Price type for evaluations	*
109	PARAM_P_LOGSAV	☐	FTI_FLG_BALLOG_DB_SAVE_CFM	XFELD	CHAR	1	0	Save Application Log (CFM)? - Yes/No
110	PARAM_P_RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
111	PARAM_P_RST_PB	☐	FTI_RSTICH_PB	RSTICH_PB	CHAR	1	0	Key Date Reference for Parallel Books
112	PARAM_P_SACCCP	☐	FTI_LDB_FLG_COUPLING_SECACCGRP	XFELD	CHAR	1	0	Interpret Assignment of Sec. Account to Sec. Account Group
113	SELECT_S_ACCGRP	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	*
114	SELECT_S_BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
115	SELECT_S_GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	*
116	SELECT_S_PERIOD	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
117	SELECT_S_POSACC	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	*
118	SELECT_S_RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
119	SELECT_S_RANLOF	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
120	SELECT_S_RANLSE	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
121	SELECT_S_RANLVD	☐	RANL	RANL	CHAR	13	0	Contract Number
122	SELECT_S_RFHA	☐	FTI_POSRFHA	T_RFHA	CHAR	13	0	Financial Transaction That Creates a Position	*
123	SELECT_S_RLDEPO	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
124	SELECT_S_RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
125	SELECT_S_TRAC	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	*
126	SELECT_S_VALCLS	☐	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	*
127	SELECT_S_VLAREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	*

History

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