SAP ABAP Table TBCO_RP (Output Structure for Repo 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_RP	Table Relationship Diagram
Short Description	Output Structure for Repo 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-_PI	☐				0	0	Securities Account Position
162	MANDT_PI	☐	MANDT	MANDT	CLNT	3	0	Client	T000
163	BUKRS_PI	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
164	RANL_PI	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
165	RLDEPO_PI	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
166	SSTATI_PI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
167	XDKBZ_PI	☐	XDKBZ	XKBEZ	CHAR	15	0	Sec.acct position short description
168	RREFKONT_PI	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	T037S
169	SVERWA_PI	☐	SVERWA	SVERWA	CHAR	1	0	Custody type	*
170	DANDPFL_PI	☐	DANDPFL	DATUM	DATS	8	0	Obligation to offer for sale until
171	DANDRE_PI	☐	DANDRE	DATUM	DATS	8	0	Right to offer until
172	SFIBG_PI	☐	SFIBG	SFIBG	NUMC	4	0	Asset Grouping Indicator	TW08
173	SGLZB_PI	☐	SGLZB	SGLZB	CHAR	4	0	SCB asset group indicator	TW07
174	SBILK_PI	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
175	JSPRI_PI	☐	JSPRI	JANEI	CHAR	1	0	Intercorporate privilege indicator
176	JBTEI_PI	☐	JBTEI	JANEI	CHAR	1	0	Shareholding indicator
177	RFGEB_PI	☐	RFGEB_NEW	BU_PARTNER	CHAR	10	0	Releaser of master record (person)	*
178	DFREI_PI	☐	DFREI	DATUM	DATS	8	0	Date of release
179	TFREI_PI	☐	TFREI	TIMES	TIMS	6	0	Time of release
180	RERF_PI	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
181	DERF_PI	☐	DERF	DATUM	DATS	8	0	First Entered on
182	TERF_PI	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
183	REHER_PI	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
184	RBEAR_PI	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
185	DBEAR_PI	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
186	TBHER_PI	☐	TBHER	TBHER	CHAR	1	0	Origin indicator for table
187	RBHER_PI	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
188	SBESANT_PI	☐	SBESANT	SBESANT	CHAR	2	0	Holding	TZBA
189	JBETEIL_PI	☐	JBETEIL	JANEI	CHAR	1	0	Shareholding indicator
190	VVSLOEKZ_PI	☐	VVSLOEKZ	VVSLOEKZ	NUMC	1	0	Deletion indicator
191	SKWG14NEU_PI	☐	VVSKWG14	VVSKWG14	CHAR	2	0	Position grouping acc. Para 14 GBA (Sec. and loans)
192	SMOVERW_PI	☐	TB_SVERWA	SMOVERW	CHAR	2	0	Custody type	TW50
193	TBEAR_PI	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
194	DERIV_CAT_PI	☐	TPM_DERIV_CAT	TPM_DERIV_CAT	NUMC	3	0	Position management procedure
195	.INCLU-_AD	☐				0	0	Sec. Acct Master Data + Address of Dep. Bank for Correspond.
196	.INCLUDE	☐				0	0	Treasury: Securities Account Master Data
197	MANDT_AD	☐	MANDT	MANDT	CLNT	3	0	Client	T000
198	BUKRS_AD	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
199	RLDEPO_AD	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
200	VERKONTO_AD	☐	VERKONTO	ABNKR	CHAR	15	0	No. of bank giro acct, security acct no. in US secur.accts
201	RDEPOTNR_AD	☐	ABNKR	ABNKR	CHAR	15	0	Securities account no.
202	XLDEPO_AD	☐	XLDEPO	XLDEPO	CHAR	30	0	Securities account ID
203	RERTRK_AD	☐	RERTRK	SAKNR	CHAR	10	0	Internal bank account	SKB1
204	RDPBANK_AD	☐	RDEPOTBANK	BU_PARTNER	CHAR	10	0	Depository Bank	*
205	RBGUE_AD	☐	RBGUENST	BU_PARTNER	CHAR	10	0	Beneficiary	*
206	SSPERRV_AD	☐			CHAR	2	0
207	DSPERR_AD	☐	DSPERR	DATUM	DATS	8	0	Block flag until
208	RGSBER_AD	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
209	SSKZB_AD	☐	SSKZB	SSKZB	NUMC	1	0	BAV stock indicator	TZ11
210	JVERMST_AD	☐	JVERMST	JANEI	CHAR	1	0	Net worth tax indicator
211	SUDEC_AD	☐	SUDEC	SUDEC	NUMC	2	0	Insurance Line of Business Indicator	TW05
212	DEDEC_AD	☐	DEDEC	DATUM	DATS	8	0	Date of entry in premium reserve fund
213	RFGEB_AD	☐	RFGEB_NEW	BU_PARTNER	CHAR	10	0	Releaser of master record (person)	*
214	DFREI_AD	☐	DFREI	DATUM	DATS	8	0	Date of release
215	TFREI_AD	☐	TFREI	TIMES	TIMS	6	0	Time of release
216	RERF_AD	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
217	DERF_AD	☐	DERF	DATUM	DATS	8	0	First Entered on
218	TERF_AD	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
219	REHER_AD	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
220	RBEAR_AD	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
221	DBEAR_AD	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
222	TBEAR_AD	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
223	RBHER_AD	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
224	RPORTB_AD	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
225	SOBJEKT_AD	☐	VVKEYOBJ	VVKEY	CHAR	10	0	Internal key for object
226	SROLEXTDEP_AD	☐	DUMMY_3	CHAR3	CHAR	3	0	Dummy function
227	SROLEXTBEG_AD	☐	DUMMY_3	CHAR3	CHAR	3	0	Dummy function
228	VVSLOEKZ_AD	☐	VVSLOEKZ	VVSLOEKZ	NUMC	1	0	Deletion indicator
229	SSPERR_AD	☐	SSPERR	SSPERR	CHAR	3	0	Block type for restraint on disposal	TW17
230	RAHABKI_AD	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	T012
231	RAHKTID_AD	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	T012K
232	SEC_ACC_GRP_AD	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	TRGT_SECACCGRP
233	STATUS_AD	☐	TPM_SEC_ACC_STATUS	TPM_SEC_ACC_STATUS	NUMC	1	0	Status of a Security Account
234	STATUS_RBEAR_AD	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
235	STATUS_DBEAR_AD	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
236	STATUS_TBEAR_AD	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
237	SECACC_TYPE_AD	☐	TPM_SECACC_TYPE	TPM_SECACC_TYPE	CHAR	3	0	Securities Account Type	TRSC_SECACC_TYPE
238	.INCLU--AP	☐				0	0	ISSR: Erweiterung für Meldewesendaten bei Depotanlage
239	.INCLUDE	☐				0	0	ISSR: Append-Struktur für Meldewesendaten bei Depotanlage
240	BUDAT_AD	☐	ISSR_BUDAT	DATUM	DATS	8	0	Gueltig Ab-Datum Meldewesen -Stamm
241	COUNTRY_VAR_AD	☐	ISSR_REP_COUNTRY	ISSR_REP_COUNTRY	CHAR	4	0		TISSR_MARECO
242	SPARTE_AD	☐	ISSR_VERS_SPARTE	ISSR_VERS_SPARTE	CHAR	2	0	Insurance Line of Business Indicator	TISSR_SPARTE
243	STOCKBAV_AD	☐	ISSR_STOCKBAV	ISSR_STOCKBAV	CHAR	1	0	BAV Stock Indicator	TISSR_STOCKBAV
244	ADDRNUMBER_AD	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
245	ANRED_AD	☐	ANRED	TEXT15	CHAR	15	0	Title
246	NAME1_AD	☐	NAME1_ADRS	TEXT40	CHAR	40	0	Name 1 of an address
247	NAME2_AD	☐	NAME2_ADRS	TEXT40	CHAR	40	0	Name 2 of an address
248	NAME3_AD	☐	NAME3_ADRS	TEXT40	CHAR	40	0	Name 3 of an address
249	NAME4_AD	☐	NAME4_ADRS	TEXT40	CHAR	40	0	Name 4 of an address
250	STRAS_AD	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
251	PFACH_AD	☐	PFACH_BAS	PFACH	CHAR	10	0	PO box
252	PSTL2_AD	☐	PSTL2_BAS	PSTLZ	CHAR	10	0	PO Box postal code
253	PFORT_AD	☐	PFORT_ADRS	TEXT40	CHAR	40	0	PO Box city
254	LAND1_AD	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
255	PSTLZ_AD	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
256	ORT01_AD	☐	ORT01_GP	TEXT35	CHAR	35	0	City
257	ORT02_AD	☐	ORT01_GP	TEXT35	CHAR	35	0	City
258	REGIO_AD	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
259	SPRAS_AD	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
260	INLND_AD	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
261	ANZZL_AD	☐	ANZEI	ANZEI	DEC	2	0	Number of lines in address
262	PRIOR_AD	☐	PRITY_ADRS	CHAR9	CHAR	9	0	Address lines priority
263	WAREN_AD	☐	WAREN	WAREN	CHAR	1	0	Delivery address ID
264	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
265	XREPKE	☐	TB_XISSUER	TEXT80	CHAR	80	0	Name and address of issuer
266	REPKE_ADDRNO	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
267	XRANLALT1_L	☐	XLANGBEZ	XLBEZ	CHAR	60	0	ATAB tables long name
268	XRANLALT1_S	☐	XKURZBEZ	XKBEZ	CHAR	15	0	Short name for ATAB tables
269	XRANLALT2_L	☐	XLANGBEZ	XLBEZ	CHAR	60	0	ATAB tables long name
270	XRANLALT2_S	☐	XKURZBEZ	XKBEZ	CHAR	15	0	Short name for ATAB tables
271	.INCLU-_SP	☐				0	0	"Page" of a Repo Transaction (Internal for Correspondence)
272	SFHAZBA_SP	☐	TB_SFHAZBA	SBEWART	CHAR	4	0	Flow Type	*
273	XBEWART_SP	☐	XBEWART	TEXT30	CHAR	30	0	Name of flow type
274	DBESTAND_SP	☐	DBESTAND	DATUM	DATS	8	0	Position value date
275	DVALUT_SP	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
276	DZTERM_SP	☐	TB_DZTERM	DATUM	DATS	8	0	Payment or Delivery Date
277	WPRICE_SP	☐	TB_WPRICE	WAERS	CUKY	5	0	Price currency	*
278	BUPRC_SP	☐	TB_BUPRC	VVPKTKUR	DEC	15	6	Security Price Without Currency Ref. with Unit Quotation
279	BPPRC_SP	☐	TB_BPPRC	VVPKTKUR	DEC	15	6	Security Price for Percentage Quotation
280	SSIGN_SP	☐	SSIGN	PD_SIGN	CHAR	1	0	Sign
281	WZBETR_SP	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
282	BZBETR_SP	☐	TB_BZBETR	WERTV7	CURR	13	2	Payment amount in payment currency
283	BHWBETR_SP	☐	TB_HWBETR	WERTV7	CURR	13	2	Payment Amount in Local Currency
284	WHWBETR_SP	☐	TB_WHWBETR	WAERS	CUKY	5	0	Local currency	*
285	KHWKURS_SP	☐	TB_KHWKURS	UKURS	DEC	9	5	Local currency rate
286	WBBETR_SP	☐	TB_WBBETR	WAERS	CUKY	5	0	Currency of Position Amount	*
287	BBBETR_SP	☐	TB_BBBETR	WERTV7	CURR	13	2	Amount that Changes the Position
288	WEBETR_SP	☐	TB_WEBETR	WAERS	CUKY	5	0	Price currency	*
289	BEBETR_SP	☐	TB_BEBETR	WERTV7	CURR	13	2	Market Value in Quotation Currency
290	BTOTAL_SP	☐	TB_BTOTAL	WERTV7	CURR	13	2	Net payment amount
291	WTOTAL_SP	☐	TB_WTOTAL	WAERS	CUKY	5	0	Currency of net payment amount	*
292	SRUNIT_SP	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
293	KZWKURS_SP	☐	TB_KZWKURS	UKURS	DEC	9	5	Payment currency rate
294	KBWKURS_SP	☐	TB_KBWKURS	UKURS	DEC	9	5	Position currency rate
295	.INCLU-_RP	☐				0	0	"Page" of a Repo Transaction (Internal for Correspondence)
296	SFHAZBA_RP	☐	TB_SFHAZBA	SBEWART	CHAR	4	0	Flow Type	*
297	XBEWART_RP	☐	XBEWART	TEXT30	CHAR	30	0	Name of flow type
298	DBESTAND_RP	☐	DBESTAND	DATUM	DATS	8	0	Position value date
299	DVALUT_RP	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
300	DZTERM_RP	☐	TB_DZTERM	DATUM	DATS	8	0	Payment or Delivery Date
301	WPRICE_RP	☐	TB_WPRICE	WAERS	CUKY	5	0	Price currency	*
302	BUPRC_RP	☐	TB_BUPRC	VVPKTKUR	DEC	15	6	Security Price Without Currency Ref. with Unit Quotation
303	BPPRC_RP	☐	TB_BPPRC	VVPKTKUR	DEC	15	6	Security Price for Percentage Quotation
304	SSIGN_RP	☐	SSIGN	PD_SIGN	CHAR	1	0	Sign
305	WZBETR_RP	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
306	BZBETR_RP	☐	TB_BZBETR	WERTV7	CURR	13	2	Payment amount in payment currency
307	BHWBETR_RP	☐	TB_HWBETR	WERTV7	CURR	13	2	Payment Amount in Local Currency
308	WHWBETR_RP	☐	TB_WHWBETR	WAERS	CUKY	5	0	Local currency	*
309	KHWKURS_RP	☐	TB_KHWKURS	UKURS	DEC	9	5	Local currency rate
310	WBBETR_RP	☐	TB_WBBETR	WAERS	CUKY	5	0	Currency of Position Amount	*
311	BBBETR_RP	☐	TB_BBBETR	WERTV7	CURR	13	2	Amount that Changes the Position
312	WEBETR_RP	☐	TB_WEBETR	WAERS	CUKY	5	0	Price currency	*
313	BEBETR_RP	☐	TB_BEBETR	WERTV7	CURR	13	2	Market Value in Quotation Currency
314	BTOTAL_RP	☐	TB_BTOTAL	WERTV7	CURR	13	2	Net payment amount
315	WTOTAL_RP	☐	TB_WTOTAL	WAERS	CUKY	5	0	Currency of net payment amount	*
316	SRUNIT_RP	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
317	KZWKURS_RP	☐	TB_KZWKURS	UKURS	DEC	9	5	Payment currency rate
318	KBWKURS_RP	☐	TB_KBWKURS	UKURS	DEC	9	5	Position currency rate
319	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
320	BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
321	WPRICE	☐	TB_WPRICE	WAERS	CUKY	5	0	Price currency	*
322	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_RP	BUKRS_AD	T001	BUKRS	KEY	1	1
2	TBCO_RP	BUKRS_PI	T001	BUKRS	KEY	1	1
3	TBCO_RP	COUNTRY_VAR_AD	TISSR_MARECO	COUNTRY_VAR	KEY	1	CN
4	TBCO_RP	GSART_CD	TZPA	GSART	KEY	1	CN
5	TBCO_RP	INSTITUTE_CD	TP07	SOL_INS
6	TBCO_RP	MANDT_AD	T000	MANDT	KEY	1	1
7	TBCO_RP	MANDT_CD	T000	MANDT	KEY	1	1
8	TBCO_RP	MANDT_PI	T000	MANDT	KEY	1	1
9	TBCO_RP	PRICE_INDEX_CD	TIDX_PRICE_INDEX	INDEX_NAME	REF	C	CN
10	TBCO_RP	RAHABKI_AD	T012	HBKID	REF	C	CN
11	TBCO_RP	RAHKTID_AD	T012K	HKTID	REF	C	CN
12	TBCO_RP	RANL_PI	VWPANLA	RANL
13	TBCO_RP	RATING_CD	TP06	RATING
14	TBCO_RP	RERTRK_AD	SKB1	SAKNR	KEY	1	1
15	TBCO_RP	REWHR_CD	TCURC	WAERS	KEY	1	1
16	TBCO_RP	RGSBER_AD	TGSB	GSBER	KEY	1	1
17	TBCO_RP	RLDEPO_PI	TWD01	RLDEPO	KEY	1	CN
18	TBCO_RP	RPORTB_AD	TWPOB	RPORTB
19	TBCO_RP	RREFKONT_PI	T037S	RREFKONT	KEY	1	CN
20	TBCO_RP	SANLF_CD	TZAF	SANLF	KEY	1	CN
21	TBCO_RP	SBESANT_PI	TZBA	SBESANT	KEY	1	1
22	TBCO_RP	SBILK_PI	TW11	SBILK	KEY	1	1
23	TBCO_RP	SBRSCH_CD	T016	BRSCH	KEY	1	1
24	TBCO_RP	SDEPOSTAT_CD	TW51	SDEPOSTAT	REF	C	CN
25	TBCO_RP	SECACC_TYPE_AD	TRSC_SECACC_TYPE	SECACC_TYPE
26	TBCO_RP	SEC_ACC_GRP_AD	TRGT_SECACCGRP	SEC_ACCT_GRP	KEY	1	CN
27	TBCO_RP	SFIBG_PI	TW08	SFIBG	KEY	1	1
28	TBCO_RP	SGLZB_PI	TW07	SGLZB	KEY	1	1
29	TBCO_RP	SMOVERW_CD	TW50	SMOVERW	KEY	1	CN
30	TBCO_RP	SMOVERW_PI	TW50	SMOVERW	KEY	1	CN
31	TBCO_RP	SPARTE_AD	TISSR_SPARTE	SPARTE	KEY	1	CN
32	TBCO_RP	SROLEXT_CD	TW22	ALWPKL	REF	C	CN
33	TBCO_RP	SSKZB_AD	TZ11	SSKZB	KEY	1	CN
34	TBCO_RP	SSPERR_AD	TW17	SSPERR	KEY	1	CN
35	TBCO_RP	STOCKBAV_AD	TISSR_STOCKBAV	STOCKBAV	KEY	1	CN
36	TBCO_RP	SUDEC_AD	TW05	SUDEC	KEY	1	1
37	TBCO_RP	SWERTTYP_CD	TW20	SWERTTYP

History

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