SAP ABAP Table TBCO_COND_SE (Output Structure (Correspondence): Securities Conditions)

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_COND_SE	Table Relationship Diagram
Short Description	Output Structure (Correspondence): Securities Conditions

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	View of VZZKOPO with additional info. from VKOPOSTEU
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
5	RKEY1	☐	RKEY1	RKEY1	CHAR	13	0	Key part 1
6	RKEY2	☐	RKEY2	RKEY2	CHAR	8	0	Key part 2
7	RKEY3	☐	RKEY3	RKEY3	CHAR	8	0	Key part 3
8	DGUEL_KK	☐	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
9	NLFD_ANG	☐	NLFD_ANG	LFNR3	NUMC	3	0	Offer consecutive number
10	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
11	DGUEL_KP	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
12	NSTUFE	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
13	XKOARTM	☐	XKOARTM	XBEZ20	CHAR	20	0	Condition type text
14	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	TZC37
15	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
16	BKOND	☐	BKOND	WERTV7	CURR	13	2	Condition item currency amount
17	SWHRKOND	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	TCURC
18	SBASIS	☐	VVSBASIS	VVSBASIS	CHAR	4	0	Calculation base reference	TZFB
19	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
20	SZSREFVZ	☐	SZSREFVZ	SZSREFVZ	CHAR	1	0	+/- sign / reference interest rate operator
21	PFLUCT	☐	TFM_PFLUCT	DECV3_7	DEC	10	7	Fluctuation margin
22	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
23	ATTRHY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
24	SZAWS	☐	SZAWS	SZAHLDIV	NUMC	1	0	Payment form (at start of period, mid-period, at period end)
25	RDIVNR	☐	RDIVNR	NUM03	NUMC	3	0	Dividend coupon number
26	JNULLKON	☐	JNULLKON	SKONDF	CHAR	1	0	Condition Form
27	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
28	JBMONAT	☐	JBMONAT	JANEI	CHAR	1	0	Indicator for calculating amount per month
29	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
30	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
31	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
32	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
33	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
34	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
35	SPARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
36	RKONT	☐	RKONT	RKONT	NUMC	6	0	Quota number
37	SVULT	☐	VVSBULT	JFLAGG	CHAR	1	0	Month-end indicator for calculation date
38	SFULT	☐	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
39	SVKALRI	☐	VVSNVER1	CHAR1	CHAR	1	0	Field is no longer used
40	SFKALRI	☐	VVSNVER1	CHAR1	CHAR	1	0	Field is no longer used
41	AVGSTAGE	☐	AVGSTAGE	NUMC2	NUMC	2	0	Number of working days for value date
42	AFGSTAGE	☐	AFGSTAGE	NUMC2	NUMC	2	0	Number of working days to due date
43	SVKALZUS	☐	VVSNVER1	CHAR1	CHAR	1	0	Field is no longer used
44	SFKALZUS	☐	VVSNVER1	CHAR1	CHAR	1	0	Field is no longer used
45	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
46	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
47	JSOFVERR	☐	JSOFVERR	TFMSOFVERR	CHAR	1	0	Immediate settlement
48	DALLGEM	☐	DALLGEM	DATUM	DATS	8	0	General date
49	SZEGEN	☐	SZEGEN	SZEGEN	NUMC	2	0	Generate incoming payment immediately	TD21
50	SBUST	☐	VVSBUST	VVSBUST	NUMC	2	0	Posting control key	TZB09
51	SKOPO	☐	VVSKOPO	VVSKOPO	NUMC	2	0	Detailed identification for condition items	TZK07
52	SALTKOND	☐	VVSALTKOND	SKONDGRP	NUMC	4	0	Bracket condition for alternative conditions
53	SZINSANP	☐	VVSZINSANP	SKONDGRP	NUMC	4	0	Cross-referenced condition grp for interest rate adjustment
54	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
55	SFORMREF	☐	VVSFORMREF	T_FORMBE	CHAR	4	0	Formula reference for the cash flow calculator	AT30
56	SVARNAME	☐	VVSVARNAME	T_XFELD04	CHAR	4	0	Description of variables in cash flow calculator
57	SVWERK	☐	VVSVWERK	T_SWERK	NUMC	1	0	Shift calculation date to working day
58	SVMETH	☐	VVSVMETH	T_SVMETH	NUMC	1	0	Method for determining the next value date
59	SFWERK	☐	VVSFWERK	T_SWERK	NUMC	1	0	Shift due date to working day
60	SFMETH	☐	VVSFMETH	T_SFMETH	NUMC	1	0	Method for determining the next due date
61	DPKOND	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
62	AZGSTAGE	☐	AZGSTAGE	NUMC2	NUMC	2	0	Number of working days for interest fixing
63	SZKALRI	☐	SZKALRI	SKALRI	CHAR	1	0	Calendar direction for interest rate fixing
64	DZSREF	☐	VVDZSREF	DATUM	DATS	8	0	Date fixing for benchmark interest rate in cash flow
65	SKALID2	☐	VVSKALID2	WFCID	CHAR	2	0	Calendar ID 2 (valid in connection with calendar ID 1)	TFACD
66	JGESUCHT	☐	VVJGESUCHT	CHAR1	CHAR	1	0	Int. indicator for alternative calculations
67	KURS1	☐	KURSF	KURSF	DEC	9	5	Exchange rate
68	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
69	SZWERK	☐	VVSZWERK	T_SWERK	NUMC	1	0	Shift to working day for interest fixing date
70	SFINCL	☐	VVSFINCL	VVSINCL	NUMC	1	0	Inclusive Indicator for Due Date
71	SRUNDVORF	☐	VVSRUNDVF	TFMSRUNDVF	NUMC	1	0	Rounding of interim results for prepayments
72	SZWKEY	☐	VVSZWKEY	VVSZWKEY	CHAR	2	0	Payment form with adjustment days	TDZW
73	SFVMETH	☐	TB_SFVMETH	T_SFVMETH	NUMC	2	0	Update method for calculation date/due date
74	SDWERK	☐	TB_SDWERK	T_SWERK	NUMC	1	0	Working Day Shift for Payment Date
75	SBERECH	☐	SBERECH	XFELD	CHAR	1	0	Grace Period Interest Method
76	JPROZR	☐	TB_JPROZR	XFELD	CHAR	1	0	Percentage Calculation
77	SZEITANT	☐	VVSZEITANT	VVSZEITANT	NUMC	1	0	Indicator for Pro Rata Temporis Calculations
78	SFANT	☐	VVSFANT	VVSFANT	NUMC	1	0	Indicator for due date-related FiMa calculations
79	SFRANZ	☐	TFMSFRANZ	TFMSFRANZ	NUMC	1	0	Shift Due Date
80	SKOAREF	☐	VVSKOAREF	SKOART	NUMC	4	0	Reference cond.type which the current cond.type refers to	TZK01
81	SBEWSOLL	☐	VVSBEWART1	SBEWART	CHAR	4	0	Flow Type 1 (Debit/Credit)	TZB0A
82	SBEWHABEN	☐	VVSBEWART2	SBEWART	CHAR	4	0	Flow Type 2 (Debit/Credit)	TZB0A
83	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	TZB03
84	AUSWAHL	☐	FEAUS	TEXT60	CHAR	60	0	Field selection
85	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	AT40
86	JMUSS	☐	JMUSS	JANE	CHAR	1	0	Indicator, condition type mandatory
87	NFOLGE	☐	NFOLGE	VVNFOLGE	NUMC	4	0	Display sequence of condition types within the group
88	NHIER	☐	NHIER	NUMC1	NUMC	1	0	Display hierarchy for entry of new conditions
89	KBKOND	☐	VVKBKOND	VVKWKURS	DEC	15	6	Condition amount independent of currency
90	SBASFIX	☐	TFMSBASFIX	TFMSBASFIX	NUMC	1	0	Indicator for fixing calculation base
91	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
92	ZAHLS	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
93	SZADRI	☐	SZADRI	XFELD	CHAR	1	0	Payment to third-party
94	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
95	BKONDQM	☐	BKONDQM	WRTV7	CURR	13	2	Currency amount per area unit
96	SFLART	☐	SFLART	SFLART	NUMC	4	0	Area type	TIV08
97	JAREA	☐	VVJAREA	XFELD	CHAR	1	0	Rental on basis of area?
98	PAY_DATA_C	☐	PAY_DATA_C	XFELD	CHAR	1	0	Change payment method or bank cat.
99	AVGSTAGEVZ	☐	AVGSTAGEVZ	PLUSM	CHAR	1	0	+/- sign for number of working days for value date
100	AFGSTAGEVZ	☐	AFGSTAGEVZ	PLUSM	CHAR	1	0	+/- sign for number of working days for due date
101	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
102	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
103	JEXPOZINS	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
104	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
105	GFZLSCH	☐	RECNGFZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos	*
106	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
107	SROUND	☐	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
108	SKALIDWT	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
109	BMWST	☐	BMWST	WRTV7	CURR	13	2	Value-added tax amount included
110	XCROSS	☐	RECNXCROSS	XFELD	CHAR	1	0	Gross amount indicator
111	PKOND2	☐	PKOND2	DECV5_10	DEC	15	10	Percentage Rate for Condition Items
112	.INCLU--AP	☐				0	0	APPEND for Consumer Loan
113	A_PAYDAY	☐	TB_MODEL_PAYDAY	T_VIEW_DAY_OF_PAYMENT	NUMC	2	0	Model Calculation: Day of Installment Payment (1-31)
114	RCO	☐	TB_MODEL_RCO	RBO	CHAR	15	0	Bus. Operation No. (Installment Plan Change: Consumer Loan)
115	.INCLU--AP	☐				0	0	Append Localization
116	BROUNDUNIT	☐	TB_BROUNDUNIT_A	TFMSRUNIT	DEC	13	7	Rounding Unit for Amounts
117	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
118	BBASISUNIT	☐	TFM_BBASISUNIT	TFM_WRTV9	CURR	17	2	Base Unit for Rounding
119	.INCLU--AP	☐				0	0	Append Structure VVZZKOPO for Loans
120	PPAYMENT	☐	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
121	AMMRHYZV	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
122	RBO	☐	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
123	STECH_COND	☐	TB_STECH_COND		CHAR	1	0	Indicator for Technical Program Condition
124	SEXCLGUEL	☐	TFMSEXCLKP	VVSEXCLVON	NUMC	1	0	Exclusive indicator for start date of condition position
125	SULTGUEL	☐	TFMSULT_KP	VVSULT	CHAR	1	0	Month-end indicator for start date of condition position
126	A_AMTMIN	☐	TB_FICO_AAMTMIN	T_CML_AMOUNT_STANDARD	CURR	13	2	Minimum Amount
127	A_AMTMAX	☐	TB_FICO_AAMTMAX	T_CML_AMOUNT_STANDARD	CURR	13	2	Maximum Amount
128	SSCHMETH	☐	TB_SSCHMETH	T_SSCHMETH	CHAR	1	0	Calculation Method for Auto Debit Amount
129	BAUDAMNT	☐	TB_BAUDAMNT	WERTV7	CURR	13	2	Amount
130	JAUSBL	☐	JAUSBL	JANE	CHAR	1	0	Suppress field for LOAD with GET_EMPTY

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TBCO_COND_SE	BUKRS	T001	BUKRS	KEY	1	CN
2	TBCO_COND_SE	KUNNR	KNA1	KUNNR	KEY	1	CN
3	TBCO_COND_SE	MABER	T047M	MABER	KEY	1	CN
4	TBCO_COND_SE	MANDT	T000	MANDT	KEY	1	CN
5	TBCO_COND_SE	MWSKZ	T007A	MWSKZ	KEY	1	CN
6	TBCO_COND_SE	SANLF	TZAF	SANLF	KEY	1	CN
7	TBCO_COND_SE	SBASIS	TZFB	SBASIS	KEY	1	CN
8	TBCO_COND_SE	SBERFIMA	AT40	SBERFIMA
9	TBCO_COND_SE	SBEWHABEN	TZB0A	SBEWART	KEY	1	CN
10	TBCO_COND_SE	SBEWSOLL	TZB0A	SBEWART	KEY	1	CN
11	TBCO_COND_SE	SBEWZITI	TZB03	SBEWZITI	KEY	1	CN
12	TBCO_COND_SE	SBUST	TZB09	SBUST	KEY	1	CN
13	TBCO_COND_SE	SFLART	TIV08	SFLART		1	CN
14	TBCO_COND_SE	SFORMREF	AT30	RFORMBEZ	KEY	1	CN
15	TBCO_COND_SE	SKALID	TFACD	IDENT	KEY	1	CN
16	TBCO_COND_SE	SKALID2	TFACD	IDENT	KEY	1	CN
17	TBCO_COND_SE	SKOAREF	TZK01	SKOART	KEY	1	CN
18	TBCO_COND_SE	SKOART	TZK01	SKOART	KEY	1	CN
19	TBCO_COND_SE	SKOPO	TZK07	SKOPO	KEY	1	CN
20	TBCO_COND_SE	SPARTNR	BP000	PARTNR	KEY	1	CN
21	TBCO_COND_SE	SSTATI	TZC37	STATU	KEY	1	CN
22	TBCO_COND_SE	SWHRKOND	TCURC	WAERS	KEY	1	CN
23	TBCO_COND_SE	SZEGEN	TD21	SZEGEN	KEY	1	CN
24	TBCO_COND_SE	SZSREF	T056R	REFERENZ	KEY	1	CN
25	TBCO_COND_SE	SZWKEY	TDZW	SZWKEY	KEY	1	CN
26	TBCO_COND_SE	ZAHLS	T008	ZAHLS
27	TBCO_COND_SE	ZLSCH	T042Z	ZLSCH	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in