SAP ABAP Table TBCO_FW (Output Structure for Forward Transaction 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_FW	Table Relationship Diagram
Short Description	Output Structure for Forward Transaction 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-_AD	☐				0	0	Sec. Acct Master Data + Address of Dep. Bank for Correspond.
162	.INCLUDE	☐				0	0	Treasury: Securities Account Master Data
163	MANDT_AD	☐	MANDT	MANDT	CLNT	3	0	Client	T000
164	BUKRS_AD	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
165	RLDEPO_AD	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
166	VERKONTO_AD	☐	VERKONTO	ABNKR	CHAR	15	0	No. of bank giro acct, security acct no. in US secur.accts
167	RDEPOTNR_AD	☐	ABNKR	ABNKR	CHAR	15	0	Securities account no.
168	XLDEPO_AD	☐	XLDEPO	XLDEPO	CHAR	30	0	Securities account ID
169	RERTRK_AD	☐	RERTRK	SAKNR	CHAR	10	0	Internal bank account	SKB1
170	RDPBANK_AD	☐	RDEPOTBANK	BU_PARTNER	CHAR	10	0	Depository Bank	*
171	RBGUE_AD	☐	RBGUENST	BU_PARTNER	CHAR	10	0	Beneficiary	*
172	SSPERRV_AD	☐			CHAR	2	0
173	DSPERR_AD	☐	DSPERR	DATUM	DATS	8	0	Block flag until
174	RGSBER_AD	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
175	SSKZB_AD	☐	SSKZB	SSKZB	NUMC	1	0	BAV stock indicator	TZ11
176	JVERMST_AD	☐	JVERMST	JANEI	CHAR	1	0	Net worth tax indicator
177	SUDEC_AD	☐	SUDEC	SUDEC	NUMC	2	0	Insurance Line of Business Indicator	TW05
178	DEDEC_AD	☐	DEDEC	DATUM	DATS	8	0	Date of entry in premium reserve fund
179	RFGEB_AD	☐	RFGEB_NEW	BU_PARTNER	CHAR	10	0	Releaser of master record (person)	*
180	DFREI_AD	☐	DFREI	DATUM	DATS	8	0	Date of release
181	TFREI_AD	☐	TFREI	TIMES	TIMS	6	0	Time of release
182	RERF_AD	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
183	DERF_AD	☐	DERF	DATUM	DATS	8	0	First Entered on
184	TERF_AD	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
185	REHER_AD	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
186	RBEAR_AD	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
187	DBEAR_AD	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
188	TBEAR_AD	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
189	RBHER_AD	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
190	RPORTB_AD	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
191	SOBJEKT_AD	☐	VVKEYOBJ	VVKEY	CHAR	10	0	Internal key for object
192	SROLEXTDEP_AD	☐	DUMMY_3	CHAR3	CHAR	3	0	Dummy function
193	SROLEXTBEG_AD	☐	DUMMY_3	CHAR3	CHAR	3	0	Dummy function
194	VVSLOEKZ_AD	☐	VVSLOEKZ	VVSLOEKZ	NUMC	1	0	Deletion indicator
195	SSPERR_AD	☐	SSPERR	SSPERR	CHAR	3	0	Block type for restraint on disposal	TW17
196	RAHABKI_AD	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	T012
197	RAHKTID_AD	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	T012K
198	SEC_ACC_GRP_AD	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	TRGT_SECACCGRP
199	STATUS_AD	☐	TPM_SEC_ACC_STATUS	TPM_SEC_ACC_STATUS	NUMC	1	0	Status of a Security Account
200	STATUS_RBEAR_AD	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
201	STATUS_DBEAR_AD	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
202	STATUS_TBEAR_AD	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
203	SECACC_TYPE_AD	☐	TPM_SECACC_TYPE	TPM_SECACC_TYPE	CHAR	3	0	Securities Account Type	TRSC_SECACC_TYPE
204	.INCLU--AP	☐				0	0	ISSR: Erweiterung für Meldewesendaten bei Depotanlage
205	.INCLUDE	☐				0	0	ISSR: Append-Struktur für Meldewesendaten bei Depotanlage
206	BUDAT_AD	☐	ISSR_BUDAT	DATUM	DATS	8	0	Gueltig Ab-Datum Meldewesen -Stamm
207	COUNTRY_VAR_AD	☐	ISSR_REP_COUNTRY	ISSR_REP_COUNTRY	CHAR	4	0		TISSR_MARECO
208	SPARTE_AD	☐	ISSR_VERS_SPARTE	ISSR_VERS_SPARTE	CHAR	2	0	Insurance Line of Business Indicator	TISSR_SPARTE
209	STOCKBAV_AD	☐	ISSR_STOCKBAV	ISSR_STOCKBAV	CHAR	1	0	BAV Stock Indicator	TISSR_STOCKBAV
210	ADDRNUMBER_AD	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
211	ANRED_AD	☐	ANRED	TEXT15	CHAR	15	0	Title
212	NAME1_AD	☐	NAME1_ADRS	TEXT40	CHAR	40	0	Name 1 of an address
213	NAME2_AD	☐	NAME2_ADRS	TEXT40	CHAR	40	0	Name 2 of an address
214	NAME3_AD	☐	NAME3_ADRS	TEXT40	CHAR	40	0	Name 3 of an address
215	NAME4_AD	☐	NAME4_ADRS	TEXT40	CHAR	40	0	Name 4 of an address
216	STRAS_AD	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
217	PFACH_AD	☐	PFACH_BAS	PFACH	CHAR	10	0	PO box
218	PSTL2_AD	☐	PSTL2_BAS	PSTLZ	CHAR	10	0	PO Box postal code
219	PFORT_AD	☐	PFORT_ADRS	TEXT40	CHAR	40	0	PO Box city
220	LAND1_AD	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
221	PSTLZ_AD	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
222	ORT01_AD	☐	ORT01_GP	TEXT35	CHAR	35	0	City
223	ORT02_AD	☐	ORT01_GP	TEXT35	CHAR	35	0	City
224	REGIO_AD	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
225	SPRAS_AD	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
226	INLND_AD	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
227	ANZZL_AD	☐	ANZEI	ANZEI	DEC	2	0	Number of lines in address
228	PRIOR_AD	☐	PRITY_ADRS	CHAR9	CHAR	9	0	Address lines priority
229	WAREN_AD	☐	WAREN	WAREN	CHAR	1	0	Delivery address ID
230	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
231	XREPKE	☐	TB_XISSUER	TEXT80	CHAR	80	0	Name and address of issuer
232	REPKE_ADDRNO	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
233	XRANLALT1_L	☐	XLANGBEZ	XLBEZ	CHAR	60	0	ATAB tables long name
234	XRANLALT1_S	☐	XKURZBEZ	XKBEZ	CHAR	15	0	Short name for ATAB tables
235	XRANLALT2_L	☐	XLANGBEZ	XLBEZ	CHAR	60	0	ATAB tables long name
236	XRANLALT2_S	☐	XKURZBEZ	XKBEZ	CHAR	15	0	Short name for ATAB tables
237	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
238	DZTERM	☐	TB_DZTERM	DATUM	DATS	8	0	Payment or Delivery Date
239	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date
240	SFHAZBA	☐	TB_SFHAZBA	SBEWART	CHAR	4	0	Flow Type	*
241	XBEWART	☐	XBEWART	TEXT30	CHAR	30	0	Name of flow type
242	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
243	BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
244	WPRICE	☐	TB_WPRICE	WAERS	CUKY	5	0	Price currency	*
245	BUPRC	☐	TB_BUPRC	VVPKTKUR	DEC	15	6	Security Price Without Currency Ref. with Unit Quotation
246	BPPRC	☐	TB_BPPRC	VVPKTKUR	DEC	15	6	Security Price for Percentage Quotation
247	SSIGN	☐	SSIGN	PD_SIGN	CHAR	1	0	Sign
248	WZBETR	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
249	BZBETR	☐	TB_BZBETR	WERTV7	CURR	13	2	Payment amount in payment currency
250	BHWBETR	☐	TB_HWBETR	WERTV7	CURR	13	2	Payment Amount in Local Currency
251	WHWBETR	☐	TB_WHWBETR	WAERS	CUKY	5	0	Local currency	*
252	KHWKURS	☐	TB_KHWKURS	UKURS	DEC	9	5	Local currency rate
253	WBBETR	☐	TB_WBBETR	WAERS	CUKY	5	0	Currency of Position Amount	*
254	BBBETR	☐	TB_BBBETR	WERTV7	CURR	13	2	Amount that Changes the Position
255	WEBETR	☐	TB_WEBETR	WAERS	CUKY	5	0	Price currency	*
256	BEBETR	☐	TB_BEBETR	WERTV7	CURR	13	2	Market Value in Quotation Currency
257	BTOTAL	☐	TB_BTOTAL	WERTV7	CURR	13	2	Net payment amount
258	WTOTAL	☐	TB_WTOTAL	WAERS	CUKY	5	0	Currency of net payment amount	*
259	SRUNIT	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
260	KZWKURS	☐	TB_KZWKURS	UKURS	DEC	9	5	Payment currency rate
261	KBWKURS	☐	TB_KBWKURS	UKURS	DEC	9	5	Position currency rate
262	BPPRC_SPOT2	☐	TB_BPPRC_SPOT_MAT	VVPKTKUR	DEC	15	6	Spot Rate at Maturity in Percentage
263	BPPRC_SPOT1	☐	TB_BPPRC_SPOT1	VVPKTKUR	DEC	15	6	Current Spot Rate in Percentage
264	BPPRC_MARG	☐	TB_BPPRC_MARG	DEC15_5DB4	DEC	15	5	Margin Rate in Percentage
265	BUPRC_MARG	☐	TB_BUPRC_MARG	VVPKTKUR	DEC	15	6	Margin Rate (Amount Without Currency Reference)
266	BUPRC_SPOT1	☐	TB_BUPRC_SPOT1	VVPKTKUR	DEC	15	6	Current Spot Rate Unit-Quoted Without Currency Reference
267	BUPRC_SPOT2	☐	TB_BUPRC_SPOT_MAT	VVPKTKUR	DEC	15	6	Spot Rate at Maturity Without Currency Reference
268	COC_RATE	☐	TB_BPPRC_COC	VVPKTKUR	DEC	15	6	Interest Rate for Cost of Carry Forward

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TBCO_FW	BUKRS_AD	T001	BUKRS	KEY	1	1
2	TBCO_FW	COUNTRY_VAR_AD	TISSR_MARECO	COUNTRY_VAR	KEY	1	CN
3	TBCO_FW	GSART_CD	TZPA	GSART	KEY	1	CN
4	TBCO_FW	INSTITUTE_CD	TP07	SOL_INS
5	TBCO_FW	MANDT_AD	T000	MANDT	KEY	1	1
6	TBCO_FW	MANDT_CD	T000	MANDT	KEY	1	1
7	TBCO_FW	PRICE_INDEX_CD	TIDX_PRICE_INDEX	INDEX_NAME	REF	C	CN
8	TBCO_FW	RAHABKI_AD	T012	HBKID	REF	C	CN
9	TBCO_FW	RAHKTID_AD	T012K	HKTID	REF	C	CN
10	TBCO_FW	RATING_CD	TP06	RATING
11	TBCO_FW	RERTRK_AD	SKB1	SAKNR	KEY	1	1
12	TBCO_FW	REWHR_CD	TCURC	WAERS	KEY	1	1
13	TBCO_FW	RGSBER_AD	TGSB	GSBER	KEY	1	1
14	TBCO_FW	RPORTB_AD	TWPOB	RPORTB
15	TBCO_FW	SANLF_CD	TZAF	SANLF	KEY	1	CN
16	TBCO_FW	SBRSCH_CD	T016	BRSCH	KEY	1	1
17	TBCO_FW	SDEPOSTAT_CD	TW51	SDEPOSTAT	REF	C	CN
18	TBCO_FW	SECACC_TYPE_AD	TRSC_SECACC_TYPE	SECACC_TYPE
19	TBCO_FW	SEC_ACC_GRP_AD	TRGT_SECACCGRP	SEC_ACCT_GRP	KEY	1	CN
20	TBCO_FW	SMOVERW_CD	TW50	SMOVERW	KEY	1	CN
21	TBCO_FW	SPARTE_AD	TISSR_SPARTE	SPARTE	KEY	1	CN
22	TBCO_FW	SROLEXT_CD	TW22	ALWPKL	REF	C	CN
23	TBCO_FW	SSKZB_AD	TZ11	SSKZB	KEY	1	CN
24	TBCO_FW	SSPERR_AD	TW17	SSPERR	KEY	1	CN
25	TBCO_FW	STOCKBAV_AD	TISSR_STOCKBAV	STOCKBAV	KEY	1	CN
26	TBCO_FW	SUDEC_AD	TW05	SUDEC	KEY	1	1
27	TBCO_FW	SWERTTYP_CD	TW20	SWERTTYP

History

Last changed by/on	SAP	20131127
SAP Release Created in	110