SAP ABAP Table VDZZKOKO (Condition header for loans)

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	VDZZKOKO	Table Relationship Diagram
Short Description	Condition header for loans

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 header
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	DGUEL_KK	☐	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
7	NLFD_ANG	☐	NLFD_ANG	LFNR3	NUMC	3	0	Offer consecutive number
8	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
9	SKOKOART	☐	SKOKOART	SKOKOART	NUMC	2	0	Type of Condition Header
10	STILGRHY	☐	STILGRHY	SRHYT	NUMC	2	0	Payment cycle
11	STILGART	☐	STILGART	STILGART	NUMC	1	0	Repayment Type Indicator
12	SDISEIN	☐	SDISEIN	SDISEIN	CHAR	1	0	Type of Discount Withholding
13	KZAHLUNG	☐	KZAHLUNG	DEC3_7	DEC	10	7	Pay-in/disbursement rate
14	BZAHLUNG	☐	BZAHLUNG	BWHR	CURR	13	2	Pay-in/disbursement amount
15	SWHRZHLG	☐	SWHRZHLG	WAERS	CUKY	5	0	Currency of payment amount	TCURC
16	BZUSAGE	☐	BZUSAGE	WERTV7	CURR	13	2	Commitment capital
17	SWHRZUSA	☐	SWHRZUSA	WAERS	CUKY	5	0	Currency of commitment amount	TCURC
18	PEFFZINS	☐	TB_EFF_RATE	DECV3_7	DEC	10	7	Effective Interest Rate
19	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
20	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
21	SDISKO	☐	SDISKO	SDISKO	CHAR	1	0	Discounted
22	DKUEND	☐	DKUEND	DATUM	DATS	8	0	Date of notice
23	SKUEND	☐	SKUEND	SKUEART	NUMC	3	0	Reason for Notice	TD04
24	DKUENDDG	☐	DKUENDDG	DATUM	DATS	8	0	Earliest Possible Date for Notice Given by the Lender
25	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
26	DBLFZ_ORIGIN	☐	DBLFZ_ORIGIN	DATUM	DATS	8	0	Original Term Start
27	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
28	DRESAM	☐	DRESAM	DATUM	DATS	8	0	Reservation of Conditions On
29	DRESBIS	☐	DRESBIS	DATUM	DATS	8	0	Reservation of Conditions Until
30	DANGAM	☐	DANGAM	DATUM	DATS	8	0	Offer creation date
31	DANGBIS	☐	DANGBIS	DATUM	DATS	8	0	Offer Effective To
32	SANGVOR	☐	SANGVOR	SANGVOR	NUMC	2	0	Offer/Acceptance Reservation Indicator	ATRESERVATION
33	JANNAHME	☐	JANNAHME	JANEI	CHAR	1	0	Offer Acceptance Indicator
34	SANNAHME	☐	SANNAHME	SKONTAKT	NUMC	2	0	Type of offer acceptance indicator	TD13
35	DANNAHME	☐	DANNAHME	DATUM	DATS	8	0	Date of acceptance of offer
36	JVERTRAG	☐	JVERTRAG	JANEI	CHAR	1	0	Indicator: Contract Created?
37	DVERTRAM	☐	DVERTRAM	DATUM	DATS	8	0	Contract creation date
38	DVERTBIS	☐	DVERTBIS	DATUM	DATS	8	0	Return contract by
39	PMANEFFZ	☐	TB_EFF_RATE_INT	DECV3_7	DEC	10	7	Effective Interest Rate
40	SEFFM2	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
41	SKUEGL	☐	VVSKUEGL	VVSKUEGL	NUMC	3	0	Notice Arrangement Lender	TD28
42	RPNR	☐	VVRPNR	NUMC08	NUMC	8	0	Activity number/rollover number
43	DEFSZ	☐	VVDEFSZ	DATUM	DATS	8	0	Date of fixed period end
44	DGES	☐	VVDGES	DATUM	DATS	8	0	Earliest Notice Date in acc. with the Legal Right of Notice
45	SGESAUS	☐	VVSGESAUS	XFELD	CHAR	1	0	Legal Right of Notice Excluded
46	SZKZ	☐	VVSZKZ	VVSZKZ	CHAR	1	0	Special int. ID for int. on arrears for remaining balance	TDSOZ
47	NANGEBOT	☐	NLFD_ANG	LFNR3	NUMC	3	0	Offer consecutive number
48	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
49	ZVRHYEFF	☐	VVZVRHYEFF	NUMC03	NUMC	3	0	Int.sttlmnt frequency for effective int.rate calc.in months
50	PVGLEFFZ	☐	TB_EFF_RATE_COM	DECV3_7	DEC	10	7	Comparative Effective Interest
51	SULTEFSZ	☐	VVSULTEFSZ	VVSULT	CHAR	1	0	Month-end indicator for end of fixed period
52	DABEFFZ	☐	VVDABEFFZ	DATUM	DATS	8	0	Date when calculation of effective rate starts
53	DKUENDDN	☐	VVDKUENDDN	DATUM	DATS	8	0	Earliest Possible Date for Notice Given by the Borrower
54	SKUEDN	☐	VVSKUEDN	VVSKUEDN	NUMC	3	0	Notice Arrangement Borrower	TD29
55	SKUEART	☐	VVSKUEART	VVSKUEART	NUMC	3	0	Notice Type for the Loan	TD27
56	DMARKTZINS	☐	DMARKTZINS	DATS	DATS	8	0	ISB: Market Rate Date: Market Interest Rate for NPV Calc.
57	SKALIDWT	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
58	EDEFFZINS	☐	TB_EFF_RATE_ED	DECV3_7	DEC	10	7	Relevant for Closely Defined Effective Interest
59	EDEFFMETH	☐	EFFMETH	EFFMETH	CHAR	1	0	Effective Interest Method - Acc. to EU Gdline Int.Statistics
60	JAHREFFZINS	☐	TB_EFF_RATE_YEAR	DECV3_7	DEC	10	7	Relevant for Yearly Eff. Interest Acc Guideline 87/102/EU
61	JAHREFFMETH	☐	EFFMETH	EFFMETH	CHAR	1	0	Effective Interest Method - Acc. to EU Gdline Int.Statistics
62	PEFFZINS_ORIGIN	☐	TB_EFF_RATE_ORIG	DECV3_7	DEC	10	7	Original Effective Interest Rate
63	.INCLU--AP	☐				0	0	Extensions of Loan Component
64	ORIGINAL_TERM	☐	TB_VIEW_ORIGINAL_TERM		NUMC	3	0	Original Term in Months
65	OVERALL_RUNTIME	☐	TB_VIEW_OVERALL_RUNTIME		NUMC	3	0	Overall Term
66	ORIG_CREDIT_SUM	☐	TB_VIEW_ORIGINAL_CREDIT_SUM	WERTV7	CURR	13	2	Original Total Loan Amount
67	DATE_REPAYMENT	☐	TB_VIEW_DATE_REPAYMENT	DATUM	DATS	8	0	Start Date for Repayment
68	DATE_FIRST_RATE	☐	TB_VIEW_DATE_FIRST_RATE	DATUM	DATS	8	0	Due Date for First Installment to Include a Repayment Amount
69	DAY_OF_PAYMENT	☐	TB_VIEW_DAY_OF_PAYMENT	T_VIEW_DAY_OF_PAYMENT	NUMC	2	0	Day of Installment Payment
70	CLEARING_RATE	☐	TB_VIEW_CLEARING_RATE	WERTV7	CURR	13	2	Amount for Final Loan Installment Payment
71	EFF_INT_L_PYMNP	☐	TB_MODEL_EFFECTIV_INTERSTS_PPC	DEC3_7	DEC	10	7	Effective Interest Rate for Last Change to Installment Plan
72	DEFF_INT_L_PYMNP	☐	TB_MODEL_DATE_LAST_PAYMENTPLAN	DATUM	DATS	8	0	Key Date for Last Change to Installment Plan
73	REPAY_DELAY	☐	TB_MODEL_REPAY_DELAY		NUMC	2	0	Model Calculation: DE for Periods of Repayment Suspension
74	CALCULATED_PARAM	☐	TB_MODEL_P_RATE_OR_TERM	T_MODEL_P_RATE_OR_TERM	CHAR	4	0	Calculate Installment Amount or Number of Installments?
75	CURR_CREDIT_SUM	☐	TB_VIEW_CURRENT_CREDIT_SUM	WERTV7	CURR	13	2	Current Total Loan Amount
76	BROUNDUNIT	☐	TB_BROUNDUNIT_A	TFMSRUNIT	DEC	13	7	Rounding Unit for Amounts
77	SROUND	☐	TB_SROUND_A	TFM_SROUND	CHAR	1	0	Rounding Category (Round up, Round Down or Number Rounding)
78	BOVERLIMIT	☐	TB_COMP_OVERLIMIT_AMOUNT	WERTV7	CURR	13	2	Drawing Tolerance as Amount
79	POVERLIMIT	☐	TB_COMP_OVERLIMT_PERCENT	DECV3_7	DEC	10	7	Drawing Tolerance as a Percentage
80	CONTAB	☐	TB_FICO_CONTAB	T_FICO_CONTAB	CHAR	8	0	Condition Table
81	CONTAB_VERSION	☐	TB_FICO_CONTAB_VERSION	T_FICO_CONTAB_VERSION	NUMC	4	0	Version Number for a Condition Table
82	TERM_PAYMENT	☐	TB_TERM_PAYMENT	T_TERM_PAYMENT	CHAR	1	0	Category of Last Installment
83	PAPR_ORIGIN	☐	TB_PAPR_ORIGIN	DECV3_7	DEC	10	7	Original U.S. Effective Interest Rate

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VDZZKOKO	BUKRS	T001	BUKRS
2	VDZZKOKO	MANDT	T000	MANDT
3	VDZZKOKO	SANGVOR	ATRESERVATION	SANGVOR
4	VDZZKOKO	SANNAHME	TD13	SANNAHME
5	VDZZKOKO	SKUEART	TD27	SKUEART
6	VDZZKOKO	SKUEDN	TD29	SKUEDN
7	VDZZKOKO	SKUEGL	TD28	SKUEGL
8	VDZZKOKO	SKUEND	TD04	SKUEND
9	VDZZKOKO	SWHRZHLG	TCURC	WAERS
10	VDZZKOKO	SWHRZUSA	TCURC	WAERS
11	VDZZKOKO	SZKZ	TDSOZ	SZKZ

History

Last changed by/on	SAP	20131127
SAP Release Created in