VZZKOKO

Table condition header | #header | Component: Treasury and Risk Management
Column Name Description
MANDT FK Client
BUKRS FK Company Code
SANLF Product Category
RKEY1 Key part 1
DGUEL_KK Date Condition Effective from
NLFD_ANG Offer consecutive number
Column Name Description
💲 Currency of payment amount (SWHRZHLG):
BZAHLUNG Pay-in/disbursement amount
💲 Currency of commitment amount (SWHRZUSA):
BZUSAGE Commitment capital
ORIG_CREDIT_SUM Original Total Loan Amount
CLEARING_RATE Amount for Final Loan Installment Payment
CURR_CREDIT_SUM Current Total Loan Amount
BOVERLIMIT Drawing Tolerance as Amount
Column Name Description
Column Name Description
DGUEL_KK Date Condition Effective from
DKUEND Date of notice
DKUENDDG Earliest Possible Date for Notice Given by the Lender
DBLFZ Start of Term
DBLFZ_ORIGIN Original Term Start
DELFZ End of Term
DRESAM Reservation of Conditions On
DRESBIS Reservation of Conditions Until
DANGAM Offer creation date
DANGBIS Offer Effective To
DANNAHME Date of acceptance of offer
DVERTRAM Contract creation date
DVERTBIS Return contract by
DEFSZ Date of fixed period end
DGES Earliest Notice Date in acc. with the Legal Right of Notice
DABEFFZ Date when calculation of effective rate starts
DKUENDDN Earliest Possible Date for Notice Given by the Borrower
DMARKTZINS ISB: Market Rate Date: Market Interest Rate for NPV Calc.
DATE_REPAYMENT Start Date for Repayment
DATE_FIRST_RATE Due Date for First Installment to Include a Repayment Amount
DEFF_INT_L_PYMNP Key Date for Last Change to Installment Plan
Column Name Description
SKOKOART Type of Condition Header Show values
STILGRHY Payment cycle Show values
STILGART Repayment Type Indicator Show values
SDISEIN Type of Discount Withholding Show values
SEFFMETH Effective Interest Method (Financial Mathematics) Show values
SZBMETH Interest Calculation Method Show values
SDISKO Discounted Show values
JANNAHME Offer Acceptance Indicator Show values
JVERTRAG Indicator: Contract Created? Show values
SEFFM2 Effective Interest Method (Financial Mathematics) Show values
SGESAUS Legal Right of Notice Excluded Show values
SINCL Inclusive indicator for beginning and end of a period Show values
SULTEFSZ Month-end indicator for end of fixed period Show values
EDEFFMETH Effective Interest Method - Acc. to EU Gdline Int.Statistics Show values
JAHREFFMETH Effective Interest Method - Acc. to EU Gdline Int.Statistics Show values
DAY_OF_PAYMENT Day of Installment Payment Show values
CALCULATED_PARAM Calculate Installment Amount or Number of Installments? Show values
SROUND Rounding Category (Round up, Round Down or Number Rounding) Show values
TERM_PAYMENT Category of Last Installment Show values
Column Name Description Domain name
SSTATI Status of data record STATI
KZAHLUNG Pay-in/disbursement rate DEC3_7
PEFFZINS Effective Interest Rate DECV3_7
PMANEFFZ Internal Effective Interest Rate DECV3_7
RPNR Activity number/rollover number NUMC08
NANGEBOT Offer consecutive number LFNR3
ZVRHYEFF Int.sttlmnt frequency for effective int.rate calc.in months NUMC03
PVGLEFFZ Comparative Effective Interest DECV3_7
SKALIDWT Interest Calendar WFCID
EDEFFZINS Relevant for Closely Defined Effective Interest DECV3_7
JAHREFFZINS Relevant for Yearly Eff. Interest Acc Guideline 87/102/EU DECV3_7
PEFFZINS_ORIGIN Original Effective Interest Rate DECV3_7
PEFFZINS_ADD Additional Effective Interest Rate DECV3_7
GROUP_ID Grouping Procedure ID VDML_GROUP_ID
VERSION Model Version
CLUSTER_NO Cluster Number INT1
ORIGINAL_TERM Original Term in Months
OVERALL_RUNTIME Overall Term
EFF_INT_L_PYMNP Effective Interest Rate for Last Change to Installment Plan DEC3_7
REPAY_DELAY Model Calculation: DE for Periods of Repayment Suspension
BROUNDUNIT Rounding Unit for Amounts TFMSRUNIT
POVERLIMIT Drawing Tolerance as a Percentage DECV3_7
CONTAB Condition Table T_FICO_CONTAB
CONTAB_VERSION Version Number for a Condition Table T_FICO_CONTAB_VERSION
PAPR_ORIGIN Original U.S. Effective Interest Rate DECV3_7
Master Data Relations Join Conditions
Company code
  • VZZKOKO.MANDT == T001.MANDT
  • VZZKOKO.BUKRS == T001.BUKRS
Client VZZKOKO.MANDT == T000.MANDT
Offer/Acceptance Reservation Indicator
Offer acceptance type
  • VZZKOKO.MANDT == TD13.MANDT
  • VZZKOKO.SANNAHME == TD13.SANNAHME
Notice Type for the Loan
  • VZZKOKO.MANDT == TD27.MANDT
  • VZZKOKO.SKUEART == TD27.SKUEART
Notice Arrangement Borrower
  • VZZKOKO.MANDT == TD29.MANDT
  • VZZKOKO.SKUEDN == TD29.SKUEDN
Notice Arrangement Lender
  • Notice Arrangement Lender
  • Client
  • VZZKOKO.SKUEGL == TD28.SKUEGL
  • VZZKOKO.MANDT == TD28.MANDT
Reason for Notice
  • VZZKOKO.MANDT == TD04.MANDT
  • VZZKOKO.SKUEND == TD04.SKUEND
Currency
  • VZZKOKO.MANDT == TCURC.MANDT
  • VZZKOKO.SWHRZHLG == TCURC.WAERS
Currency
  • VZZKOKO.MANDT == TCURC.MANDT
  • VZZKOKO.SWHRZUSA == TCURC.WAERS
Special int. ID for int. on arrears for remaining balance
  • Special int. ID for int. on arrears for remaining balance
  • Client
  • VZZKOKO.SZKZ == TDSOZ.SZKZ
  • VZZKOKO.MANDT == TDSOZ.MANDT