SAP ABAP Table TBCO_SEC (Security order confirmation display structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVW (Package) Treasury Management: Securities

Basic Data

Table Category	INTTAB	Structure
Structure	TBCO_SEC	Table Relationship Diagram
Short Description	Security order confirmation display structure

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	LTX	☐	LTX	TEXT30	CHAR	30	0	Status name
110	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
111	XLDEPO	☐	XLDEPO	XLDEPO	CHAR	30	0	Securities account ID
112	NORDER	☐	NORDER	NUM8	NUMC	8	0	Order Number
113	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	TZC37
114	DORDER	☐	DORDER	DATUM	DATS	8	0	Order day
115	DVALUT	☐	VVDZINVAL	DATUM	DATS	8	0	Interest Value Date/Calculation Date
116	DDISPO	☐	VVDWERTST	DATUM	DATS	8	0	Value date / planning day
117	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date
118	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
119	BWKURS	☐	BWKURS	BWKURS	CURR	13	2	Security price for unit quotation
120	SNWHR	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	TCURC
121	BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
122	PWKURS	☐	PWKURS	PWKURS	DEC	10	7	Security price for percentage quotation
123	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
124	BBWHR	☐	BBWHR	WERTV7	CURR	13	2	Amount in position currency
125	SCWHR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency	TCURC
126	BCWHR	☐	BCWHR	WERTV7	CURR	13	2	Settlement Amount
127	SHWHR	☐	VVSHWHR	WAERS	CUKY	5	0	Local currency	TCURC
128	BHWHR	☐	BHWHR	WERTV7	CURR	13	2	Amount in local currency
129	KURS1	☐	VVKURS1	KURSF	DEC	9	5	Exchange rate into settlement currency
130	KURS2	☐	VVKURS2	KURSF	DEC	9	5	Exchange rate from settlement currency into local currency
131	KCROSS	☐	KURSF	KURSF	DEC	9	5	Exchange rate
132	SSWHR	☐	VVSSWHR	WAERS	CUKY	5	0	Stock price currency	TCURC
133	BSWHR	☐	VVBSWHR	WERTV7	CURR	13	2	Market value
134	SLIMIT	☐	SLIMIT	SLIMIT	CHAR	1	0	Order notation
135	BLIMIT	☐	BLIMIT	BWKURS	CURR	13	2	Limit price for unit quotation
136	PLIMIT	☐	PLIMIT	PWKURS	DEC	10	7	Limit price for percentage quotation
137	XORDZU	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
138	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
139	XBEWART	☐	XBEWART	TEXT30	CHAR	30	0	Name of flow type
140	JVERK6B	☐	VVJVERK6B	CHAR1	CHAR	1	0	Sale in acc. with tax credit method
141	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	TZB03
142	SRUNIT	☐	VVSRUNIT	VVSRUNIT	CHAR	5	0	Currency unit	TZUNI
143	KWKURS	☐	VVKWKURS	VVKWKURS	DEC	15	6	Security price
144	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
145	RBANKK	☐	RBANKK	SAKNR	CHAR	10	0	Bank account	*
146	RZBANK	☐	VVRZBANK_NEW	BU_PARTNER	CHAR	10	0	Paying Bank	*
147	XZUSATZ	☐	XZUSATZ	CHAR18	CHAR	18	0	Assignment
148	DSCHLUSS	☐	VVDSCHLUSS	DATUM	DATS	8	0	Date of business closing
149	XRKONTRAH	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
150	REPKE	☐	REPKE_NEW	BU_PARTNER	CHAR	10	0	Issuer Identity Key	*
151	XREPKE	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TBCO_SEC	SBEWZITI	TZB03	SBEWZITI
2	TBCO_SEC	SBWHR	TCURC	WAERS
3	TBCO_SEC	SCWHR	TCURC	WAERS
4	TBCO_SEC	SHWHR	TCURC	WAERS
5	TBCO_SEC	SNWHR	TCURC	WAERS
6	TBCO_SEC	SRUNIT	TZUNI	SRUNIT
7	TBCO_SEC	SSTATI	TZC37	STATU
8	TBCO_SEC	SSWHR	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in