VWORDE

Order Data | #transactional | Component: Transaction Manager
Column Name Description
MANDT Client
BUKRS FK Company Code
NORDER Order Number
DTRANS Flow data key: System date
TTRANS Transaction data key: system time
NTRANS Transaction data key: Consecutive number
Column Name Description
๐Ÿ’ฒ Stock price currency (SSWHR):
BWKURS Security price for unit quotation
BLIMIT Limit price for unit quotation
BSWHR Market value
๐Ÿ’ฒ Currency of nominal amount (VWBEPP.SNWHR):
BNWHR Nominal amount
BBASIS Calculation Base Amount
๐Ÿ’ฒ Position Currency (Currency of Position Amount) (VWBEPP.SBWHR):
BBWHR Amount in position currency
๐Ÿ’ฒ Settlement Currency (VWBEPP.SCWHR):
BCWHR Settlement Amount
๐Ÿ’ฒ Currency Key (T001.WAERS):
BHWHR Amount in local currency
Column Name Description
Column Name Description
DTRANS Flow data key: System date
TTRANS Transaction data key: system time
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DVORGANG Activity date
DORDER Order day
DVALUT Interest Value Date/Calculation Date
DDISPO Value Date / Planning Day
DBESTAND Position value date
DBEST6B Date for ยง6b EstG relevant postings
DANST Reservation date
TANST Order time of day
DBERVON Start of Calculation Period
DBERBIS End of Calculation Period
DCOUPON Coupon date of next delivered coupon
DSCHLUSS Date of business closing
TSCHLUSS Time of business closing
DBUDAT Posting Date in the Document
Column Name Description
SSOLHAB Debit/credit indicator Show values
SSPESEN Expenses key Show values
SLIMIT Order notation Show values
JFDUPD Record transferred to cash management and forecast 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
SZBMETH Interest Calculation Method Show values
SFLAT Indicator 'Traded flat',i.e.no accrued interest calculation Show values
SCOUPON Coupon ID for interest and accrued interest calculation Show values
SINCL Inclusive indicator for beginning and end of a period Show values
SFGKZ Release Indicator Show values
SZART Payment Transaction Show values
SEXCLVON Exclusive Indicator for the Start of a Calculation Period Show values
SULTVON Month-End Indicator for Start of a Calculation Period Show values
SINCLBIS Inclusive Indicator for the End of a Calculation Period Show values
SULTBIS Month-End Indicator for the End of a Calculation Period Show values
SDELETE Deletion indicator Show values
SPAYRQ Generate Payment Request Show values
SPRSNG Individual 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
INTEB Financial Assets Management internal level INTEB
SVORGANG Securities-Activity RVORGANG
ASTUECK Number of units for unit-quoted securities ASTUECK
PWKURS Security price for percentage quotation PWKURS
KURS1 Exchange rate KURSF
KURS2 Exchange rate KURSF
PLIMIT Limit price for percentage quotation PWKURS
SROLEXTKO Dummy function CHAR3
SFDLEV Planning Level FDLEV
PKOND Percentage rate for condition items DECV3_7
PEFFZINS Effective Interest Rate DEC3_7
KCROSS Exchange rate KURSF
NORDEXT External order number CHAR20
SWOHER Source of flow record CHAR1
XZUSATZ Assignment CHAR18
SANST Reservation reason SANST
SABRECH Single-Character Flag CHAR1
SVERFALL Single-Character Flag CHAR1
SOBJECT Internal key for object VVKEY
KOSTL Cost Center KOSTL
GSBER Business Area GSBER
ATAGE Number of Days INT6
ABASTAGE Number of base days in a calculation period INT6
SROLEXTZB External role of partner SROLEXT
JVERK6B Single-Character Flag CHAR1
SRUNIT Currency unit VVSRUNIT
KWKURS Security price VVKWKURS
RAHABKI Short Key for Own House Bank HBKID
RAHKTID Short Key for House Bank Account HKTID
RPBANK Partner Bank Details BVTYP
ZLSCH Payment Method ZLSCH
PEFFZCALL Effective Interest Rate DEC3_7
RFHA Financial Transaction T_RFHA
TBEGRU Authorization Group TRBEGRU
ZUOND Assignment TEXT18
REFER Internal Reference CHAR16
MERKM Characteristics CHAR25
RPZAHL Payer/Payee BU_PARTNER
Master Data Relations | to Other Relations โ†“ Join Conditions
Company code
  • VWORDE.MANDT == T001.MANDT
  • VWORDE.BUKRS == T001.BUKRS
ID number
Bank account
  • Company Code
  • Client
  • Bank account
  • VWORDE.BUKRS == SKB1.BUKRS
  • VWORDE.MANDT == SKB1.MANDT
  • VWORDE.RBANKK == SKB1.SAKNR
Reference to Counterparty
  • Reference to Counterparty
  • Client
  • VWORDE.RKONTRA == BUT000.PARTNER
  • VWORDE.MANDT == BUT000.CLIENT
Securities Account
  • Securities Account
  • Company Code
  • VWORDE.MANDT == TWD01.MANDT
  • VWORDE.RLDEPO == TWD01.RLDEPO
  • VWORDE.BUKRS == TWD01.BUKRS
Paying Bank
  • Paying Bank
  • Client
  • VWORDE.RZBANK == BUT000.PARTNER
  • VWORDE.MANDT == BUT000.CLIENT
Flow type
  • Flow Type
  • Client
  • ?
  • VWORDE.SBEWART == TZB0A.SBEWART
  • VWORDE.MANDT == TZB0A.MANDT
  • VWORDE.[column in domain "RANTYP"] == TZB0A.RANTYP
Calculation category VWORDE.SBEWZITI == TZB03.SBEWZITI
Currency
  • VWORDE.MANDT == TCURC.MANDT
  • VWORDE.SBWHR == TCURC.WAERS
Currency
  • VWORDE.MANDT == TCURC.MANDT
  • VWORDE.SCRWHR1 == TCURC.WAERS
Currency
  • VWORDE.MANDT == TCURC.MANDT
  • VWORDE.SCRWHR2 == TCURC.WAERS
Currency
  • VWORDE.MANDT == TCURC.MANDT
  • VWORDE.SCWHR == TCURC.WAERS
Currency
  • VWORDE.MANDT == TCURC.MANDT
  • VWORDE.SNWHR == TCURC.WAERS
Status of data record
  • ?
  • Company Code
  • Status of data record
  • VWORDE.MANDT == TZC37.MANDT
  • VWORDE.[column in domain "VVSART"] == TZC37.GSART
  • VWORDE.BUKRS == TZC37.BUKRS
  • VWORDE.SSTATI == TZC37.STATU
Other Relations | to Master Data Relations โ†‘ Join Conditions
Trader
  • Company Code
  • Trader
  • Client
  • VWORDE.BUKRS == TZDEA.BUKRS
  • VWORDE.RDEALER == TZDEA.RDEALER
  • VWORDE.MANDT == TZDEA.MANDT
Exchange
  • Exchange
  • Client
  • VWORDE.RHANDPL == TWH01.RHANDPL
  • VWORDE.MANDT == TWH01.MANDT