VDESCROWKOPO0 SAP table for – TEMPORARY USE: Escrow Condition Items

Here we would like to draw your attention to VDESCROWKOPO0 table in SAP. As we know it is being mainly used with the SAP FS-CML (Loans Management in FS) component which is coming under FS module (Financial Services). VDESCROWKOPO0 is a SAP standard transp table used for storing TEMPORARY USE: Escrow Condition Items related data in SAP. It comes under the package FVVD_ESCROW.

SAP VDESCROWKOPO0 table

Table VDESCROWKOPO0 technical data

TableVDESCROWKOPO0
Data storingTEMPORARY USE: Escrow Condition Items
ModuleFS
Sub ModuleFS-CML-BD-MD
SAP PackageFVVD_ESCROW
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDESCROWKOPO0 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VDESCROWKOPO0 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Escrow Key
    Its a key field.
  • MGUID : GUID
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • DGUEL_KK : Start of Effective Period for Escrow Analysis
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SKOART : Payment Type (Condition Type)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • DGUEL_KP : Escrow Condition Item Effective from
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NSTUFE : Level Number of Escrow Item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • SSTATE : Status of the Payment Plan
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • MCONTREF : Reference to (Insurance) Policy
    Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : Structure VZZKOPO_BODY
  • SSTATI : Status of data record
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PKOND : Percentage rate for condition items
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • BKOND : Condition item currency amount
    Its data type is CURR (Currency Field) with field length 13
  • SWHRKOND : Currency of Condition Item
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • SBASIS : Calculation base reference
    Its data type is CHAR (Character String) with field length 4
  • SZSREF : Reference Interest Rate
    Its data type is CHAR (Character String) with field length 10
  • SZSREFVZ : +/- sign / reference interest rate operator
    Its data type is CHAR (Character String) with field length 1
  • PFLUCT : Fluctuation margin
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • AMMRHY : Frequency in months
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ATTRHY : Frequency in Days
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SZAWS : Payment form (at start of period, mid-period, at period end)
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • RDIVNR : Dividend coupon number
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • JNULLKON : Condition Form
    Its data type is CHAR (Character String) with field length 1
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • JBMONAT : Indicator for calculating amount per month
    Its data type is CHAR (Character String) with field length 1
  • DVALUT : Calculation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DFAELL : Due date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • ZLSCH : Payment method
    Its data type is CHAR (Character String) with field length 1
  • BVTYP : Partner bank type
    Its data type is CHAR (Character String) with field length 4
  • MABER : Dunning Area
    Its data type is CHAR (Character String) with field length 2
  • SPARTNR : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • RKONT : Quota number
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • SVULT : Month-end indicator for calculation date
    Its data type is CHAR (Character String) with field length 1
  • SFULT : Month-End Indicator for Due Date
    Its data type is CHAR (Character String) with field length 1
  • SVKALRI : Field is no longer used
    Its data type is CHAR (Character String) with field length 1
  • SFKALRI : Calculation of periods with flexible valid-to date?
    Its data type is CHAR (Character String) with field length 1
  • AVGSTAGE : Number of working days for value date
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • AFGSTAGE : Number of working days to due date
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SVKALZUS : Field is no longer used
    Its data type is CHAR (Character String) with field length 1
  • SFKALZUS : Field is no longer used
    Its data type is CHAR (Character String) with field length 1
  • SKALID : Factory calendar
    Its data type is CHAR (Character String) with field length 2
  • SZBMETH : Interest Calculation Method
    Its data type is CHAR (Character String) with field length 1
  • JSOFVERR : Immediate settlement
    Its data type is CHAR (Character String) with field length 1
  • DALLGEM : General date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SZEGEN : Generate incoming payment immediately
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SBUST : Posting control key
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SKOPO : Detailed identification for condition items
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SALTKOND : Bracket condition for alternative conditions
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SZINSANP : Cross-referenced condition grp for interest rate adjustment
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SINCL : Inclusive indicator for beginning and end of a period
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SFORMREF : Formula reference for the cash flow calculator
    Its data type is CHAR (Character String) with field length 4
  • SVARNAME : Description of variables in cash flow calculator
    Its data type is CHAR (Character String) with field length 4
  • SVWERK : Shift calculation date to working day
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SVMETH : Method for determining the next value date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SFWERK : Shift due date to working day
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SFMETH : Method for determining the next due date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • DPKOND : Determination date for percentage rate of condition items
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AZGSTAGE : Number of working days for interest fixing
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SZKALRI : Calendar direction for interest rate fixing
    Its data type is CHAR (Character String) with field length 1
  • DZSREF : Date fixing for benchmark interest rate in cash flow
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SKALID2 : Calendar ID 2 (valid in connection with calendar ID 1)
    Its data type is CHAR (Character String) with field length 2
  • JGESUCHT : Int. indicator for alternative calculations
    Its data type is CHAR (Character String) with field length 1
  • KURS1 : Exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • BBASIS : Calculation base amount
    Its data type is CURR (Currency Field) with field length 13
  • SZWERK : Shift to working day for interest fixing date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SFINCL : Inclusive Indicator for Due Date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SRUNDVORF : Rounding of interim results for prepayments
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SZWKEY : Payment form with adjustment days
    Its data type is CHAR (Character String) with field length 2
  • SFVMETH : Update method for calculation date/due date
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SDWERK : Working Day Shift for Payment Date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SBERECH : Grace Period Interest Method
    Its data type is CHAR (Character String) with field length 1
  • JPROZR : Percentage Calculation
    Its data type is CHAR (Character String) with field length 1
  • SZEITANT : Indicator for Pro Rata Temporis Calculations
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SFANT : Indicator for due date-related FiMa calculations
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SFRANZ : Shift Due Date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • KBKOND : Condition amount independent of currency
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SBASFIX : Indicator for fixing calculation base
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • MANSP : Dunning block
    Its data type is CHAR (Character String) with field length 1
  • ZAHLS : Payment Block Key
    Its data type is CHAR (Character String) with field length 1
  • BKONDQM : Currency amount per area unit
    Its data type is CURR (Currency Field) with field length 13
  • JAREA : Rental on basis of area?
    Its data type is CHAR (Character String) with field length 1
  • SFLART : Area type
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • AVGSTAGEVZ : +/- sign for number of working days for value date
    Its data type is CHAR (Character String) with field length 1
  • AFGSTAGEVZ : +/- sign for number of working days for due date
    Its data type is CHAR (Character String) with field length 1
  • LIFNR : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • JEXPOZINS : Exponential Interest Calculation
    Its data type is CHAR (Character String) with field length 1
  • KOSTL : Cost center of internal contract
    Its data type is CHAR (Character String) with field length 10
  • GFZLSCH : Payment method for credit memos
    Its data type is CHAR (Character String) with field length 1
  • ZLSPR : Payment Block Key
    Its data type is CHAR (Character String) with field length 1
  • SROUND : Rounding Category
    Its data type is CHAR (Character String) with field length 1
  • SKALIDWT : Interest Calendar
    Its data type is CHAR (Character String) with field length 2
  • BMWST : Value-added tax amount included
    Its data type is CURR (Currency Field) with field length 13
  • XCROSS : Gross amount indicator
    Its data type is CHAR (Character String) with field length 1
  • PPAYMENT : Payment Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • AMMRHYZV : Interest Settlement Frequency for Exponential Interest Calc.
    Its data type is NUMC (Character String with Digits Only) with field length 2