SAP ABAP Table FTI_LDB_TR_POSITIONS (Treasury: Positions (-> LDB))
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FIN-FSCM-TRM-TM-IS (Application Component) Information System
     FTI_LDB (Package) Logical Databases for the R/3 CFM Information System
Basic Data
Table Category INTTAB    Structure 
Structure FTI_LDB_TR_POSITIONS   Table Relationship Diagram
Short Description Treasury: Positions (-> LDB)    
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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
3 LAND1 FTI_LAND1 LAND1 CHAR 3   0   Country key of company code T005
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 POS_MAN_PROC TPM_POS_MAN_PROC TPM_POS_MAN_PROC CHAR 4   0   Position Management Procedure TRGC_PM_PROC
8 ACTIVE_PASSIVE FTI_ASSLIAB_IND FTI_ASSLIAB_IND CHAR 1   0   Assets/Liabilities Indicator  
9 GSART VVSART VVSART CHAR 3   0   Product Type TZPA
10 PORTFOLIO TPM_PORTFOLIO_DIFF RPORTB CHAR 10   0   Portfolio as Differentiation Characteristic TWPOB
11 SECURITY_ID VVRANLW WP_RANL CHAR 13   0   Security ID Number VWPANLA
12 LOANS_CONTRACT RANL RANL CHAR 13   0   Contract Number VDARL
13 DEAL_NUMBER FTI_POSRFHA T_RFHA CHAR 13   0   Financial Transaction That Creates a Position VTBFHA
14 HEDGE_ID THM_HEDGE_ID THM_HEDGE_ID NUMC 10   0   Hedge Item Identification Number *
15 ACCOUNT_GROUP TPM_SEC_ACCT_GRP TPM_SEC_ACCT_GRP CHAR 10   0   Securities Account Group TRGT_SECACCGRP
16 SECURITY_ACCOUNT RLDEPO RLDEPO CHAR 10   0   Securities Account TWD01
17 POSITION_ACCOUNT TPM_POS_ACCOUNT_FUT TPM_POS_ACCOUNT_FUT CHAR 10   0   Futures Account for Listed Options and Futures TRFT_POS_ACCOUNT
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_USER FTI_LOTGENERATIONUSER SYCHAR12 CHAR 12   0   Lot Entered By  
23 LOTGENERATION_BUSTRANSCAT FTI_LOTGENERATION_BUSTRANSCAT TPM_BUSTRANSCAT NUMC 4   0   Business Transaction Category Which Generated the Lot TRDTS_BT_CAT
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_BUKRS FTI_LOTGENERATION_BUKRS BUKRS CHAR 4   0   Company Code of Lot-Generating Transaction *
27 LOTGEN_DEALNR FTI_LOTGENERATION_DEALNR T_RFHA CHAR 13   0   Lot-Generating Transaction Number *
28 SANLF SANLF VVSANLF NUMC 3   0   Product Category TZAF
29 STICHTAG FTI_STICHTAG VVSTDAT DATS 8   0   Key Date  
30 RANTYP_R FTI_RANTYP FTI_RANTYP CHAR 1   0   Contract type  
31 RREFKONT_R TB_REFKONT USTRU CHAR 8   0   Acct Assignment Ref. for Operative Valn Area and Loan T037S
32 ACC_ASS_REF TPM_AA_REF TPM_AA_REF CHAR 12   0   Account Assignment Reference of Position Management TRACC_AA_REF
33 HKONT FTI_HKONT SAKNR CHAR 10   0   General ledger account SKB1
34 DBLFZ DBLFZ DATUM DATS 8   0   Start of Term  
35 DELFZ DELFZ DATUM DATS 8   0   End of Term  
36 RLZTG FTI_RLZTG NUMC5 NUMC 5   0   Remaining Term in Days  
37 RLZMO FTI_RLZMO NUMC4 NUMC 4   0   Remaining Term in Months  
38 RLZJA FTI_RLZJA NUMC3 NUMC 3   0   Remaining Term in Years  
39 UEBTG FTI_UEBTG NUMC5 NUMC 5   0   Overdue Period in Days  
40 UEBMO FTI_UEBMO NUMC3 NUMC 3   0   Overdue Period in Months  
41 UEBJA FTI_UEBJA NUMC2 NUMC 2   0   Overdue Period in Years  
42 .INCLUDE       0   0   Include for Data of Commitment Partner (->LDBs)  
43 .INCLUDE       0   0   Treasury: Commitment Partner  
44 PARTNR FTI_LDB_RISK_COUNTERPARTY BU_PARTNER CHAR 10   0   Partner with Whom Commitment Exists BUT000
45 .INCLUDE       0   0   Treasury: Partner Attributes  
46 TYPE BP_TYPE_NEW BU_TYPE CHAR 1   0   Business Partner Category  
47 ISTYPE BU_ISTYPE BU_ISTYPE CHAR 4   0   Industry System TB038
48 IND_SECTOR BU_IND_SECTOR BU_INDSECTOR CHAR 10   0   Industry TB038A
49 CNTRY_COMP FTI_LANDBP LAND1 CHAR 3   0   Country of Registered Office of Business Partner T005
50 LEGAL_ENTY BP_LEG_ETY_NEW BU_LEGENTY CHAR 2   0   Legal Form of Organization TB019
51 LEGAL_ORG BU_LEGAL_ORG_NEW BU_LEGAL_ORG CHAR 2   0   Legal Entity of Organization TB032
52 NATION BP_CNTR_N LAND1 CHAR 3   0   Nationality T005
53 STATE BP_CNTR_ST LAND1 CHAR 3   0   Citizenship T005
54 GROUP_ID BU_GRP_ID_NEW BU_GROUP CHAR 4   0   Business Partner Grouping TB001
55 GROUP_D BP_GROUP_D BP_GROUP_D CHAR 4   0   Target Group TP13
56 STAFF_GRP BP_STAFF_G BP_STAFF_G CHAR 4   0   Employee Group TP05
57 COMP_RE BP_COMP_RE BP_COMP_RE CHAR 1   0   Organization Relationship  
58 .INCLUDE       0   0   Business partner credit standing data  
59 SOLVNCY BP_SOLVNCY BP_SOLVNCY CHAR 1   0   Credit Standing  
60 RATING BP_RATING BP_RATING CHAR 3   0   Rating TP06
61 SOL_INS BP_SOL_INS BP_SOL_INS CHAR 4   0   Institute Providing Credit Standing Information TP07
62 SOL_INF BP_SOL_INF BP_SOL_INF CHAR 1   0   Status of Credit Standing Information  
63 SOL_I_D BP_SOL_I_D DATUM DATS 8   0   Date of Credit Standing Information  
64 .INCLUDE       0   0   Include for Transaction Attributes Rel. for Position (->LDB)  
65 SFHAART TB_SFHAART T_SFHAART CHAR 3   0   Financial Transaction Type *
66 FINPROJ TB_TFPROJ T_TFPROJ CHAR 13   0   Finance Project  
67 RMAID TB_RMAID T_RMAID CHAR 10   0   Master Agreement VTBMA
68 RGARANT TB_RGARANT_NEW BU_PARTNER CHAR 10   0   Guarantor of Financial Transaction BUT000
69 NORDEXT TB_NORDEXT FTI_CHAR16LOW CHAR 16   0   External Reference  
70 ZUOND TB_ZUOND TEXT18 CHAR 18   0   Assignment  
71 REFER TB_REFER CHAR16 CHAR 16   0   Internal Reference  
72 MERKM TB_MERKM CHAR25 CHAR 25   0   Characteristics  
73 PORTFOLIO_TM RPORTB RPORTB CHAR 10   0   Portfolio TWPOB
74 RDEALER RDEALER RDEALER CHAR 12   0   Trader TZDEA
75 RDPBANK RDEPOTBANK BU_PARTNER CHAR 10   0   Depository Bank BUT000
76 SECACC_TYPE TPM_SECACC_TYPE TPM_SECACC_TYPE CHAR 3   0   Securities Account Type TRSC_SECACC_TYPE
77 SECACC_CAT TPM_SECACC_CAT TPM_SECACC_CAT CHAR 1   0   Securities Account Category  
78 SBILK SBILK SBILK CHAR 2   0   Balance Sheet Indicator TW11
79 .INCLUDE       0   0   Include for Time-Dependent Class Data (-> LDBs)  
80 SNOTI SNOTI SNOTI NUMC 1   0   Quotation Indicator  
81 ALWPKL ALWPKL ALWPKL CHAR 3   0   General Security Classification TW22
82 SWERTTYP SWERTTYP SAKTTYP NUMC 1   0   Security Type ID TW20
83 SOL_INS_RANL FTI_SOL_INS_RANL BP_SOL_INS CHAR 4   0   Institut Supplying Credit Rating Information for Secur. ID TP07
84 RATING_RANL BP_RATING_RANL BP_RATING CHAR 3   0   Rating for Securities ID Number/OTC Transaction TP06
85 SWPKLASS SWPKLASS SWPKLASS NUMC 3   0   Classification of bond TW01
86 SAKAR SAKAR SAKAR NUMC 1   0   Stock category  
87 SFOART VVSFOART VVSFOART CHAR 2   0   Fund category indicator  
88 SFOTY SFOTY SFOTY NUMC 1   0   Fund type indicator TW21
89 SARTBET SARTBET SARTBET NUMC 2   0   Type of shareholding TW02
90 SBOERNOT SBOERNOT JANEI CHAR 1   0   Indicator: Listed on an Exchange  
91 VVRANLWX VVRANLWXS CHAR20S CHAR 20   0   Secondary index class data  
92 RHANDPL FTI_RHANDPL_MW VVRHANDPL CHAR 10   0   Exchange TWH01
93 AAAAKTIE FTI_AAAKTIE DEC12 DEC 12   0   Number of stocks issued  
94 KBNEWE VVBNEWE VVKWKURS DEC 15   6   Nominal Value per Stock (Independent of Currency)  
95 KZAHLAKT KZAHLAKT DEC3_7 DEC 10   7   Pay-in rate  
96 INT_CAT FTI_INTTYPE FTI_INTEREST_TYPE CHAR 1   0   Interest Category  
97 PKOND TV_PKOND DECV3_7 DEC 10   7   Interest rate  
98 BKOND TB_BKOND WERTV7 CURR 13   2   Interest rate as amount  
99 PEFFZINS FTI_EFFZINS DEC3_7 DEC 10   7   Effective Interest Rate  
100 SEFFMETH SEFFMETH SEFFMETH NUMC 1   0   Effective Interest Method (Financial Mathematics)  
101 SHWHR TB_SHWHR WAERS CUKY 5   0   Local Currency TCURC
102 SVWHR TPM_VALUATION_CURR WAERS CUKY 5   0   Valuation Currency TCURC
103 SBWHR SBWHR WAERS CUKY 5   0   Position Currency (Currency of Position Amount) TCURC
104 ANZGW FTI_ANZGW WAERS CUKY 5   0   Display Currency TCURC
105 CALC_CCY AFW_EVAL_CURRENCY WAERS CUKY 5   0   Evaluation Currency TCURC
106 WVERB1 FTI_WHR_SHORT WAERS CUKY 5   0   Nominal currency borrowing/sale/outgoing side/short TCURC
107 WFORD1 FTI_WHR_LONG WAERS CUKY 5   0   Nominal currency investment/purchase incoming side/long TCURC
108 SWHRKOND TB_WHRKOND WAERS CUKY 5   0   Interest Currency TCURC
109 UNITS FTI_UNITS TPM_UNITS DEC 22   6   Number of units  
110 UNITS_LOCKED FTI_UNITS_LOCKED TPM_UNITS DEC 22   6   Number of Blocked Units  
111 NOMINAL_AMT_PC FTI_NOMINAL_AMT_PC TPM_AMOUNT CURR 21   2   Nominal Amount in Position Currency  
112 NOMINAL_AMT_LO_PC FTI_NOMINAL_AMT_LO_PC TPM_AMOUNT CURR 21   2   Locked Nominal Amount in Position Currency  
113 NOMINAL_AMT_DC FTI_NOMINAL_AMT_DC TPM_AMOUNT CURR 21   2   Nominal Amount in Display Currency  
114 NOMINAL_AMT_LO_DC FTI_NOMINAL_AMT_LO_DC TPM_AMOUNT CURR 21   2   Locked Nominal Amount in Display Currency (From Pos. Crcy)  
115 NOMINAL_ORG_AMT_PC TPM_NOMINAL_ORG_AMT TPM_AMOUNT CURR 21   2   Original Nominal Amount in Position Currency  
116 NOMINAL_AMT_OUT_PC FTI_NOMINAL_OUT_PCOUT TPM_AMOUNT CURR 21   2   Nominal Value, Outgoing Side, in Position Crcy (Outg. Side)  
117 NOMINAL_AMT_IN_PC FTI_NOMINAL_IN_PCIN TPM_AMOUNT CURR 21   2   Nominal Value, Incoming Side, in Position Crcy (Inc. Side)  
118 NOMINAL_AMT_OUT_DC FTI_NOMINAL_AMT_OUT_DC TPM_AMOUNT CURR 21   2   Nominal Value, Outgoing Side, in Display Currency  
119 NOMINAL_AMT_IN_DC FTI_NOMINAL_AMT_IN_DC TPM_AMOUNT CURR 21   2   Nominal Value Incoming Side in Display Currency  
120 ACC_INTEREST_PC FTI_ACC_INTEREST_PC TPM_AMOUNT CURR 21   2   Accrued Interest in Position Currency  
121 ACC_INTEREST_DC FTI_ACC_INTEREST_DC TPM_AMOUNT CURR 21   2   Accrued Interest in Display Currency (From PC)  
122 PURCH_PC FTI_PURCH_PC TPM_AMOUNT CURR 21   2   Purchase Value in Position Currency  
123 PURCH_LC FTI_PURCH_LC TPM_AMOUNT CURR 21   2   Purchase Value in Local Currency  
124 PURCH_VC FTI_PURCH_VC TPM_AMOUNT CURR 21   2   Purchase Value in Valuation Currency  
125 PURCH_DC FTI_PURCH_DC TPM_AMOUNT CURR 21   2   Purchase Value in Display Currency (From Position Currency)  
126 AQU_VAL_PC FTI_AQU_VAL_PC TPM_AMOUNT CURR 21   2   Acquisition Value in Position Currency  
127 AQU_VAL_LC FTI_AQU_VAL_LC TPM_AMOUNT CURR 21   2   Acquisition Value in Local Currency  
128 AQU_VAL_VC FTI_AQU_VAL_VC TPM_AMOUNT CURR 21   2   Acquisition Value in Valuation Currency  
129 AQU_VAL_DC FTI_AQU_VAL_DC TPM_AMOUNT CURR 21   2   Acquisition Value in Display Currency (From Position Crcy)  
130 BOOK_VAL_PC FTI_BOOK_VAL_PC TPM_AMOUNT CURR 21   2   Book Value in Position Currency  
131 BOOK_VAL_LC FTI_BOOK_VAL_LC TPM_AMOUNT CURR 21   2   Book Value in Local Currency  
132 BOOK_VAL_VC FTI_BOOK_VAL_VC TPM_AMOUNT CURR 21   2   Book Value in Valuation Currency  
133 BOOK_VAL_DC FTI_BOOK_VAL_DC TPM_AMOUNT CURR 21   2   Book Value in Display Currency (From Position Currency)  
134 CHARGE_PC FTI_CHARGE_PC TPM_AMOUNT CURR 21   2   Costs in position currency  
135 CHARGE_LC FTI_CHARGE_LC TPM_AMOUNT CURR 21   2   Costs in Local Currency  
136 CHARGE_VC FTI_CHARGE_VC TPM_AMOUNT CURR 21   2   Costs in Valuation Currency  
137 CHARGE_DC FTI_CHARGE_DC TPM_AMOUNT CURR 21   2   Costs in Display Currency (From Position Currency)  
138 BOOK_VAL_EX_PC FTI_BOOK_VAL_EX_PC TPM_AMOUNT CURR 21   2   Book Value Excluding Costs in Position Currency  
139 BOOK_VAL_EX_LC FTI_BOOK_VAL_EX_LC TPM_AMOUNT CURR 21   2   Book Value Excluding Costs in Local Currency  
140 BOOK_VAL_EX_VC FTI_BOOK_VAL_EX_VC TPM_AMOUNT CURR 21   2   Book Value Excluding Costs in Valuation Currency  
141 BOOK_VAL_EX_DC FTI_BOOK_VAL_EX_DC TPM_AMOUNT CURR 21   2   Book Value Excl. Costs in Display Currency (From Pos. Crcy)  
142 VAL_TI_PC FTI_VAL_TI_PC TPM_AMOUNT CURR 21   2   Security Valuation in Position Currency  
143 VAL_TI_LC FTI_VAL_TI_LC TPM_AMOUNT CURR 21   2   Security Valuation in Local Currency  
144 VAL_TI_VC FTI_VAL_TI_VC TPM_AMOUNT CURR 21   2   Security Valuation in Valuation Currency  
145 VAL_TI_DC FTI_VAL_TI_DC TPM_AMOUNT CURR 21   2   Security Valuation in Display Currency (from Position Crcy)  
146 VAL_FX_LC FTI_VAL_FX_LC TPM_AMOUNT CURR 21   2   Foreign Currency Valuation in Local Currency  
147 VAL_FX_VC FTI_VAL_FX_VC TPM_AMOUNT CURR 21   2   Foreign Currency Valuation in Valuation Currency  
148 VAL_CH_TI_PC FTI_VAL_CH_TI_PC TPM_AMOUNT CURR 21   2   Valuation of Cap. Costs, Security, in Position Currency  
149 VAL_CH_TI_LC FTI_VAL_CH_TI_LC TPM_AMOUNT CURR 21   2   Valuation of Cap. Costs, Security, in Local Currency  
150 VAL_CH_TI_VC FTI_VAL_CH_TI_VC TPM_AMOUNT CURR 21   2   Valuation of Cap. Costs, Security, in Valuation Currency  
151 VAL_CH_TI_DC FTI_VAL_CH_TI_DC TPM_AMOUNT CURR 21   2   Valuation of Cap. Costs, Security, in Display Crcy (from PC)  
152 VAL_CH_FX_LC FTI_VAL_CH_FX_LC TPM_AMOUNT CURR 21   2   Valuation of Capitalized Costs, FX, in Local Currency  
153 VAL_CH_FX_VC FTI_VAL_CH_FX_VC TPM_AMOUNT CURR 21   2   Valuation of Capitalized Costs, FX, in Valuation Currency  
154 AMORT_PC FTI_AMORT_PC TPM_AMOUNT CURR 21   2   Amortization in Position Currency  
155 AMORT_LC FTI_AMORT_LC TPM_AMOUNT CURR 21   2   Amortization in Local Currency  
156 AMORT_VC FTI_AMORT_VC TPM_AMOUNT CURR 21   2   Amortization in Valuation Currency  
157 AMORT_DC FTI_AMORT_DC TPM_AMOUNT CURR 21   2   Amortization in Display Currency (From Position Currency)  
158 IMPMNT_PC FTI_IMPMNT_PC TPM_AMOUNT CURR 21   2   Impairment in Position Currency  
159 IMPMNT_LC FTI_IMPMNT_LC TPM_AMOUNT CURR 21   2   Impairment in Local Currency  
160 IMPMNT_VC FTI_IMPMNT_VC TPM_AMOUNT CURR 21   2   Impairment in Valuation Currency  
161 IMPMNT_DC FTI_IMPMNT_DC TPM_AMOUNT CURR 21   2   Impairment in Display Currency  
162 REPAYMENT_PC TPM_REPAYMENT_PC TPM_AMOUNT CURR 21   2   Cumulative Repayment in Position Currency  
163 REPAYMENT_LC TPM_REPAYMENT_LC TPM_AMOUNT CURR 21   2   Cumulative Repayment in Local Currency  
164 REPAYMENT_VC TPM_REPAYMENT_VC TPM_AMOUNT CURR 21   2   Cumulative Repayment in Valuation Currency  
165 REPAYMENT_DC FTI_REPAYMENT_DC TPM_AMOUNT CURR 21   2   Cumulative Repayment in Display Currency  
166 AMAQU_VAL_PC FTI_AMAQU_VAL_PC TPM_AMOUNT CURR 21   2   Amortized Acquisition Value in Position Currency  
167 AMAQU_VAL_LC FTI_AMAQU_VAL_LC TPM_AMOUNT CURR 21   2   Amortized Acquisition Value in Local Currency  
168 AMAQU_VAL_VC FTI_AMAQU_VAL_VC TPM_AMOUNT CURR 21   2   Amortized Acquisition Value in Valuation Currency  
169 AMAQU_VAL_DC FTI_AMAQU_VAL_DC TPM_AMOUNT CURR 21   2   Amortized Acquisition Value in Display Currency (From PC)  
170 DISAGIO_PC FTI_DISAGIO_PC TPM_AMOUNT CURR 21   2   Cleared PD Deferral/Tax Compensation in Position Currency  
171 DISAGIO_LC FTI_DISAGIO_LC TPM_AMOUNT CURR 21   2   Cleared PD Deferral/Tax Compensation in Local Currency  
172 DISAGIO_VC FTI_DISAGIO_VC TPM_AMOUNT CURR 21   2   Cleared PD Deferral/Tax Compensation in Valuation Currency  
173 DISAGIO_DC FTI_DISAGIO_DC TPM_AMOUNT CURR 21   2   Cleared PD Deferral/Tax Compensation in Display Currency  
174 VAL_TI_NPL_PC FTI_VAL_TI_NPL_PC TPM_AMOUNT CURR 21   2   Security Valuation, Not Affecting P/L, in Position Currency  
175 VAL_TI_NPL_LC FTI_VAL_TI_NPL_LC TPM_AMOUNT CURR 21   2   Security Valuation, Not Affecting P/L, in Local Currency  
176 VAL_TI_NPL_VC FTI_VAL_TI_NPL_VC TPM_AMOUNT CURR 21   2   Security Valuation, Not Affecting P/L, in Valuation Currency  
177 VAL_TI_NPL_DC FTI_VAL_TI_NPL_DC TPM_AMOUNT CURR 21   2   Security Valuation, Not Affecting P/L, in Display Currency  
178 VAL_FX_NPL_LC FTI_VAL_FX_NPL_LC TPM_AMOUNT CURR 21   2   Foreign Currency Valuation, Not Affecting P/L, in Local Crcy  
179 VAL_FX_NPL_VC FTI_VAL_FX_NPL_VC TPM_AMOUNT CURR 21   2   Foreign Currency Valuation, Not Affecting P/L, in Val. Crcy  
180 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  
181 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  
182 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  
183 VAL_CH_TI_NPL_DC FTI_VAL_CH_TI_NPL_DC TPM_AMOUNT CURR 21   2   Valuation of Cap. Costs, Sec., Not Aff. P/L in DC (from PC)  
184 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  
185 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  
186 VARMAR_PC FTI_VARMAR_PC TPM_AMOUNT CURR 21   2   Variation Margin in Position Currency  
187 VARMAR_LC FTI_VARMAR_LC TPM_AMOUNT CURR 21   2   Variation Margin in Local Currency  
188 VARMAR_VC FTI_VARMAR_VC TPM_AMOUNT CURR 21   2   Variation Margin in Valuation Currency  
189 VARMAR_DC FTI_VARMAR_DC TPM_AMOUNT CURR 21   2   Variation Margin in Display Currency  
190 SPOTVALP_LC FTI_SPOTVALP_LC TPM_AMOUNT CURR 21   2   Spot Valuation of Purchase Currency in Local Currency  
191 SPOTVALP_VC FTI_SPOTVALP_VC TPM_AMOUNT CURR 21   2   Spot Valuation of Purchase Currency in Valuation Currency  
192 SPOTVALS_LC FTI_SPOTVALS_LC TPM_AMOUNT CURR 21   2   Spot Valuation of Sale Currency in Local Currency  
193 SPOTVALS_VC FTI_SPOTVALS_VC TPM_AMOUNT CURR 21   2   Spot Valuation of Sale Currency in Valuation Currency  
194 SWAPACC_PC FTI_SWAPACC_PC TPM_AMOUNT CURR 21   2   Swap/Margin Accrual/Deferral in Position Currency  
195 SWAPACC_LC FTI_SWAPACC_LC TPM_AMOUNT CURR 21   2   Swap or Margin Accrual/Deferral in Local Currency  
196 SWAPACC_VC FTI_SWAPACC_VC TPM_AMOUNT CURR 21   2   Swap or Margin Accrual/Deferral in Valuation Currency  
197 SWAPACC_DC FTI_SWAPACC_DC TPM_AMOUNT CURR 21   2   Swap/Margin Accrual/Deferral in Display Currency  
198 SWAPVAL_LC FTI_SWAPVAL_LC TPM_AMOUNT CURR 21   2   Swap Valuation in Local Currency  
199 SWAPVAL_VC FTI_SWAPVAL_VC TPM_AMOUNT CURR 21   2   Swap Valuation in Valuation Currency  
200 KAKUPR FTI_KAKUPR VVPKTKUR DEC 15   6   Purchase Price for Percentage-Quoted Securities in %  
201 KAKSBW FTI_KAKSBW VVPKTKUR DEC 15   6   Purchase Price for Unit-Quoted Securities in Position Crcy  
202 ANKUPR FTI_ANKUPR VVPKTKUR DEC 15   6   Acquisition Price for Percentage-Quoted Securities in %  
203 ANKSBW FTI_ANKSBW VVPKTKUR DEC 15   6   Acquisition Price f. Unit-Quoted Securities in Position Crcy  
204 BUKUPR FTI_BUKUPR VVPKTKUR DEC 15   6   Book Price for Percentage-Quoted Securities in %  
205 BUKSBW FTI_BUKSBW VVPKTKUR DEC 15   6   Book Price for Unit-Quoted Securities in Position Currency  
206 KURSPR FTI_KURSPR VVPKTKUR DEC 15   6   Market Price / % (Percentage-Quoted Securities)  
207 KURSBW FTI_KURSBW VVPKTKUR DEC 15   6   Market Price/Unit in Position Crcy (Unit-Quoted Securities)  
208 MARKET_PC FTI_MARKET_PC TPM_AMOUNT CURR 21   2   Market Value in Position Currency  
209 MARKET_DC FTI_MARKET_DC TPM_AMOUNT CURR 21   2   Market Value (SE Only) in Display Crcy (From Position Crcy)  
210 MARKET_DATE FTI_MARKET_DATE DATUM DATS 8   0   Rate Date  
211 STUECKZINS_PC TB_STZINS TPM_AMOUNT CURR 21   2   Accrued Interest in Position Currency  
212 STUECKZINS_DC FTI_STZINS TPM_AMOUNT CURR 21   2   Accumulated Accrued Interest in DC (PC)  
213 NPV_PC TV_NPV_PC WERTV8_TR CURR 15   2   RM Net Present Value in Position Currency  
214 NPV_DC TV_NPV_DC WERTV8_TR CURR 15   2   RM NPV in Display Currency from Position Currency  
215 NPV_CC TV_NPV_CC WERTV8_TR CURR 15   2   RM NPV in Evaluation Currency  
216 NPV_LONG_PC TV_NPV_LONG_PC WERTV8_TR CURR 15   2   RM NPV of Incoming Side in Currency of Incoming Side  
217 NPV_SHORT_PC TV_NPV_SHORT_PC WERTV8_TR CURR 15   2   RM NPV of Outgoing Side in Currency of Outgoing Side  
218 NPV_LONG_CC TV_NPV_LONG_CC WERTV8_TR CURR 15   2   RM NPV of Incoming Side in Evaluation Currency  
219 NPV_SHORT_CC TV_NPV_SHORT_CC WERTV8_TR CURR 15   2   RM NPV of Outgoing Side in Evaluation Currency  
220 CLEAN_PRICE_PC TV_CLEAN_PRICE_PC T_PRESVAL CURR 17   2   Clean Price in Position Currency  
221 CLEAN_PRICE_DC TV_CLEAN_PRICE_DC T_PRESVAL CURR 17   2   Clean Price in Display Currency from Position Currency  
222 CLEAN_PRICE_CC FTI_CLEAN_PRICE_CC T_PRESVAL CURR 17   2   Clean Price in Valuation Currency  
223 BPVALUE_PC TV_VALBP_PC T_PRESVAL CURR 17   2   Basis Point Value in Position Currency  
224 BPVALUE_DC TV_VALBP_DC T_PRESVAL CURR 17   2   Basis Point Value in Display Currency from Position Currency  
225 BPVALUE_CC TV_VALBP T_PRESVAL CURR 17   2   Basis Point Value in Evaluation Currency  
226 MAC_DURATION TV_MAC_DURATION DEC9_3SIGN DEC 12   3   Macaulay Duration  
227 MOD_DURATION TV_MOD_DURATION DEC9_3SIGN DEC 12   3   Fisher-Weil Duration  
228 CONVEXITY TV_CONVEXITY_MORE_ACCURATE DEC6_5SIGN DEC 11   5   Convexity with 5 Decimal Places  
229 DELTA TV_DELTA T_SENSI DEC 15   10   Delta, 1st derivation of premium based on underlying rate  
230 GAMMA TV_GAMMA T_GAMMA DEC 14   8   Gamma, 2nd derivation of premium based on underlying rate  
231 THETA TV_THETA T_SENSI DEC 15   10   Theta, 1st derivation of premium according to time  
232 VEGA TV_VEGA T_SENSI DEC 15   10   Vega, 1st Volatility Derivative  
233 S_VAL_TI_PC FTI_S_VAL_TI_PC TPM_AMOUNT CURR 21   2   Security Valuation in Position Currency (Simulation)  
234 S_VAL_TI_LC FTI_S_VAL_TI_LC TPM_AMOUNT CURR 21   2   Security Valuation in Local Currency (Simulation)  
235 S_VAL_TI_VC FTI_S_VAL_TI_VC TPM_AMOUNT CURR 21   2   Security Valuation in Valuation Currency (Simulation)  
236 S_VAL_TI_DC FTI_S_VAL_TI_DC TPM_AMOUNT CURR 21   2   Security Valuation in Display Currency (Simulation)  
237 S_VAL_FX_LC FTI_S_VAL_FX_LC TPM_AMOUNT CURR 21   2   Foreign Currency Valuation in Local Currency (Simulation)  
238 S_VAL_FX_VC FTI_S_VAL_FX_VC TPM_AMOUNT CURR 21   2   Foreign Currency Valuation in Valuation Crcy (Simulation)  
239 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.)  
240 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.)  
241 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.)  
242 S_VAL_CH_TI_DC FTI_S_VAL_CH_TI_DC TPM_AMOUNT CURR 21   2   Valuation of Capitalized Costs, Sec., in Displ.Crcy (Simul.)  
243 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.)  
244 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.)  
245 S_AMORT_PC FTI_S_AMORT_PC TPM_AMOUNT CURR 21   2   Amortization in Position Currency (Simulation)  
246 S_AMORT_LC FTI_S_AMORT_LC TPM_AMOUNT CURR 21   2   Amortization in Local Currency (Simulation)  
247 S_AMORT_VC FTI_S_AMORT_VC TPM_AMOUNT CURR 21   2   Amortization in Valuation Currency (Simulation)  
248 S_AMORT_DC FTI_S_AMORT_DC TPM_AMOUNT CURR 21   2   Amortization in Display Currency (Simulation)  
249 S_DISAGIO_PC FTI_S_DISAGIO_PC TPM_AMOUNT CURR 21   2   Cleared PD Def./Tax Compensation in Pos. Crcy: Simulation  
250 S_DISAGIO_LC FTI_S_DISAGIO_LC TPM_AMOUNT CURR 21   2   Cleared PD Def./Tax Compensation in Local Crcy: Simulation  
251 S_DISAGIO_VC FTI_S_DISAGIO_VC TPM_AMOUNT CURR 21   2   Cleared PD Def./Tax Compensation in Val. Crcy: Simulation  
252 S_DISAGIO_DC FTI_S_DISAGIO_DC TPM_AMOUNT CURR 21   2   Cleared PD Def./Tax Compensation in Display Crcy: Simulation  
253 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)  
254 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)  
255 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)  
256 S_VAL_TI_NPL_DC FTI_S_VAL_TI_NPL_DC TPM_AMOUNT CURR 21   2   Security Valuation, Not Affecting P/L, in DC (Simulation)  
257 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)  
258 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)  
259 S_VAL_CH_TI_NPL_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.)  
260 S_VAL_CH_TI_NPL_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.)  
261 S_VAL_CH_TI_NPL_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.)  
262 S_VAL_CH_TI_NPL_DC FTI_S_VAL_CH_TI_NPL_DC TPM_AMOUNT CURR 21   2   Valuation of Cap. Costs, Sec., Not Aff. P/L, in DC (Sim.)  
263 S_VAL_CH_FX_NPL_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.)  
264 S_VAL_CH_FX_NPL_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.)  
265 S_SPOTVALP_LC FTI_S_SPOTVALP_LC TPM_AMOUNT CURR 21   2   Spot Valuation, Purchase Currency, in Local Crcy: Simulation  
266 S_SPOTVALP_VC FTI_S_SPOTVALP_VC TPM_AMOUNT CURR 21   2   Spot Valuation, Purchase Currency, in Val. Crcy: Simulation  
267 S_SPOTVALS_LC FTI_S_SPOTVALS_LC TPM_AMOUNT CURR 21   2   Spot Valuation, Sale Currency, in Local Crcy: Simulation  
268 S_SPOTVALS_VC FTI_S_SPOTVALS_VC TPM_AMOUNT CURR 21   2   Spot Valuation, Sale Currency, in Valuation Crcy: Simulation  
269 S_SWAPACC_PC FTI_S_SWAPACC_PC TPM_AMOUNT CURR 21   2   Swap/Margin Accrual/Deferral in Position Crcy (Simulation)  
270 S_SWAPACC_LC FTI_S_SWAPACC_LC TPM_AMOUNT CURR 21   2   Swap/Margin Accrual/Deferral in Local Currency: Simulation  
271 S_SWAPACC_VC FTI_S_SWAPACC_VC TPM_AMOUNT CURR 21   2   Swap/Margin Accrual/Deferral in Valuation Crcy: Simulation  
272 S_SWAPACC_DC FTI_S_SWAPACC_DC TPM_AMOUNT CURR 21   2   Swap/Margin Accrual/Deferral in Display Currency: Simulation  
273 S_SWAPVAL_LC FTI_S_SWAPVAL_LC TPM_AMOUNT CURR 21   2   Swap Valuation in Local Currency: Simulation  
274 S_SWAPVAL_VC FTI_S_SWAPVAL_VC TPM_AMOUNT CURR 21   2   Swap Valuation in Valuation Currency: Simulation  
275 S_VALID_DATE TPM_VALID_DATE DATS DATS 8   0   Date of Found Rate or Present Value  
276 S_VALID_RATE_DATE TPM_VALID_RATE_DATE DATS DATS 8   0   Date of Exchange Rate Found  
277 S_MAP FTI_LDB_MAP VVPKTKUR DEC 15   6   Valuation Price  
278 S_MAV FTI_LDB_MAV TPM_AMOUNT CURR 21   2   Current Value for Valuation (Market Value, NPV)  
279 S_MAR_FE FTI_LDB_MAR_FE UKURS DEC 9   5   Exchange Rate - Position/Valuation Currency on Market  
280 S_SPOT_RATE_P FTI_LDB_SPOT_RATE_P UKURS DEC 9   5   Spot Rate Purchase Currency/Valuation Currency in the Market  
281 S_SPOT_RATE_S FTI_LDB_SPOT_RATE_S UKURS DEC 9   5   Spot Rate Sales Currency/Valuation Currency in the Market  
282 S_SWAP_RATE_P FTI_LDB_SWAP_RATE_P TB_DEVSWSA DEC 9   5   Swap Rate Purchase Currency/Valuation Currency in the Market  
283 S_SWAP_RATE_S FTI_LDB_SWAP_RATE_S TB_DEVSWSA DEC 9   5   Swap Rate Sales Currency/Valuation Currency in the Market  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 FTI_LDB_TR_POSITIONS ACCOUNT_GROUP TRGT_SECACCGRP SEC_ACCT_GRP    
2 FTI_LDB_TR_POSITIONS ACC_ASS_REF TRACC_AA_REF AA_REF    
3 FTI_LDB_TR_POSITIONS ALWPKL TW22 ALWPKL    
4 FTI_LDB_TR_POSITIONS ANZGW TCURC WAERS    
5 FTI_LDB_TR_POSITIONS BUKRS T001 BUKRS    
6 FTI_LDB_TR_POSITIONS CALC_CCY TCURC WAERS    
7 FTI_LDB_TR_POSITIONS CNTRY_COMP T005 LAND1    
8 FTI_LDB_TR_POSITIONS DEAL_NUMBER VTBFHA RFHA    
9 FTI_LDB_TR_POSITIONS GROUP_D TP13 GROUP_D    
10 FTI_LDB_TR_POSITIONS GROUP_ID TB001 BU_GROUP    
11 FTI_LDB_TR_POSITIONS GSART TZPA GSART    
12 FTI_LDB_TR_POSITIONS HKONT SKB1 SAKNR    
13 FTI_LDB_TR_POSITIONS IND_SECTOR TB038A IND_SECTOR    
14 FTI_LDB_TR_POSITIONS ISTYPE TB038 ISTYPE    
15 FTI_LDB_TR_POSITIONS LAND1 T005 LAND1    
16 FTI_LDB_TR_POSITIONS LEGAL_ENTY TB019 LEGAL_ENTY    
17 FTI_LDB_TR_POSITIONS LEGAL_ORG TB032 LEGAL_ORG    
18 FTI_LDB_TR_POSITIONS LOANS_CONTRACT VDARL RANL    
19 FTI_LDB_TR_POSITIONS LOTGENERATION_BUSTRANSCAT TRDTS_BT_CAT BUSTRANSCAT    
20 FTI_LDB_TR_POSITIONS MANDT T000 MANDT    
21 FTI_LDB_TR_POSITIONS NATION T005 LAND1    
22 FTI_LDB_TR_POSITIONS PARTNR BUT000 PARTNER    
23 FTI_LDB_TR_POSITIONS PORTFOLIO TWPOB RPORTB    
24 FTI_LDB_TR_POSITIONS PORTFOLIO_TM TWPOB RPORTB    
25 FTI_LDB_TR_POSITIONS POSITION_ACCOUNT TRFT_POS_ACCOUNT POS_ACCOUNT    
26 FTI_LDB_TR_POSITIONS POS_MAN_PROC TRGC_PM_PROC POS_MAN_PROC    
27 FTI_LDB_TR_POSITIONS RATING TP06 RATING    
28 FTI_LDB_TR_POSITIONS RATING_RANL TP06 RATING    
29 FTI_LDB_TR_POSITIONS RDEALER TZDEA RDEALER    
30 FTI_LDB_TR_POSITIONS RDPBANK BUT000 PARTNER    
31 FTI_LDB_TR_POSITIONS RGARANT BUT000 PARTNER    
32 FTI_LDB_TR_POSITIONS RHANDPL TWH01 RHANDPL    
33 FTI_LDB_TR_POSITIONS RMAID VTBMA RMAID    
34 FTI_LDB_TR_POSITIONS RREFKONT_R T037S RREFKONT    
35 FTI_LDB_TR_POSITIONS SANLF TZAF SANLF    
36 FTI_LDB_TR_POSITIONS SARTBET TW02 SARTBET    
37 FTI_LDB_TR_POSITIONS SBILK TW11 SBILK    
38 FTI_LDB_TR_POSITIONS SBWHR TCURC WAERS    
39 FTI_LDB_TR_POSITIONS SECACC_TYPE TRSC_SECACC_TYPE SECACC_TYPE    
40 FTI_LDB_TR_POSITIONS SECURITY_ACCOUNT TWD01 RLDEPO    
41 FTI_LDB_TR_POSITIONS SECURITY_ID VWPANLA RANL    
42 FTI_LDB_TR_POSITIONS SFOTY TW21 SFOTY    
43 FTI_LDB_TR_POSITIONS SHWHR TCURC WAERS    
44 FTI_LDB_TR_POSITIONS SOL_INS TP07 SOL_INS    
45 FTI_LDB_TR_POSITIONS SOL_INS_RANL TP07 SOL_INS    
46 FTI_LDB_TR_POSITIONS STAFF_GRP TP05 STAFF_GRP    
47 FTI_LDB_TR_POSITIONS STATE T005 LAND1    
48 FTI_LDB_TR_POSITIONS SVWHR TCURC WAERS    
49 FTI_LDB_TR_POSITIONS SWERTTYP TW20 SWERTTYP    
50 FTI_LDB_TR_POSITIONS SWHRKOND TCURC WAERS    
51 FTI_LDB_TR_POSITIONS SWPKLASS TW01 SWPKLASS    
52 FTI_LDB_TR_POSITIONS TR_ACC_CODE TRGC_TR_ACC_CODE TR_ACC_CODE    
53 FTI_LDB_TR_POSITIONS VALUATION_AREA TRGC_VAL_AREA VALUATION_AREA    
54 FTI_LDB_TR_POSITIONS VALUATION_CLASS TRGC_VAL_CLASS VALUATION_CLASS    
55 FTI_LDB_TR_POSITIONS WFORD1 TCURC WAERS    
56 FTI_LDB_TR_POSITIONS WVERB1 TCURC WAERS    
History
Last changed by/on SAP  20131127 
SAP Release Created in 463_20