SAP ABAP Table FTI_TEMPLATE_INIT_POSITION (CFM: Initialize Position)
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 | FTI_TEMPLATE_INIT_POSITION | Table Relationship Diagram |
Short Description | CFM: Initialize Position |
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 | .INCLUDE | 0 | 0 | CFM: Initialize Position | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
4 | TR_ACC_CODE | TPM_ACC_CODE | TPM_ACC_CODE | CHAR | 4 | 0 | Accounting Code | TRGC_TR_ACC_CODE | |
5 | VALUATION_AREA | TPM_VAL_AREA | TPM_VAL_AREA | CHAR | 3 | 0 | Valuation Area | TRGC_VAL_AREA | |
6 | VALUATION_CLASS | TPM_VAL_CLASS | TPM_VAL_CLASS | NUMC | 4 | 0 | Valuation Class | TRGC_VAL_CLASS | |
7 | GSART | VVSART | VVSART | CHAR | 3 | 0 | Product Type | TZPA | |
8 | PORTFOLIO | RPORTB | RPORTB | CHAR | 10 | 0 | Portfolio | TWPOB | |
9 | SECURITY_ID | VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | VWPANLA | |
10 | LOANS_CONTRACT | RANL | RANL | CHAR | 13 | 0 | Contract Number | VDARL | |
11 | DEAL_NUMBER | FTI_POSRFHA | T_RFHA | CHAR | 13 | 0 | Financial Transaction That Creates a Position | VTBFHA | |
12 | ACCOUNT_GROUP | TPM_SEC_ACCT_GRP | TPM_SEC_ACCT_GRP | CHAR | 10 | 0 | Securities Account Group | TRGT_SECACCGRP | |
13 | SECURITY_ACCOUNT | RLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | TWD01 | |
14 | POSITION_ACCOUNT | TPM_POS_ACCOUNT_FUT | TPM_POS_ACCOUNT_FUT | CHAR | 10 | 0 | Futures Account for Listed Options and Futures | TRFT_POS_ACCOUNT | |
15 | FLAG_LONG_SHORT | TPM_FLAG_LONG_SHORT | TPM_FLAG_LONG_SHORT | CHAR | 1 | 0 | Indicator: Long or Short Position | ||
16 | LOT_ID | TPM_LOT_ID | SYSUUID | RAW | 16 | 0 | Identifier of the Lot | ||
17 | DLOTGENERATION | DLOTGENERATION | DATUM | DATS | 8 | 0 | Date On Which Lot Was Generated | ||
18 | TLOTGENERATION | TLOTGENERATION | UZEIT | TIMS | 6 | 0 | Lot Generation Time | ||
19 | LOTGENERATION_US | FTI_LOTGENERATIONUSER | SYCHAR12 | CHAR | 12 | 0 | Lot Entered By | ||
20 | LOTGENERATION_CT | FTI_LOTGENERATION_BUSTRANSCAT | TPM_BUSTRANSCAT | NUMC | 4 | 0 | Business Transaction Category Which Generated the Lot | * | |
21 | LOTPOS_INIT_DATE | FTI_LOTPOSITION_INIT_DATE | TPM_POSITION_DATE | DATS | 8 | 0 | Position Acquisition Date of a Lot | ||
22 | LOTPOS_ORG_DATE | FTI_LOTPOSITION_ORG_DATE | TPM_POSITION_DATE | DATS | 8 | 0 | Original Position Acquisition Date of a Lot | ||
23 | LOTGEN_DEALNR | FTI_LOTGENERATION_DEALNR | T_RFHA | CHAR | 13 | 0 | Lot-Generating Transaction Number | * | |
24 | ACC_ASS_REF | TPM_AA_REF | TPM_AA_REF | CHAR | 12 | 0 | Account Assignment Reference of Position Management | * | |
25 | HKONT | FTI_HKONT | SAKNR | CHAR | 10 | 0 | General ledger account | * | |
26 | STICHTAG | VVSTDAT | VVSTDAT | DATS | 8 | 0 | Key date | ||
27 | SHWHR | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | TCURC | |
28 | SVWHR | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | * | |
29 | SBWHR | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | TCURC | |
30 | .INCLUDE | 0 | 0 | CFM: Initialization of Position - Key Figures | |||||
31 | UNITS | FTI_UNITS | TPM_UNITS | DEC | 22 | 6 | Number of units | ||
32 | NOMINAL_AMT_PC | FTI_NOMINAL_AMT_PC | TPM_AMOUNT | CURR | 21 | 2 | Nominal Amount in Position Currency | ||
33 | NOMINAL_ORG_PC | TPM_NOMINAL_ORG_AMT | TPM_AMOUNT | CURR | 21 | 2 | Original Nominal Amount in Position Currency | ||
34 | PURCH_PC | FTI_PURCH_PC | TPM_AMOUNT | CURR | 21 | 2 | Purchase Value in Position Currency | ||
35 | PURCH_LC | FTI_PURCH_LC | TPM_AMOUNT | CURR | 21 | 2 | Purchase Value in Local Currency | ||
36 | PURCH_VC | FTI_PURCH_VC | TPM_AMOUNT | CURR | 21 | 2 | Purchase Value in Valuation Currency | ||
37 | AQU_VAL_PC | FTI_AQU_VAL_PC | TPM_AMOUNT | CURR | 21 | 2 | Acquisition Value in Position Currency | ||
38 | AQU_VAL_LC | FTI_AQU_VAL_LC | TPM_AMOUNT | CURR | 21 | 2 | Acquisition Value in Local Currency | ||
39 | AQU_VAL_VC | FTI_AQU_VAL_VC | TPM_AMOUNT | CURR | 21 | 2 | Acquisition Value in Valuation Currency | ||
40 | BOOK_VAL_PC | FTI_BOOK_VAL_PC | TPM_AMOUNT | CURR | 21 | 2 | Book Value in Position Currency | ||
41 | BOOK_VAL_LC | FTI_BOOK_VAL_LC | TPM_AMOUNT | CURR | 21 | 2 | Book Value in Local Currency | ||
42 | BOOK_VAL_VC | FTI_BOOK_VAL_VC | TPM_AMOUNT | CURR | 21 | 2 | Book Value in Valuation Currency | ||
43 | CHARGE_PC | FTI_CHARGE_PC | TPM_AMOUNT | CURR | 21 | 2 | Costs in position currency | ||
44 | CHARGE_LC | FTI_CHARGE_LC | TPM_AMOUNT | CURR | 21 | 2 | Costs in Local Currency | ||
45 | CHARGE_VC | FTI_CHARGE_VC | TPM_AMOUNT | CURR | 21 | 2 | Costs in Valuation Currency | ||
46 | BOOK_VAL_EX_PC | FTI_BOOK_VAL_EX_PC | TPM_AMOUNT | CURR | 21 | 2 | Book Value Excluding Costs in Position Currency | ||
47 | BOOK_VAL_EX_LC | FTI_BOOK_VAL_EX_LC | TPM_AMOUNT | CURR | 21 | 2 | Book Value Excluding Costs in Local Currency | ||
48 | BOOK_VAL_EX_VC | FTI_BOOK_VAL_EX_VC | TPM_AMOUNT | CURR | 21 | 2 | Book Value Excluding Costs in Valuation Currency | ||
49 | VAL_TI_PC | FTI_VAL_TI_PC | TPM_AMOUNT | CURR | 21 | 2 | Security Valuation in Position Currency | ||
50 | VAL_TI_LC | FTI_VAL_TI_LC | TPM_AMOUNT | CURR | 21 | 2 | Security Valuation in Local Currency | ||
51 | VAL_TI_VC | FTI_VAL_TI_VC | TPM_AMOUNT | CURR | 21 | 2 | Security Valuation in Valuation Currency | ||
52 | VAL_FX_LC | FTI_VAL_FX_LC | TPM_AMOUNT | CURR | 21 | 2 | Foreign Currency Valuation in Local Currency | ||
53 | VAL_FX_VC | FTI_VAL_FX_VC | TPM_AMOUNT | CURR | 21 | 2 | Foreign Currency Valuation in Valuation Currency | ||
54 | VAL_CH_TI_PC | FTI_VAL_CH_TI_PC | TPM_AMOUNT | CURR | 21 | 2 | Valuation of Cap. Costs, Security, in Position Currency | ||
55 | VAL_CH_TI_LC | FTI_VAL_CH_TI_LC | TPM_AMOUNT | CURR | 21 | 2 | Valuation of Cap. Costs, Security, in Local Currency | ||
56 | VAL_CH_TI_VC | FTI_VAL_CH_TI_VC | TPM_AMOUNT | CURR | 21 | 2 | Valuation of Cap. Costs, Security, in Valuation Currency | ||
57 | VAL_CH_FX_LC | FTI_VAL_CH_FX_LC | TPM_AMOUNT | CURR | 21 | 2 | Valuation of Capitalized Costs, FX, in Local Currency | ||
58 | VAL_CH_FX_VC | FTI_VAL_CH_FX_VC | TPM_AMOUNT | CURR | 21 | 2 | Valuation of Capitalized Costs, FX, in Valuation Currency | ||
59 | AMORT_PC | FTI_AMORT_PC | TPM_AMOUNT | CURR | 21 | 2 | Amortization in Position Currency | ||
60 | AMORT_LC | FTI_AMORT_LC | TPM_AMOUNT | CURR | 21 | 2 | Amortization in Local Currency | ||
61 | AMORT_VC | FTI_AMORT_VC | TPM_AMOUNT | CURR | 21 | 2 | Amortization in Valuation Currency | ||
62 | AMAQU_VAL_PC | FTI_AMAQU_VAL_PC | TPM_AMOUNT | CURR | 21 | 2 | Amortized Acquisition Value in Position Currency | ||
63 | AMAQU_VAL_LC | FTI_AMAQU_VAL_LC | TPM_AMOUNT | CURR | 21 | 2 | Amortized Acquisition Value in Local Currency | ||
64 | AMAQU_VAL_VC | FTI_AMAQU_VAL_VC | TPM_AMOUNT | CURR | 21 | 2 | Amortized Acquisition Value in Valuation Currency | ||
65 | IMPMNT_PC | FTI_IMPMNT_PC | TPM_AMOUNT | CURR | 21 | 2 | Impairment in Position Currency | ||
66 | IMPMNT_LC | FTI_IMPMNT_LC | TPM_AMOUNT | CURR | 21 | 2 | Impairment in Local Currency | ||
67 | IMPMNT_VC | FTI_IMPMNT_VC | TPM_AMOUNT | CURR | 21 | 2 | Impairment in Valuation Currency | ||
68 | REPAYMENT_PC | TPM_REPAYMENT_PC | TPM_AMOUNT | CURR | 21 | 2 | Cumulative Repayment in Position Currency | ||
69 | REPAYMENT_LC | TPM_REPAYMENT_LC | TPM_AMOUNT | CURR | 21 | 2 | Cumulative Repayment in Local Currency | ||
70 | REPAYMENT_VC | TPM_REPAYMENT_VC | TPM_AMOUNT | CURR | 21 | 2 | Cumulative Repayment in Valuation Currency | ||
71 | DISAGIO_PC | FTI_DISAGIO_PC | TPM_AMOUNT | CURR | 21 | 2 | Cleared PD Deferral/Tax Compensation in Position Currency | ||
72 | DISAGIO_LC | FTI_DISAGIO_LC | TPM_AMOUNT | CURR | 21 | 2 | Cleared PD Deferral/Tax Compensation in Local Currency | ||
73 | DISAGIO_VC | FTI_DISAGIO_VC | TPM_AMOUNT | CURR | 21 | 2 | Cleared PD Deferral/Tax Compensation in Valuation Currency | ||
74 | VAL_TI_NPL_PC | FTI_VAL_TI_NPL_PC | TPM_AMOUNT | CURR | 21 | 2 | Security Valuation, Not Affecting P/L, in Position Currency | ||
75 | VAL_TI_NPL_LC | FTI_VAL_TI_NPL_LC | TPM_AMOUNT | CURR | 21 | 2 | Security Valuation, Not Affecting P/L, in Local Currency | ||
76 | VAL_TI_NPL_VC | FTI_VAL_TI_NPL_VC | TPM_AMOUNT | CURR | 21 | 2 | Security Valuation, Not Affecting P/L, in Valuation Currency | ||
77 | VAL_FX_NPL_LC | FTI_VAL_FX_NPL_LC | TPM_AMOUNT | CURR | 21 | 2 | Foreign Currency Valuation, Not Affecting P/L, in Local Crcy | ||
78 | VAL_FX_NPL_VC | FTI_VAL_FX_NPL_VC | TPM_AMOUNT | CURR | 21 | 2 | Foreign Currency Valuation, Not Affecting P/L, in Val. Crcy | ||
79 | VAL_CH_TI_NPL_PC | FTI_VAL_CH_TI_NPL_PC | TPM_AMOUNT | CURR | 21 | 2 | Valuation of Cap. Costs, Sec., Not Aff. P/L in Position Crcy | ||
80 | VAL_CH_TI_NPL_LC | FTI_VAL_CH_TI_NPL_LC | TPM_AMOUNT | CURR | 21 | 2 | Valuation of Cap. Costs, Sec., Not Aff. P/L in Local Crcy | ||
81 | VAL_CH_TI_NPL_VC | FTI_VAL_CH_TI_NPL_VC | TPM_AMOUNT | CURR | 21 | 2 | Valuation of Cap. Costs, Sec., Not Aff. P/L in Val. Crcy | ||
82 | VAL_CH_FX_NPL_LC | FTI_VAL_CH_FX_NPL_LC | TPM_AMOUNT | CURR | 21 | 2 | Valuation of Cap. Costs, FX, Not Aff. P/L in Local Currency | ||
83 | VAL_CH_FX_NPL_VC | FTI_VAL_CH_FX_NPL_VC | TPM_AMOUNT | CURR | 21 | 2 | Valuation of Cap. Costs, FX, Not Aff. P/L in Valuation Crcy | ||
84 | VARMAR_PC | FTI_VARMAR_PC | TPM_AMOUNT | CURR | 21 | 2 | Variation Margin in Position Currency | ||
85 | VARMAR_LC | FTI_VARMAR_LC | TPM_AMOUNT | CURR | 21 | 2 | Variation Margin in Local Currency | ||
86 | VARMAR_VC | FTI_VARMAR_VC | TPM_AMOUNT | CURR | 21 | 2 | Variation Margin in Valuation Currency | ||
87 | SPOTVALP_LC | FTI_SPOTVALP_LC | TPM_AMOUNT | CURR | 21 | 2 | Spot Valuation of Purchase Currency in Local Currency | ||
88 | SPOTVALP_VC | FTI_SPOTVALP_VC | TPM_AMOUNT | CURR | 21 | 2 | Spot Valuation of Purchase Currency in Valuation Currency | ||
89 | SPOTVALS_LC | FTI_SPOTVALS_LC | TPM_AMOUNT | CURR | 21 | 2 | Spot Valuation of Sale Currency in Local Currency | ||
90 | SPOTVALS_VC | FTI_SPOTVALS_VC | TPM_AMOUNT | CURR | 21 | 2 | Spot Valuation of Sale Currency in Valuation Currency | ||
91 | SWAPACC_PC | FTI_SWAPACC_PC | TPM_AMOUNT | CURR | 21 | 2 | Swap/Margin Accrual/Deferral in Position Currency | ||
92 | SWAPACC_LC | FTI_SWAPACC_LC | TPM_AMOUNT | CURR | 21 | 2 | Swap or Margin Accrual/Deferral in Local Currency | ||
93 | SWAPACC_VC | FTI_SWAPACC_VC | TPM_AMOUNT | CURR | 21 | 2 | Swap or Margin Accrual/Deferral in Valuation Currency | ||
94 | SWAPVAL_LC | FTI_SWAPVAL_LC | TPM_AMOUNT | CURR | 21 | 2 | Swap Valuation in Local Currency | ||
95 | SWAPVAL_VC | FTI_SWAPVAL_VC | TPM_AMOUNT | CURR | 21 | 2 | Swap Valuation in Valuation Currency | ||
96 | CON_GAIN_TI_PC | FTI_CONS_GAINS_TI_PC | TPM_AMOUNT | CURR | 21 | 2 | Consolidated Security Gains in Position Currency | ||
97 | CON_GAIN_TI_LC | FTI_CONS_GAINS_TI_LC | TPM_AMOUNT | CURR | 21 | 2 | Consolidated Security Gains in Local Currency | ||
98 | CON_GAIN_TI_VC | FTI_CONS_GAINS_TI_VC | TPM_AMOUNT | CURR | 21 | 2 | Consolidated Security Gains in Valuation Currency | ||
99 | CON_LOSS_TI_PC | FTI_CONS_LOSSES_TI_PC | TPM_AMOUNT | CURR | 21 | 2 | Consolidated Security Losses in Position Currency | ||
100 | CON_LOSS_TI_LC | FTI_CONS_LOSSES_TI_LC | TPM_AMOUNT | CURR | 21 | 2 | Consolidated Security Losses in Local Currency | ||
101 | CON_LOSS_TI_VC | FTI_CONS_LOSSES_TI_VC | TPM_AMOUNT | CURR | 21 | 2 | Consolidated Security Losses in Valuation Currency | ||
102 | CON_GAIN_FX_VC | FTI_CONS_GAINS_FX_VC | TPM_AMOUNT | CURR | 21 | 2 | Consolidated FX Gains in Valuation Currency | ||
103 | CON_LOSS_FX_VC | FTI_CONS_LOSSES_FX_VC | TPM_AMOUNT | CURR | 21 | 2 | Consolidated FX Losses in Valuation Currency | ||
104 | CON_GAIN_FX_LC | FTI_CONS_GAINS_FX_LC | TPM_AMOUNT | CURR | 21 | 2 | Consolidated FX Gains in Local Currency | ||
105 | CON_LOSS_FX_LC | FTI_CONS_LOSSES_FX_LC | TPM_AMOUNT | CURR | 21 | 2 | Consolidated FX Losses in Local Currency | ||
106 | UPDMOD | RODMUPDMOD | RODMUPDMOD | CHAR | 1 | 0 | BW Delta Process: Record Mode |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FTI_TEMPLATE_INIT_POSITION | ACCOUNT_GROUP | TRGT_SECACCGRP | SEC_ACCT_GRP | |||
2 | FTI_TEMPLATE_INIT_POSITION | BUKRS | T001 | BUKRS | |||
3 | FTI_TEMPLATE_INIT_POSITION | DEAL_NUMBER | VTBFHA | RFHA | |||
4 | FTI_TEMPLATE_INIT_POSITION | GSART | TZPA | GSART | |||
5 | FTI_TEMPLATE_INIT_POSITION | LOANS_CONTRACT | VDARL | RANL | |||
6 | FTI_TEMPLATE_INIT_POSITION | MANDT | T000 | MANDT | |||
7 | FTI_TEMPLATE_INIT_POSITION | PORTFOLIO | TWPOB | RPORTB | |||
8 | FTI_TEMPLATE_INIT_POSITION | POSITION_ACCOUNT | TRFT_POS_ACCOUNT | POS_ACCOUNT | |||
9 | FTI_TEMPLATE_INIT_POSITION | SBWHR | TCURC | WAERS | |||
10 | FTI_TEMPLATE_INIT_POSITION | SECURITY_ACCOUNT | TWD01 | RLDEPO | |||
11 | FTI_TEMPLATE_INIT_POSITION | SECURITY_ID | VWPANLA | RANL | |||
12 | FTI_TEMPLATE_INIT_POSITION | SHWHR | TCURC | WAERS | |||
13 | FTI_TEMPLATE_INIT_POSITION | TR_ACC_CODE | TRGC_TR_ACC_CODE | TR_ACC_CODE | |||
14 | FTI_TEMPLATE_INIT_POSITION | VALUATION_AREA | TRGC_VAL_AREA | VALUATION_AREA | |||
15 | FTI_TEMPLATE_INIT_POSITION | VALUATION_CLASS | TRGC_VAL_CLASS | VALUATION_CLASS |
History
Last changed by/on | SAP | 20080505 |
SAP Release Created in | 200 |