VDORDER SAP table for – Borrower’s note loan order data

Here we would like to draw your attention to VDORDER 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). VDORDER is a SAP standard transp table used for storing Borrower’s note loan order data related data in SAP. It comes under the package FVVD.

SAP VDORDER table

Table VDORDER technical data

TableVDORDER
Data storingBorrower’s note loan order data
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDORDER 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 VDORDER table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • RANL : Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • NORDER : Order Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10
  • SABRECH : Status borrower’s note order
    Its data type is CHAR (Character String) with field length 1
  • SBEWART : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • SBEWZITI : Flow category
    Its data type is CHAR (Character String) with field length 4
  • SPLANIST : Plan/actual record/record to be released indicator
    Its data type is CHAR (Character String) with field length 1
  • SSOLHAB : Debit/credit indicator
    Its data type is CHAR (Character String) with field length 1
  • SANLF : Product Category
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SSTATI : Order Status
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • GSART : Product Type
    Its data type is CHAR (Character String) with field length 3
  • RREFKONT : Account Assignment Reference in Financial Assets Management
    Its data type is CHAR (Character String) with field length 8
  • DORDER : Order day
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BNWHR : Nominal amount
    Its data type is CURR (Currency Field) with field length 13
  • SNWHR : Currency of nominal amount
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BBWHR : Amount in position currency
    Its data type is CURR (Currency Field) with field length 13
  • SBWHR : Position Currency (Currency of Position Amount)
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BCWHR : Settlement Amount
    Its data type is CURR (Currency Field) with field length 13
  • SCWHR : Settlement Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BHWHR : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • KURS1 : Exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • KURS2 : Exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • DVALUT : Calculation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DFAELL : Due date/calculation date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DDISPO : Payment Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBESTAND : Position value date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBERVON : Start of Calculation Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBERBIS : End of Calculation Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ATAGE : Number of days
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • ABASTAGE : Number of base days in a calculation period
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • SZBMETH : Interest Calculation Method
    Its data type is CHAR (Character String) with field length 1
  • JONLAEN : Indicator for fixing a flow record
    Its data type is CHAR (Character String) with field length 1
  • JZINSBAS : Flow in interest base
    Its data type is CHAR (Character String) with field length 1
  • JZINSZPT : Interest date
    Its data type is CHAR (Character String) with field length 1
  • PKOND : Percentage rate for condition items
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • BBASIS : Calculation base amount
    Its data type is CURR (Currency Field) with field length 13
  • SSORTZIT : Sort indicator for interest/repayment schedule calculations
    Its data type is CHAR (Character String) with field length 1
  • SWOHER : Source of flow record
    Its data type is CHAR (Character String) with field length 1
  • SSTCKKZ : Accrued interest method
    Its data type is CHAR (Character String) with field length 1
  • SSTCKTG : Accrued interest: Daily method
    Its data type is CHAR (Character String) with field length 1
  • PEFFZINS : Effective Interest Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • SEFFMETH : Effective Interest Method (Financial Mathematics)
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • PARTNR : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • SROLEXT : Dummy function
    Its data type is CHAR (Character String) with field length 3
  • XPART : Name of Contact Person (User-Defined Text)
    Its data type is CHAR (Character String) with field length 30
  • SANRED : Form of Address (Key)
    Its data type is CHAR (Character String) with field length 4
  • SWORTL : Wording of order/contract
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DVKMAX : Value date for preemption at the latest by
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • KKASSE : Cash price for repeat purchases
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • KMARKT : Market price for preemptions
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • BVTYP : Partner bank type
    Its data type is CHAR (Character String) with field length 4
  • RBANKK : Bank account
    Its data type is CHAR (Character String) with field length 10
  • PWKURS : Security price for percentage quotation
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • RDEALER : Trader
    Its data type is CHAR (Character String) with field length 12
  • DVKMIN : Preemption payment date Poss. as from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ZUONR : Assignment number
    Its data type is CHAR (Character String) with field length 18
  • XPORE : Indicator: Individual Payment?
    Its data type is CHAR (Character String) with field length 1
  • SPAYRQ : Generate payment request
    Its data type is CHAR (Character String) with field length 1
  • HBKID : Short key for a house bank
    Its data type is CHAR (Character String) with field length 5
  • HKTID : ID for account details
    Its data type is CHAR (Character String) with field length 5
  • ZLSCH : Payment method
    Its data type is CHAR (Character String) with field length 1
  • SPRSNG : Individual payment
    Its data type is CHAR (Character String) with field length 1
  • UZAWE : Payment method supplement
    Its data type is CHAR (Character String) with field length 2
  • SPRGRD : Determine grouping definition
    Its data type is CHAR (Character String) with field length 1
  • SCSPAY : Same direction necessary for joint payment?
    Its data type is CHAR (Character String) with field length 1
  • ZWELS : List of the Payment Methods to be Considered
    Its data type is CHAR (Character String) with field length 10
  • PAYGR : Grouping Field for Automatic Payments
    Its data type is CHAR (Character String) with field length 20