VZZKOPO

Table condition items | #masterdata | Component: Treasury and Risk Management
Column Name Description
MANDT FK Client
BUKRS FK Company Code
SANLF Product Category
RKEY1 Key part 1
RKEY2 Key part 2
RKEY3 Key part 3
DGUEL_KK Date Condition Effective from
NLFD_ANG Offer consecutive number
SKOART FK Condition Type (Smallest Subdivision of Condition Records)
DGUEL_KP Condition Item Effective From
NSTUFE Level number of condition item for recurring payments
Column Name Description
💲 Currency of Condition Item (SWHRKOND):
BKOND Condition Item Currency Amount
BBASIS Calculation Base Amount
BKONDQM Currency amount per area unit
BMWST Value-added tax amount included
A_AMTMIN Minimum Amount to Be Capitalized
A_AMTMAX Maximum Amount to Be Capitalized
BAUDAMNT Amount
BBASISUNIT Base Unit for Rounding
Column Name Description
Column Name Description
DGUEL_KK Date Condition Effective from
DGUEL_KP Condition Item Effective From
DVALUT Calculation Date
DFAELL Due date
DALLGEM General date
DPKOND Fixing Date of Percentage Rate from Condition
DZSREF Date fixing for benchmark interest rate in cash flow
Column Name Description
SZSREFVZ +/- sign / reference interest rate operator Show values
SZAWS Payment form (at start of period, mid-period, at period end) Show values
JNULLKON Condition Form Show values
JBMONAT Indicator for calculating amount per month Show values
SVULT Month-End Indicator for Calculation Date Show values
SFULT Month-End Indicator for Due Date Show values
SFKALRI Calculation of periods with flexible valid-to date? Show values
SZBMETH Interest Calculation Method Show values
JSOFVERR Immediate settlement Show values
SINCL Inclusive indicator for beginning and end of a period Show values
SVWERK Shift calculation date to working day Show values
SVMETH Method for determining the next value date Show values
SFWERK Shift due date to working day Show values
SFMETH Method for determining the next due date Show values
SZKALRI Calendar direction for interest rate fixing Show values
SZWERK Shift to Working Day for Interest Fixing Date Show values
SFINCL Inclusive Indicator for Due Date Show values
SRUNDVORF Rounding of interim results for prepayments Show values
SFVMETH Update Method for Calculation Date/Due Date Show values
SDWERK Working Day Shift for Payment Date Show values
SBERECH Grace Period Interest Method Show values
JPROZR Percentage Calculation Show values
SZEITANT Indicator for Pro Rata Temporis Calculations Show values
SFANT Indicator for due date-related FiMa calculations Show values
SFRANZ Shift Due Date Show values
SBASFIX Indicator for fixing calculation base Show values
JAREA Rental on basis of area? Show values
AVGSTAGEVZ +/- sign for number of working days for value date Show values
AFGSTAGEVZ +/- sign for number of working days for due date Show values
JEXPOZINS Type of Compound Interest Calculation Show values
SROUND Rounding Category Show values
XCROSS Gross amount indicator Show values
AMMRHYZV Interest Settlement Frequency for Exponential Interest Calc. Show values
SROUNDFACTOR Rounding Category of a Factor Show values
JEXPOINTFACTOR Exponential Interest Calculation with Factor Show values
SROUNDBASEFACTOR Rounding Category of a Base Factor Show values
SROUNDRATEFACTOR Rounding Category of Interest Factor Show values
JAVGCAP Use Upper Limit of Average Interest Rate Show values
JAVGFLOOR Use Lower Limit of Average Interest Rate Show values
SROUNDAVGINTEREST Rounding Category of Average Interest Rate Show values
SAVGWEIGHT Weighting Category of Interest Rate Show values
SFACTORRESET Event for Resetting Factor Calculation Show values
SEXCLGUEL Exclusive indicator for start date of condition position Show values
SULTGUEL Month-end indicator for start date of condition position Show values
SSCHMETH Calculation Method for Auto Debit Amount Show values
A_PAYDAY Model Calculation: Day of Installment Payment (1-31) Show values
IND_IOAGP Indicator for IOA/GP condition item Show values
Column Name Description Domain name
SSTATI Status of data record STATI
PKOND Percentage rate for condition items DECV3_7
PFLUCT Fluctuation margin DECV3_7
AMMRHY Frequency in months NUMC03
ATTRHY Frequency in Days NUMC03
RDIVNR Dividend coupon number NUM03
BVTYP Partner bank type BVTYP
RKONT Quota number RKONT
SVKALRI Field is no longer used CHAR1
AVGSTAGE Number of working days for value date NUMC2
AFGSTAGE Number of working days to due date NUMC2
SVKALZUS Field is no longer used CHAR1
SFKALZUS Field is no longer used CHAR1
SALTKOND Bracket condition for alternative conditions SKONDGRP
SZINSANP Cross-referenced condition grp for interest rate adjustment SKONDGRP
SVARNAME Description of variables in cash flow calculator T_XFELD04
AZGSTAGE Number of working days for interest fixing NUMC2
SKALID3 Calendar ID 3 (valid in connection with calendar ID 1) WFCID
SKALID4 Calendar ID 4 (valid in connection with calendar ID 1) WFCID
SKALID5 Calendar ID 5 (valid in connection with calendar ID 1) WFCID
JGESUCHT Int. indicator for alternative calculations CHAR1
KURS1 Exchange rate KURSF
KBKOND Condition amount independent of currency VVKWKURS2
TXJCD Tax Jurisdiction TXJCD
KOSTL Cost center of internal contract KOSTL
GFZLSCH Payment method for credit memos ZLSCH
SKALIDWT Interest Calendar WFCID
PPAYMENT Payment Rate TFM_PPAYMENT
PKOND2 Percentage Rate for Condition Items DECV5_10
FACTOR_TYPE Factor Type TB_FACTYPE
ROUNDDECFACTOR Number of Rounding Decimal Places for a Factor TFM_ROUNDDECIMALS
ROUNDDECBASEFACTOR Number of Rounding Decimal Places for a Base Factor TFM_ROUNDDECIMALS
ROUNDDECRATEFACTOR Number of Rounding Decimal Places for Interest Factor TFM_ROUNDDECIMALS
PAVGCAP Upper Limit of Average Interest Rate DECV5_10
PAVGFLOOR Lower Limit of Average Interest Rate DECV5_10
PAVGSPREAD Average Interest Rate Spread DECV5_10
ROUNDDECAVGINTEREST Number of Rounding Decimal Places for Average Interest Rate TFM_ROUNDDECIMALS
ADGSTAGE Number of Days for Relative Payment Date Calculation
FACE_FACTOR_CURRENT Factor TFM_FACTOR
SPAYMENT_METHOD Single Character Field FTBAS_CHAR1
MNDID Unique Reference to Mandate for each Payee ID035
RBO Business Operation Number (Loans) RBO
STECH_COND Indicator for Technical Program Condition
RCO Bus. Operation No. (Installment Plan Change: Consumer Loan) RBO
BROUNDUNIT Rounding Unit for Amounts TFMSRUNIT
GPDAYS Tolerance Days for Grace Period NUM2
DISBRATE Disbursement Rate TD_DISBRATE_CMLCHN
Master Data Relations | to Other Relations ↓ Join Conditions
Company code
  • VZZKOPO.MANDT == T001.MANDT
  • VZZKOPO.BUKRS == T001.BUKRS
