SAP ABAP Table TBCO_ALL (Output Structure for Correspondence: Overall Structure)

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	TBCO_ALL	Table Relationship Diagram
Short Description	Output Structure for Correspondence: Overall Structure

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	BUTXT	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
4	BU_SWIFT	TB_BUSWIFT	SWIFT	CHAR	11	0	SWIFT Code for Company Code (Sender of Message)
5	RANTYP	RANTYP	RANTYP	CHAR	1	0	Contract Type
6	SGSART	VVSART	VVSART	CHAR	3	0	Product Type	*
7	XSGSART	TB_XGSART	TEXT30	CHAR	30	0	Name of product type
8	XSGSART_K	TB_XGSART_K	TEXT10	CHAR	10	0	Short text for product type
9	XSGSART_E	TB_DONT_USE_TEXT30	TEXT30	CHAR	30	0	Do not use this field (see documention)
10	SFHAART	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
11	XSFHAART	TB_FATEXT	T_XTEXT30	CHAR	30	0	Name of Transaction Type
12	XSFHAART_E	TB_DONT_USE_TEXT30	TEXT30	CHAR	30	0	Do not use this field (see documention)
13	SFGZUSTT	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	*
14	XSFGZUSTT	TB_XTTEXT	TEXT30	CHAR	30	0	Name of activity category
15	XSFGZUSTTE	TB_DONT_USE_TEXT30	TEXT30	CHAR	30	0	Do not use this field (see documention)
16	SFUNKTV	TB_SFUNKTV	T_FUNKTION	CHAR	4	0	Transition Function from Directly Preceding Activity	*
17	XSFUNKTV	TB_XFUNKT	TEXT30	CHAR	30	0	Name of Treasury function
18	SFUNKTL	TB_SFUNKTL	T_FUNKTION	CHAR	4	0	Latest function used in editing activity	*
19	XSFUNKTL	TB_XFUNKT	TEXT30	CHAR	30	0	Name of Treasury function
20	XSFUNKTL_E	TB_DONT_USE_TEXT30	TEXT30	CHAR	30	0	Do not use this field (see documention)
21	LANGU_BEFORE	TB_LANGU_BEFORE	SPRAS	LANG	1	0	Language Key Before Cross-Language Search for SAPscript Form	*
22	LANGU_AFTER	TB_LANGU_AFTER	SPRAS	LANG	1	0	Language Key After Cross-Language Search for SAPscript Form	*
23	OBJNR	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
24	RFHA	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
25	RFHAZU	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
26	RFHAZUL	TB_RFHAZUL	T_RFHAZU	NUMC	5	0	Last Active Transaction Activity
27	SFIXRFHAZU	TB_SFIXRFHAZU	XFELD	CHAR	1	0	Fixing activity (Indicator)
28	SFIRST	TB_SFIRST	XFELD	CHAR	1	0	Indicator: 1st correspond. for activity, corr.type + medium?
29	RLFDNR	TB_RLFDNR	T_LFDNR2	NUMC	2	0	Sequential No. VRBKORES Data Record per Activity (Key Field)
30	SREPEAT	TB_REPEAT	XFELD	CHAR	1	0	Repeat correspondence?
31	DATUM	TB_DCRDAT	DATUM	DATS	8	0	Entered On
32	CRUSER	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
33	DCRDAT	TB_DCRDAT	DATUM	DATS	8	0	Entered On
34	TCRTIM	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
35	UPUSER	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
36	DUPDAT	TB_DUPDAT	DATUM	DATS	8	0	Changed on
37	TUPTIM	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
38	DVTRAB	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
39	RMAID	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	*
40	GSPPART	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
41	DBLFZ	TB_DBLFZ	DATUM	DATS	8	0	Term Start
42	DELFZ	TB_DELFZ	DATUM	DATS	8	0	Term End
43	KONTRH	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
44	XKONTRH	TB_XKONTRH	TEXT80	CHAR	80	0	Name and address of business partner
45	ADDRNUMBER	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
46	ADDR_TYPE	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
47	PERSNUMBER	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
48	FROMCOUNTRY	LAND1	LAND1	CHAR	3	0	Country Key	*
49	ROLETYP	BU_PARTNERROLECAT	BU_ROLECAT	CHAR	6	0	BP Role Category	*
50	XROLETYP	BU_BEZ50	TEXT50	CHAR	50	0	Description
51	RGARANT	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	*
52	XRGARANT	TB_XGARANT	TEXT80	CHAR	80	0	Name and address of guarantor
53	KO_FAX	TB_KOTELFX	TEXT31	CHAR	31	0	Business partner fax number
54	KO_ADR_COUNTRY	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
55	KO_SWIFT	TB_KOSWIFT	SWIFT	CHAR	11	0	SWIFT Code of Counterparty (Receiver of Message)
56	KO_ADSMTP	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
57	RPZAHL	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	*
58	ZR_SWIFT	TB_ZRSWIFT	SWIFT	CHAR	11	0	SWIFT code of payer/payee
59	RPBANK	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
60	PB_SWIFT	TB_PBSWIFT	SWIFT	CHAR	11	0	SWIFT code of partner bank
61	PB_IBAN	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
62	RAHABKI	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	*
63	HB_SWIFT	TB_HBSWIFT	SWIFT	CHAR	11	0	House bank SWIFT code
64	HB_IBAN	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
65	RAHKTID	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	*
66	RAHK_NO	TB_RAHK_NO	BANKN	CHAR	18	0	Do Not Use
67	RPCODE	RPCODE	RPCODE	CHAR	20	0	Repetitive Code	*
68	SZART	TB_SZART	XFELD	CHAR	1	0	Payment transaction
69	UZAWE	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
70	NORDEXT	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
71	RDEALER	RDEALER	RDEALER	CHAR	12	0	Trader	*
72	SSTOGRD	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	*
73	XSSTOGRD	TB_XSTOGRD	XKBEZ	CHAR	15	0	Short description for reversal reason
74	SRNDNG	TB_SRNDNG	TFM_SROUND	CHAR	1	0	Rounding of Amount from Generated Flows
75	CORTYP	TB_CORTYP	T_CORTYP	CHAR	3	0	Correspondence type	*
76	FORMULAR	TDFORM	TDFORM	CHAR	16	0	Form name
77	SWIFT_DAT	TB_SWI_DAT	TB_SWI_DAT	CHAR	8	0	Format for SWIFT files
78	SANLF	SANLF	VVSANLF	NUMC	3	0	Product Category	*
79	SFGTYP	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	*
80	SAKTIV	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
81	RPORTB	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
82	ZUONR	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
83	RANL	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
84	RLDEPO	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
85	PEFFZINS	TB_PYIELD	DECV3_7	DEC	10	7	Effective Interest Rate
86	SEFFMETH	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
87	XEFFMETH	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
88	ZUOND	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
89	REFER	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
90	MERKM	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
91	RCOMVALCL	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	*
92	XRCOMVALCL	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
93	FACILITYNR	TB_FACILITYNR	T_RFHA	CHAR	13	0	Transaction Number of Facility	*
94	FACILITYBUKRS	TB_FACILITYBUKRS	BUKRS	CHAR	4	0	Company Code of Facility	*
95	VRFHA	TB_VORFHA	T_RFHA	CHAR	13	0	Reference transaction (Rollover/premature settlement)	*
96	RRFHA	TB_RRFHA	T_RFHA	CHAR	13	0	Reference transaction (general)	*
97	RBUKRS	TB_RBUKRS	BUKRS	CHAR	4	0	Company code of reference transaction	*
98	.INCLUDE				0	0	Ouptut structure: Authorized bank
99	BANKA_SB	BANKA	TEXT60	CHAR	60	0	Name of bank
100	BRNCH_SB	BRNCH	TEXT40	CHAR	40	0	Bank Branch
101	STRAS_SB	STRAS_GP	TEXT35	CHAR	35	0	House number and street
102	ORT01_SB	ORT01_GP	TEXT35	CHAR	35	0	City
103	SWIFT_SB	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
104	BNKLZ_SB	BANKL	BANKL	CHAR	15	0	Bank number
105	BANKN_SK	BANKN	BANKN	CHAR	18	0	Bank account number
106	BNKN2_SK	BNKN2	BNKN2	CHAR	24	0	Alternative Bank Acct Number (for Ambiguous Acct Number)
107	IBAN_SK	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)