SAP ABAP Table ROXPLN0008 (ROXPLN0008)
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
⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
⤷ CFM_TR_BIW (Package) CFM: Connection to BW
Basic Data
Table Category | INTTAB | Structure |
Structure | ROXPLN0008 | 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_DISAGIO_PC | FTI_S_DISAGIO_PC | TPM_AMOUNT | CURR | 21 | 2 | Cleared PD Def./Tax Compensation in Pos. Crcy: Simulation | ||
35 | SBWHR004 | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | * | |
36 | S_DISAGIO_LC | FTI_S_DISAGIO_LC | TPM_AMOUNT | CURR | 21 | 2 | Cleared PD Def./Tax Compensation in Local Crcy: Simulation | ||
37 | SHWHR | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
38 | S_DISAGIO_VC | FTI_S_DISAGIO_VC | TPM_AMOUNT | CURR | 21 | 2 | Cleared PD Def./Tax Compensation in Val. Crcy: Simulation | ||
39 | SVWHR | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
40 | S_VAL_TI_PC | FTI_S_VAL_TI_PC | TPM_AMOUNT | CURR | 21 | 2 | Security Valuation in Position Currency (Simulation) | ||
41 | SBWHR005 | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | * | |
42 | S_VAL_TI_LC | FTI_S_VAL_TI_LC | TPM_AMOUNT | CURR | 21 | 2 | Security Valuation in Local Currency (Simulation) | ||
43 | SHWHR001 | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
44 | S_VAL_TI_VC | FTI_S_VAL_TI_VC | TPM_AMOUNT | CURR | 21 | 2 | Security Valuation in Valuation Currency (Simulation) | ||
45 | SVWHR001 | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
46 | S_VAL_FX_LC | FTI_S_VAL_FX_LC | TPM_AMOUNT | CURR | 21 | 2 | Foreign Currency Valuation in Local Currency (Simulation) | ||
47 | SHWHR002 | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
48 | S_VAL_FX_VC | FTI_S_VAL_FX_VC | TPM_AMOUNT | CURR | 21 | 2 | Foreign Currency Valuation in Valuation Crcy (Simulation) | ||
49 | SVWHR002 | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
50 | 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.) | ||
51 | SBWHR006 | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | * | |
52 | 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.) | ||
53 | SHWHR003 | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
54 | 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.) | ||
55 | SVWHR003 | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
56 | 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.) | ||
57 | SHWHR004 | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
58 | 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.) | ||
59 | SVWHR004 | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
60 | S_AMORT_PC | FTI_S_AMORT_PC | TPM_AMOUNT | CURR | 21 | 2 | Amortization in Position Currency (Simulation) | ||
61 | SBWHR007 | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | * | |
62 | S_AMORT_LC | FTI_S_AMORT_LC | TPM_AMOUNT | CURR | 21 | 2 | Amortization in Local Currency (Simulation) | ||
63 | SHWHR005 | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
64 | S_AMORT_VC | FTI_S_AMORT_VC | TPM_AMOUNT | CURR | 21 | 2 | Amortization in Valuation Currency (Simulation) | ||
65 | SVWHR005 | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
66 | 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) | ||
67 | SBWHR008 | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | * | |
68 | 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) | ||
69 | SHWHR006 | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
70 | 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) | ||
71 | SVWHR006 | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
72 | 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) | ||
73 | SHWHR007 | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
74 | 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) | ||
75 | SVWHR007 | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
76 | 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.) | ||
77 | SBWHR009 | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | * | |
78 | 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.) | ||
79 | SHWHR008 | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
80 | 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.) | ||
81 | SVWHR008 | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
82 | 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.) | ||
83 | SHWHR009 | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
84 | 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.) | ||
85 | SVWHR009 | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
86 | S_SPOTVALP_LC | FTI_S_SPOTVALP_LC | TPM_AMOUNT | CURR | 21 | 2 | Spot Valuation, Purchase Currency, in Local Crcy: Simulation | ||
87 | SHWHR010 | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
88 | S_SPOTVALP_VC | FTI_S_SPOTVALP_VC | TPM_AMOUNT | CURR | 21 | 2 | Spot Valuation, Purchase Currency, in Val. Crcy: Simulation | ||
89 | SVWHR010 | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
90 | S_SPOTVALS_LC | FTI_S_SPOTVALS_LC | TPM_AMOUNT | CURR | 21 | 2 | Spot Valuation, Sale Currency, in Local Crcy: Simulation | ||
91 | SHWHR011 | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
92 | S_SPOTVALS_VC | FTI_S_SPOTVALS_VC | TPM_AMOUNT | CURR | 21 | 2 | Spot Valuation, Sale Currency, in Valuation Crcy: Simulation | ||
93 | SVWHR011 | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
94 | S_SWAPACC_PC | FTI_S_SWAPACC_PC | TPM_AMOUNT | CURR | 21 | 2 | Swap/Margin Accrual/Deferral in Position Crcy (Simulation) | ||
95 | SBWHR010 | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | * | |
96 | S_SWAPACC_LC | FTI_S_SWAPACC_LC | TPM_AMOUNT | CURR | 21 | 2 | Swap/Margin Accrual/Deferral in Local Currency: Simulation | ||
97 | SHWHR012 | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
98 | S_SWAPACC_VC | FTI_S_SWAPACC_VC | TPM_AMOUNT | CURR | 21 | 2 | Swap/Margin Accrual/Deferral in Valuation Crcy: Simulation | ||
99 | SVWHR012 | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
100 | S_SWAPVAL_LC | FTI_S_SWAPVAL_LC | TPM_AMOUNT | CURR | 21 | 2 | Swap Valuation in Local Currency: Simulation | ||
101 | SHWHR013 | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
102 | S_SWAPVAL_VC | FTI_S_SWAPVAL_VC | TPM_AMOUNT | CURR | 21 | 2 | Swap Valuation in Valuation Currency: Simulation | ||
103 | SVWHR013 | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
104 | S_VALID_DATE | TPM_VALID_DATE | DATS | DATS | 8 | 0 | Date of Found Rate or Present Value | ||
105 | S_VALID_RATE_DAT | TPM_VALID_RATE_DATE | DATS | DATS | 8 | 0 | Date of Exchange Rate Found | ||
106 | S_MAP | TPM_MAP | VVPKTKUR | DEC | 15 | 6 | Market Price | ||
107 | S_MAR_FE | TPM_MAR_FE | UKURS | DEC | 9 | 5 | Exchange Rate - Position/Valuation Currency on Market | ||
108 | S_SPOT_RATE_P | TPM_SPOT_RATE_P | UKURS | DEC | 9 | 5 | Spot Rate Purchase Currency/Valuation Currency in the Market | ||
109 | S_SPOT_RATE_S | TPM_SPOT_RATE_S | UKURS | DEC | 9 | 5 | Spot Rate Sales Currency/Valuation Currency in the Market | ||
110 | S_SWAP_RATE_P | TPM_SWAP_RATE_P | TB_DEVSWSA | DEC | 9 | 5 | Swap Rate Purchase Currency/Valuation Currency in the Market | ||
111 | S_SWAP_RATE_S | TPM_SWAP_RATE_S | TB_DEVSWSA | DEC | 9 | 5 | Swap Rate Sales Currency/Valuation Currency in the Market | ||
112 | PARAM_P_ANZGW | FTI_ANZGW | WAERS | CUKY | 5 | 0 | Display Currency | * | |
113 | PARAM_P_AUSWT | FTI_EVALTYPE | JBREVAL | CHAR | 4 | 0 | Evaluation Type (Risk Management) | * | |
114 | PARAM_P_DAT | SYDATUM | SYDATS | DATS | 8 | 0 | System Date | ||
115 | PARAM_P_HISTKR | FTI_LDB_FLG_HISTORIC_ACCASSREF | XFELD | CHAR | 1 | 0 | Indicator: Historical Account Assignment Reference | ||
116 | PARAM_P_KURSA | VVKURSAUSW | VVSKURSART | CHAR | 2 | 0 | Price type for evaluations | * | |
117 | PARAM_P_LOGSAV | FTI_FLG_BALLOG_DB_SAVE_CFM | XFELD | CHAR | 1 | 0 | Save Application Log (CFM)? - Yes/No | ||
118 | PARAM_P_RSTICH | RSTICH | RSTICH | CHAR | 1 | 0 | Key date reference | ||
119 | PARAM_P_RST_PB | FTI_RSTICH_PB | RSTICH_PB | CHAR | 1 | 0 | Key Date Reference for Parallel Books | ||
120 | PARAM_P_SACCCP | FTI_LDB_FLG_COUPLING_SECACCGRP | XFELD | CHAR | 1 | 0 | Interpret Assignment of Sec. Account to Sec. Account Group | ||
121 | SELECT_S_ACCGRP | TPM_SEC_ACCT_GRP | TPM_SEC_ACCT_GRP | CHAR | 10 | 0 | Securities Account Group | * | |
122 | SELECT_S_BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
123 | SELECT_S_GSART | VVSART | VVSART | CHAR | 3 | 0 | Product Type | * | |
124 | SELECT_S_PERIOD | VVSTDAT | VVSTDAT | DATS | 8 | 0 | Key date | ||
125 | SELECT_S_POSACC | TPM_POS_ACCOUNT_FUT | TPM_POS_ACCOUNT_FUT | CHAR | 10 | 0 | Futures Account for Listed Options and Futures | * | |
126 | SELECT_S_RANL | VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | * | |
127 | SELECT_S_RANLOF | VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | * | |
128 | SELECT_S_RANLSE | VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | * | |
129 | SELECT_S_RANLVD | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
130 | SELECT_S_RFHA | FTI_POSRFHA | T_RFHA | CHAR | 13 | 0 | Financial Transaction That Creates a Position | * | |
131 | SELECT_S_RLDEPO | RLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | * | |
132 | SELECT_S_RPORTB | RPORTB | RPORTB | CHAR | 10 | 0 | Portfolio | * | |
133 | SELECT_S_TRAC | TPM_ACC_CODE | TPM_ACC_CODE | CHAR | 4 | 0 | Accounting Code | * | |
134 | SELECT_S_VALCLS | TPM_VAL_CLASS | TPM_VAL_CLASS | NUMC | 4 | 0 | Valuation Class | * | |
135 | 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 |