SAP ABAP Table RECNVZZKOPO2 (Real Estate Condition Items: Work and Screen Fields 2)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ RE (Application Component) Real Estate Management
     ⤷ FVVICN (Package) R/3 Real Estate Application Development - General Contract

Basic Data

Table Category	INTTAB	Structure
Structure	RECNVZZKOPO2	Table Relationship Diagram
Short Description	Real Estate Condition Items: Work and Screen Fields 2

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	Real Estate Condition Items: Work and Screen Fields
2	.INCLUDE	☐				0	0	Table condition items
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	*
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	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
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_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
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	☐	VVSFKALRI	XFELD	CHAR	1	0	Calculation of periods with flexible valid-to date?
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	KBKOND	☐	VVKBKOND	VVKWKURS	DEC	15	6	Condition amount independent of currency
81	SBASFIX	☐	TFMSBASFIX	TFMSBASFIX	NUMC	1	0	Indicator for fixing calculation base
82	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
83	ZAHLS	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
84	BKONDQM	☐	BKONDQM	WRTV7	CURR	13	2	Currency amount per area unit
85	JAREA	☐	VVJAREA	XFELD	CHAR	1	0	Rental on basis of area?
86	SFLART	☐	SFLART	SFLART	NUMC	4	0	Area type	TIV08
87	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
88	AVGSTAGEVZ	☐	AVGSTAGEVZ	PLUSM	CHAR	1	0	+/- sign for number of working days for value date
89	AFGSTAGEVZ	☐	AFGSTAGEVZ	PLUSM	CHAR	1	0	+/- sign for number of working days for due date
90	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
91	JEXPOZINS	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
92	KOSTL	☐	RECNKOSTL	KOSTL	CHAR	10	0	Cost center of internal contract	*
93	GFZLSCH	☐	RECNGFZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos	*
94	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
95	SROUND	☐	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
96	SKALIDWT	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
97	BMWST	☐	BMWST	WRTV7	CURR	13	2	Value-added tax amount included
98	XCROSS	☐	RECNXCROSS	XFELD	CHAR	1	0	Gross amount indicator
99	PPAYMENT	☐	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
100	AMMRHYZV	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
101	PKOND2	☐	PKOND2	DECV5_10	DEC	15	10	Percentage Rate for Condition Items
102	.INCLU--AP	☐				0	0	APPEND FOR MANDATE FIELD
103	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
104	.INCLU--AP	☐				0	0	Append VZZKOPO for Loans
105	RBO	☐	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
106	STECH_COND	☐	TB_STECH_COND		CHAR	1	0	Indicator for Technical Program Condition
107	SEXCLGUEL	☐	TFMSEXCLKP	VVSEXCLVON	NUMC	1	0	Exclusive indicator for start date of condition position
108	SULTGUEL	☐	TFMSULT_KP	VVSULT	CHAR	1	0	Month-end indicator for start date of condition position
109	A_AMTMIN	☐	TB_FICO_AAMTMIN	T_CML_AMOUNT_STANDARD	CURR	13	2	Minimum Amount
110	A_AMTMAX	☐	TB_FICO_AAMTMAX	T_CML_AMOUNT_STANDARD	CURR	13	2	Maximum Amount
111	SSCHMETH	☐	TB_SSCHMETH	T_SSCHMETH	CHAR	1	0	Calculation Method for Auto Debit Amount
112	BAUDAMNT	☐	TB_BAUDAMNT	WERTV7	CURR	13	2	Amount
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 for Localization
117	BROUNDUNIT	☐	TB_BROUNDUNIT_A	TFMSRUNIT	DEC	13	7	Rounding Unit for Amounts
118	BBASISUNIT	☐	TFM_BBASISUNIT	TFM_WRTV9	CURR	17	2	Base Unit for Rounding
119	XKOARTM	☐	XKOARTM	XBEZ20	CHAR	20	0	Condition type text
120	FQMFLART	☐	FQMFLART13_2	DEC13_2	DEC	15	2	Area of area type
121	JENDEKON	☐	VVJENDEKON	JANE	CHAR	1	0	Indicator: Condition type no longer valid as from today
122	BUT_SWITCH	☐	VVMSGID	CHAR02	CHAR	2	0	Message ID
123	SBEWSOLL	☐	VVSBEWART1	SBEWART	CHAR	4	0	Flow Type 1 (Debit/Credit)	*
124	SBEWHABEN	☐	VVSBEWART2	SBEWART	CHAR	4	0	Flow Type 2 (Debit/Credit)	*
125	OLD_ATTRHY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
126	OLD_AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
127	RESZBMETH	☐	VVSZBMETMV	VVSZBMETMV	NUMC	1	0	Calculation method for time-dependent periods
128	JEINMKON	☐	VVJEINMKON	JANE	CHAR	1	0	Indicator: Condition type valid once
129	RESZEITANT	☐	VVSZEITMV	VVSZEITMV	NUMC	1	0	Indicator for Pro Rata Temporis Calculations
130	BBBBTR	☐	BBBBTR	WRTV7	CURR	13	2	Gross invoice amount
131	BMWST3	☐	BMWST	WRTV7	CURR	13	2	Value-added tax amount included
132	GESPERRT	☐	JGESPERRT	JFLAGG	CHAR	1	0	Internal flag: Record is blocked for changes
133	GESPERRT_NACH	☐	JGESPERRT	JFLAGG	CHAR	1	0	Internal flag: Record is blocked for changes
134	LOCK_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
135	BUCH_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
136	BKOND2	☐	BKOND	WERTV7	CURR	13	2	Condition item currency amount
137	BMWST2	☐	BMWST	WRTV7	CURR	13	2	Value-added tax amount included
138	BBBBTR2	☐	BBBBTR	WRTV7	CURR	13	2	Gross invoice amount
139	SWHRKOND2	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	*
140	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	*
141	KUNNRTXT	☐	RECNADRLINE	RECNADRLINE	CHAR	80	0	Address line
142	LIFNRTXT	☐	RECNADRLINE	RECNADRLINE	CHAR	80	0	Address line
143	KUNNRLIFNRTXT	☐	RECNADRLINE	RECNADRLINE	CHAR	80	0	Address line
144	TXJCDTEXT	☐	TEXT1_TXJT	TEXT50	CHAR	50	0	Description
145	ZLSCHTEXT	☐	TEXT1_042Z	TEXT30	CHAR	30	0	Name of Payment Method in Language of the Country
146	MWSKZTEXT	☐	TEXT1_007S	TEXT50	CHAR	50	0	Name for value-added tax
147	KOSTLTEXT	☐	KLTXT	TEXT40	CHAR	40	0	Description
148	NO_CHANGE	☐	JGESPERRT	JFLAGG	CHAR	1	0	Internal flag: Record is blocked for changes
149	SPARTNRTXT	☐	RECNADRLINE	RECNADRLINE	CHAR	80	0	Address line
150	GFZLSCHTEXT	☐	TEXT1_042Z	TEXT30	CHAR	30	0	Name of Payment Method in Language of the Country
151	ZLSPRTXT	☐	TEXTL_008	TEXT20	CHAR	20	0	Explanation of the Reason for Payment Block
152	JMARKED	☐	VVJMARKED	XFELD	CHAR	1	0	Flag: List entry is selected
153	OLD_SFLART	☐	SFLART	SFLART	NUMC	4	0	Area type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RECNVZZKOPO2	BUKRS	T001	BUKRS	KEY	1	1
2	RECNVZZKOPO2	KUNNR	KNA1	KUNNR	KEY	1	CN
3	RECNVZZKOPO2	LIFNR	LFA1	LIFNR	KEY	1	CN
4	RECNVZZKOPO2	MABER	T047M	MABER	KEY	1	CN
5	RECNVZZKOPO2	MANDT	T000	MANDT	KEY	1	1
6	RECNVZZKOPO2	MANSP	T040S	MANSP
7	RECNVZZKOPO2	MWSKZ	T007A	MWSKZ	KEY	1	CN
8	RECNVZZKOPO2	SBASIS	TZFB	SBASIS	KEY	1	CN
9	RECNVZZKOPO2	SBUST	TZB09	SBUST	KEY	1	CN
10	RECNVZZKOPO2	SFLART	TIV08	SFLART		1	CN
11	RECNVZZKOPO2	SFORMREF	AT30	RFORMBEZ	KEY	1	CN
12	RECNVZZKOPO2	SKALID	TFACD	IDENT	KEY	1	CN
13	RECNVZZKOPO2	SKALID2	TFACD	IDENT	KEY	1	CN
14	RECNVZZKOPO2	SKOART	TZK01	SKOART	KEY	1	CN
15	RECNVZZKOPO2	SKOPO	TZK07	SKOPO	KEY	1	CN
16	RECNVZZKOPO2	SPARTNR	BUT000	PARTNER	KEY	1	CN
17	RECNVZZKOPO2	SWHRKOND	TCURC	WAERS	REF	1	1
18	RECNVZZKOPO2	SZEGEN	TD21	SZEGEN	KEY	1	CN
19	RECNVZZKOPO2	SZSREF	T056R	REFERENZ	KEY	1	CN
20	RECNVZZKOPO2	SZWKEY	TDZW	SZWKEY	KEY	1	CN
21	RECNVZZKOPO2	ZAHLS	T008	ZAHLS
22	RECNVZZKOPO2	ZLSCH	T042Z	ZLSCH	KEY	1	CN
23	RECNVZZKOPO2	ZLSPR	T008	ZAHLS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	470