SAP ABAP Table VIRACOND (RE: Lease-Out - Condition Items and Additional Fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	INTTAB	Structure
Structure	VIRACOND	Table Relationship Diagram
Short Description	RE: Lease-Out - Condition Items and Additional Fields

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in