SAP ABAP Table VZZKOPO (Table condition items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVV (Package) R/3 application development for Financial Assets Management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VZZKOPO	Table Relationship Diagram
Short Description	Table condition items

Delivery and Maintenance

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

History

Last changed by/on	SAP	20130529
SAP Release Created in