SAP ABAP Table ROXPLN0002 (ROXPLN0002)

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

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	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	TEXT_BW_CFM_VALU	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
3	TR_ACC_CODE	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	*
4	SPECNAME00000001	TPM_TR_ACC_CODE_NAME	TPM_DESCRIPTION	CHAR	60	0	Name of Accounting Code
5	VALUATION_AREA	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	*
6	SPECNAME00000002	TPM_VAL_AREA_NAME	TPM_DESCRIPTION	CHAR	60	0	Name of the Valuation Area
7	VALUATION_CLASS	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	*
8	SPECNAME00000003	TPM_VAL_CLASS_NAME	TPM_DESCRIPTION	CHAR	60	0	Description of valuation class
9	GSART	VVSART	VVSART	CHAR	3	0	Product Type	*
10	SPECNAME00000004	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
11	PORTFOLIO	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
12	SPECNAME00000005	VVXPORTB	TEXT30	CHAR	30	0	Portfolio name
13	SECURITY_ID	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
14	SPECNAME00000006	XALLB	XLBEZ	CHAR	60	0	Long name
15	LOANS_CONTRACT	RANL	RANL	CHAR	13	0	Contract Number
16	SPECNAME00000007	XALLB	XLBEZ	CHAR	60	0	Long name
17	DEAL_NUMBER	FTI_POSRFHA	T_RFHA	CHAR	13	0	Financial Transaction That Creates a Position	*
18	SPECNAME00000008	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
19	ACCOUNT_GROUP	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	*
20	SPECNAME00000009	TPM_SEC_ACCT_GRP_NAME	TPM_DESCRIPTION	CHAR	60	0	Name of Securities Account Group
21	SECURITY_ACCOUNT	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
22	SPECNAME00000010	XLDEPO	XLDEPO	CHAR	30	0	Securities account ID
23	POSITION_ACCOUNT	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	*
24	SPECNAME00000011	TPM_POS_ACC_FUT_TEXT	TPM_POS_ACC_FUT_TEXT	CHAR	30	0	Futures Account Text
25	LOT_ID	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
26	DLOTGENERATION	DLOTGENERATION	DATUM	DATS	8	0	Date On Which Lot Was Generated
27	TLOTGENERATION	TLOTGENERATION	UZEIT	TIMS	6	0	Lot Generation Time
28	LOTGENERATION_US	FTI_LOTGENERATIONUSER	SYCHAR12	CHAR	12	0	Lot Entered By
29	LOTGENERATION_CT	FTI_LOTGENERATION_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category Which Generated the Lot	*
30	SPECNAME00000012	TPM_BUSTRANSCAT_TEXT	TPM_DESCRIPTION	CHAR	60	0	Name of Business Transaction Category
31	STICHTAG	VVSTDAT	VVSTDAT	DATS	8	0	Key date
32	SPECNAME00000013	LTEXT	TEXT40	CHAR	40	0	Long Text
33	SPECNAME00000014	LTEXT	TEXT40	CHAR	40	0	Long Text
34	SPECNAME00000015	LTEXT	TEXT40	CHAR	40	0	Long Text
35	PEFFZINS	FTI_EFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
36	SPECNAME00000016	LTEXT	TEXT40	CHAR	40	0	Long Text
37	SPECNAME00000017	LTEXT	TEXT40	CHAR	40	0	Long Text
38	NOMINAL_AMT_O_PC	FTI_NOMINAL_OUT_PCOUT	TPM_AMOUNT	CURR	21	2	Nominal Value, Outgoing Side, in Position Crcy (Outg. Side)
39	WVERB1	FTI_WHR_SHORT	WAERS	CUKY	5	0	Nominal currency borrowing/sale/outgoing side/short	*
40	NOMINAL_AMT_I_PC	FTI_NOMINAL_IN_PCIN	TPM_AMOUNT	CURR	21	2	Nominal Value, Incoming Side, in Position Crcy (Inc. Side)
41	WFORD1	FTI_WHR_LONG	WAERS	CUKY	5	0	Nominal currency investment/purchase incoming side/long	*
42	MARKET_PC	FTI_MARKET_PC	TPM_AMOUNT	CURR	21	2	Market Value in Position Currency
43	SBWHR	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
44	NPV_PC	TV_NPV_PC	WERTV8_TR	CURR	15	2	RM Net Present Value in Position Currency
45	SBWHR001	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
46	CLEAN_PRICE_PC	TV_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
47	SBWHR002	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
48	BPVALUE_PC	TV_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Position Currency
49	SBWHR003	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
50	MAC_DURATION	TV_MAC_DURATION	DEC9_3SIGN	DEC	12	3	Macaulay Duration
51	MOD_DURATION	TV_MOD_DURATION	DEC9_3SIGN	DEC	12	3	Fisher-Weil Duration
52	S_VAL_TI_PC	FTI_S_VAL_TI_PC	TPM_AMOUNT	CURR	21	2	Security Valuation in Position Currency (Simulation)
53	SBWHR004	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
54	S_VAL_TI_LC	FTI_S_VAL_TI_LC	TPM_AMOUNT	CURR	21	2	Security Valuation in Local Currency (Simulation)
55	SHWHR	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
56	S_VAL_TI_VC	FTI_S_VAL_TI_VC	TPM_AMOUNT	CURR	21	2	Security Valuation in Valuation Currency (Simulation)
57	SVWHR	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
58	S_VAL_FX_LC	FTI_S_VAL_FX_LC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Local Currency (Simulation)
59	SHWHR001	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
60	S_VAL_FX_VC	FTI_S_VAL_FX_VC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Valuation Crcy (Simulation)
61	SVWHR001	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
62	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.)
63	SBWHR005	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
64	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.)
65	SHWHR002	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
66	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.)
67	SVWHR002	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
68	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.)
69	SHWHR003	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
70	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.)
71	SVWHR003	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
72	S_AMORT_PC	FTI_S_AMORT_PC	TPM_AMOUNT	CURR	21	2	Amortization in Position Currency (Simulation)
73	SBWHR006	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
74	S_AMORT_LC	FTI_S_AMORT_LC	TPM_AMOUNT	CURR	21	2	Amortization in Local Currency (Simulation)
75	SHWHR004	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
76	S_AMORT_VC	FTI_S_AMORT_VC	TPM_AMOUNT	CURR	21	2	Amortization in Valuation Currency (Simulation)
77	SVWHR004	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
78	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)
79	SBWHR007	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
80	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)
81	SHWHR005	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
82	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)
83	SVWHR005	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
84	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)
85	SHWHR006	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
86	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)
87	SVWHR006	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
88	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.)
89	SBWHR008	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
90	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.)
91	SHWHR007	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
92	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.)
93	SVWHR007	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
94	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.)
95	SHWHR008	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
96	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.)
97	SVWHR008	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
98	S_SPOTVALP_LC	FTI_S_SPOTVALP_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Purchase Currency, in Local Crcy: Simulation
99	SHWHR009	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
100	S_SPOTVALP_VC	FTI_S_SPOTVALP_VC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Purchase Currency, in Val. Crcy: Simulation
101	SVWHR009	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
102	S_SPOTVALS_LC	FTI_S_SPOTVALS_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Sale Currency, in Local Crcy: Simulation
103	SHWHR010	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
104	S_SPOTVALS_VC	FTI_S_SPOTVALS_VC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Sale Currency, in Valuation Crcy: Simulation
105	SVWHR010	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
106	S_SWAPACC_LC	FTI_S_SWAPACC_LC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Local Currency: Simulation
107	SHWHR011	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
108	S_SWAPACC_VC	FTI_S_SWAPACC_VC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Valuation Crcy: Simulation
109	SVWHR011	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
110	S_SWAPVAL_LC	FTI_S_SWAPVAL_LC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Local Currency: Simulation
111	SHWHR012	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
112	S_SWAPVAL_VC	FTI_S_SWAPVAL_VC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Valuation Currency: Simulation
113	SVWHR012	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
114	S_VALID_DATE	TPM_VALID_DATE	DATS	DATS	8	0	Date of Found Rate or Present Value
115	S_VALID_RATE_DAT	TPM_VALID_RATE_DATE	DATS	DATS	8	0	Date of Exchange Rate Found
116	S_MAP	TPM_MAP	VVPKTKUR	DEC	15	6	Market Price
117	S_MAR_FE	TPM_MAR_FE	UKURS	DEC	9	5	Exchange Rate - Position/Valuation Currency on Market
118	S_SPOT_RATE_P	TPM_SPOT_RATE_P	UKURS	DEC	9	5	Spot Rate Purchase Currency/Valuation Currency in the Market
119	S_SPOT_RATE_S	TPM_SPOT_RATE_S	UKURS	DEC	9	5	Spot Rate Sales Currency/Valuation Currency in the Market
120	S_SWAP_RATE_P	TPM_SWAP_RATE_P	TB_DEVSWSA	DEC	9	5	Swap Rate Purchase Currency/Valuation Currency in the Market
121	S_SWAP_RATE_S	TPM_SWAP_RATE_S	TB_DEVSWSA	DEC	9	5	Swap Rate Sales Currency/Valuation Currency in the Market