SAP ABAP Table VTVDMW1_TR (Treasury: Regulatory Reporting)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       FTA (Package) R/3 appl. development for Treasury money,forex,forward gen
Basic Data
Table Category INTTAB    Structure 
Structure VTVDMW1_TR   Table Relationship Diagram
Short Description Treasury: Regulatory Reporting    
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   Treasury: For a Given Period  
2 .INCLUDE       0   0   Treasury: Non-Cumulative (MM+FX+SEC): Charact. Trans./Activ.  
3 .INCLUDE       0   0   Fixed characteristics in Treasury  
4 MANDT MANDT MANDT CLNT 3   0   Client T000
5 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
6 RPORTB RPORTB RPORTB CHAR 10   0   Portfolio TWPOB
7 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
8 RANTYP_R FTI_RANTYP FTI_RANTYP CHAR 1   0   Contract type  
9 GSART VVSART VVSART CHAR 3   0   Product Type TZPA
10 RFHA TB_RFHA T_RFHA CHAR 13   0   Financial Transaction VTBFHA
11 RANL VVRANLW WP_RANL CHAR 13   0   Security ID Number VWPANLA
12 SARCHIV SARCHIV SARCHIV CHAR 1   0   Archiving Category Indicator  
13 RANLVD RANL RANL CHAR 13   0   Contract Number VDARL
14 RLDEPO VRLDEPO RLDEPO CHAR 10   0   Securities Account TWD01
15 SFGTYP TB_SFGTYP T_SFGTYP NUMC 3   0   Transaction Category AT01
16 SFHAART TB_SFHAART T_SFHAART CHAR 3   0   Financial Transaction Type AT10
17 SAKTIV FTI_SAKTIV FTI_SAKTIV CHAR 1   0   Active status of financial transaction (drilldown reporting)  
18 RREFKONT_R TB_REFKONT USTRU CHAR 8   0   Acct Assignment Ref. for Operative Valn Area and Loan T037S
19 SBILK SBILK SBILK CHAR 2   0   Balance Sheet Indicator TW11
20 FINPROJ TB_TFPROJ T_TFPROJ CHAR 13   0   Finance Project  
21 SFGZUSTT TB_SFGZUTY T_SFGZUTY NUMC 2   0   Transaction Activity Category AT02
22 RDEALER RDEALER RDEALER CHAR 12   0   Trader TZDEA
23 NORDEXT TB_NORDEXT FTI_CHAR16LOW CHAR 16   0   External Reference  
24 ZUOND TB_ZUOND TEXT18 CHAR 18   0   Assignment  
25 REFER TB_REFER CHAR16 CHAR 16   0   Internal Reference  
26 MERKM TB_MERKM CHAR25 CHAR 25   0   Characteristics  
27 RMAID TB_RMAID T_RMAID CHAR 10   0   Master Agreement VTBMA
28 RGARANT TB_RGARANT_NEW BU_PARTNER CHAR 10   0   Guarantor of Financial Transaction BUT000
29 HKONT FTI_HKONT SAKNR CHAR 10   0   General ledger account SKB1
30 LOT_ID TPM_LOT_ID SYSUUID RAW 16   0   Identifier of the Lot  
31 DLOTGENERATION DLOTGENERATION DATUM DATS 8   0   Date On Which Lot Was Generated  
32 TLOTGENERATION TLOTGENERATION UZEIT TIMS 6   0   Lot Generation Time  
33 LOTGENERATION_USER FTI_LOTGENERATIONUSER SYCHAR12 CHAR 12   0   Lot Entered By  
34 LOTGENERATION_BUSTRANSCAT FTI_LOTGENERATION_BUSTRANSCAT TPM_BUSTRANSCAT NUMC 4   0   Business Transaction Category Which Generated the Lot TRDTS_BT_CAT
35 .INCLUDE       0   0   Treasury: Commitment Partner  
36 PARTNR FTI_LDB_RISK_COUNTERPARTY BU_PARTNER CHAR 10   0   Partner with Whom Commitment Exists BUT000
37 .INCLUDE       0   0   Treasury: Partner Attributes  
38 TYPE BP_TYPE_NEW BU_TYPE CHAR 1   0   Business Partner Category  
39 ISTYPE BU_ISTYPE BU_ISTYPE CHAR 4   0   Industry System TB038
40 IND_SECTOR BU_IND_SECTOR BU_INDSECTOR CHAR 10   0   Industry TB038A
41 CNTRY_COMP FTI_LANDBP LAND1 CHAR 3   0   Country of Registered Office of Business Partner T005
42 LEGAL_ENTY BP_LEG_ETY_NEW BU_LEGENTY CHAR 2   0   Legal Form of Organization TB019
43 LEGAL_ORG BU_LEGAL_ORG_NEW BU_LEGAL_ORG CHAR 2   0   Legal Entity of Organization TB032
44 NATION BP_CNTR_N LAND1 CHAR 3   0   Nationality T005
45 STATE BP_CNTR_ST LAND1 CHAR 3   0   Citizenship T005
46 GROUP_ID BU_GRP_ID_NEW BU_GROUP CHAR 4   0   Business Partner Grouping TB001
47 GROUP_D BP_GROUP_D BP_GROUP_D CHAR 4   0   Target Group TP13
48 STAFF_GRP BP_STAFF_G BP_STAFF_G CHAR 4   0   Employee Group TP05
49 COMP_RE BP_COMP_RE BP_COMP_RE CHAR 1   0   Organization Relationship  
50 .INCLUDE       0   0   Business partner credit standing data  
51 SOLVNCY BP_SOLVNCY BP_SOLVNCY CHAR 1   0   Credit Standing  
52 RATING BP_RATING BP_RATING CHAR 3   0   Rating TP06
53 SOL_INS BP_SOL_INS BP_SOL_INS CHAR 4   0   Institute Providing Credit Standing Information TP07
54 SOL_INF BP_SOL_INF BP_SOL_INF CHAR 1   0   Status of Credit Standing Information  
55 SOL_I_D BP_SOL_I_D DATUM DATS 8   0   Date of Credit Standing Information  
56 .INCLUDE       0   0   TR: Class Information for Drilldown Reporting (Flow)  
57 .INCLUDE       0   0   Treasury: Class info for drill-down reporting  
58 SANLF SANLF VVSANLF NUMC 3   0   Product Category TZAF
59 SWERTTYP SWERTTYP SAKTTYP NUMC 1   0   Security Type ID TW20
60 SWPKLASS SWPKLASS SWPKLASS NUMC 3   0   Classification of bond TW01
61 ALWPKL ALWPKL ALWPKL CHAR 3   0   General Security Classification TW22
62 SARTBET SARTBET SARTBET NUMC 2   0   Type of shareholding TW02
63 SAKAR SAKAR SAKAR NUMC 1   0   Stock category  
64 DBLFZ DBLFZ DATUM DATS 8   0   Start of Term  
65 DELFZ DELFZ DATUM DATS 8   0   End of Term  
66 SNOTI SNOTI SNOTI NUMC 1   0   Quotation Indicator  
67 SBOERNOT SBOERNOT JANEI CHAR 1   0   Indicator: Listed on an Exchange  
68 SFOTY SFOTY SFOTY NUMC 1   0   Fund type indicator TW21
69 SOL_INS_RANL FTI_SOL_INS_RANL BP_SOL_INS CHAR 4   0   Institut Supplying Credit Rating Information for Secur. ID TP07
70 RATING_RANL BP_RATING_RANL BP_RATING CHAR 3   0   Rating for Securities ID Number/OTC Transaction TP06
71 KBNEWE_E FTI_VVBNEWE_E VVKWKURS DEC 15   6   Nominal Value per Stock (Independent of Currency)  
72 KZAHLAKT_E FTI_KZAHLAKT_E DEC3_7 DEC 10   7   Pay-in rate  
73 .INCLUDE       0   0   Treasury: Cumulative Values: Characteristics Trans./Activity  
74 VONDAT DVONDAT DATUM DATS 8   0   Start Date of Evaluation  
75 BISDAT DBISDAT DATUM DATS 8   0   Date of evaluation end  
76 RSTICH RSTICH RSTICH CHAR 1   0   Key date reference  
77 DBUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
78 DGJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
79 DMONAT MONAT MONAT NUMC 2   0   Fiscal period  
80 PERIO JAHRPER JAHRPER NUMC 7   0   Period/year  
81 DFAELL DFAELL DATUM DATS 8   0   Due date  
82 RPBANK TB_RPBANK BVTYP CHAR 4   0   Partner bank details  
83 RPZAHL TB_RPZAHL_NEW BU_PARTNER CHAR 10   0   Payer/payee BUT000
84 JFDBUC FTI_FDBUC FTI_FDBUC CHAR 1   0   Relevance to CM  
85 LAND1 FTI_LAND1 LAND1 CHAR 3   0   Country key of company code T005
86 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method T042Z
87 BANKK_HB FTI_BANKK BANKK CHAR 15   0   Bank key of house bank  
88 BANKN_HB FTI_BANKN BANKN CHAR 18   0   Bank account number of house bank  
89 BANKK_BP FTI_BANKKP BANKK CHAR 15   0   Bank key of business partner bank  
90 BANKN_BP FTI_BANKNP BANKN CHAR 18   0   Bank account number of business partner  
91 SSIGN TB_SSIGN T_SSIGN CHAR 1   0   Direction of flow  
92 JAHR TB_JAHR GJAHR NUMC 4   0   Calendar year  
93 MONAT TB_MONAT TB_MONAT NUMC 2   0   Calendar month  
94 WOCHE FTI_WOCHE NUMC2 NUMC 2   0   Calendar Week  
95 MONAT_JAHR FTI_MONTH_YEAR MCPERIOD NUMC 6   0   Calendar Month/Year  
96 WOCHE_JAHR FTI_WEEK_YEAR MCPERIOD NUMC 6   0   Calendar Week/Year  
97 .INCLUDE       0   0   Contains Invisible Calculation Fields for Drilldown Reportng  
98 SZART TB_SZART XFELD CHAR 1   0   Payment transaction  
99 SPAYRQ TB_SPAYRQK XFELD CHAR 1   0   Generate payment request  
100 PRKEY PRQ_KEYNO PRQ_KEYNO CHAR 10   0   Key Number for Payment Request PAYRQ
101 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
102 AWKEY AWKEY AWKEY CHAR 20   0   Object key  
103 GL_ACCOUNT_D FTI_GLACC_D SAKNR CHAR 10   0   Number of G/L Account: Debit *
104 GL_ACCOUNT_C FTI_GLACC_C SAKNR CHAR 10   0   Number of G/L Account: Credit *
105 DBESTAND DBESTAND DATUM DATS 8   0   Position value date  
106 DDISPO DDISPO DATUM DATS 8   0   Payment Date  
107 BUCHST_TR BUCHST_TR BUCHST_TR CHAR 1   0   Posting status of flow for Treasury  
108 SBEWART_R SBEWART SBEWART CHAR 4   0   Flow Type TZB0A
109 SBFREI TB_SBFREI XFELD CHAR 1   0   Release Given for Flow to Be Posted?  
110 RKONTRA RKONTRA_NEW BU_PARTNER CHAR 10   0   Reference to Counterparty BUT000
111 RAHABKI TB_RHABKI HBKID CHAR 5   0   Short key for own house bank T012
112 RAHKTID TB_RHKTID HKTID CHAR 5   0   Short key for house bank account T012K
113 PAYIND TB_SPAYIND T_SPAYIND CHAR 1   0   Payment Status of Flows  
114 GSVGANG GSVGANG GSVGANG NUMC 3   0   TR transaction activity for securities  
115 VVRANLWX VVRANLWXS CHAR20S CHAR 20   0   Secondary index class data  
116 SBWHR TB_BWHR WAERS CUKY 5   0   Position Currency/Transaction Currency TCURC
117 WVERB1 FTI_WHR_SHORT WAERS CUKY 5   0   Nominal currency borrowing/sale/outgoing side/short TCURC
118 WFORD1 FTI_WHR_LONG WAERS CUKY 5   0   Nominal currency investment/purchase incoming side/long TCURC
119 .INCLUDE       0   0   Key Figures Occurring in Position and Flow Lists  
120 .INCLUDE       0   0   Actual Key Figures Occurring in Position and Flow Lists  
121 RLZTG_K_F FTI_RLZTGK_F DEC7 DEC 7   0   Remaining Term in Days (Key Figure)  
122 UEBTG_K_F FTI_UEBTGK_F DEC7 DEC 7   0   Overdue Period in Days (Key Figure)  
123 .INCLUDE       0   0   Quasi Key Figures Occurring in Position and Flow Lists  
124 RLZTG_F FTI_RLZTG_F NUMC5 NUMC 5   0   Remaining Term in Days  
125 RLZMO_F FTI_RLZMO_F NUMC4 NUMC 4   0   Remaining Term in Months  
126 RLZJA_F FTI_RLZJA_F NUMC3 NUMC 3   0   Remaining Term in Years  
127 UEBTG_F FTI_UEBTG_F NUMC5 NUMC 5   0   Overdue Period in Days  
128 UEBMO_F FTI_UEBMO_F NUMC3 NUMC 3   0   Overdue Period in Months  
129 UEBJA_F FTI_UEBJA_F NUMC2 NUMC 2   0   Overdue Period in Years  
130 .INCLUDE       0   0   Treasury: Characteristics for Cumulative Values  
131 BZBETR D_CASHCW WERTV8_TR CURR 15   2   Payment amount in payment currency  
132 BHWBETR D_CASHHW WERTV8_TR CURR 15   2   Payment amount in local currency  
133 EHBETR EHBETR WERTV7 CURR 13   2   Profit/loss amount in local currency  
134 EEBETR EEBETR WERTV7 CURR 13   2   Profit/loss amount in profit/loss currency  
135 WZBETR TB_WZBETR WAERS CUKY 5   0   Payment Currency TCURC
136 SPLWHR SPLWHR WAERS CUKY 5   0   Profit/loss currency TCURC
137 BBWHR_P FTI_BBWHRP WERTV7 CURR 13   2   Amount which changes position in curr. of position increase  
138 SBWHR_P FTI_SBWP WAERS CUKY 5   0   Currency of position increase TCURC
139 D_ASTUECK D_ASTUECK ASTUECK DEC 15   5   Change in no. of units (for unit-quoted securities)  
140 D_AKTNOMWBW D_AKTNOMWBW WERTV8_TR CURR 15   2   Asset: Change in nominal value in purchase currency  
141 D_PASNOMWBW D_PASNOMWBW WERTV8_TR CURR 15   2   Liability: Change in nominal value in sale currency  
142 D_AWBW_A D_AWBW_A WERTV8_TR CURR 15   2   Change in acquisition value in position currency (asset)  
143 D_AWBW_P D_AWBW_P WERTV8_TR CURR 15   2   Change in acquisition value in position currency (liability)  
144 D_AWHW_A D_AWHW_A WERTV8_TR CURR 15   2   Change in acquisition value in local currency (asset)  
145 D_AWHW_P D_AWHW_P WERTV8_TR CURR 15   2   Change in acquisition value in local currency (liability)  
146 D_AKTBWBW D_AKTBWBW WERTV8_TR CURR 15   2   Asset: Change in book value in position/transaction curr.  
147 D_AKTBWHW D_AKTBWHW WERTV8_TR CURR 15   2   Asset: Change in book value in local currency  
148 D_PASBWBW D_PASBWBW WERTV8_TR CURR 15   2   Liability: Change in book value in position/trans. curr.  
149 D_PASBWHW D_PASBWHW WERTV8_TR CURR 15   2   Liability: Change in book value in local currency  
150 D_NKBWBW D_NKBWBW WERTV8_TR CURR 15   2   Delta Incidental Costs for Book Value in Position Currency  
151 D_NKBWHW D_NKBWHW WERTV8_TR CURR 15   2   Delta Incidental Costs for Book Value in Local Currency  
152 PABGERFPL PABGERFPLW WERTV8_TR CURR 15   2   Revenue Accrued/Deferred in Profit/Loss Currency  
153 PABGERFHW PABGERFHW WERTV8_TR CURR 15   2   Revenue Accrued/Deferred in Local Currency  
154 D_VAL_TI_PC FTI_D_VAL_TI_PC TPM_AMOUNT CURR 21   2   Delta Security Valuation in Position Currency  
155 D_VAL_TI_LC FTI_D_VAL_TI_LC TPM_AMOUNT CURR 21   2   Delta Security Valuation in Local Currency  
156 D_VAL_FX_LC FTI_D_VAL_FX_LC TPM_AMOUNT CURR 21   2   Delta Foreign Currency Valuation in Local Currency  
157 D_VAL_CH_TI_PC FTI_D_VAL_CH_TI_PC TPM_AMOUNT CURR 21   2   Delta Valuation of Capitalized Costs, Security, in PC  
158 D_VAL_CH_TI_LC FTI_D_VAL_CH_TI_LC TPM_AMOUNT CURR 21   2   Delta Valuation of Capitalized Costs, Security, in LC  
159 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  
160 .INCLUDE       0   0   Key Figures for Position Trend List Cross-Treasury  
161 CALC_CCY AFW_EVAL_CURRENCY WAERS CUKY 5   0   Evaluation Currency TCURC
162 MPKOND_A MPKOND_A FTI_NUMC3 NUMC 3   0   Interest rate - start (drilldown reporting characteristic)  
163 MPKOND_E MPKOND_E FTI_NUMC3 NUMC 3   0   Interest rate - end (drilldown reporting characteristic)  
164 PKOND_A FTI_PKOND_A DECV3_7 DEC 10   7   Interest rate: Start  
165 PKOND_E FTI_PKOND_E DECV3_7 DEC 10   7   Interest rate - end  
166 STUECKE_A FTI_STUECKE_A ASTUECK DEC 15   5   Number of units / Number of transactions - start  
167 STUECKE_E FTI_STUECKE_E ASTUECK DEC 15   5   No. of units/No. of transactions - end  
168 BVERA1 FTI_PASNOMWBW_A WERTV8_TR CURR 15   2   Liability: Nominal value in sale currency - start  
169 BFORA1 FTI_AKTNOMWBW_A WERTV8_TR CURR 15   2   Asset: Nominal value in purchase currency - start  
170 BVERE1 FTI_PASNOMWBW_E WERTV8_TR CURR 15   2   Liability: Nominal Value in Currency of Sale - End  
171 BFORE1 FTI_AKTNOMWBW_E WERTV8_TR CURR 15   2   Asset: Nominal value in purchase currency - end  
172 BKAUFWR_A_A FTI_BKAUFWR_A_A WERTV8_TR CURR 15   2   Asset: Acquisition value in position currency - start  
173 BKAUFWR_A_E FTI_BKAUFWR_A_E WERTV8_TR CURR 15   2   Asset: Acquisition value in position currency - end  
174 BKAUFHW_A_A FTI_BKAUFHW_A_A WERTV8_TR CURR 15   2   Asset: Acquisition value in local currency - start  
175 BKAUFHW_A_E FTI_BKAUFHW_A_E WERTV8_TR CURR 15   2   Asset: Acquisition value in local currency - end  
176 BKAUFWR_P_A FTI_BKAUFWR_P_A WERTV8_TR CURR 15   2   Liability: Acquisition value in position currency - start  
177 BKAUFWR_P_E FTI_BKAUFWR_P_E WERTV8_TR CURR 15   2   Liability: Acquisition value in position currency - end  
178 BKAUFHW_P_A FTI_BKAUFHW_P_A WERTV8_TR CURR 15   2   Liability: Acquisition value in local currency - start  
179 BKAUFHW_P_E FTI_BKAUFHW_P_E WERTV8_TR CURR 15   2   Liability: Acquisition value in local currency - end  
180 BKOSTWR_A FTI_BKOSTWR_A WERTV8_TR CURR 15   2   Asset: Incidental costs acquisition value in pos.curr.-start  
181 BKOSTWR_E FTI_BKOSTWR_E WERTV8_TR CURR 15   2   Asset: Incidental costs acquisition value in pos.curr. - end  
182 BKOSTHW_A FTI_BKOSTHW_A WERTV8_TR CURR 15   2   Asset: Incidental costs acquis. value in local curr. -start  
183 BKOSTHW_E FTI_BKOSTHW_E WERTV8_TR CURR 15   2   Asset: Incidental costs acquisition value in local curr.-end  
184 BKS_AWR FTI_VVBKSTBWR_A WERTV8_TR CURR 15   2   Book value of cap. incidental costs in position curr.- start  
185 BKS_EWR FTI_VVBKSTBWR_E WERTV8_TR CURR 15   2   Book value of cap. incidental costs in position curr. - end  
186 BKS_AHW FTI_VVBKSTBHW_A WERTV8_TR CURR 15   2   Book value of cap. incidental costs in local curr. - start  
187 BKS_EHW FTI_VVBKSTBHW_E WERTV8_TR CURR 15   2   Book value of capitalized incidental costs in loc.curr.- end  
188 AKTBWBW_A FTI_AKTBWBW_A WERTV8_TR CURR 15   2   Asset: Book value in position currency - start  
189 AKTBWHW_A FTI_AKTBWHW_A WERTV8_TR CURR 15   2   Asset: Book value in local currency - start  
190 PASBWBW_A FTI_PASBWBW_A WERTV8_TR CURR 15   2   Liability: Book value in position currency - start  
191 PASBWHW_A FTI_PASBWHW_A WERTV8_TR CURR 15   2   Liability: Book value in local currency - start  
192 AKTBWBW_E FTI_AKTBWBW_E WERTV8_TR CURR 15   2   Asset: Book value in position currency - end  
193 AKTBWHW_E FTI_AKTBWHW_E WERTV8_TR CURR 15   2   Asset: Book value in local currency - end  
194 PASBWBW_E FTI_PASBWBW_E WERTV8_TR CURR 15   2   Liability: Book value in position currency - end  
195 PASBWHW_E FTI_PASBWHW_E WERTV8_TR CURR 15   2   Liability: Book value in local currency - end  
196 BAKTPOSVALBW_A FTI_AKTPOSVALBW_A WERTV8_TR CURR 15   2   Asset: Current Value in Position Currency: Start  
197 BAKTPOSVALBW_E FTI_AKTPOSVALBW_E WERTV8_TR CURR 15   2   Asset: Current Value in Position Currency: End  
198 BPASPOSVALBW_A FTI_PASPOSVALBW_A WERTV8_TR CURR 15   2   Liability: Current Value in Position Currency: Start  
199 BPASPOSVALBW_E FTI_PASPOSVALBW_E WERTV8_TR CURR 15   2   Liability: Current Value in Position Currency: End  
200 ANKUPR_A FTI_ANKUPR_A VVPKTKUR DEC 15   6   Acq.Price for Percentage-Quoted Securities / Start of Period  
201 ANKUPR_E FTI_ANKUPR_E VVPKTKUR DEC 15   6   Acq.Price for Percentage-Quoted Securities / End of Period  
202 ANKSBW_A FTI_ANKSBW_A VVPKTKUR DEC 15   6   Acq. Price f. Unit-Quoted Securities in PC / Start of Period  
203 ANKSBW_E FTI_ANKSBW_E VVPKTKUR DEC 15   6   Acq. Price f. Unit-Quoted Securities in PC / End of Period  
204 BUKSBW_A FTI_BUKSBW_A VVPKTKUR DEC 15   6   Book Price f. Unit-Quoted Securities in PC / Start of Period  
205 BUKSBW_E FTI_BUKSBW_E VVPKTKUR DEC 15   6   Book Price f. Unit-Quoted Securities in PC / End of Period  
206 BUKUPR_A FTI_BUKUPR_A VVPKTKUR DEC 15   6   Book Price f. Perc.-Quoted Securities in % / Start of Period  
207 BUKUPR_E FTI_BUKUPR_E VVPKTKUR DEC 15   6   Book Price f. Perc.-Quoted Securities in % / End of Period  
208 KAKSBW_A FTI_KAKSBW_A VVPKTKUR DEC 15   6   Purchase Price for Unit-Quoted Secs in PC / Start of Period  
209 KAKSBW_E FTI_KAKSBW_E VVPKTKUR DEC 15   6   Purchase Price for Unit-Quoted Secs in PC / End of Period  
210 KAKUPR_A FTI_KAKUPR_A VVPKTKUR DEC 15   6   Purchase Price for Perc.-Quoted Secs in % / Start of Period  
211 KAKUPR_E FTI_KAKUPR_E VVPKTKUR DEC 15   6   Purchase Price for Perc.-Quoted Secs in % / End of Period  
212 KURSBW_A FTI_KURSBW_A VVPKTKUR DEC 15   6   Market Price for Unit-Quoted Secs in PC / Start of Period  
213 KURSBW_E FTI_KURSBW_E VVPKTKUR DEC 15   6   Market Price for Unit-Quoted Secs in PC / End of Period  
214 KURSPR_A FTI_KURSPR_A VVPKTKUR DEC 15   6   Market Price Percentage-Quoted Securities / Start of Period  
215 KURSPR_E FTI_KURSPR_E VVPKTKUR DEC 15   6   Market Price Percentage-Quoted Securities / End of Period  
216 NPV_PC_A FTI_NPV_PC_A WERTV8_TR CURR 15   2   RM NPV in Position Currency: Start  
217 NPV_PC_E FTI_NPV_PC_E WERTV8_TR CURR 15   2   RM NPV in Position Currency: End  
218 NPV_CC_A FTI_NPV_CC_A WERTV8_TR CURR 15   2   RM Net Present Value in Valuation Currency Start  
219 NPV_CC_E FTI_NPV_CC_E WERTV8_TR CURR 15   2   RM Net Present Value in Valuation Currency End  
220 NPV_LONG_PC_A FTI_NPV_LONG_PC_A WERTV8_TR CURR 15   2   RM NPV Incoming Side in Currency Incoming Side Start  
221 NPV_LONG_PC_E FTI_NPV_LONG_PC_E WERTV8_TR CURR 15   2   RM NPV Incoming Side in Currency Incoming Side End  
222 NPV_SHORT_PC_A FTI_NPV_SHORT_PC_A WERTV8_TR CURR 15   2   RM NPV Outgoing Side in Currency Outgoing Side Start  
223 NPV_SHORT_PC_E FTI_NPV_SHORT_PC_E WERTV8_TR CURR 15   2   RM NPV Outgoing Side in Currency Outgoing Side End  
224 NPV_LONG_CC_A FTI_NPV_LONG_CC_A WERTV8_TR CURR 15   2   RM Net Present Value Incoming Side in Val. Currency Start  
225 NPV_LONG_CC_E FTI_NPV_LONG_CC_E WERTV8_TR CURR 15   2   RM Net Present Value Incoming Side in Val. Currency End  
226 NPV_SHORT_CC_A FTI_NPV_SHORT_CC_A WERTV8_TR CURR 15   2   RM NPV Outgoing Side in Valuation Currency Start  
227 NPV_SHORT_CC_E FTI_NPV_SHORT_CC_E WERTV8_TR CURR 15   2   RM NPV Outgoing Side in Valuation Currency End  
228 CLEAN_PRICE_PC_A FTI_CLEAN_PRICE_PC_A WERTV8_TR CURR 15   2   Clean Price in Position Currency: Start  
229 CLEAN_PRICE_PC_E FTI_CLEAN_PRICE_PC_E WERTV8_TR CURR 15   2   Clean Price in Position Currency: End  
230 CLEAN_PRICE_CC_A FTI_CLEAN_PRICE_CC_A WERTV8_TR CURR 15   2   Clean Price in Valuation Currency - Start  
231 CLEAN_PRICE_CC_E FTI_CLEAN_PRICE_CC_E WERTV8_TR CURR 15   2   Clean Price in Evaluation Currency End  
232 BPVALUE_PC_A FTI_VALBP_PC_A WERTV8_TR CURR 15   2   Basis Point Value in Position Currency: Start  
233 BPVALUE_PC_E FTI_VALBP_PC_E WERTV8_TR CURR 15   2   Basis Point Value in Position Currency: End  
234 BPVALUE_CC_A FTI_VALBP_CC_A WERTV8_TR CURR 15   2   Basis Point Value in Valuation Currency Start  
235 BPVALUE_CC_E FTI_VALBP_CC_E WERTV8_TR CURR 15   2   Basis Point Value in Valuation Currency End  
236 MAC_DURATION_A FTI_MAC_DURATION_A DEC9_3 DEC 12   3   Macaulay Duration: Start  
237 MAC_DURATION_E FTI_MAC_DURATION_E DEC9_3 DEC 12   3   Macaulay Duration: End  
238 MOD_DURATION_A FTI_MOD_DURATION_A DEC9_3 DEC 12   3   Modified Duration: Start  
239 MOD_DURATION_E FTI_MOD_DURATION_E DEC9_3 DEC 12   3   Modified Duration: End  
240 BAMORTWR_A FTI_AMORT_PC_A TPM_AMOUNT CURR 21   2   Amortization in Position Currency / Start of Period  
241 BAMORTWR_E FTI_AMORT_PC_E TPM_AMOUNT CURR 21   2   Amortization in Position Currency / End of Period  
242 BAMORTHW_A FTI_AMORT_LC_A TPM_AMOUNT CURR 21   2   Amortization in Local Currency / Start of Period  
243 BAMORTHW_E FTI_AMORT_LC_E TPM_AMOUNT CURR 21   2   Amortization in Local Currency / End of Period  
244 BAGIOWR_A FTI_DISAGIO_PC_A TPM_AMOUNT CURR 21   2   Cleared PD Deferral/Tax Compensation in PC / Start of Period  
245 BAGIOWR_E FTI_DISAGIO_PC_E TPM_AMOUNT CURR 21   2   Cleared PD Deferral/Tax Compensation in PC / End of Period  
246 BAGIOHW_A FTI_DISAGIO_LC_A TPM_AMOUNT CURR 21   2   Cleared PD Deferral/Tax Compensation in LC / Start of Period  
247 BAGIOHW_E FTI_DISAGIO_LC_E TPM_AMOUNT CURR 21   2   Cleared PD Deferral/Tax Compensation in LC / End of Period  
248 VAL_TI_PC_A FTI_VAL_TI_PC_A TPM_AMOUNT CURR 21   2   Security Valuation in Position Currency / Start of Period  
249 VAL_TI_PC_E FTI_VAL_TI_PC_E TPM_AMOUNT CURR 21   2   Security Valuation in Position Currency / End of Period  
250 VAL_TI_LC_A FTI_VAL_TI_LC_A TPM_AMOUNT CURR 21   2   Security Valuation in Local Currency / Start of Period  
251 VAL_TI_LC_E FTI_VAL_TI_LC_E TPM_AMOUNT CURR 21   2   Security Valuation in Local Currency / End of Period  
252 VAL_FX_LC_A FTI_VAL_FX_LC_A TPM_AMOUNT CURR 21   2   Foreign Currency Valuation in Local Crcy / Start of Period  
253 VAL_FX_LC_E FTI_VAL_FX_LC_E TPM_AMOUNT CURR 21   2   Foreign Currency Valuation in Local Crcy / End of Period  
254 VAL_CH_TI_PC_A FTI_VAL_CH_TI_PC_A TPM_AMOUNT CURR 21   2   Valuation of Cap. Costs, Security, in PC / Start of Period  
255 VAL_CH_TI_PC_E FTI_VAL_CH_TI_PC_E TPM_AMOUNT CURR 21   2   Valuation of Cap. Costs, Security, in PC / End of Period  
256 VAL_CH_TI_LC_A FTI_VAL_CH_TI_LC_A TPM_AMOUNT CURR 21   2   Valuation of Cap. Costs, Security, in LC / Start of Period  
257 VAL_CH_TI_LC_E FTI_VAL_CH_TI_LC_E TPM_AMOUNT CURR 21   2   Valuation of Cap. Costs, Security, in LC / End of Period  
258 VAL_CH_FX_LC_A FTI_VAL_CH_FX_LC_A TPM_AMOUNT CURR 21   2   Valuation of Cap. Costs, FX, in Local Crcy / Start of Period  
259 VAL_CH_FX_LC_E FTI_VAL_CH_FX_LC_E TPM_AMOUNT CURR 21   2   Valuation of Cap. Costs, FX, in Local Crcy / End of Period  
260 ACC_INTEREST_PC_A FTI_ACC_INTEREST_PC_A TPM_AMOUNT CURR 21   2   Accrued Interest in Position Currency / Start of Period  
261 ACC_INTEREST_PC_E FTI_ACC_INTEREST_PC_E TPM_AMOUNT CURR 21   2   Accrued Interest in Position Currency / End of Period  
262 NOMINAL_AMT_LO_PC_A FTI_NOMINAL_AMT_LO_PC_A TPM_AMOUNT CURR 21   2   Locked Nominal Amount in Position Currency / Start of Period  
263 NOMINAL_AMT_LO_PC_E FTI_NOMINAL_AMT_LO_PC_E TPM_AMOUNT CURR 21   2   Locked Nominal Amount in Position Currency / End of Period  
264 .INCLUDE       0   0   Display Currency Fields Cumulative Values Treasury  
265 BZBETR_AW FTI_CASWCW WERTV8 CURR 15   2   Payment Amount of Flow in Display Crcy (from Pmnt Crcy)  
266 BHWBETR_AW FTI_CASWHW WERTV8 CURR 15   2   Payment amount of flow in display currency from local curr.  
267 EHBETR_AW EHBETR_AW WERTV8_TR CURR 15   2   Profit/loss amount in display currency from local currency  
268 EEBETR_AW EEBETR_AW WERTV8_TR CURR 15   2   Profit/Loss Amount in DC (from P/L Currency)  
269 ANZGW FTI_ANZGW WAERS CUKY 5   0   Display Currency TCURC
270 BVERA1_AW FTI_PASNOMWBW_A_AW WERTV8_TR CURR 15   2   Liability: Nominal value in display currency - start  
271 BFORA1_AW FTI_AKTNOMWBW_A_AW WERTV8_TR CURR 15   2   Asset: Nominal value in display currency - start  
272 BVERE1_AW FTI_PASNOMWBW_E_AW WERTV8_TR CURR 15   2   Liability: Nominal value in display currency - end  
273 BFORE1_AW FTI_AKTNOMWBW_E_AW WERTV8_TR CURR 15   2   Asset: Nominal value in display currency - end  
274 AKTBWBW_A_AW FTI_AKTBWBW_A_AW WERTV8_TR CURR 15   2   Asset: Book value in display currency - start  
275 AKTBWHW_A_AW FTI_AKTBWHW_A_AW WERTV8_TR CURR 15   2   Asset: Book value in display currency (from LC) - start  
276 PASBWBW_A_AW FTI_PASBWBW_A_AW WERTV8_TR CURR 15   2   Liability: Book value in display currency - start  
277 PASBWHW_A_AW FTI_PASBWHW_A_AW WERTV8_TR CURR 15   2   Liability: Book value in display currency (from LC) - start  
278 AKTBWBW_E_AW FTI_AKTBWBW_E_AW WERTV8_TR CURR 15   2   Asset: Book value in display currency - end  
279 AKTBWHW_E_AW FTI_AKTBWHW_E_AW WERTV8_TR CURR 15   2   Asset: Book value in display currency (from LC) - end  
280 PASBWBW_E_AW FTI_PASBWBW_E_AW WERTV8_TR CURR 15   2   Liability: Book value in display currency - end  
281 PASBWHW_E_AW FTI_PASBWHW_E_AW WERTV8_TR CURR 15   2   Liability: Book value in display currency (from LC) - end  
282 BAKTPOSVALBW_A_AW FTI_AKTPOSVALBW_A_AW WERTV8_TR CURR 15   2   Asset: Current Value in Display Currency: Start  
283 BAKTPOSVALBW_E_AW FTI_AKTPOSVALBW_E_AW WERTV8_TR CURR 15   2   Asset: Current Value in Display Currency: End  
284 BPASPOSVALBW_A_AW FTI_PASPOSVALBW_A_AW WERTV8_TR CURR 15   2   Liability: Current Value in Display Currency: Start  
285 BPASPOSVALBW_E_AW FTI_PASPOSVALBW_E_AW WERTV8_TR CURR 15   2   Liability: Current Value in Display Currency: End  
286 D_AKTNOMWBW_AW FTI_D_AKTNOMWBW_AW WERTV8_TR CURR 15   2   Asset: Change in nominal value in disp.curr.from purch.curr.  
287 D_PASNOMWBW_AW FTI_D_PASNOMWBW_AW WERTV8_TR CURR 15   2   Liability: Change in nom.value in displ.curr.from sale curr.  
288 D_AWBW_A_AW FTI_D_AWBW_A_AW WERTV8_TR CURR 15   2   Asset: Change in acquisition value in display currency  
289 D_AWHW_A_AW FTI_D_AWHW_A_AW WERTV8_TR CURR 15   2   Asset: Change in acquis.value in disp.curr. from local curr.  
290 D_AWBW_P_AW FTI_D_AWBW_P_AW WERTV8_TR CURR 15   2   Change in acquisition value in display currency (liability)  
291 D_AWHW_P_AW FTI_D_AWHW_P_AW WERTV8_TR CURR 15   2   Liability: Change in acquis.val.in disp.curr. from loc.curr.  
292 D_AKTBWBW_AW FTI_D_AKTBWBW_AW WERTV8_TR CURR 15   2   Asset: Change in book value in display currency  
293 D_AKTBWHW_AW FTI_D_AKTBWHW_AW WERTV8_TR CURR 15   2   Asset: Change in book value in disp. curr. from local curr.  
294 D_PASBWBW_AW FTI_D_PASBWBW_AW WERTV8_TR CURR 15   2   Liability: Change in book value in display currency  
295 D_PASBWHW_AW FTI_D_PASBWHW_AW WERTV8_TR CURR 15   2   Liability: Change in book val. in disp.curr.from local curr.  
296 D_NKBWHW_AW FTI_D_NKBWBW_AW WERTV8_TR CURR 15   2   Change in Book Value of Incidental Costs in DC (From PC)  
297 D_NKBWBW_AW FTI_D_NKBWHW_AW WERTV8_TR CURR 15   2   Change in Book Value of Incidental Costs in DC (From LC)  
298 D_VAL_TI_DC FTI_D_VAL_TI_DC TPM_AMOUNT CURR 21   2   Delta Security Valuation in Display Currency (From Pos.Crcy)  
299 D_VAL_CH_TI_DC FTI_D_VAL_CH_TI_DC TPM_AMOUNT CURR 21   2   Delta Valuation of Capitalized Costs, Sec., in DC (from PC)  
300 PABGERFPL_AW FTI_PABGERFPLW_AW WERTV8_TR CURR 15   2   Revenue Accrued/Deferred in DC (from P/L Currency)  
301 PABGERFHW_AW FTI_PABGERFHW_AW WERTV8_TR CURR 15   2   Revenue accrued/deferred in display currency (local curr.)  
302 BKAUFWR_A_A_AW FTI_BKAUFWR_A_A_AW WERTV8_TR CURR 15   2   Asset: Acquis.value in display curr. from pos. curr. - start  
303 BKAUFWR_A_E_AW FTI_BKAUFWR_A_E_AW WERTV8_TR CURR 15   2   Asset: Acquisition value in display curr.from pos.curr.- end  
304 BKAUFHW_A_A_AW FTI_BKAUFHW_A_A_AW WERTV8_TR CURR 15   2   Asset: Acq. value in displ. curr. from local. curr. - start  
305 BKAUFHW_A_E_AW FTI_BKAUFHW_A_E_AW WERTV8_TR CURR 15   2   Asset: Acquis. value in displ. curr. from local. curr. - end  
306 BKAUFWR_P_A_AW FTI_BKAUFWR_P_A_AW WERTV8_TR CURR 15   2   Liability: Acquis. value in disp.curr. from pos.curr - start  
307 BKAUFWR_P_E_AW FTI_BKAUFWR_P_E_AW WERTV8_TR CURR 15   2   Liability: Acquis. value in disp. curr. from pos. curr - end  
308 BKAUFHW_P_A_AW FTI_BKAUFHW_P_A_AW WERTV8_TR CURR 15   2   Liability: Acquis.val.in displ.curr.from local curr. - start  
309 BKAUFHW_P_E_AW FTI_BKAUFHW_P_E_AW WERTV8_TR CURR 15   2   Liability: Acquis.value in displ.curr.from local curr. - end  
310 BKOSTHW_A_AW FTI_BKOSTHW_A_AW WERTV8_TR CURR 15   2   Asset: Incidental costs acquisition value in DC(LC) - start  
311 BKOSTHW_E_AW FTI_BKOSTHW_E_AW WERTV8_TR CURR 15   2   Asset: Incidental costs acquisition value in DC(LC) - end  
312 BKOSTWR_A_AW FTI_BKOSTWR_A_AW WERTV8_TR CURR 15   2   Asset: Incidental costs acquisition value in DC(PC) - start  
313 BKOSTWR_E_AW FTI_BKOSTWR_E_AW WERTV8_TR CURR 15   2   Asset: Incidental costs acquisition value in DC(PC) - end  
314 BKS_AWR_AW FTI_VVBKSTBWR_A_AW WERTV8_TR CURR 15   2   Book value of capitalized incidental costs in DC(PC) - start  
315 BKS_EWR_AW FTI_VVBKSTBWR_E_AW WERTV8_TR CURR 15   2   Book value of capitalized incidental costs in DC(PC) - end  
316 BKS_AHW_AW FTI_VVBKSTBHW_A_AW WERTV8_TR CURR 15   2   Book value of capitalized incidental costs in DC(LC) - start  
317 BKS_EHW_AW FTI_VVBKSTBHW_E_AW WERTV8_TR CURR 15   2   Book value of capitalized incidental costs in DC(LC) - end  
318 NPV_PC_A_AW FTI_NPV_PC_A_AW WERTV8_TR CURR 15   2   RM NPV in Display Currency: Start  
319 NPV_PC_E_AW FTI_NPV_PC_E_AW WERTV8_TR CURR 15   2   RM NPV in Display Currency: End  
320 CLEAN_PRICE_PC_A_AW FTI_CLEAN_PRICE_AW_A WERTV8_TR CURR 15   2   Clean Price in Display Currency: Start  
321 CLEAN_PRICE_PC_E_AW FTI_CLEAN_PRICE_AW_E WERTV8_TR CURR 15   2   Clean Price in Display Currency: End  
322 BPVALUE_PC_A_AW FTI_VALBP_AW_A WERTV8_TR CURR 15   2   Basis Point Value in Display Currency: Start  
323 BPVALUE_PC_E_AW FTI_VALBP_AW_E WERTV8_TR CURR 15   2   Basis Point Value in Display Currency: End  
324 BAMORTWR_A_AW FTI_AMORT_DC_A TPM_AMOUNT CURR 21   2   Amortization in Display Currency / Start of Period  
325 BAMORTWR_E_AW FTI_AMORT_DC_E TPM_AMOUNT CURR 21   2   Amortization in Display Currency / End of Period  
326 BAMORTHW_A_AW FTI_AMORTHW_DC_A TPM_AMOUNT CURR 21   2   Amortization in Display Currency from LC: Start of Period  
327 BAMORTHW_E_AW FTI_AMORTHW_DC_E TPM_AMOUNT CURR 21   2   Amortization in Display Currency from LC: End of Period  
328 BAGIOWR_A_AW FTI_DISAGIO_DC_A TPM_AMOUNT CURR 21   2   Cleared PD Deferral/Tax Compensation in DC / Start of Period  
329 BAGIOWR_E_AW FTI_DISAGIO_DC_E TPM_AMOUNT CURR 21   2   Cleared PD Deferral/Tax Compensation in DC / End of Period  
330 BAGIOHW_A_AW FTI_DISAGIOHW_DC_A TPM_AMOUNT CURR 21   2   Cleared PD Def./Tax Compensation in DC from LC: Start  
331 BAGIOHW_E_AW FTI_DISAGIOHW_DC_E TPM_AMOUNT CURR 21   2   Cleared PD Def./Tax Compensation in DC from LC: End  
332 VAL_TI_DC_A FTI_VAL_TI_DC_A TPM_AMOUNT CURR 21   2   Security Valuation in Display Currency / Start of Period  
333 VAL_TI_DC_E FTI_VAL_TI_DC_E TPM_AMOUNT CURR 21   2   Security Valuation in Display Currency / End of Period  
334 VAL_CH_TI_DC_A FTI_VAL_CH_TI_DC_A TPM_AMOUNT CURR 21   2   Valuation of Cap. Costs, Security, in DC / Start of Period  
335 VAL_CH_TI_DC_E FTI_VAL_CH_TI_DC_E TPM_AMOUNT CURR 21   2   Valuation of Cap. Costs, Security, in DC / End of Period  
336 ACC_INTEREST_DC_A FTI_ACC_INTEREST_DC_A TPM_AMOUNT CURR 21   2   Accrued Interest in Display Currency / Start of Period  
337 ACC_INTEREST_DC_E FTI_ACC_INTEREST_DC_E TPM_AMOUNT CURR 21   2   Accrued Interest in Display Currency / End of Period  
338 NOMINAL_AMT_LO_DC_A FTI_NOMINAL_AMT_LO_DC_A TPM_AMOUNT CURR 21   2   Locked Nominal Amount in Display Currency / Start of Period  
339 NOMINAL_AMT_LO_DC_E FTI_NOMINAL_AMT_LO_DC_E TPM_AMOUNT CURR 21   2   Locked Nominal Amount in Display Currency / End of Period  
340 .INCLUDE       0   0   Additional Treasury Selections  
341 NUMBR CFNUMBR CFNUMBR NUMC 3   0   Number of translation key in currency translation T242Q
342 NUMBR_LC FTI_NUMBR_LC CFNUMBR NUMC 3   0   Translation Type for Currency Translation into Local Crcy T242Q
343 KURSA VVKURSAUSW VVSKURSART CHAR 2   0   Price type for evaluations TW56
344 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant T009
345 VVRANLWI VVRANLWI VVRANLWI NUMC 2   0   No. of the secondary index description for class data TWX1
346 CASHF SCASHFLOW XFELD CHAR 1   0   Indicator for cash flow calculation up to end of term  
347 BILST FTI_BILST DATUM DATS 8   0   Reference Date  
348 BILST2 FTI_BILST2 DATUM DATS 8   0   Reference Date  
349 BILST_REF_B FTI_BILST_REF_B FTI_BILST_REF_B CHAR 1   0   Positions: Remaining Term/Overdue Period Based On  
350 BILST_REF_F FTI_BILST_REF_F FTI_BILST_REF_F CHAR 1   0   Flows: Remaining Term/Overdue Period Based On  
351 STORNO FTI_STORNO XFELD CHAR 1   0   Evaluate Reversed Flows  
352 AUSWT FTI_EVALTYPE JBREVAL CHAR 4   0   Evaluation Type (Risk Management) JBREVAL
353 FLG_SE FTI_LDB_FLG_SE XFELD CHAR 1   0   Product Group Securities: Yes/No  
354 FLG_LO FTI_LDB_FLG_LO XFELD CHAR 1   0   Product Group Loans: Yes/No  
355 FLG_OTC FTI_LDB_FLG_OTC XFELD CHAR 1   0   Product Group OTC (MM, FX, DE): Yes/No  
356 FLG_LOF FTI_LDB_FLG_LOF XFELD CHAR 1   0   Product Group Listed Derivatives (Futures): Yes/No  
357 FLG_COUPLING_SECACCGRP FTI_LDB_FLG_COUPLING_SECACCGRP XFELD CHAR 1   0   Interpret Assignment of Sec. Account to Sec. Account Group  
358 FLG_HISTORIC_ACCASSREF FTI_LDB_FLG_HISTORIC_ACCASSREF XFELD CHAR 1   0   Indicator: Historical Account Assignment Reference  
359 FLG_CONDENSE FTI_CONDENSE XFELD CHAR 1   0   Summarize Results (for Query)  
360 FLG_NO_NULL FTI_NO_NULL XFELD CHAR 1   0   Hide Zero Records  
361 FLG_EXCLUDING_PLAN FTI_EXCL_PLAN XFELD CHAR 1   0   Exclude Plan Data (for Query)  
362 FLG_REVERSED_FLOWS FTI_REVERSED_FLOWS XFELD CHAR 1   0   Process Reversed Flows (for Query)  
363 .INCLU--AP       0   0   Append regulatory reporting Treasury SAP  
364 XLAND VVXLAND VVXLAND CHAR 2   0   Country variant for regulatory reporting  
365 SNW600 VVSNW600 VVSNW600 CHAR 4   0   Asset group BAV stmt 101, 201 and 600 TZ29P
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VTVDMW1_TR ALWPKL TW22 ALWPKL    
2 VTVDMW1_TR ANZGW TCURC WAERS    
3 VTVDMW1_TR AUSWT JBREVAL AUSWERTUNG    
4 VTVDMW1_TR BUKRS T001 BUKRS 1 CN
5 VTVDMW1_TR CALC_CCY TCURC WAERS    
6 VTVDMW1_TR CNTRY_COMP T005 LAND1    
7 VTVDMW1_TR GROUP_D TP13 GROUP_D    
8 VTVDMW1_TR GROUP_ID TB001 BU_GROUP    
9 VTVDMW1_TR GSART TZPA GSART    
10 VTVDMW1_TR HKONT SKB1 SAKNR    
11 VTVDMW1_TR IND_SECTOR TB038A IND_SECTOR    
12 VTVDMW1_TR ISTYPE TB038 ISTYPE    
13 VTVDMW1_TR KURSA TW56 SKURSART    
14 VTVDMW1_TR LAND1 T005 LAND1    
15 VTVDMW1_TR LEGAL_ENTY TB019 LEGAL_ENTY    
16 VTVDMW1_TR LEGAL_ORG TB032 LEGAL_ORG    
17 VTVDMW1_TR LOTGENERATION_BUSTRANSCAT TRDTS_BT_CAT BUSTRANSCAT    
18 VTVDMW1_TR MANDT T000 MANDT 1 CN
19 VTVDMW1_TR NATION T005 LAND1    
20 VTVDMW1_TR NUMBR T242Q NUMBR    
21 VTVDMW1_TR NUMBR_LC T242Q NUMBR    
22 VTVDMW1_TR PARTNR BUT000 PARTNER    
23 VTVDMW1_TR PERIV T009 PERIV    
24 VTVDMW1_TR PRKEY PAYRQ KEYNO C CN
25 VTVDMW1_TR RAHABKI T012 HBKID    
26 VTVDMW1_TR RAHKTID T012K HKTID    
27 VTVDMW1_TR RANL VWPANLA RANL    
28 VTVDMW1_TR RANLVD VDARL RANL    
29 VTVDMW1_TR RATING TP06 RATING    
30 VTVDMW1_TR RATING_RANL TP06 RATING    
31 VTVDMW1_TR RDEALER TZDEA RDEALER    
32 VTVDMW1_TR RFHA VTBFHA RFHA 1 CN
33 VTVDMW1_TR RGARANT BUT000 PARTNER C CN
34 VTVDMW1_TR RKONTRA BUT000 PARTNER    
35 VTVDMW1_TR RLDEPO TWD01 RLDEPO    
36 VTVDMW1_TR RMAID VTBMA RMAID C CN
37 VTVDMW1_TR RPORTB TWPOB RPORTB 1 CN
38 VTVDMW1_TR RPZAHL BUT000 PARTNER 1 CN
39 VTVDMW1_TR RREFKONT_R T037S RREFKONT    
40 VTVDMW1_TR SANLF TZAF SANLF    
41 VTVDMW1_TR SARTBET TW02 SARTBET    
42 VTVDMW1_TR SBEWART_R TZB0A SBEWART    
43 VTVDMW1_TR SBILK TW11 SBILK    
44 VTVDMW1_TR SBWHR TCURC WAERS 1 CN
45 VTVDMW1_TR SBWHR_P TCURC WAERS    
46 VTVDMW1_TR SFGTYP AT01 SFGTYP 1 CN
47 VTVDMW1_TR SFGZUSTT AT02 SFGZUSTT    
48 VTVDMW1_TR SFHAART AT10 SFHAART 1 CN
49 VTVDMW1_TR SFOTY TW21 SFOTY    
50 VTVDMW1_TR SNW600 TZ29P SNW600 KEY 1 CN
51 VTVDMW1_TR SOL_INS TP07 SOL_INS    
52 VTVDMW1_TR SOL_INS_RANL TP07 SOL_INS    
53 VTVDMW1_TR SPLWHR TCURC WAERS C CN
54 VTVDMW1_TR STAFF_GRP TP05 STAFF_GRP    
55 VTVDMW1_TR STATE T005 LAND1    
56 VTVDMW1_TR SWERTTYP TW20 SWERTTYP    
57 VTVDMW1_TR SWPKLASS TW01 SWPKLASS    
58 VTVDMW1_TR VVRANLWI TWX1 VVRANLWI    
59 VTVDMW1_TR WAERS TCURC WAERS    
60 VTVDMW1_TR WFORD1 TCURC WAERS C CN
61 VTVDMW1_TR WVERB1 TCURC WAERS C CN
62 VTVDMW1_TR WZBETR TCURC WAERS    
63 VTVDMW1_TR ZLSCH T042Z ZLSCH    
History
Last changed by/on SAP  20131127 
SAP Release Created in