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

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