SAP ABAP Table FTI_TEMPLATE_DELTA_POSITION (CFM: Delta 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_DELTA_POSITION   Table Relationship Diagram
Short Description CFM: Delta 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: Delta Position for ODS 0CFM_O01  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 VALUATION_AREA TPM_VAL_AREA TPM_VAL_AREA CHAR 3   0   Valuation Area TRGC_VAL_AREA
4 BUSTRANSID TPM_BUSTRANSID SYSUUID RAW 16   0   Identifier of the Distributor Business Transaction  
5 TRLFLOWNUMBER TPM_TRLFLOWNR TPM_TRLFLOW_NR INT4 10   0   Number of TRL Flow  
6 .INCLUDE       0   0   Semantic Attributes for ODS 0CFM_O01  
7 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
8 TR_ACC_CODE TPM_ACC_CODE TPM_ACC_CODE CHAR 4   0   Accounting Code *
9 VALUATION_CLASS TPM_VAL_CLASS TPM_VAL_CLASS NUMC 4   0   Valuation Class *
10 GSART VVSART VVSART CHAR 3   0   Product Type *
11 PORTFOLIO RPORTB RPORTB CHAR 10   0   Portfolio *
12 SECURITY_ID VVRANLW WP_RANL CHAR 13   0   Security ID Number *
13 LOANS_CONTRACT RANL RANL CHAR 13   0   Contract Number *
14 DEAL_NUMBER FTI_POSRFHA T_RFHA CHAR 13   0   Financial Transaction That Creates a Position *
15 ACCOUNT_GROUP TPM_SEC_ACCT_GRP TPM_SEC_ACCT_GRP CHAR 10   0   Securities Account Group *
16 SECURITY_ACCOUNT VRLDEPO RLDEPO CHAR 10   0   Securities Account *
17 POSITION_ACCOUNT TPM_POS_ACCOUNT_FUT TPM_POS_ACCOUNT_FUT CHAR 10   0   Futures Account for Listed Options and Futures *
18 FLAG_LONG_SHORT TPM_FLAG_LONG_SHORT TPM_FLAG_LONG_SHORT CHAR 1   0   Indicator: Long or Short Position  
19 LOT_ID TPM_LOT_ID SYSUUID RAW 16   0   Identifier of the Lot  
20 DLOTGENERATION DLOTGENERATION DATUM DATS 8   0   Date On Which Lot Was Generated  
21 TLOTGENERATION TLOTGENERATION UZEIT TIMS 6   0   Lot Generation Time  
22 LOTGENERATION_US FTI_LOTGENERATIONUSER SYCHAR12 CHAR 12   0   Lot Entered By  
23 LOTGENERATION_CT FTI_LOTGENERATION_BUSTRANSCAT TPM_BUSTRANSCAT NUMC 4   0   Business Transaction Category Which Generated the Lot *
24 LOTPOS_INIT_DATE FTI_LOTPOSITION_INIT_DATE TPM_POSITION_DATE DATS 8   0   Position Acquisition Date of a Lot  
25 LOTPOS_ORG_DATE FTI_LOTPOSITION_ORG_DATE TPM_POSITION_DATE DATS 8   0   Original Position Acquisition Date of a Lot  
26 LOTGEN_DEALNR FTI_LOTGENERATION_DEALNR T_RFHA CHAR 13   0   Lot-Generating Transaction Number *
27 ACC_ASS_REF TPM_AA_REF TPM_AA_REF CHAR 12   0   Account Assignment Reference of Position Management *
28 HKONT FTI_HKONT_BI SAKNR CHAR 10   0   General Ledger Account *
29 DBESTAND DBESTAND DATUM DATS 8   0   Position value date  
30 SE_DEAL_NUMBER FTI_SE_RFHA T_RFHA CHAR 13   0   Securities/Futures Transaction *
31 RKONTRA RKONTRA_NEW BU_PARTNER CHAR 10   0   Reference to Counterparty *
32 FLOW_TYPE TPM_DIS_FLOWTYPE TPM_DIS_FLOWTYPE CHAR 8   0   Update Type *
33 BUSTRANSCAT TPM_BUSTRANSCAT TPM_BUSTRANSCAT NUMC 4   0   Business Transaction Category *
34 GEN_BUSTRANSCAT FTI_GENERATING_BUSTRANSCAT TPM_BUSTRANSCAT NUMC 4   0   Generating Business Transaction Category *
35 SOURCETARGET_FLG TPM_SOURCE_TARGET_FLG TPM_SOURCE_TARGET_FLG CHAR 1   0   Indicator: Source or Target of a Flow  
36 QUANT_CAT FTI_QTY_PM_CAT TPM_QTY_PM_CAT CHAR 4   0   Position Change Category: Quantity  
37 AMOUNT_CAT FTI_AMT_PM_CAT TPM_PM_CAT CHAR 4   0   Position Change Category *
38 TRL_BOOKINGSTATE TPM_TRL_BOOKINGSTATE TPM_TRL_BOOKINGSTATE CHAR 1   0   Posting Status Treasury Ledger Business Transaction  
39 PL_CATEGORY TPM_PL_CATEGORY TPM_PL_CATEGORY CHAR 3   0   P/L Type *
40 LEDGER_POST_STAT FTR_LEDGER_POSTING_STATE FTR_LEDGER_POSTING_STATE CHAR 1   0   Ledger Posting Status  
41 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
42 AWKEY AWKEY AWKEY CHAR 20   0   Object key  
43 GL_ACCOUNT_D FTI_GLACC_D SAKNR CHAR 10   0   Number of G/L Account: Debit *
44 GL_ACCOUNT_C FTI_GLACC_C SAKNR CHAR 10   0   Number of G/L Account: Credit *
45 DBUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
46 DGJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
47 DMONAT MONAT MONAT NUMC 2   0   Fiscal period  
48 PERIO JAHRPER JAHRPER NUMC 7   0   Period/year  
49 SZBMETH SZBMETH SZBMETH CHAR 1   0   Interest Calculation Method  
50 DBERVON DBERVON DATUM DATS 8   0   Start of Calculation Period  
51 DBERBIS DBERBIS DATUM DATS 8   0   End of Calculation Period  
52 SINCLVON VVSINCL VVSINCL NUMC 1   0   Inclusive indicator for beginning and end of a period  
53 SINCLBIS VVSINCL VVSINCL NUMC 1   0   Inclusive indicator for beginning and end of a period  
54 SSOLHAB VVSSOLHAB VVSSOLHAB CHAR 1   0   Debit/credit indicator  
55 SHWHR TB_SHWHR WAERS CUKY 5   0   Local Currency TCURC
56 SVWHR TPM_VALUATION_CURR WAERS CUKY 5   0   Valuation Currency TCURC
57 SBWHR TB_BWHR WAERS CUKY 5   0   Position Currency/Transaction Currency TCURC
58 PLWHR SPLWHR WAERS CUKY 5   0   Profit/loss currency TCURC
59 .INCLUDE       0   0   CFM: Delta Position (Key Figures)  
60 D_UNITS FTI_D_UNITS TPM_UNITS DEC 22   6   Delta Number of Units  
61 D_NOMINAL_AMT_PC FTI_D_NOMINAL_AMT_PC TPM_AMOUNT CURR 21   2   Delta Nominal Amount in Position Currency  
62 D_NOMINAL_ORG_PC FTI_D_NOMINAL_ORG_AMT_PC TPM_AMOUNT CURR 21   2   Delta: Original Nominal Amount in Position Currency  
63 D_PURCH_PC FTI_D_PURCH_PC TPM_AMOUNT CURR 21   2   Delta Purchase Value in Position Currency  
64 D_PURCH_LC FTI_D_PURCH_LC TPM_AMOUNT CURR 21   2   Delta Purchase Value in Local Currency  
65 D_PURCH_VC FTI_D_PURCH_VC TPM_AMOUNT CURR 21   2   Delta Purchase Value in Valuation Currency  
66 D_AQU_VAL_PC FTI_D_AQU_VAL_PC TPM_AMOUNT CURR 21   2   Delta Acquisition Value in Position Currency  
67 D_AQU_VAL_LC FTI_D_AQU_VAL_LC TPM_AMOUNT CURR 21   2   Delta Acquisition Value in Local Currency  
68 D_AQU_VAL_VC FTI_D_AQU_VAL_VC TPM_AMOUNT CURR 21   2   Delta Acquisition Value in Valuation Currency  
69 D_BOOK_VAL_PC FTI_D_BOOK_VAL_PC TPM_AMOUNT CURR 21   2   Delta Book Value in Position Currency  
70 D_BOOK_VAL_LC FTI_D_BOOK_VAL_LC TPM_AMOUNT CURR 21   2   Delta Book Value in Local Currency  
71 D_BOOK_VAL_VC FTI_D_BOOK_VAL_VC TPM_AMOUNT CURR 21   2   Delta Book Value in Valuation Currency  
72 D_CHARGE_PC FTI_D_CHARGE_PC TPM_AMOUNT CURR 21   2   Delta Costs in Position Currency  
73 D_CHARGE_LC FTI_D_CHARGE_LC TPM_AMOUNT CURR 21   2   Delta Costs in Local Currency  
74 D_CHARGE_VC FTI_D_CHARGE_VC TPM_AMOUNT CURR 21   2   Delta Costs in Valuation Currency  
75 D_BOOK_VAL_EX_PC FTI_D_BOOK_VAL_EX_PC TPM_AMOUNT CURR 21   2   Delta Book Value Excl. Costs in Position Currency  
76 D_BOOK_VAL_EX_LC FTI_D_BOOK_VAL_EX_LC TPM_AMOUNT CURR 21   2   Delta Book Value Excl. Costs in Local Currency  
77 D_BOOK_VAL_EX_VC FTI_D_BOOK_VAL_EX_VC TPM_AMOUNT CURR 21   2   Delta Book Value Excl. Costs in Valuation Currency  
78 D_VAL_TI_PC FTI_D_VAL_TI_PC TPM_AMOUNT CURR 21   2   Delta Security Valuation in Position Currency  
79 D_VAL_TI_LC FTI_D_VAL_TI_LC TPM_AMOUNT CURR 21   2   Delta Security Valuation in Local Currency  
80 D_VAL_TI_VC FTI_D_VAL_TI_VC TPM_AMOUNT CURR 21   2   Delta Security Valuation in Valuation Currency  
81 D_VAL_FX_LC FTI_D_VAL_FX_LC TPM_AMOUNT CURR 21   2   Delta Foreign Currency Valuation in Local Currency  
82 D_VAL_FX_VC FTI_D_VAL_FX_VC TPM_AMOUNT CURR 21   2   Delta Foreign Currency Valuation in Valuation Currency  
83 D_VAL_CH_TI_PC FTI_D_VAL_CH_TI_PC TPM_AMOUNT CURR 21   2   Delta Valuation of Capitalized Costs, Security, in PC  
84 D_VAL_CH_TI_LC FTI_D_VAL_CH_TI_LC TPM_AMOUNT CURR 21   2   Delta Valuation of Capitalized Costs, Security, in LC  
85 D_VAL_CH_TI_VC FTI_D_VAL_CH_TI_VC TPM_AMOUNT CURR 21   2   Delta Valuation of Capitalized Costs, Security, in VC  
86 D_VAL_CH_FX_LC FTI_D_VAL_CH_FX_LC TPM_AMOUNT CURR 21   2   Delta Valuation of Capitalized Costs, FX, in Local Currency  
87 D_VAL_CH_FX_VC FTI_D_VAL_CH_FX_VC TPM_AMOUNT CURR 21   2   Delta Valuation of Capitalized Costs, FX, in Valuation Crcy  
88 D_AMORT_PC FTI_D_AMORT_PC TPM_AMOUNT CURR 21   2   Delta Amortization in Position Currency  
89 D_AMORT_LC FTI_D_AMORT_LC TPM_AMOUNT CURR 21   2   Delta Amortization in Local Currency  
90 D_AMORT_VC FTI_D_AMORT_VC TPM_AMOUNT CURR 21   2   Delta Amortization in Valuation Currency  
91 D_IMPMNT_PC FTI_D_IMPMNT_PC TPM_AMOUNT CURR 21   2   Delta Impairment in Position Currency  
92 D_IMPMNT_LC FTI_D_IMPMNT_LC TPM_AMOUNT CURR 21   2   Delta Impairment in Local Currency  
93 D_IMPMNT_VC FTI_D_IMPMNT_VC TPM_AMOUNT CURR 21   2   Delta Impairment in Valuation Currency  
94 D_REPAYMENT_PC FTI_D_REPAYMENT_PC TPM_AMOUNT CURR 21   2   Delta: Cumulative Repayment in Position Currency  
95 D_REPAYMENT_LC FTI_D_REPAYMENT_LC TPM_AMOUNT CURR 21   2   Delta: Cumulative Repayment in Local Currency  
96 D_REPAYMENT_VC FTI_D_REPAYMENT_VC TPM_AMOUNT CURR 21   2   Delta: Cumulative Repayment in Valuation Currency  
97 D_AMAQU_VAL_PC FTI_D_AMAQU_VAL_PC TPM_AMOUNT CURR 21   2   Delta Amortized Acquisition Value in Position Currency  
98 D_AMAQU_VAL_LC FTI_D_AMAQU_VAL_LC TPM_AMOUNT CURR 21   2   Delta Amortized Acquisition Value in Local Currency  
99 D_AMAQU_VAL_VC FTI_D_AMAQU_VAL_VC TPM_AMOUNT CURR 21   2   Delta Amortized Acquisition Value in Valuation Currency  
100 D_DISAGIO_PC FTI_D_DISAGIO_PC TPM_AMOUNT CURR 21   2   Delta Cleared PD Def./Tax Compensation in Position Currency  
101 D_DISAGIO_LC FTI_D_DISAGIO_LC TPM_AMOUNT CURR 21   2   Delta Cleared PD Def./Tax Compensation in Local Currency  
102 D_DISAGIO_VC FTI_D_DISAGIO_VC TPM_AMOUNT CURR 21   2   Delta Cleared PD Def./Tax Compensation in Valuation Currency  
103 D_VAL_TI_NPL_PC FTI_D_VAL_TI_NPL_PC TPM_AMOUNT CURR 21   2   Delta Security Valuation, Not Affecting P/L, in Pos. Crcy  
104 D_VAL_TI_NPL_LC FTI_D_VAL_TI_NPL_LC TPM_AMOUNT CURR 21   2   Delta Security Valuation, Not Affecting P/L, in Local Crcy  
105 D_VAL_TI_NPL_VC FTI_D_VAL_TI_NPL_VC TPM_AMOUNT CURR 21   2   Delta Security Valuation, Not Affecting P/L, in Val. Crcy  
106 D_VAL_FX_NPL_LC FTI_D_VAL_FX_NPL_LC TPM_AMOUNT CURR 21   2   Delta Foreign Currency Valuation, Not Affecting P/L, in LC  
107 D_VAL_FX_NPL_VC FTI_D_VAL_FX_NPL_VC TPM_AMOUNT CURR 21   2   Delta Foreign Currency Valuation, Not Affecting P/L, in VC  
108 D_VAL_CH_TI_N_PC FTI_D_VAL_CH_TI_NPL_PC TPM_AMOUNT CURR 21   2   Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Position Crcy  
109 D_VAL_CH_TI_N_LC FTI_D_VAL_CH_TI_NPL_LC TPM_AMOUNT CURR 21   2   Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Local Crcy  
110 D_VAL_CH_TI_N_VC FTI_D_VAL_CH_TI_NPL_VC TPM_AMOUNT CURR 21   2   Delta Val.of Cap.Costs, Sec., Not Aff. P/L, Valuation Crcy  
111 D_VAL_CH_FX_N_LC FTI_D_VAL_CH_FX_NPL_LC TPM_AMOUNT CURR 21   2   Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Local Crcy  
112 D_VAL_CH_FX_N_VC FTI_D_VAL_CH_FX_NPL_VC TPM_AMOUNT CURR 21   2   Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Val. Crcy  
113 D_VARMAR_PC FTI_D_VARMAR_PC TPM_AMOUNT CURR 21   2   Delta Variation Margin in Position Currency  
114 D_VARMAR_LC FTI_D_VARMAR_LC TPM_AMOUNT CURR 21   2   Delta Variation Margin in Local Currency  
115 D_VARMAR_VC FTI_D_VARMAR_VC TPM_AMOUNT CURR 21   2   Delta Variation Margin in Valuation Currency  
116 D_SPOTVALP_LC FTI_D_SPOTVALP_LC TPM_AMOUNT CURR 21   2   Delta Spot Valuation of Purchase Crcy in Local Currency  
117 D_SPOTVALP_VC FTI_D_SPOTVALP_VC TPM_AMOUNT CURR 21   2   Delta Spot Valuation of Purchase Crcy in Valuation Currency  
118 D_SPOTVALS_LC FTI_D_SPOTVALS_LC TPM_AMOUNT CURR 21   2   Delta Spot Valuation of Sale Currency in Local Currency  
119 D_SPOTVALS_VC FTI_D_SPOTVALS_VC TPM_AMOUNT CURR 21   2   Delta Spot Valuation of Sale Currency in Valuation Currency  
120 D_SWAPACC_PC FTI_D_SWAPACC_PC TPM_AMOUNT CURR 21   2   Delta Swap/Margin Accrual/Deferral in Position Currency  
121 D_SWAPACC_LC FTI_D_SWAPACC_LC TPM_AMOUNT CURR 21   2   Delta Swap/Margin Accrual/Deferral in Local Currency  
122 D_SWAPACC_VC FTI_D_SWAPACC_VC TPM_AMOUNT CURR 21   2   Delta Swap/Margin Accrual/Deferral in Valuation Currency  
123 D_SWAPVAL_LC FTI_D_SWAPVAL_LC TPM_AMOUNT CURR 21   2   Delta Swap Valuation in Local Currency  
124 D_SWAPVAL_VC FTI_D_SWAPVAL_VC TPM_AMOUNT CURR 21   2   Delta Swap Valuation in Valuation Currency  
125 AMOUNT_PC FTI_D_AMOUNT_PC TPM_AMOUNT CURR 21   2   Flow Amount in Position Currency  
126 AMOUNT_LC FTI_D_AMOUNT_LC TPM_AMOUNT CURR 21   2   Flow Amount in Local Currency  
127 AMOUNT_VC FTI_D_AMOUNT_VC TPM_AMOUNT CURR 21   2   Flow Amount in Valuation Currency  
128 PLAMOUNT_PLC FTI_PLAMOUNT_PLC TPM_AMOUNT CURR 21   2   Profit/loss amount in profit/loss currency  
129 PLAMOUNT_LC FTI_PLAMOUNT_LC TPM_AMOUNT CURR 21   2   Profit/loss amount in local currency  
130 D_CON_GAIN_FX_LC FTI_D_CONS_GAINS_FX_LC TPM_AMOUNT CURR 21   2   Delta Consolidated FX Gains in Local Currency  
131 D_CON_GAIN_FX_VC FTI_D_CONS_GAINS_FX_VC TPM_AMOUNT CURR 21   2   Delta Consolidated FX Gains in Valuation Currency  
132 D_CON_GAIN_TI_LC FTI_D_CONS_GAINS_TI_LC TPM_AMOUNT CURR 21   2   Delta Consolidated Security Gains in Local Currency  
133 D_CON_GAIN_TI_PC FTI_D_CONS_GAINS_TI_PC TPM_AMOUNT CURR 21   2   Delta Consolidated Security Gains in Position Currency  
134 D_CON_GAIN_TI_VC FTI_D_CONS_GAINS_TI_VC TPM_AMOUNT CURR 21   2   Delta Consolidated Security Gains in Valuation Currency  
135 D_CON_LOSS_FX_LC FTI_D_CONS_LOSSES_FX_LC TPM_AMOUNT CURR 21   2   Delta Consolidated FX Losses in Local Currency  
136 D_CON_LOSS_FX_VC FTI_D_CONS_LOSSES_FX_VC TPM_AMOUNT CURR 21   2   Delta Consolidated FX Losses in Valuation Currency  
137 D_CON_LOSS_TI_LC FTI_D_CONS_LOSSES_TI_LC TPM_AMOUNT CURR 21   2   Delta Consolidated Security Losses in Local Currency  
138 D_CON_LOSS_TI_PC FTI_D_CONS_LOSSES_TI_PC TPM_AMOUNT CURR 21   2   Delta Consolidated Security Losses in Position Currency  
139 D_CON_LOSS_TI_VC FTI_D_CONS_LOSSES_TI_VC TPM_AMOUNT CURR 21   2   Delta Consolidated Security Losses in Valuation Currency  
140 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_DELTA_POSITION MANDT T000 MANDT    
2 FTI_TEMPLATE_DELTA_POSITION PLWHR TCURC WAERS    
3 FTI_TEMPLATE_DELTA_POSITION SBWHR TCURC WAERS    
4 FTI_TEMPLATE_DELTA_POSITION SHWHR TCURC WAERS    
5 FTI_TEMPLATE_DELTA_POSITION SVWHR TCURC WAERS    
6 FTI_TEMPLATE_DELTA_POSITION VALUATION_AREA TRGC_VAL_AREA VALUATION_AREA    
History
Last changed by/on SAP  20130529 
SAP Release Created in 200