SAP Table VDORDER - Borrower's note loan order data

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
BUKRS X BUKRS CHAR 3 4 0 T001 Company Code
RANL X RANL CHAR 7 13 0 Contract Number
NORDER X NORDER NUMC 20 8 0 Order Number
RERF RERF CHAR 28 12 0 Entered by
DERF DERF DATS 40 8 0 First Entered on
TERF TERF TIMS 48 6 0 Time of Initial Entry
REHER REHER CHAR 54 10 0 Source of initial entry
RBEAR RBEAR CHAR 64 12 0 Employee ID
DBEAR DBEAR DATS 76 8 0 Last Edited on
TBEAR TBEAR TIMS 84 6 0 Last Edited at
RBHER RBHER CHAR 90 10 0 Editing Source
SABRECH SSDSTAT CHAR 100 1 0 Status borrower's note order
SBEWART SBEWART CHAR 101 4 0 TZB0A Flow Type
SBEWZITI SBEWZITI CHAR 105 4 0 TZB03 Flow category
SPLANIST SPLANIST CHAR 109 1 0 Plan/actual record/record to be released indicator
SSOLHAB VVSSOLHAB CHAR 110 1 0 Debit/credit indicator
SANLF SANLF NUMC 111 3 0 TZAF Product Category
SSTATI VVDSTATORD NUMC 114 2 0 TZC37 Order Status
GSART VVSART CHAR 116 3 0 TZPA Product Type
RREFKONT RREFKONT CHAR 119 8 0 T037S Account Assignment Reference in Financial Assets Management
DORDER DORDER DATS 127 8 0 Order day
BNWHR BNWHR CURR 135 13 2 Nominal amount
SNWHR SNWHR CUKY 142 5 0 TCURC Currency of nominal amount
BBWHR BBWHR CURR 147 13 2 Amount in position currency
SBWHR SBWHR CUKY 154 5 0 TCURC Position Currency (Currency of Position Amount)
BCWHR BCWHR CURR 159 13 2 Settlement Amount
SCWHR SCWHR CUKY 166 5 0 TCURC Settlement Currency
BHWHR BHWHR CURR 171 13 2 Amount in local currency
KURS1 VVKURSF DEC 178 9 5 Exchange rate
KURS2 VVKURSF DEC 183 9 5 Exchange rate
DVALUT DVALUT DATS 188 8 0 Calculation Date
DFAELL DFAELLIG DATS 196 8 0 Due date/calculation date
DDISPO DDISPO DATS 204 8 0 Payment Date
DBESTAND DBESTAND DATS 212 8 0 Position value date
DBERVON DBERVON DATS 220 8 0 Start of Calculation Period
DBERBIS DBERBIS DATS 228 8 0 End of Calculation Period
ATAGE VVATAGE NUMC 236 6 0 Number of days
ABASTAGE ABASTAGE NUMC 242 6 0 Number of base days in a calculation period
SZBMETH SZBMETH CHAR 248 1 0 Interest Calculation Method
JONLAEN JONLAEN CHAR 249 1 0 Indicator for fixing a flow record
JZINSBAS JZINSBAS CHAR 250 1 0 Flow in interest base
JZINSZPT JZINSZPT CHAR 251 1 0 Interest date
PKOND PKOND DEC 252 10 7 Percentage rate for condition items
BBASIS BBASIS CURR 258 13 2 Calculation base amount
SSORTZIT SSORTZIT CHAR 265 1 0 Sort indicator for interest/repayment schedule calculations
SWOHER SWOHER CHAR 266 1 0 Source of flow record
SSTCKKZ SSTCKKZ CHAR 267 1 0 Accrued interest method
SSTCKTG SSTCKTG CHAR 268 1 0 Accrued interest: Daily method
PEFFZINS PEFFZINS DEC 269 10 7 Effective Interest Rate
SEFFMETH SEFFMETH NUMC 275 1 0 Effective Interest Method (Financial Mathematics)
PARTNR BU_PARTNER CHAR 276 10 0 Business Partner Number
SROLEXT DUMMY_3 CHAR 286 3 0 Dummy function
XPART XPART CHAR 289 30 0 Name of Contact Person (User-Defined Text)
SANRED BP_TITLE_NEW CHAR 319 4 0 TSAD3 Form of Address (Key)
SWORTL SWORTL NUMC 323 2 0 Wording of order/contract
DVKMAX DVKMAX DATS 325 8 0 Value date for preemption at the latest by
KKASSE KKASSE DEC 333 10 7 Cash price for repeat purchases
KMARKT KMARKT DEC 339 10 7 Market price for preemptions
BVTYP BVTYP CHAR 345 4 0 Partner Bank Type
RBANKK RBANKK CHAR 349 10 0 Bank account
PWKURS PWKURS DEC 359 10 7 Security price for percentage quotation
SGTXT SGTXT CHAR 365 50 0 Item Text
RDEALER RDEALER CHAR 415 12 0 TZDEA Trader
DVKMIN DVKMIN DATS 427 8 0 Preemption payment date Poss. as from
ZUONR DZUONR CHAR 435 18 0 Assignment Number
XPORE PRQ_XPORE CHAR 453 1 0 Indicator: Individual Payment?
SPAYRQ TB_SPAYRQK CHAR 454 1 0 Generate payment request
HBKID HBKID CHAR 455 5 0 T012 Short Key for a House Bank
HKTID HKTID CHAR 460 5 0 T012K ID for Account Details
ZLSCH DZLSCH CHAR 465 1 0 T042E Payment Method
SPRSNG TB_SPRSNGK CHAR 466 1 0 Individual payment
UZAWE UZAWE CHAR 467 2 0 Payment Method Supplement
SPRGRD TB_SPRGRD CHAR 469 1 0 Determine grouping definition
SCSPAY TB_SCSPAY CHAR 470 1 0 Same direction necessary for joint payment?
ZWELS DZWELS CHAR 471 10 0 List of the Payment Methods to be Considered
PAYGR PAYGR CHAR 481 20 0 Grouping Field for Automatic Payments