VWBEPI

Treasury Securities: Actual Flows - Item | #transactional | Component: Transaction Manager
Column Name Description
MANDT FK Client
BUKRS FK Company Code
RBELNR FK Number of flow header
RPOSNR Activity number
Column Name Description
๐Ÿ’ฒ Stock price currency (SSWHR):
BWKURS Security price for unit quotation
BSWHR Market value
๐Ÿ’ฒ Currency of nominal amount (SNWHR):
BNWHR Nominal amount
BBASIS Calculation Base Amount
๐Ÿ’ฒ Position Currency (Currency of Position Amount) (SBWHR):
BBWHR Amount in position currency
BBWHR_IDX_CLEAN Amount in position currency
๐Ÿ’ฒ 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
DVALUT Interest Value Date/Calculation Date
DDISPO Value Date / Planning Day
DBESTAND Position value date
DBEST6B Date for ยง6b EstG relevant postings
DBERVON Start of Calculation Period
DBERBIS End of Calculation Period
DFAELL Due date
DVERRECH Settlement date
DPKOND Fixing Date of Percentage Rate from Condition
DBPERIOD Period start
DEPERIOD Period End
DGUEL_KP Condition Item Effective From
DCOUPON Coupon date of next delivered coupon
DSCHLUSS Date of business closing
TSCHLUSS Time of business closing
DZFEST Interest rate fixing date
Column Name Description
SSOLHAB Debit/credit indicator Show values
SWHRT Currency swap indicator Show values
JONLAEN Indicator for fixing a flow record Show values
JZINSBAS Flow in interest base Show values
JZINSZPT Interest date Show values
SZBMETH Interest Calculation Method Show values
JEXPOZINS Type of Compound Interest Calculation Show values
SWOHER Treasury: Source of Flow Show values
JSTOCK Premium reserve fund-relevant indicator 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
SINCLVON Inclusive Indicator for the End of a Calculation Period Show values
SULTBIS Month-End Indicator for the End of a Calculation Period Show values
SINCL Inclusive indicator for beginning and end of a period Show values
SVULT Month-End Indicator for Value Date Show values
STGMETH Daily Method Show values
STGBASIS Base Days Method Show values
SPAEXCL Exclusive Indicator for Start Date of a Period Show values
SPAULT Month-End Indicator for Start Date of a Period Show values
SPEINCL Inclusive Indicator for End Date of a Period Show values
SPEULT Month-End Indicator for End of a Period Show values
SINCLVERR Inclusive Indicator for Clearing Date Show values
SULTVERR Month-End Indicator for Clearing Date Show values
SCOUPON Coupon ID for interest and accrued interest calculation Show values
SFLAT Indicator 'Traded flat',i.e.no accrued interest calculation Show values
SVORGKZ Activity indicator for debit/credit control Show values
SINCLBIS Inclusive Indicator for the End of a Calculation Period Show values
SZART Payment Transaction Show values
KGV_FLAG Manages status of the related price gains/losses flows Show values
SPAYRQ Generate Payment Request Show values
SPRSNG Individual Payment Show values
MIGR_CFM10 Status of Flow Related to Migration to CFM 1.0 Show values
MIGR_ERP20 Status of Flow Related to Migration to ERP2.0 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
ASTUECK Number of units for unit-quoted securities ASTUECK
PWKURS Security price for percentage quotation PWKURS
KURS1 Exchange rate KURSF
KURS2 Exchange rate KURSF
SBSLSOLL Posting Key BSCHL
SBSLZKSO Posting Key BSCHL
SBSLZKHA Posting Key BSCHL
SBSLHABEN Posting Key BSCHL
PKOND Percentage rate for condition items DECV3_7
ATAGE Number of Days INT6
ABASTAGE Number of base days in a calculation period INT6
SKALIDWT Interest Calendar WFCID
SREFZITI Refer.flow category in accrual/deferral flow records SBEWZITI
APERTAGE No. of Days of a (Calculation) Period in Cash Flow INT6
NSTUFE Level number of condition item for recurring payments NUMC2
SREFBEW Reference flow type SBEWART
KWKURS Security price VVKWKURS
SBUCHA Indicator for postings to accruals/deferrals accounts CHAR1
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
KMNR Corporate Action Number VKMNR
ERNR ID number of exercised right TER_RIGHTNUMBER
PRKEY Key Number for Payment Request PRQ_KEYNO
RPZAHL Payer/Payee BU_PARTNER
INDEX_VALUE Index Value (Independent of Basis) TIDX_INDEX_VALUE_NO_RATIO
PPAYMENT Payment Rate TFM_PPAYMENT
BUSTRANSID Identifier of the Distributor Business Transaction SYSUUID
LOT_ID Identifier of the Lot SYSUUID
Master Data Relations Join Conditions
Company Code
  • VWBEPI.MANDT == T001.MANDT
  • VWBEPI.BUKRS == T001.BUKRS
