SAP ABAP Table VVZZKOPO (View of VZZKOPO with additional info. from VKOPOSTEU)

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	INTTAB	Structure
Structure	VVZZKOPO	Table Relationship Diagram
Short Description	View of VZZKOPO with additional info. from VKOPOSTEU

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	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	TZAF
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	XKOARTM	☐	XKOARTM	XBEZ20	CHAR	20	0	Condition type text
13	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	TZC37
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	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
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	☐	VVSNVER1	CHAR1	CHAR	1	0	Field is no longer used
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	SKOAREF	☐	VVSKOAREF	SKOART	NUMC	4	0	Reference cond.type which the current cond.type refers to	TZK01
80	SBEWSOLL	☐	VVSBEWART1	SBEWART	CHAR	4	0	Flow Type 1 (Debit/Credit)	TZB0A
81	SBEWHABEN	☐	VVSBEWART2	SBEWART	CHAR	4	0	Flow Type 2 (Debit/Credit)	TZB0A
82	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	TZB03
83	AUSWAHL	☐	FEAUS	TEXT60	CHAR	60	0	Field selection
84	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	AT40
85	JMUSS	☐	JMUSS	JANE	CHAR	1	0	Indicator, condition type mandatory
86	NFOLGE	☐	NFOLGE	VVNFOLGE	NUMC	4	0	Display sequence of condition types within the group
87	NHIER	☐	NHIER	NUMC1	NUMC	1	0	Display hierarchy for entry of new conditions
88	KBKOND	☐	VVKBKOND	VVKWKURS	DEC	15	6	Condition amount independent of currency
89	SBASFIX	☐	TFMSBASFIX	TFMSBASFIX	NUMC	1	0	Indicator for fixing calculation base
90	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
91	ZAHLS	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
92	SZADRI	☐	SZADRI	XFELD	CHAR	1	0	Payment to third-party
93	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
94	BKONDQM	☐	BKONDQM	WRTV7	CURR	13	2	Currency amount per area unit
95	SFLART	☐	SFLART	SFLART	NUMC	4	0	Area type	TIV08
96	JAREA	☐	VVJAREA	XFELD	CHAR	1	0	Rental on basis of area?
97	PAY_DATA_C	☐	PAY_DATA_C	XFELD	CHAR	1	0	Change payment method or bank cat.
98	AVGSTAGEVZ	☐	AVGSTAGEVZ	PLUSM	CHAR	1	0	+/- sign for number of working days for value date
99	AFGSTAGEVZ	☐	AFGSTAGEVZ	PLUSM	CHAR	1	0	+/- sign for number of working days for due date
100	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
101	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
102	JEXPOZINS	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
103	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
104	GFZLSCH	☐	RECNGFZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos	*
105	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
106	SROUND	☐	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
107	SKALIDWT	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
108	BMWST	☐	BMWST	WRTV7	CURR	13	2	Value-added tax amount included
109	XCROSS	☐	RECNXCROSS	XFELD	CHAR	1	0	Gross amount indicator
110	PKOND2	☐	PKOND2	DECV5_10	DEC	15	10	Percentage Rate for Condition Items
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 Localization
115	BROUNDUNIT	☐	TB_BROUNDUNIT_A	TFMSRUNIT	DEC	13	7	Rounding Unit for Amounts
116	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
117	BBASISUNIT	☐	TFM_BBASISUNIT	TFM_WRTV9	CURR	17	2	Base Unit for Rounding
118	.INCLU--AP	☐				0	0	Append Structure VVZZKOPO for Loans
119	PPAYMENT	☐	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
120	AMMRHYZV	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
121	RBO	☐	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
122	STECH_COND	☐	TB_STECH_COND		CHAR	1	0	Indicator for Technical Program Condition
123	SEXCLGUEL	☐	TFMSEXCLKP	VVSEXCLVON	NUMC	1	0	Exclusive indicator for start date of condition position
124	SULTGUEL	☐	TFMSULT_KP	VVSULT	CHAR	1	0	Month-end indicator for start date of condition position
125	A_AMTMIN	☐	TB_FICO_AAMTMIN	T_CML_AMOUNT_STANDARD	CURR	13	2	Minimum Amount
126	A_AMTMAX	☐	TB_FICO_AAMTMAX	T_CML_AMOUNT_STANDARD	CURR	13	2	Maximum Amount
127	SSCHMETH	☐	TB_SSCHMETH	T_SSCHMETH	CHAR	1	0	Calculation Method for Auto Debit Amount
128	BAUDAMNT	☐	TB_BAUDAMNT	WERTV7	CURR	13	2	Amount
129	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	VVZZKOPO	BUKRS	T001	BUKRS	KEY	1	CN
2	VVZZKOPO	KUNNR	KNA1	KUNNR	KEY	1	CN
3	VVZZKOPO	MABER	T047M	MABER	KEY	1	CN
4	VVZZKOPO	MANDT	T000	MANDT	KEY	1	CN
5	VVZZKOPO	MWSKZ	T007A	MWSKZ	KEY	1	CN
6	VVZZKOPO	SANLF	TZAF	SANLF	KEY	1	CN
7	VVZZKOPO	SBASIS	TZFB	SBASIS	KEY	1	CN
8	VVZZKOPO	SBERFIMA	AT40	SBERFIMA
9	VVZZKOPO	SBEWHABEN	TZB0A	SBEWART	KEY	1	CN
10	VVZZKOPO	SBEWSOLL	TZB0A	SBEWART	KEY	1	CN
11	VVZZKOPO	SBEWZITI	TZB03	SBEWZITI	KEY	1	CN
12	VVZZKOPO	SBUST	TZB09	SBUST	KEY	1	CN
13	VVZZKOPO	SFLART	TIV08	SFLART		1	CN
14	VVZZKOPO	SFORMREF	AT30	RFORMBEZ	KEY	1	CN
15	VVZZKOPO	SKALID	TFACD	IDENT	KEY	1	CN
16	VVZZKOPO	SKALID2	TFACD	IDENT	KEY	1	CN
17	VVZZKOPO	SKOAREF	TZK01	SKOART	KEY	1	CN
18	VVZZKOPO	SKOART	TZK01	SKOART	KEY	1	CN
19	VVZZKOPO	SKOPO	TZK07	SKOPO	KEY	1	CN
20	VVZZKOPO	SPARTNR	BP000	PARTNR	KEY	1	CN
21	VVZZKOPO	SSTATI	TZC37	STATU	KEY	1	CN
22	VVZZKOPO	SWHRKOND	TCURC	WAERS	KEY	1	CN
23	VVZZKOPO	SZEGEN	TD21	SZEGEN	KEY	1	CN
24	VVZZKOPO	SZSREF	T056R	REFERENZ	KEY	1	CN
25	VVZZKOPO	SZWKEY	TDZW	SZWKEY	KEY	1	CN
26	VVZZKOPO	ZAHLS	T008	ZAHLS
27	VVZZKOPO	ZLSCH	T042Z	ZLSCH	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in