VDORDER

Borrower's note loan order data | #masterdata | Component: Loans Management
Column Name Description
MANDT FK Client
BUKRS FK Company Code
RANL Contract Number
NORDER Order Number
Column Name Description
💲 Currency of nominal amount (SNWHR):
BNWHR Nominal amount
💲 Position Currency (Currency of Position Amount) (SBWHR):
BBWHR Amount in position currency
BBASIS Calculation Base Amount
💲 Settlement Currency (SCWHR):
BCWHR Settlement Amount
💲 Currency Key (T001.WAERS):
BHWHR Amount in local currency
Column Name Description
Column Name Description
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DORDER Order day
DVALUT Calculation Date
DFAELL Due date/calculation date
DDISPO Payment Date
DBESTAND Position value date
DBERVON Start of Calculation Period
DBERBIS End of Calculation Period
DVKMAX Value date for preemption at the latest by
DVKMIN Preemption payment date Poss. as from
Column Name Description
SABRECH Status borrower's note order Show values
SPLANIST Plan/actual record/record to be released indicator Show values
SSOLHAB Debit/credit indicator Show values
SZBMETH Interest Calculation Method Show values
JONLAEN Indicator for fixing a flow record Show values
JZINSBAS Flow in interest base Show values
JZINSZPT Interest date Show values
SSTCKKZ Accrued interest method Show values
SSTCKTG Accrued interest: Daily method Show values
SEFFMETH Effective Interest Method (Financial Mathematics) Show values
XPORE Indicator: Individual Payment? Show values
SPAYRQ Generate Payment Request Show values
SPRSNG Individual Payment Show values
SPRGRD Determine Grouping Definition Show values
SCSPAY Same Direction Necessary for Joint Payment? Show values
Column Name Description Domain name
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
SBEWART Flow Type SBEWART
SANLF Product Category VVSANLF
SSTATI Order Status STATI
KURS1 Exchange rate KURSF
KURS2 Exchange rate KURSF
ATAGE Number of Days INT6
ABASTAGE Number of base days in a calculation period INT6
PKOND Percentage rate for condition items DECV3_7
SSORTZIT Sort indicator for interest/repayment schedule calculations CHAR1
SWOHER Source of flow record CHAR1
PEFFZINS Effective Interest Rate DEC3_7
SROLEXT Dummy function CHAR3
XPART Name of Contact Person (User-Defined Text) XMBEZ
KKASSE Cash price for repeat purchases DEC3_7
KMARKT Market price for preemptions DEC3_7
BVTYP Partner bank type BVTYP
RBANKK Bank account SAKNR
PWKURS Security price for percentage quotation PWKURS
SGTXT Item Text TEXT50
ZUONR Assignment number ZUONR
UZAWE Payment method supplement UZAWE
ZWELS List of Respected Payment Methods ZWELS
PAYGR Grouping Field for Automatic Payments CHAR20
Master Data Relations | to Other Relations ↓ Join Conditions
Company Code
  • VDORDER.MANDT == T001.MANDT
  • VDORDER.BUKRS == T001.BUKRS
Short Key for a House Bank
  • Short Key for a House Bank
  • Company Code
  • VDORDER.MANDT == T012.MANDT
  • VDORDER.HBKID == T012.HBKID
  • VDORDER.BUKRS == T012.BUKRS
ID for Account Details
  • Company Code
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • VDORDER.BUKRS == T012K.BUKRS
  • VDORDER.HKTID == T012K.HKTID
  • VDORDER.MANDT == T012K.MANDT
  • VDORDER.HBKID == T012K.HBKID
Client VDORDER.MANDT == T000.MANDT
Business Partner Number
  • Business Partner Number
  • Client
  • VDORDER.PARTNR == BUT000.PARTNER
  • VDORDER.MANDT == BUT000.CLIENT
Account Assignment Reference
  • Company Code
  • ?
  • Account Assignment Reference in Financial Assets Management
  • VDORDER.MANDT == T037S.MANDT
  • VDORDER.BUKRS == T037S.BUKRS
  • VDORDER.[column in domain "RANTYP"] == T037S.RANTYP
  • VDORDER.RREFKONT == T037S.RREFKONT
Form of Address (Key)
  • Form of Address (Key)
  • Client
  • VDORDER.SANRED == TSAD3.TITLE
  • VDORDER.MANDT == TSAD3.CLIENT
Flow Category VDORDER.SBEWZITI == TZB03.SBEWZITI
Currency
  • VDORDER.MANDT == TCURC.MANDT
  • VDORDER.SBWHR == TCURC.WAERS
Currency
  • VDORDER.MANDT == TCURC.MANDT
  • VDORDER.SCWHR == TCURC.WAERS
Currency
  • VDORDER.MANDT == TCURC.MANDT
  • VDORDER.SNWHR == TCURC.WAERS
Wording of Order
  • Wording of order/contract
  • Client
  • VDORDER.SWORTL == TD20.SWORTL
  • VDORDER.MANDT == TD20.MANDT
Payment Method
  • Payment Method
  • ?
  • VDORDER.MANDT == T042Z.MANDT
  • VDORDER.ZLSCH == T042Z.ZLSCH
  • VDORDER.[column in domain "LAND1"] == T042Z.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Product Type
  • Company Code
  • Product Type
  • VDORDER.MANDT == TZPAB.MANDT
  • VDORDER.BUKRS == TZPAB.BUKRS
  • VDORDER.GSART == TZPAB.GSART
Trader
  • Company Code
  • Trader
  • Client
  • VDORDER.BUKRS == TZDEA.BUKRS
  • VDORDER.RDEALER == TZDEA.RDEALER
  • VDORDER.MANDT == TZDEA.MANDT