SAP ABAP Table VIZZKOPO (Real Estate condition items for BAV)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-SR-DE (Application Component) Germany
     ⤷ VVSRG (Package) Statutory Reporting Germany

Basic Data

Table Category	INTTAB	Structure
Structure	VIZZKOPO	Table Relationship Diagram
Short Description	Real Estate condition items for BAV

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	Table condition items
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	*
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	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
14	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
15	BKOND	☐	BKOND	WERTV7	CURR	13	2	Condition item currency amount
16	SWHRKOND	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	TCURC
17	SBASIS	☐	VVSBASIS	VVSBASIS	CHAR	4	0	Calculation base reference	TZFB
18	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
19	SZSREFVZ	☐	SZSREFVZ	SZSREFVZ	CHAR	1	0	+/- sign / reference interest rate operator
20	PFLUCT	☐	TFM_PFLUCT	DECV3_7	DEC	10	7	Fluctuation margin
21	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
22	ATTRHY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
23	SZAWS	☐	SZAWS	SZAHLDIV	NUMC	1	0	Payment form (at start of period, mid-period, at period end)
24	RDIVNR	☐	RDIVNR	NUM03	NUMC	3	0	Dividend coupon number
25	JNULLKON	☐	JNULLKON	SKONDF	CHAR	1	0	Condition Form
26	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
27	JBMONAT	☐	JBMONAT	JANEI	CHAR	1	0	Indicator for calculating amount per month
28	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
29	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
30	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
31	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
32	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
33	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
34	SPARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
35	RKONT	☐	RKONT	RKONT	NUMC	6	0	Quota number
36	SVULT	☐	VVSBULT	JFLAGG	CHAR	1	0	Month-end indicator for calculation date
37	SFULT	☐	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
38	SVKALRI	☐	VVSNVER1	CHAR1	CHAR	1	0	Field is no longer used
39	SFKALRI	☐	VVSFKALRI	XFELD	CHAR	1	0	Calculation of periods with flexible valid-to date?
40	AVGSTAGE	☐	AVGSTAGE	NUMC2	NUMC	2	0	Number of working days for value date
41	AFGSTAGE	☐	AFGSTAGE	NUMC2	NUMC	2	0	Number of working days to due date
42	SVKALZUS	☐	VVSNVER1	CHAR1	CHAR	1	0	Field is no longer used
43	SFKALZUS	☐	VVSNVER1	CHAR1	CHAR	1	0	Field is no longer used
44	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
45	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
46	JSOFVERR	☐	JSOFVERR	TFMSOFVERR	CHAR	1	0	Immediate settlement
47	DALLGEM	☐	DALLGEM	DATUM	DATS	8	0	General date
48	SZEGEN	☐	SZEGEN	SZEGEN	NUMC	2	0	Generate incoming payment immediately	TD21
49	SBUST	☐	VVSBUST	VVSBUST	NUMC	2	0	Posting control key	TZB09
50	SKOPO	☐	VVSKOPO	VVSKOPO	NUMC	2	0	Detailed identification for condition items	TZK07
51	SALTKOND	☐	VVSALTKOND	SKONDGRP	NUMC	4	0	Bracket condition for alternative conditions
52	SZINSANP	☐	VVSZINSANP	SKONDGRP	NUMC	4	0	Cross-referenced condition grp for interest rate adjustment
53	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
54	SFORMREF	☐	VVSFORMREF	T_FORMBE	CHAR	4	0	Formula reference for the cash flow calculator	AT30
55	SVARNAME	☐	VVSVARNAME	T_XFELD04	CHAR	4	0	Description of variables in cash flow calculator
56	SVWERK	☐	VVSVWERK	T_SWERK	NUMC	1	0	Shift calculation date to working day
57	SVMETH	☐	VVSVMETH	T_SVMETH	NUMC	1	0	Method for determining the next value date
58	SFWERK	☐	VVSFWERK	T_SWERK	NUMC	1	0	Shift due date to working day
59	SFMETH	☐	VVSFMETH	T_SFMETH	NUMC	1	0	Method for determining the next due date
60	DPKOND	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
61	AZGSTAGE	☐	AZGSTAGE	NUMC2	NUMC	2	0	Number of working days for interest fixing
62	SZKALRI	☐	SZKALRI	SKALRI	CHAR	1	0	Calendar direction for interest rate fixing
63	DZSREF	☐	VVDZSREF	DATUM	DATS	8	0	Date fixing for benchmark interest rate in cash flow
64	SKALID2	☐	VVSKALID2	WFCID	CHAR	2	0	Calendar ID 2 (valid in connection with calendar ID 1)	TFACD
65	JGESUCHT	☐	VVJGESUCHT	CHAR1	CHAR	1	0	Int. indicator for alternative calculations
66	KURS1	☐	KURSF	KURSF	DEC	9	5	Exchange rate
67	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
68	SZWERK	☐	VVSZWERK	T_SWERK	NUMC	1	0	Shift to working day for interest fixing date
69	SFINCL	☐	VVSFINCL	VVSINCL	NUMC	1	0	Inclusive Indicator for Due Date
70	SRUNDVORF	☐	VVSRUNDVF	TFMSRUNDVF	NUMC	1	0	Rounding of interim results for prepayments
71	SZWKEY	☐	VVSZWKEY	VVSZWKEY	CHAR	2	0	Payment form with adjustment days	TDZW
72	SFVMETH	☐	TB_SFVMETH	T_SFVMETH	NUMC	2	0	Update method for calculation date/due date
73	SDWERK	☐	TB_SDWERK	T_SWERK	NUMC	1	0	Working Day Shift for Payment Date
74	SBERECH	☐	SBERECH	XFELD	CHAR	1	0	Grace Period Interest Method
75	JPROZR	☐	TB_JPROZR	XFELD	CHAR	1	0	Percentage Calculation
76	SZEITANT	☐	VVSZEITANT	VVSZEITANT	NUMC	1	0	Indicator for Pro Rata Temporis Calculations
77	SFANT	☐	VVSFANT	VVSFANT	NUMC	1	0	Indicator for due date-related FiMa calculations
78	SFRANZ	☐	TFMSFRANZ	TFMSFRANZ	NUMC	1	0	Shift Due Date
79	KBKOND	☐	VVKBKOND	VVKWKURS	DEC	15	6	Condition amount independent of currency
80	SBASFIX	☐	TFMSBASFIX	TFMSBASFIX	NUMC	1	0	Indicator for fixing calculation base
81	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
82	ZAHLS	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
83	BKONDQM	☐	BKONDQM	WRTV7	CURR	13	2	Currency amount per area unit
84	JAREA	☐	VVJAREA	XFELD	CHAR	1	0	Rental on basis of area?
85	SFLART	☐	SFLART	SFLART	NUMC	4	0	Area type	TIV08
86	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
87	AVGSTAGEVZ	☐	AVGSTAGEVZ	PLUSM	CHAR	1	0	+/- sign for number of working days for value date
88	AFGSTAGEVZ	☐	AFGSTAGEVZ	PLUSM	CHAR	1	0	+/- sign for number of working days for due date
89	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
90	JEXPOZINS	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
91	KOSTL	☐	RECNKOSTL	KOSTL	CHAR	10	0	Cost center of internal contract	*
92	GFZLSCH	☐	RECNGFZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos	*
93	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
94	SROUND	☐	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
95	SKALIDWT	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
96	BMWST	☐	BMWST	WRTV7	CURR	13	2	Value-added tax amount included
97	XCROSS	☐	RECNXCROSS	XFELD	CHAR	1	0	Gross amount indicator
98	PPAYMENT	☐	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
99	AMMRHYZV	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
100	PKOND2	☐	PKOND2	DECV5_10	DEC	15	10	Percentage Rate for Condition Items
101	.INCLU--AP	☐				0	0	APPEND FOR MANDATE FIELD
102	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
103	.INCLU--AP	☐				0	0	Append VZZKOPO for Loans
104	RBO	☐	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
105	STECH_COND	☐	TB_STECH_COND		CHAR	1	0	Indicator for Technical Program Condition
106	SEXCLGUEL	☐	TFMSEXCLKP	VVSEXCLVON	NUMC	1	0	Exclusive indicator for start date of condition position
107	SULTGUEL	☐	TFMSULT_KP	VVSULT	CHAR	1	0	Month-end indicator for start date of condition position
108	A_AMTMIN	☐	TB_FICO_AAMTMIN	T_CML_AMOUNT_STANDARD	CURR	13	2	Minimum Amount
109	A_AMTMAX	☐	TB_FICO_AAMTMAX	T_CML_AMOUNT_STANDARD	CURR	13	2	Maximum Amount
110	SSCHMETH	☐	TB_SSCHMETH	T_SSCHMETH	CHAR	1	0	Calculation Method for Auto Debit Amount
111	BAUDAMNT	☐	TB_BAUDAMNT	WERTV7	CURR	13	2	Amount
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 for Localization
116	BROUNDUNIT	☐	TB_BROUNDUNIT_A	TFMSRUNIT	DEC	13	7	Rounding Unit for Amounts
117	BBASISUNIT	☐	TFM_BBASISUNIT	TFM_WRTV9	CURR	17	2	Base Unit for Rounding

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in