Business Transaction Category VWBEPI.BUSTRANSCAT == TRDTS_BT_CAT.BUSTRANSCAT
Foreign Key Customer
  • VWBEPI.MANDT == KNA1.MANDT
  • VWBEPI.KUNNR == KNA1.KUNNR
Client VWBEPI.MANDT == T000.MANDT
Account for credit posting
  • ?
  • Client
  • Account for credit posting
  • VWBEPI.[column in domain "KTOPL"] == SKA1.KTOPL
  • VWBEPI.MANDT == SKA1.MANDT
  • VWBEPI.RHABEN == SKA1.SAKNR
Account for debit posting
  • ?
  • Client
  • Account for debit posting
  • VWBEPI.[column in domain "KTOPL"] == SKA1.KTOPL
  • VWBEPI.MANDT == SKA1.MANDT
  • VWBEPI.RSOLL == SKA1.SAKNR
Credit interim account
  • ?
  • Client
  • Credit interim account
  • VWBEPI.[column in domain "KTOPL"] == SKA1.KTOPL
  • VWBEPI.MANDT == SKA1.MANDT
  • VWBEPI.RZKHABE == SKA1.SAKNR
Debit interim account
  • ?
  • Client
  • Debit interim account
  • VWBEPI.[column in domain "KTOPL"] == SKA1.KTOPL
  • VWBEPI.MANDT == SKA1.MANDT
  • VWBEPI.RZKSOLL == SKA1.SAKNR
FiMa Calculation Category VWBEPI.SBERFIMA == AT40.SBERFIMA
Transaction Type
  • Flow Type
  • Client
  • ?
  • VWBEPI.SBEWART == TZB0A.SBEWART
  • VWBEPI.MANDT == TZB0A.MANDT
  • VWBEPI.[column in domain "RANTYP"] == TZB0A.RANTYP
Flow Category VWBEPI.SBEWZITI == TZB03.SBEWZITI
Position Currency (Currency of Position Amount)
  • VWBEPI.MANDT == TCURC.MANDT
  • VWBEPI.SBWHR == TCURC.WAERS
Settlement Currency
  • VWBEPI.MANDT == TCURC.MANDT
  • VWBEPI.SCWHR == TCURC.WAERS
Condition Type
  • Condition Type (Smallest Subdivision of Condition Records)
  • ?
  • VWBEPI.MANDT == TZK01.MANDT
  • VWBEPI.SKOART == TZK01.SKOART
  • VWBEPI.[column in domain "RANTYP"] == TZK01.RANTYP
Currency of nominal amount
  • VWBEPI.MANDT == TCURC.MANDT
  • VWBEPI.SNWHR == TCURC.WAERS
Currency unit
  • VWBEPI.MANDT == TZUNI.MANDT
  • VWBEPI.SRUNIT == TZUNI.SRUNIT
Stock price currency
  • VWBEPI.MANDT == TCURC.MANDT
  • VWBEPI.SSWHR == TCURC.WAERS