SAP ABAP Table TBCO_SE (Output Structure: Securities Order Confirmations)
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FIN-FSCM-TRM-TM-TR (Application Component) Transaction Management
     FTTR (Package) Treasury: Financial Transaction
Basic Data
Table Category INTTAB    Structure 
Structure TBCO_SE   Table Relationship Diagram
Short Description Output Structure: Securities Order Confirmations    
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   Output Structure for Correspondence: Overall Structure  
2 MANDT MANDT MANDT CLNT 3   0   Client *
3 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
4 BUTXT BUTXT TEXT25 CHAR 25   0   Name of Company Code or Company  
5 BU_SWIFT TB_BUSWIFT SWIFT CHAR 11   0   SWIFT Code for Company Code (Sender of Message)  
6 RANTYP RANTYP RANTYP CHAR 1   0   Contract Type  
7 SGSART VVSART VVSART CHAR 3   0   Product Type *
8 XSGSART TB_XGSART TEXT30 CHAR 30   0   Name of product type  
9 XSGSART_K TB_XGSART_K TEXT10 CHAR 10   0   Short text for product type  
10 XSGSART_E TB_DONT_USE_TEXT30 TEXT30 CHAR 30   0   Do not use this field (see documention)  
11 SFHAART TB_SFHAART T_SFHAART CHAR 3   0   Financial Transaction Type *
12 XSFHAART TB_FATEXT T_XTEXT30 CHAR 30   0   Name of Transaction Type  
13 XSFHAART_E TB_DONT_USE_TEXT30 TEXT30 CHAR 30   0   Do not use this field (see documention)  
14 SFGZUSTT TB_SFGZUTY T_SFGZUTY NUMC 2   0   Transaction Activity Category *
15 XSFGZUSTT TB_XTTEXT TEXT30 CHAR 30   0   Name of activity category  
16 XSFGZUSTTE TB_DONT_USE_TEXT30 TEXT30 CHAR 30   0   Do not use this field (see documention)  
17 SFUNKTV TB_SFUNKTV T_FUNKTION CHAR 4   0   Transition Function from Directly Preceding Activity *
18 XSFUNKTV TB_XFUNKT TEXT30 CHAR 30   0   Name of Treasury function  
19 SFUNKTL TB_SFUNKTL T_FUNKTION CHAR 4   0   Latest function used in editing activity *
20 XSFUNKTL TB_XFUNKT TEXT30 CHAR 30   0   Name of Treasury function  
21 XSFUNKTL_E TB_DONT_USE_TEXT30 TEXT30 CHAR 30   0   Do not use this field (see documention)  
22 LANGU_BEFORE TB_LANGU_BEFORE SPRAS LANG 1   0   Language Key Before Cross-Language Search for SAPscript Form *
23 LANGU_AFTER TB_LANGU_AFTER SPRAS LANG 1   0   Language Key After Cross-Language Search for SAPscript Form *
24 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number *
25 RFHA TB_RFHA T_RFHA CHAR 13   0   Financial Transaction *
26 RFHAZU TB_RFHAZU T_RFHAZU NUMC 5   0   Transaction activity  
27 RFHAZUL TB_RFHAZUL T_RFHAZU NUMC 5   0   Last Active Transaction Activity  
28 SFIXRFHAZU TB_SFIXRFHAZU XFELD CHAR 1   0   Fixing activity (Indicator)  
29 SFIRST TB_SFIRST XFELD CHAR 1   0   Indicator: 1st correspond. for activity, corr.type + medium?  
30 RLFDNR TB_RLFDNR T_LFDNR2 NUMC 2   0   Sequential No. VRBKORES Data Record per Activity (Key Field)  
31 SREPEAT TB_REPEAT XFELD CHAR 1   0   Repeat correspondence?  
32 DATUM TB_DCRDAT DATUM DATS 8   0   Entered On  
33 CRUSER TB_CRUSER SYCHAR12 CHAR 12   0   Entered by  
34 DCRDAT TB_DCRDAT DATUM DATS 8   0   Entered On  
35 TCRTIM TB_TCRTIM UZEIT TIMS 6   0   Entry Time  
36 UPUSER TB_UPUSER SYCHAR12 CHAR 12   0   Last Changed by  
37 DUPDAT TB_DUPDAT DATUM DATS 8   0   Changed on  
38 TUPTIM TB_TUPTIM UZEIT TIMS 6   0   Time changed  
39 DVTRAB TB_DVTRAB DATUM DATS 8   0   Contract Conclusion Date  
40 RMAID TB_RMAID T_RMAID CHAR 10   0   Master Agreement *
41 GSPPART TB_GSPPART TEXT19 CHAR 19   0   Contact Person  
42 DBLFZ TB_DBLFZ DATUM DATS 8   0   Term Start  
43 DELFZ TB_DELFZ DATUM DATS 8   0   Term End  
44 KONTRH TB_KUNNR_NEW BU_PARTNER CHAR 10   0   Business Partner Number *
45 XKONTRH TB_XKONTRH TEXT80 CHAR 80   0   Name and address of business partner  
46 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
47 ADDR_TYPE AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
48 PERSNUMBER AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
49 FROMCOUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
50 ROLETYP BU_PARTNERROLECAT BU_ROLECAT CHAR 6   0   BP Role Category *
51 XROLETYP BU_BEZ50 TEXT50 CHAR 50   0   Description  
52 RGARANT TB_RGARANT_NEW BU_PARTNER CHAR 10   0   Guarantor of Financial Transaction *
53 XRGARANT TB_XGARANT TEXT80 CHAR 80   0   Name and address of guarantor  
54 KO_FAX TB_KOTELFX TEXT31 CHAR 31   0   Business partner fax number  
55 KO_ADR_COUNTRY LAND1_GP LAND1 CHAR 3   0   Country Key *
56 KO_SWIFT TB_KOSWIFT SWIFT CHAR 11   0   SWIFT Code of Counterparty (Receiver of Message)  
57 KO_ADSMTP AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
58 RPZAHL TB_RPZAHL_NEW BU_PARTNER CHAR 10   0   Payer/payee *
59 ZR_SWIFT TB_ZRSWIFT SWIFT CHAR 11   0   SWIFT code of payer/payee  
60 RPBANK TB_RPBANK BVTYP CHAR 4   0   Partner bank details  
61 PB_SWIFT TB_PBSWIFT SWIFT CHAR 11   0   SWIFT code of partner bank  
62 PB_IBAN IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
63 RAHABKI TB_RHABKI HBKID CHAR 5   0   Short key for own house bank *
64 HB_SWIFT TB_HBSWIFT SWIFT CHAR 11   0   House bank SWIFT code  
65 HB_IBAN IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
66 RAHKTID TB_RHKTID HKTID CHAR 5   0   Short key for house bank account *
67 RAHK_NO TB_RAHK_NO BANKN CHAR 18   0   Do Not Use  
68 RPCODE RPCODE RPCODE CHAR 20   0   Repetitive Code *
69 SZART TB_SZART XFELD CHAR 1   0   Payment transaction  
70 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement *
71 NORDEXT TB_NORDEXT FTI_CHAR16LOW CHAR 16   0   External Reference  
72 RDEALER RDEALER RDEALER CHAR 12   0   Trader *
73 SSTOGRD SSTOGRD SSTOGRD CHAR 2   0   Reason for Reversal *
74 XSSTOGRD TB_XSTOGRD XKBEZ CHAR 15   0   Short description for reversal reason  
75 SRNDNG TB_SRNDNG TFM_SROUND CHAR 1   0   Rounding of Amount from Generated Flows  
76 CORTYP TB_CORTYP T_CORTYP CHAR 3   0   Correspondence type *
77 FORMULAR TDFORM TDFORM CHAR 16   0   Form name  
78 SWIFT_DAT TB_SWI_DAT TB_SWI_DAT CHAR 8   0   Format for SWIFT files  
79 SANLF SANLF VVSANLF NUMC 3   0   Product Category *
80 SFGTYP TB_SFGTYP T_SFGTYP NUMC 3   0   Transaction Category *
81 SAKTIV TB_SAKTIV T_SAKTIV NUMC 1   0   Active Status of Transaction or Activity  
82 RPORTB RPORTB RPORTB CHAR 10   0   Portfolio *
83 ZUONR TB_TFPROJ T_TFPROJ CHAR 13   0   Finance Project  
84 RANL VVRANLW WP_RANL CHAR 13   0   Security ID Number *
85 RLDEPO VRLDEPO RLDEPO CHAR 10   0   Securities Account *
86 PEFFZINS TB_PYIELD DECV3_7 DEC 10   7   Effective Interest Rate  
87 SEFFMETH SEFFMETH SEFFMETH NUMC 1   0   Effective Interest Method (Financial Mathematics)  
88 XEFFMETH TEXT60 TEXT60 CHAR 60   0   Text Field of Length 60  
89 ZUOND TB_ZUOND TEXT18 CHAR 18   0   Assignment  
90 REFER TB_REFER CHAR16 CHAR 16   0   Internal Reference  
91 MERKM TB_MERKM CHAR25 CHAR 25   0   Characteristics  
92 RCOMVALCL TPM_COM_VAL_CLASS TPM_COM_VAL_CLASS NUMC 4   0   General Valuation Class *
93 XRCOMVALCL TEXT60 TEXT60 CHAR 60   0   Text Field of Length 60  
94 FACILITYNR TB_FACILITYNR T_RFHA CHAR 13   0   Transaction Number of Facility *
95 FACILITYBUKRS TB_FACILITYBUKRS BUKRS CHAR 4   0   Company Code of Facility *
96 VRFHA TB_VORFHA T_RFHA CHAR 13   0   Reference transaction (Rollover/premature settlement) *
97 RRFHA TB_RRFHA T_RFHA CHAR 13   0   Reference transaction (general) *
98 RBUKRS TB_RBUKRS BUKRS CHAR 4   0   Company code of reference transaction *
99 .INCLUDE       0   0   Ouptut structure: Authorized bank  
100 BANKA_SB BANKA TEXT60 CHAR 60   0   Name of bank  
101 BRNCH_SB BRNCH TEXT40 CHAR 40   0   Bank Branch  
102 STRAS_SB STRAS_GP TEXT35 CHAR 35   0   House number and street  
103 ORT01_SB ORT01_GP TEXT35 CHAR 35   0   City  
104 SWIFT_SB SWIFT SWIFT CHAR 11   0   SWIFT/BIC for International Payments  
105 BNKLZ_SB BANKL BANKL CHAR 15   0   Bank number  
106 BANKN_SK BANKN BANKN CHAR 18   0   Bank account number  
107 BNKN2_SK BNKN2 BNKN2 CHAR 24   0   Alternative Bank Acct Number (for Ambiguous Acct Number)  
108 IBAN_SK IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
109 .INCLU-_CD       0   0   Asset master for securities  
110 MANDT_CD MANDT MANDT CLNT 3   0   Client T000
111 RANL_CD VVRANLW WP_RANL CHAR 13   0   Security ID Number *
112 SANLF_CD SANLF VVSANLF NUMC 3   0   Product Category TZAF
113 SSTATI_CD SEC_STATUS SEC_STATUS NUMC 2   0   Status of a security  
114 RANLALT1_CD RANLALT1S CHAR13S CHAR 13   0   RANLALT1  
115 RANLALT2_CD RANLALT2S CHAR13S CHAR 13   0   Alternative identification 2  
116 GSART_CD VVSART VVSART CHAR 3   0   Product Type TZPA
117 SBRSCH_CD BRSCH BRSCH CHAR 4   0   Industry key T016
118 SWERTTYP_CD SWERTTYP SAKTTYP NUMC 1   0   Security Type ID TW20
119 SBOERNOT_CD SBOERNOT JANEI CHAR 1   0   Indicator: Listed on an Exchange  
120 WLOMB_CD WLOMB JANEI CHAR 1   0   Indicator eligible as collateral  
121 JDECK_CD JDECK JANEI CHAR 1   0   Regulatory reporting BPV (hedge fund Y/N)  
122 WPFAN_CD WPFAN JANEI CHAR 1   0   Indicator pledgeable  
123 SSTBE_CD SSTBE JANEI CHAR 1   0   Tax treatment indicator  
124 LOEVM_CD LOEVM XFELD CHAR 1   0   Deletion Indicator  
125 JABMI_CD JABMI JANEI CHAR 1   0   Joint partner vote indicator  
126 XALKZ_CD XALKZ XKBEZ CHAR 15   0   Short name  
127 XALLB_CD XALLB XLBEZ CHAR 60   0   Long name  
128 REPKE_CD REPKE_NEW BU_PARTNER CHAR 10   0   Issuer Identity Key *
129 BEMPREIS_CD BEMPREIS VVBNENNW CURR 10   2   Issue Price  
130 REWHR_CD REWHR WAERS CUKY 5   0   Issue currency TCURC
131 PEMKURS_CD PEMKURS DEC3_7 DEC 10   7   Issue rate in percent  
132 SNOTI_CD SNOTI SNOTI NUMC 1   0   Quotation Indicator  
133 PKUAB_CD PKUAB DEC3_7 DEC 10   7   Price deviation in percent  
134 BKUAB_CD BKUAB WHRBTRG CURR 10   2   Absolute price deviation  
135 DANDPFL_CD DANDPFL DATUM DATS 8   0   Obligation to offer for sale until  
136 DANDRE_CD DANDRE DATUM DATS 8   0   Right to offer until  
137 SOBJEKT_CD VVKEYOBJ VVKEY CHAR 10   0   Internal key for object  
138 RERF_CD RERF SYCHAR12 CHAR 12   0   Entered by  
139 DERF_CD DERF DATUM DATS 8   0   First Entered on  
140 TERF_CD TERF TIMES TIMS 6   0   Time of Initial Entry  
141 REHER_CD REHER CHAR10 CHAR 10   0   Source of initial entry  
142 RBEAR_CD RBEAR SYCHAR12 CHAR 12   0   Employee ID  
143 DBEAR_CD DBEAR DATUM DATS 8   0   Last Edited on  
144 TBEAR_CD TBEAR TIMES TIMS 6   0   Last Edited at  
145 RBHER_CD RBHER CHAR10 CHAR 10   0   Editing Source  
146 SROLEXT_CD ALWPKL ALWPKL CHAR 3   0   General Security Classification TW22
147 VVSLOEKZ_CD VVSLOEKZ VVSLOEKZ NUMC 1   0   Deletion indicator  
148 JMUENDEL_CD VVJMUEND JANEI CHAR 1   0   Eligibility indicator  
149 SMOVERW_CD SMOVERW SMOVERW CHAR 2   0   Possible custody type TW50
150 SIHERK_CD CHAR2 CHAR2 CHAR 2   0   Version Number Component  
151 KBEMPREIS_CD VVKBEMPR VVKWKURS DEC 15   6   Issue price independent of currency  
152 SDEPOSTAT_CD VVDEPOSTAT VVDEPOSTA NUMC 2   0   Securities account statistics key TW51
153 SFUNDI_CD VVSFUNDI JANEI CHAR 1   0   Indicator: Funded  
154 SWPHGMPF_CD VVSWPHGMPF JANEI CHAR 1   0   Securities trading law reporting obligation indicator  
155 RISIN_CD VVRISIN RISIN CHAR 13   0   International securities ID number (no longer used)  
156 INSTITUTE_CD BP_SOL_INS BP_SOL_INS CHAR 4   0   Institute Providing Credit Standing Information TP07
157 RATING_CD BP_RATING BP_RATING CHAR 3   0   Rating TP06
158 PRICE_INDEX_CD TIDX_INDEX_NAME TIDX_INDEX_NAME CHAR 15   0   Name of Price Index TIDX_PRICE_INDEX
159 PRICE_IDX_BDATE_CD TIDX_INDEX_BASE_DATE DATPER DATS 8   0   Price Index Base Date  
160 .INCLU--AP       0   0   Append for VWPANLA  
161 .INCLU-_HB       0   0   Table condition header  
162 MANDT_HB MANDT MANDT CLNT 3   0   Client T000
163 BUKRS_HB BUKRS BUKRS CHAR 4   0   Company Code T001
164 SANLF_HB SANLF VVSANLF NUMC 3   0   Product Category *
165 RKEY1_HB RKEY1 RKEY1 CHAR 13   0   Key part 1  
166 DGUEL_KK_HB DGUEL DATUM DATS 8   0   Date Condition Effective from  
167 NLFD_ANG_HB NLFD_ANG LFNR3 NUMC 3   0   Offer consecutive number  
168 SSTATI_HB SSTATI STATI NUMC 2   0   Status of data record *
169 SKOKOART_HB SKOKOART SKOKOART NUMC 2   0   Type of Condition Header  
170 STILGRHY_HB STILGRHY SRHYT NUMC 2   0   Payment cycle  
171 STILGART_HB STILGART STILGART NUMC 1   0   Repayment Type Indicator  
172 SDISEIN_HB SDISEIN SDISEIN CHAR 1   0   Type of Discount Withholding  
173 KZAHLUNG_HB KZAHLUNG DEC3_7 DEC 10   7   Pay-in/disbursement rate  
174 BZAHLUNG_HB BZAHLUNG BWHR CURR 13   2   Pay-in/disbursement amount  
175 SWHRZHLG_HB SWHRZHLG WAERS CUKY 5   0   Currency of payment amount TCURC
176 BZUSAGE_HB BZUSAGE WERTV7 CURR 13   2   Commitment capital  
177 SWHRZUSA_HB SWHRZUSA WAERS CUKY 5   0   Currency of commitment amount TCURC
178 PEFFZINS_HB TB_EFF_RATE DECV3_7 DEC 10   7   Effective Interest Rate  
179 SEFFMETH_HB SEFFMETH SEFFMETH NUMC 1   0   Effective Interest Method (Financial Mathematics)  
180 SZBMETH_HB SZBMETH SZBMETH CHAR 1   0   Interest Calculation Method  
181 SDISKO_HB SDISKO SDISKO CHAR 1   0   Discounted  
182 DKUEND_HB DKUEND DATUM DATS 8   0   Date of notice  
183 SKUEND_HB SKUEND SKUEART NUMC 3   0   Reason for Notice TD04
184 DKUENDDG_HB DKUENDDG DATUM DATS 8   0   Earliest Possible Date for Notice Given by the Lender  
185 DBLFZ_HB DBLFZ DATUM DATS 8   0   Start of Term  
186 DBLFZ_ORIGIN_HB DBLFZ_ORIGIN DATUM DATS 8   0   Original Term Start  
187 DELFZ_HB DELFZ DATUM DATS 8   0   End of Term  
188 DRESAM_HB DRESAM DATUM DATS 8   0   Reservation of Conditions On  
189 DRESBIS_HB DRESBIS DATUM DATS 8   0   Reservation of Conditions Until  
190 DANGAM_HB DANGAM DATUM DATS 8   0   Offer creation date  
191 DANGBIS_HB DANGBIS DATUM DATS 8   0   Offer Effective To  
192 SANGVOR_HB SANGVOR SANGVOR NUMC 2   0   Offer/Acceptance Reservation Indicator ATRESERVATION
193 JANNAHME_HB JANNAHME JANEI CHAR 1   0   Offer Acceptance Indicator  
194 SANNAHME_HB SANNAHME SKONTAKT NUMC 2   0   Type of offer acceptance indicator TD13
195 DANNAHME_HB DANNAHME DATUM DATS 8   0   Date of acceptance of offer  
196 JVERTRAG_HB JVERTRAG JANEI CHAR 1   0   Indicator: Contract Created?  
197 DVERTRAM_HB DVERTRAM DATUM DATS 8   0   Contract creation date  
198 DVERTBIS_HB DVERTBIS DATUM DATS 8   0   Return contract by  
199 PMANEFFZ_HB TB_EFF_RATE_INT DECV3_7 DEC 10   7   Effective Interest Rate  
200 SEFFM2_HB SEFFMETH SEFFMETH NUMC 1   0   Effective Interest Method (Financial Mathematics)  
201 SKUEGL_HB VVSKUEGL VVSKUEGL NUMC 3   0   Notice Arrangement Lender TD28
202 RPNR_HB VVRPNR NUMC08 NUMC 8   0   Activity number/rollover number  
203 DEFSZ_HB VVDEFSZ DATUM DATS 8   0   Date of fixed period end  
204 DGES_HB VVDGES DATUM DATS 8   0   Earliest Notice Date in acc. with the Legal Right of Notice  
205 SGESAUS_HB VVSGESAUS XFELD CHAR 1   0   Legal Right of Notice Excluded  
206 SZKZ_HB VVSZKZ VVSZKZ CHAR 1   0   Special int. ID for int. on arrears for remaining balance TDSOZ
207 NANGEBOT_HB NLFD_ANG LFNR3 NUMC 3   0   Offer consecutive number  
208 SINCL_HB VVSINCL VVSINCL NUMC 1   0   Inclusive indicator for beginning and end of a period  
209 ZVRHYEFF_HB VVZVRHYEFF NUMC03 NUMC 3   0   Int.sttlmnt frequency for effective int.rate calc.in months  
210 PVGLEFFZ_HB TB_EFF_RATE_COM DECV3_7 DEC 10   7   Comparative Effective Interest  
211 SULTEFSZ_HB VVSULTEFSZ VVSULT CHAR 1   0   Month-end indicator for end of fixed period  
212 DABEFFZ_HB VVDABEFFZ DATUM DATS 8   0   Date when calculation of effective rate starts  
213 DKUENDDN_HB VVDKUENDDN DATUM DATS 8   0   Earliest Possible Date for Notice Given by the Borrower  
214 SKUEDN_HB VVSKUEDN VVSKUEDN NUMC 3   0   Notice Arrangement Borrower TD29
215 SKUEART_HB VVSKUEART VVSKUEART NUMC 3   0   Notice Type for the Loan TD27
216 DMARKTZINS_HB DMARKTZINS DATS DATS 8   0   ISB: Market Rate Date: Market Interest Rate for NPV Calc.  
217 SKALIDWT_HB TFMSKALIDWT WFCID CHAR 2   0   Interest Calendar *
218 EDEFFZINS_HB TB_EFF_RATE_ED DECV3_7 DEC 10   7   Relevant for Closely Defined Effective Interest  
219 EDEFFMETH_HB EFFMETH EFFMETH CHAR 1   0   Effective Interest Method - Acc. to EU Gdline Int.Statistics  
220 JAHREFFZINS_HB TB_EFF_RATE_YEAR DECV3_7 DEC 10   7   Relevant for Yearly Eff. Interest Acc Guideline 87/102/EU  
221 JAHREFFMETH_HB EFFMETH EFFMETH CHAR 1   0   Effective Interest Method - Acc. to EU Gdline Int.Statistics  
222 PEFFZINS_ORIGIN_HB TB_EFF_RATE_ORIG DECV3_7 DEC 10   7   Original Effective Interest Rate  
223 .INCLU--AP       0   0   Extensions of Loan Component  
224 ORIGINAL_TERM_HB TB_VIEW_ORIGINAL_TERM   NUMC 3   0   Original Term in Months  
225 OVERALL_RUNTIME_HB TB_VIEW_OVERALL_RUNTIME   NUMC 3   0   Overall Term  
226 ORIG_CREDIT_SUM_HB TB_VIEW_ORIGINAL_CREDIT_SUM WERTV7 CURR 13   2   Original Total Loan Amount  
227 DATE_REPAYMENT_HB TB_VIEW_DATE_REPAYMENT DATUM DATS 8   0   Start Date for Repayment  
228 DATE_FIRST_RATE_HB TB_VIEW_DATE_FIRST_RATE DATUM DATS 8   0   Due Date for First Installment to Include a Repayment Amount  
229 DAY_OF_PAYMENT_HB TB_VIEW_DAY_OF_PAYMENT T_VIEW_DAY_OF_PAYMENT NUMC 2   0   Day of Installment Payment  
230 CLEARING_RATE_HB TB_VIEW_CLEARING_RATE WERTV7 CURR 13   2   Amount for Final Loan Installment Payment  
231 EFF_INT_L_PYMNP_HB TB_MODEL_EFFECTIV_INTERSTS_PPC DEC3_7 DEC 10   7   Effective Interest Rate for Last Change to Installment Plan  
232 DEFF_INT_L_PYMNP_HB TB_MODEL_DATE_LAST_PAYMENTPLAN DATUM DATS 8   0   Key Date for Last Change to Installment Plan  
233 REPAY_DELAY_HB TB_MODEL_REPAY_DELAY   NUMC 2   0   Model Calculation: DE for Periods of Repayment Suspension  
234 CALCULATED_PARAM_HB TB_MODEL_P_RATE_OR_TERM T_MODEL_P_RATE_OR_TERM CHAR 4   0   Calculate Installment Amount or Number of Installments?  
235 CURR_CREDIT_SUM_HB TB_VIEW_CURRENT_CREDIT_SUM WERTV7 CURR 13   2   Current Total Loan Amount  
236 BROUNDUNIT_HB TB_BROUNDUNIT_A TFMSRUNIT DEC 13   7   Rounding Unit for Amounts  
237 SROUND_HB TB_SROUND_A TFM_SROUND CHAR 1   0   Rounding Category (Round up, Round Down or Number Rounding)  
238 BOVERLIMIT_HB TB_COMP_OVERLIMIT_AMOUNT WERTV7 CURR 13   2   Drawing Tolerance as Amount  
239 POVERLIMIT_HB TB_COMP_OVERLIMT_PERCENT DECV3_7 DEC 10   7   Drawing Tolerance as a Percentage  
240 CONTAB_HB TB_FICO_CONTAB T_FICO_CONTAB CHAR 8   0   Condition Table  
241 CONTAB_VERSION_HB TB_FICO_CONTAB_VERSION T_FICO_CONTAB_VERSION NUMC 4   0   Version Number for a Condition Table  
242 TERM_PAYMENT_HB TB_TERM_PAYMENT T_TERM_PAYMENT CHAR 1   0   Category of Last Installment  
243 PAPR_ORIGIN_HB TB_PAPR_ORIGIN DECV3_7 DEC 10   7   Original U.S. Effective Interest Rate  
244 .INCLU-_HS       0   0   Condition header for stock, subscrip.rights, investments  
245 MANDT_HS MANDT MANDT CLNT 3   0   Client T000
246 RANL_HS RANL RANL CHAR 13   0   Contract Number  
247 DGUEL_KK_HS DGUEL DATUM DATS 8   0   Date Condition Effective from  
248 SANLF_HS SANLF VVSANLF NUMC 3   0   Product Category *
249 SSTATI_HS SSTATI STATI NUMC 2   0   Status of data record *
250 KZAHLAKT_HS KZAHLAKT DEC3_7 DEC 10   7   Pay-in rate  
251 BZAHLAKT_HS BZAHLAKT WHRBTRG CURR 10   2   Amount Deposited  
252 DREST_HS DREST DATUM DATS 8   0   Balance payment date  
253 SZAHLDIV_HS SZAHLDIV SZAHLDIV NUMC 1   0   Dividend form of payment  
254 DDBAB_HS DDBAB DATUM DATS 8   0   Date from which entitled to dividends  
255 RDIVNR_HS RDIVNR NUM03 NUMC 3   0   Dividend coupon number  
256 BAUSGLCH_HS BABTA WHRBTRG CURR 10   2   Clearing amount for swap  
257 SWHRAUSG_HS SWHRAUSG WAERS CUKY 5   0   Clearing amount currency TCURC
258 DXGUELT_HS DTGBI DATUM DATS 8   0   Trading until  
259 DTSCHAB_HS DTFVO DATUM DATS 8   0   Swap period from  
260 DXTAUSCH_HS DTFBI DATUM DATS 8   0   Swap period to  
261 ATCHNEN_HS BTVNE DEC5_4 DEC 9   4   Swap ratio - denominator  
262 ATSHZAE_HS BTVZA DEC5_4 DEC 9   4   Swap ratio - numerator  
263 PWANLRAB_HS PWARB DEC3_7 DEC 10   7   Reinvestment discount percent  
264 JTHESAU_HS STHES JANEI CHAR 1   0   Reinvestment indicator  
265 DBFRB_HS DBFRB DATUM DATS 8   0   Date subscription period until  
266 DBFRV_HS DBFRV DATUM DATS 8   0   Subscription period from  
267 BBPRU_HS BBPRU VVBNENNW CURR 10   2   Underlying subscription price  
268 RWBZP_HS RWBZP WAERS CUKY 5   0   Subscription price currency TCURC
269 RWBZP_T_HS CHAR30 CHAR30 CHAR 30   0   30 Characters  
270 DBHAB_HS DBHAB DATUM DATS 8   0   Date of subscription rights trading until  
271 DBHAV_HS DBHAV DATUM DATS 8   0   Date of subscription rights trading from  
272 BBVHN_HS BBVHN DEC5_4 DEC 9   4   Subscription ratio - Denominator  
273 BBVHZ_HS BBVHZ DEC5_4 DEC 9   4   Subscription ratio - Numerator  
274 BVNJA_HS BVNJA WHRBTRG CURR 10   2   Advantage/disadvantage dividend of new stock  
275 KREAK_HS KREAK VVKWKURS DEC 15   6   Post Subscription Rights  
276 .INCLU-_PI       0   0   Securities Account Position  
277 MANDT_PI MANDT MANDT CLNT 3   0   Client T000
278 BUKRS_PI BUKRS BUKRS CHAR 4   0   Company Code T001
279 RANL_PI VVRANLW WP_RANL CHAR 13   0   Security ID Number VWPANLA
280 RLDEPO_PI VRLDEPO RLDEPO CHAR 10   0   Securities Account TWD01
281 SSTATI_PI SSTATI STATI NUMC 2   0   Status of data record *
282 XDKBZ_PI XDKBZ XKBEZ CHAR 15   0   Sec.acct position short description  
283 RREFKONT_PI RREFKONT USTRU CHAR 8   0   Account Assignment Reference in Financial Assets Management T037S
284 SVERWA_PI SVERWA SVERWA CHAR 1   0   Custody type *
285 DANDPFL_PI DANDPFL DATUM DATS 8   0   Obligation to offer for sale until  
286 DANDRE_PI DANDRE DATUM DATS 8   0   Right to offer until  
287 SFIBG_PI SFIBG SFIBG NUMC 4   0   Asset Grouping Indicator TW08
288 SGLZB_PI SGLZB SGLZB CHAR 4   0   SCB asset group indicator TW07
289 SBILK_PI SBILK SBILK CHAR 2   0   Balance Sheet Indicator TW11
290 JSPRI_PI JSPRI JANEI CHAR 1   0   Intercorporate privilege indicator  
291 JBTEI_PI JBTEI JANEI CHAR 1   0   Shareholding indicator  
292 RFGEB_PI RFGEB_NEW BU_PARTNER CHAR 10   0   Releaser of master record (person) *
293 DFREI_PI DFREI DATUM DATS 8   0   Date of release  
294 TFREI_PI TFREI TIMES TIMS 6   0   Time of release  
295 RERF_PI RERF SYCHAR12 CHAR 12   0   Entered by  
296 DERF_PI DERF DATUM DATS 8   0   First Entered on  
297 TERF_PI TERF TIMES TIMS 6   0   Time of Initial Entry  
298 REHER_PI REHER CHAR10 CHAR 10   0   Source of initial entry  
299 RBEAR_PI RBEAR SYCHAR12 CHAR 12   0   Employee ID  
300 DBEAR_PI DBEAR DATUM DATS 8   0   Last Edited on  
301 TBHER_PI TBHER TBHER CHAR 1   0   Origin indicator for table  
302 RBHER_PI RBHER CHAR10 CHAR 10   0   Editing Source  
303 SBESANT_PI SBESANT SBESANT CHAR 2   0   Holding TZBA
304 JBETEIL_PI JBETEIL JANEI CHAR 1   0   Shareholding indicator  
305 VVSLOEKZ_PI VVSLOEKZ VVSLOEKZ NUMC 1   0   Deletion indicator  
306 SKWG14NEU_PI VVSKWG14 VVSKWG14 CHAR 2   0   Position grouping acc. Para 14 GBA (Sec. and loans)  
307 SMOVERW_PI TB_SVERWA SMOVERW CHAR 2   0   Custody type TW50
308 TBEAR_PI TBEAR TIMES TIMS 6   0   Last Edited at  
309 DERIV_CAT_PI TPM_DERIV_CAT TPM_DERIV_CAT NUMC 3   0   Position management procedure  
310 .INCLU-_AD       0   0   Sec. Acct Master Data + Address of Dep. Bank for Correspond.  
311 .INCLUDE       0   0   Treasury: Securities Account Master Data  
312 MANDT_AD MANDT MANDT CLNT 3   0   Client T000
313 BUKRS_AD BUKRS BUKRS CHAR 4   0   Company Code T001
314 RLDEPO_AD VRLDEPO RLDEPO CHAR 10   0   Securities Account *
315 VERKONTO_AD VERKONTO ABNKR CHAR 15   0   No. of bank giro acct, security acct no. in US secur.accts  
316 RDEPOTNR_AD ABNKR ABNKR CHAR 15   0   Securities account no.  
317 XLDEPO_AD XLDEPO XLDEPO CHAR 30   0   Securities account ID  
318 RERTRK_AD RERTRK SAKNR CHAR 10   0   Internal bank account SKB1
319 RDPBANK_AD RDEPOTBANK BU_PARTNER CHAR 10   0   Depository Bank *
320 RBGUE_AD RBGUENST BU_PARTNER CHAR 10   0   Beneficiary *
321 SSPERRV_AD     CHAR 2   0    
322 DSPERR_AD DSPERR DATUM DATS 8   0   Block flag until  
323 RGSBER_AD GSBER GSBER CHAR 4   0   Business Area TGSB
324 SSKZB_AD SSKZB SSKZB NUMC 1   0   BAV stock indicator TZ11
325 JVERMST_AD JVERMST JANEI CHAR 1   0   Net worth tax indicator  
326 SUDEC_AD SUDEC SUDEC NUMC 2   0   Insurance Line of Business Indicator TW05
327 DEDEC_AD DEDEC DATUM DATS 8   0   Date of entry in premium reserve fund  
328 RFGEB_AD RFGEB_NEW BU_PARTNER CHAR 10   0   Releaser of master record (person) *
329 DFREI_AD DFREI DATUM DATS 8   0   Date of release  
330 TFREI_AD TFREI TIMES TIMS 6   0   Time of release  
331 RERF_AD RERF SYCHAR12 CHAR 12   0   Entered by  
332 DERF_AD DERF DATUM DATS 8   0   First Entered on  
333 TERF_AD TERF TIMES TIMS 6   0   Time of Initial Entry  
334 REHER_AD REHER CHAR10 CHAR 10   0   Source of initial entry  
335 RBEAR_AD RBEAR SYCHAR12 CHAR 12   0   Employee ID  
336 DBEAR_AD DBEAR DATUM DATS 8   0   Last Edited on  
337 TBEAR_AD TBEAR TIMES TIMS 6   0   Last Edited at  
338 RBHER_AD RBHER CHAR10 CHAR 10   0   Editing Source  
339 RPORTB_AD RPORTB RPORTB CHAR 10   0   Portfolio TWPOB
340 SOBJEKT_AD VVKEYOBJ VVKEY CHAR 10   0   Internal key for object  
341 SROLEXTDEP_AD DUMMY_3 CHAR3 CHAR 3   0   Dummy function  
342 SROLEXTBEG_AD DUMMY_3 CHAR3 CHAR 3   0   Dummy function  
343 VVSLOEKZ_AD VVSLOEKZ VVSLOEKZ NUMC 1   0   Deletion indicator  
344 SSPERR_AD SSPERR SSPERR CHAR 3   0   Block type for restraint on disposal TW17
345 RAHABKI_AD TB_RHABKI HBKID CHAR 5   0   Short key for own house bank T012
346 RAHKTID_AD TB_RHKTID HKTID CHAR 5   0   Short key for house bank account T012K
347 SEC_ACC_GRP_AD TPM_SEC_ACCT_GRP TPM_SEC_ACCT_GRP CHAR 10   0   Securities Account Group TRGT_SECACCGRP
348 STATUS_AD TPM_SEC_ACC_STATUS TPM_SEC_ACC_STATUS NUMC 1   0   Status of a Security Account  
349 STATUS_RBEAR_AD RBEAR SYCHAR12 CHAR 12   0   Employee ID  
350 STATUS_DBEAR_AD DBEAR DATUM DATS 8   0   Last Edited on  
351 STATUS_TBEAR_AD TBEAR TIMES TIMS 6   0   Last Edited at  
352 SECACC_TYPE_AD TPM_SECACC_TYPE TPM_SECACC_TYPE CHAR 3   0   Securities Account Type TRSC_SECACC_TYPE
353 .INCLU--AP       0   0   ISSR: Erweiterung für Meldewesendaten bei Depotanlage  
354 .INCLUDE       0   0   ISSR: Append-Struktur für Meldewesendaten bei Depotanlage  
355 BUDAT_AD ISSR_BUDAT DATUM DATS 8   0   Gueltig Ab-Datum Meldewesen -Stamm  
356 COUNTRY_VAR_AD ISSR_REP_COUNTRY ISSR_REP_COUNTRY CHAR 4   0   TISSR_MARECO
357 SPARTE_AD ISSR_VERS_SPARTE ISSR_VERS_SPARTE CHAR 2   0   Insurance Line of Business Indicator TISSR_SPARTE
358 STOCKBAV_AD ISSR_STOCKBAV ISSR_STOCKBAV CHAR 1   0   BAV Stock Indicator TISSR_STOCKBAV
359 ADDRNUMBER_AD AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
360 ANRED_AD ANRED TEXT15 CHAR 15   0   Title  
361 NAME1_AD NAME1_ADRS TEXT40 CHAR 40   0   Name 1 of an address  
362 NAME2_AD NAME2_ADRS TEXT40 CHAR 40   0   Name 2 of an address  
363 NAME3_AD NAME3_ADRS TEXT40 CHAR 40   0   Name 3 of an address  
364 NAME4_AD NAME4_ADRS TEXT40 CHAR 40   0   Name 4 of an address  
365 STRAS_AD STRAS_GP TEXT35 CHAR 35   0   House number and street  
366 PFACH_AD PFACH_BAS PFACH CHAR 10   0   PO box  
367 PSTL2_AD PSTL2_BAS PSTLZ CHAR 10   0   PO Box postal code  
368 PFORT_AD PFORT_ADRS TEXT40 CHAR 40   0   PO Box city  
369 LAND1_AD LAND1 LAND1 CHAR 3   0   Country Key *
370 PSTLZ_AD PSTLZ_BAS PSTLZ CHAR 10   0   Postal code  
371 ORT01_AD ORT01_GP TEXT35 CHAR 35   0   City  
372 ORT02_AD ORT01_GP TEXT35 CHAR 35   0   City  
373 REGIO_AD REGIO REGIO CHAR 3   0   Region (State, Province, County) *
374 SPRAS_AD SPRAS SPRAS LANG 1   0   Language Key *
375 INLND_AD LAND1 LAND1 CHAR 3   0   Country Key *
376 ANZZL_AD ANZEI ANZEI DEC 2   0   Number of lines in address  
377 PRIOR_AD PRITY_ADRS CHAR9 CHAR 9   0   Address lines priority  
378 WAREN_AD WAREN WAREN CHAR 1   0   Delivery address ID  
379 RHANDPL VVRHANDPL VVRHANDPL CHAR 10   0   Exchange *
380 XREPKE TB_XISSUER TEXT80 CHAR 80   0   Name and address of issuer  
381 REPKE_ADDRNO AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
382 XRANLALT1_L XLANGBEZ XLBEZ CHAR 60   0   ATAB tables long name  
383 XRANLALT1_S XKURZBEZ XKBEZ CHAR 15   0   Short name for ATAB tables  
384 XRANLALT2_L XLANGBEZ XLBEZ CHAR 60   0   ATAB tables long name  
385 XRANLALT2_S XKURZBEZ XKBEZ CHAR 15   0   Short name for ATAB tables  
386 DORDER DORDER DATUM DATS 8   0   Order day  
387 DVALUT DVALUT DATUM DATS 8   0   Calculation Date  
388 DZTERM TB_DZTERM DATUM DATS 8   0   Payment or Delivery Date  
389 DBESTAND DBESTAND DATUM DATS 8   0   Position value date  
390 SFHAZBA TB_SFHAZBA SBEWART CHAR 4   0   Flow Type *
391 ASTUECK ASTUECK ASTUECK DEC 15   5   Number of units for unit-quoted securities  
392 BNWHR BNWHR WERTV7 CURR 13   2   Nominal amount  
393 WPRICE TB_WPRICE WAERS CUKY 5   0   Price currency *
394 BUPRC TB_BUPRC VVPKTKUR DEC 15   6   Security Price Without Currency Ref. with Unit Quotation  
395 BPPRC TB_BPPRC VVPKTKUR DEC 15   6   Security Price for Percentage Quotation  
396 SSIGN SSIGN PD_SIGN CHAR 1   0   Sign  
397 WZBETR TB_WZBETR WAERS CUKY 5   0   Payment Currency *
398 BZBETR TB_BZBETR WERTV7 CURR 13   2   Payment amount in payment currency  
399 BHWBETR TB_HWBETR WERTV7 CURR 13   2   Payment Amount in Local Currency  
400 WHWBETR TB_WHWBETR WAERS CUKY 5   0   Local currency *
401 KHWKURS TB_KHWKURS UKURS DEC 9   5   Local currency rate  
402 WBBETR TB_WBBETR WAERS CUKY 5   0   Currency of Position Amount *
403 BBBETR TB_BBBETR WERTV7 CURR 13   2   Amount that Changes the Position  
404 WEBETR TB_WEBETR WAERS CUKY 5   0   Price currency *
405 BEBETR TB_BEBETR WERTV7 CURR 13   2   Market Value in Quotation Currency  
406 BTOTAL TB_BTOTAL WERTV7 CURR 13   2   Net payment amount  
407 WTOTAL TB_WTOTAL WAERS CUKY 5   0   Currency of net payment amount *
408 SRUNIT TB_RUNIT VVSRUNIT CHAR 5   0   Currency unit of rate TZUNI
409 KZWKURS TB_KZWKURS UKURS DEC 9   5   Payment currency rate  
410 KBWKURS TB_KBWKURS UKURS DEC 9   5   Position currency rate  
411 LIMITART TB_LIMITAR T_LIMITAR CHAR 2   0   Limit type *
412 LIMITBEZ TB_LIMITBE T_XTEXT30 CHAR 30   0   Name of limit type  
413 LIMITDAT TB_LIMITDA DATUM DATS 8   0   Limit date  
414 BUPRCLIM TB_BUPRCLIM VVPKTKUR DEC 15   6   Limit Price for Unit Quotation  
415 BPPRCLIM TB_BPPRCLIM VVPKTKUR DEC 15   6   Limit Price for Percentage Quotation  
416 PEFFZCALL TB_PYIELDCALL DECV3_7 DEC 10   7   Effective interest rate - termination of issuer  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 TBCO_SE BUKRS_AD T001 BUKRS KEY 1 1
2 TBCO_SE BUKRS_HB T001 BUKRS KEY 1 1
3 TBCO_SE BUKRS_PI T001 BUKRS KEY 1 1
4 TBCO_SE COUNTRY_VAR_AD TISSR_MARECO COUNTRY_VAR KEY 1 CN
5 TBCO_SE GSART_CD TZPA GSART KEY 1 CN
6 TBCO_SE INSTITUTE_CD TP07 SOL_INS    
7 TBCO_SE MANDT_AD T000 MANDT KEY 1 1
8 TBCO_SE MANDT_CD T000 MANDT KEY 1 1
9 TBCO_SE MANDT_HB T000 MANDT KEY 1 1
10 TBCO_SE MANDT_HS T000 MANDT KEY 1 1
11 TBCO_SE MANDT_PI T000 MANDT KEY 1 1
12 TBCO_SE PRICE_INDEX_CD TIDX_PRICE_INDEX INDEX_NAME REF C CN
13 TBCO_SE RAHABKI_AD T012 HBKID REF C CN
14 TBCO_SE RAHKTID_AD T012K HKTID REF C CN
15 TBCO_SE RANL_PI VWPANLA RANL    
16 TBCO_SE RATING_CD TP06 RATING    
17 TBCO_SE RERTRK_AD SKB1 SAKNR KEY 1 1
18 TBCO_SE REWHR_CD TCURC WAERS KEY 1 1
19 TBCO_SE RGSBER_AD TGSB GSBER KEY 1 1
20 TBCO_SE RLDEPO_PI TWD01 RLDEPO KEY 1 CN
21 TBCO_SE RPORTB_AD TWPOB RPORTB    
22 TBCO_SE RREFKONT_PI T037S RREFKONT KEY 1 CN
23 TBCO_SE RWBZP_HS TCURC WAERS KEY 1 1
24 TBCO_SE SANGVOR_HB ATRESERVATION SANGVOR    
25 TBCO_SE SANLF_CD TZAF SANLF KEY 1 CN
26 TBCO_SE SANNAHME_HB TD13 SANNAHME KEY 1 CN
27 TBCO_SE SBESANT_PI TZBA SBESANT KEY 1 1
28 TBCO_SE SBILK_PI TW11 SBILK KEY 1 1
29 TBCO_SE SBRSCH_CD T016 BRSCH KEY 1 1
30 TBCO_SE SDEPOSTAT_CD TW51 SDEPOSTAT REF C CN
31 TBCO_SE SECACC_TYPE_AD TRSC_SECACC_TYPE SECACC_TYPE    
32 TBCO_SE SEC_ACC_GRP_AD TRGT_SECACCGRP SEC_ACCT_GRP KEY 1 CN
33 TBCO_SE SFIBG_PI TW08 SFIBG KEY 1 1
34 TBCO_SE SGLZB_PI TW07 SGLZB KEY 1 1
35 TBCO_SE SKUEART_HB TD27 SKUEART    
36 TBCO_SE SKUEDN_HB TD29 SKUEDN    
37 TBCO_SE SKUEGL_HB TD28 SKUEGL    
38 TBCO_SE SKUEND_HB TD04 SKUEND    
39 TBCO_SE SMOVERW_CD TW50 SMOVERW KEY 1 CN
40 TBCO_SE SMOVERW_PI TW50 SMOVERW KEY 1 CN
41 TBCO_SE SPARTE_AD TISSR_SPARTE SPARTE KEY 1 CN
42 TBCO_SE SROLEXT_CD TW22 ALWPKL REF C CN
43 TBCO_SE SRUNIT TZUNI SRUNIT    
44 TBCO_SE SSKZB_AD TZ11 SSKZB KEY 1 CN
45 TBCO_SE SSPERR_AD TW17 SSPERR KEY 1 CN
46 TBCO_SE STOCKBAV_AD TISSR_STOCKBAV STOCKBAV KEY 1 CN
47 TBCO_SE SUDEC_AD TW05 SUDEC KEY 1 1
48 TBCO_SE SWERTTYP_CD TW20 SWERTTYP    
49 TBCO_SE SWHRAUSG_HS TCURC WAERS KEY 1 1
50 TBCO_SE SWHRZHLG_HB TCURC WAERS REF 1 1
51 TBCO_SE SWHRZUSA_HB TCURC WAERS REF 1 1
52 TBCO_SE SZKZ_HB TDSOZ SZKZ KEY 1 CN
History
Last changed by/on SAP  20131127 
SAP Release Created in