Customer number
  • VZZKOPO.MANDT == KNA1.MANDT
  • VZZKOPO.KUNNR == KNA1.KUNNR
Account Number of Supplier
  • VZZKOPO.MANDT == LFA1.MANDT
  • VZZKOPO.LIFNR == LFA1.LIFNR
Dunning Area
  • Dunning Area
  • Company Code
  • VZZKOPO.MANDT == T047M.MANDT
  • VZZKOPO.MABER == T047M.MABER
  • VZZKOPO.BUKRS == T047M.BUKRS
Client VZZKOPO.MANDT == T000.MANDT
Dunning Block
  • VZZKOPO.MANDT == T040S.MANDT
  • VZZKOPO.MANSP == T040S.MANSP
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • VZZKOPO.MANDT == T007A.MANDT
  • VZZKOPO.[column in domain "KALSM_D"] == T007A.KALSM
  • VZZKOPO.MWSKZ == T007A.MWSKZ
Calculation base reference
  • ?
  • Calculation base reference
  • VZZKOPO.[column in domain "RANTYP"] == TZFB.RANTYP
  • VZZKOPO.SBASIS == TZFB.SBASIS
Posting Control Key
  • ?
  • Posting Control Key
  • VZZKOPO.[column in domain "RANTYP"] == TZB09.RANTYP
  • VZZKOPO.SBUST == TZB09.SBUST
Area type
  • VZZKOPO.MANDT == TIV08.MANDT
  • VZZKOPO.SFLART == TIV08.SFLART
Calendar ID VZZKOPO.SKALID == TFACD.IDENT
Calendar ID VZZKOPO.SKALID2 == TFACD.IDENT
Condition type
  • Condition Type (Smallest Subdivision of Condition Records)
  • ?
  • VZZKOPO.MANDT == TZK01.MANDT
  • VZZKOPO.SKOART == TZK01.SKOART
  • VZZKOPO.[column in domain "RANTYP"] == TZK01.RANTYP
Detailed description/Reason key
  • Condition Type (Smallest Subdivision of Condition Records)
  • Detailed identification for condition items
  • ?
  • Client
  • VZZKOPO.SKOART == TZK07.SKOART
  • VZZKOPO.SKOPO == TZK07.SKOPO
  • VZZKOPO.[column in domain "RANTYP"] == TZK07.RANTYP
  • VZZKOPO.MANDT == TZK07.MANDT
Partner number
  • Business Partner Number
  • Client
  • VZZKOPO.SPARTNR == BUT000.PARTNER
  • VZZKOPO.MANDT == BUT000.CLIENT
Currency
  • VZZKOPO.MANDT == TCURC.MANDT
  • VZZKOPO.SWHRKOND == TCURC.WAERS
Generate incoming payment immediately
  • Generate Incoming Payment Immediately
  • Client
  • ?
  • VZZKOPO.SZEGEN == TD21.SZEGEN
  • VZZKOPO.MANDT == TD21.MANDT
  • VZZKOPO.[column in domain "RANTYP"] == TD21.RANTYP
Payment form to-the-day
  • VZZKOPO.MANDT == TDZW.MANDT
  • VZZKOPO.SZWKEY == TDZW.SZWKEY
Payment Block Key
  • Payment Block Key
  • Client
  • VZZKOPO.ZAHLS == T008.ZAHLS
  • VZZKOPO.MANDT == T008.MANDT
Payment method
  • Payment Method
  • ?
  • VZZKOPO.MANDT == T042Z.MANDT
  • VZZKOPO.ZLSCH == T042Z.ZLSCH
  • VZZKOPO.[column in domain "LAND1"] == T042Z.LAND1
Payment Block Key
  • Payment Block Key
  • Client
  • VZZKOPO.ZLSPR == T008.ZAHLS
  • VZZKOPO.MANDT == T008.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Form reference VZZKOPO.SFORMREF == AT30.RFORMBEZ
Reference Interest Rate
  • VZZKOPO.MANDT == T056R.MANDT
  • VZZKOPO.SZSREF == T056R.REFERENZ