Menu

SAP Table VDORDER

Borrower's note loan order data

The table VDORDER (Borrower's note loan order data) is a standard table in SAP ERP. It belongs to the package FVVD.

Technical Information

Table VDORDER
Short Text Borrower's note loan order data
Package FVVD
Table Type Transparent Table

Fields for Table VDORDER

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 T000
BUKRS Company Code BUKRS CHAR 4 T001
RANL Contract Number RANL CHAR 13
NORDER Order Number NORDER NUMC 8
RERF Entered by RERF CHAR 12
DERF First Entered on DERF DATS 8
TERF Time of Initial Entry TERF TIMS 6
REHER Source of initial entry REHER CHAR 10
RBEAR Employee ID RBEAR CHAR 12
DBEAR Last Edited on DBEAR DATS 8
TBEAR Last Edited at TBEAR TIMS 6
RBHER Editing Source RBHER CHAR 10
SABRECH Status borrower's note order SSDSTAT CHAR 1
SBEWART Flow Type SBEWART CHAR 4 *
SBEWZITI Flow category SBEWZITI CHAR 4 TZB03
SPLANIST Plan/actual record/record to be released indicator SPLANIST CHAR 1
SSOLHAB Debit/credit indicator VVSSOLHAB CHAR 1
SANLF Product Category SANLF NUMC 3 *
SSTATI Order Status VVDSTATORD NUMC 2 *
GSART Product Type VVSART CHAR 3 TZPAB
RREFKONT Account Assignment Reference in Financial Assets Management RREFKONT CHAR 8 T037S
DORDER Order day DORDER DATS 8
BNWHR Nominal amount BNWHR CURR 13
SNWHR Currency of nominal amount SNWHR CUKY 5 TCURC
BBWHR Amount in position currency BBWHR CURR 13
SBWHR Position Currency (Currency of Position Amount) SBWHR CUKY 5 TCURC
BCWHR Settlement Amount BCWHR CURR 13
SCWHR Settlement Currency SCWHR CUKY 5 TCURC
BHWHR Amount in local currency BHWHR CURR 13
KURS1 Exchange rate VVKURSF DEC 9
KURS2 Exchange rate VVKURSF DEC 9
DVALUT Calculation Date DVALUT DATS 8
DFAELL Due date/calculation date DFAELLIG DATS 8
DDISPO Payment Date DDISPO DATS 8
DBESTAND Position value date DBESTAND DATS 8
DBERVON Start of Calculation Period DBERVON DATS 8
DBERBIS End of Calculation Period DBERBIS DATS 8
ATAGE Number of days VVATAGE NUMC 6
ABASTAGE Number of base days in a calculation period ABASTAGE NUMC 6
SZBMETH Interest Calculation Method SZBMETH CHAR 1
JONLAEN Indicator for fixing a flow record JONLAEN CHAR 1
JZINSBAS Flow in interest base JZINSBAS CHAR 1
JZINSZPT Interest date JZINSZPT CHAR 1
PKOND Percentage rate for condition items PKOND DEC 10
BBASIS Calculation base amount BBASIS CURR 13
SSORTZIT Sort indicator for interest/repayment schedule calculations SSORTZIT CHAR 1
SWOHER Source of flow record SWOHER CHAR 1
SSTCKKZ Accrued interest method SSTCKKZ CHAR 1
SSTCKTG Accrued interest: Daily method SSTCKTG CHAR 1
PEFFZINS Effective Interest Rate PEFFZINS DEC 10
SEFFMETH Effective Interest Method (Financial Mathematics) SEFFMETH NUMC 1
PARTNR Business Partner Number BU_PARTNER CHAR 10 BUT000
SROLEXT Dummy function DUMMY_3 CHAR 3
XPART Name of Contact Person (User-Defined Text) XPART CHAR 30
SANRED Form of Address (Key) BP_TITLE_NEW CHAR 4 TSAD3
SWORTL Wording of order/contract SWORTL NUMC 2 TD20
DVKMAX Value date for preemption at the latest by DVKMAX DATS 8
KKASSE Cash price for repeat purchases KKASSE DEC 10
KMARKT Market price for preemptions KMARKT DEC 10
BVTYP Partner Bank Type BVTYP CHAR 4
RBANKK Bank account RBANKK CHAR 10 *
PWKURS Security price for percentage quotation PWKURS DEC 10
SGTXT Item Text SGTXT CHAR 50
RDEALER Trader RDEALER CHAR 12 TZDEA
DVKMIN Preemption payment date Poss. as from DVKMIN DATS 8
ZUONR Assignment Number DZUONR CHAR 18
XPORE Indicator: Individual Payment? PRQ_XPORE CHAR 1
SPAYRQ Generate payment request TB_SPAYRQK CHAR 1
HBKID Short Key for a House Bank HBKID CHAR 5 T012
HKTID ID for account details HKTID CHAR 5 T012K
ZLSCH Payment Method DZLSCH CHAR 1 T042Z
SPRSNG Individual payment TB_SPRSNGK CHAR 1
UZAWE Payment Method Supplement UZAWE CHAR 2 *
SPRGRD Determine grouping definition TB_SPRGRD CHAR 1
SCSPAY Same direction necessary for joint payment? TB_SCSPAY CHAR 1
ZWELS List of the Payment Methods to be Considered DZWELS CHAR 10
PAYGR Grouping Field for Automatic Payments PAYGR CHAR 20