VDBOBEPP

Business Operation: Entered and Activated Flow Data | #transactional | Component: Loans Management
Column Name Description
MANDT FK Client
BUKRS FK Company Code
RANL Contract Number
DTRANS Flow data key: System date
TTRANS Transaction data key: system time
NTRANS Transaction data key: Consecutive number
Column Name Description
💲 Currency of nominal amount (SNWHR):
BNWHR Nominal amount
BBASIS Calculation Base Amount
BKOND Condition Item Currency Amount
BKARZINS Int.for days betw. redemption clear.and pmnt (FiMa-internal)
BTITALK Imputed annuity repayment amount (FiMa internal)
💲 Position Currency (Currency of Position Amount) (SBWHR):
BBWHR 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
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
DGUEL_KK Date Condition Effective from
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
DTRANSREF Flow data key: System date
TTRANSREF Transaction data key: system time
DSTOCK Premium reserve fund date
DVERRECH Settlement date
DPKOND Fixing Date of Percentage Rate from Condition
DGUEL_KP Condition Item Effective From
DBPERIOD Period start
DEPERIOD Period End
DAUSZ Lead date for withholding amounts for disbursement
ZFBDT Payment Date
DZFEST Interest rate fixing date
DFAELL_OLD_EXT Old Due Date
DDISPO_OLD_EXT Old Payment Date
DIP_DATE Date (Differentiated Incoming Payment)
CA_DTRANS Flow data key: System date
CA_TTRANS Transaction data key: system time
SEPA_PD Posting Date in the Document
Column Name Description
SPLANIST Plan/actual record/record to be released indicator Show values
SSOLHAB Debit/credit indicator Show values
SSTORNO Reversal indicator Show values
SZBMETH Interest Calculation Method Show values
SSPESEN Expenses key 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
JVERF Indicator whether drawings exist for the disbursement Show values
JEINBEHALT Indicator for withholding of amount during disbursement Show values
JVORAUS ID for planned record reference to an advance payment 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
SINCL Inclusive indicator for beginning and end of a period Show values
ZINKZ Exempted from Interest Calculation Show values
SVULT Month-End Indicator for Value Date Show values
JSOFVERR Immediate settlement Show values
SINCLVERR Inclusive Indicator for Clearing Date Show values
SULTVERR Month-End Indicator for Clearing Date Show values
STGBASIS Base Days Method Show values
STGMETH Daily Method Show values
SVORGKZ Activity indicator for debit/credit control 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
SBERECH Grace Period Interest Method Show values
SZART Payment Transaction Show values
SAEND Change Indicator for FiMa Flow Records Show values
XPORE Indicator: Individual Payment? Show values
SPAYRQ Generate Payment Request Show values
VORGTYP Activity Category (Posting Area) Show values
ACENV Source in TR-LO posting area Show values
SSIGN Direction of Flow Show values
SPRSNG Individual Payment Show values
SPRGRD Determine Grouping Definition Show values
SCSPAY Same Direction Necessary for Joint Payment? Show values
JEXPOZINS Type of Compound Interest Calculation Show values
SREVALEXCL Price gains w/o proportionate gains from deferral write-back Show values
SROUND Rounding Category Show values
AMMRHYZV Interest Settlement Frequency for Exponential Interest Calc. Show values
FLG_IP_CLI_NOTICE Payment created by CLI notice Show values
JAVGCAP Use Upper Limit of Average Interest Rate Show values
JAVGFLOOR Use Lower Limit of Average Interest Rate Show values
SROUNDAVGINTEREST Rounding Category of Average Interest Rate Show values
JEXPOINTFACTOR Exponential Interest Calculation with Factor Show values
SFACTORRESET Event for Resetting Factor Calculation Show values
CA_FLG_ORG Flow is orginal flow for customer specific dependent flow(s) 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
SVORGANG Business Operation (Activity) SVORFALL
NVORGANG Activity number CHAR3
SBEWART Flow Type SBEWART
SREFBEW Reference flow type SBEWART
SBEWZITI Flow category SBEWZITI
ZUONR Assignment number ZUONR
RSTBLG Reverse Document Number BELNR
SGTXT Item Text TEXT50
SANLF Product Category VVSANLF
NLFD_ANG Offer consecutive number LFNR3
SSTATI Status of data record STATI
NORDER Order Number NUM8
KURS1 Exchange rate KURSF
KURS2 Exchange rate KURSF
ATAGE Number of Days INT6
ABASTAGE Number of base days in a calculation period INT6
UMSKZ Special G/L Indicator UMSKZ
KOSTL Cost Center KOSTL
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
BVTYP Partner bank type BVTYP
SROLEXT Dummy function CHAR3
RKLAMMER Classification Number for Finance Projects RANL
SZEGEN Generate Incoming Payment Immediately SZEGEN
NTRANSREF Transaction data key: Consecutive number NUMC4
RPNNR Daybook no. VVRPNNR
PWKURS Security price for percentage quotation PWKURS
AMMRHY Frequency in months NUMC03
RUMBLG Reference transfer document number BELNR
SREFZITI Refer.flow category in accrual/deferral flow records SBEWZITI
NSTUFE Level number of condition item for recurring payments NUMC2
RKONT Quota number RKONT
SSOLIST Calculation using actual principle (or debit) CHAR1
RDARNEHM Borrower/Applicant Number BU_PARTNER
RZEBEL Document number of waiver/write-off document BELNR
RUZBEL Document Number of an Accounting Document BELNR
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
REBZG Document No. of the Invoice to Which the Transaction Belongs BELNR
REBZZ Line Item in the Relevant Invoice BUZEI
S_SSDREF Reference flow category in borrower's note loan flow records SBEWZITI
PRKEY Key Number for Payment Request PRQ_KEYNO
ZWELS List of Respected Payment Methods ZWELS
PAYGR Grouping Field for Automatic Payments CHAR20
RBO Business Operation Number (Loans) RBO
SKALIDWT Interest Calendar WFCID
PPAYMENT Payment Rate TFM_PPAYMENT
LC_CAPITALS Effect of the Flow on Capital Amounts Status T_LC_CASH_FLOW
LC_DISBURSE Effect of the Flow on the Disbursement Status T_LC_CASH_FLOW
OP_APPLICATION Open Item Tool: Application Key T_OPAPPL
OP_RBO OI Tool: Locking Business Operation RBO
RBO_EXT Business Operation Number (Loans) RBO
SBEWEGRP2 Flow Record Group in Cash Flow Calculator (Incoming Payment) SBEWEGRP2
MNDID Unique Reference to Mandate for each Payee ID035
SBEWEGRP Flow record group in cash flow calculator SBEWEGRP
REMIT_INFO Payment Notes Info T_REMIT_INFO_LC
AAVGDAYS No. of Days for Interest Calc. with Average Interest Rate INT4
PAVGINTEREST Average Interest Rate DECV5_10
PAVGCAP Upper Limit of Average Interest Rate DECV5_10
PAVGFLOOR Lower Limit of Average Interest Rate DECV5_10
PAVGSPREAD Average Interest Rate Spread DECV5_10
ROUNDDECAVGINTEREST Number of Rounding Decimal Places for Average Interest Rate TFM_ROUNDDECIMALS
AAVGWEIGHT Weighting of Interest Rate INT4
AAVGWEIGHTSUM Cumulative Weighting of Interest Rate INT4
FLOWFACTOR Flow Factor TFM_FACTOR
BASEFACTOR Base Factor TFM_FACTOR
PNON_CUMULATIVE_RATE Non Cumulative Rate DECV5_10
CA_NTRANS Transaction data key: Consecutive number NUMC4
CA_REFERENCE null
BROUNDUNIT Rounding Unit for Amounts TFMSRUNIT
Master Data Relations Join Conditions
Company Code
  • VDBOBEPP.MANDT == T001.MANDT
  • VDBOBEPP.BUKRS == T001.BUKRS
ID (Differentiated Incominmg Payment)
  • ID (Differentiated Incominmg Payment)
  • Client
Business Area
  • VDBOBEPP.MANDT == TGSB.MANDT
  • VDBOBEPP.GSBER == TGSB.GSBER
House Bank Key
  • Short Key for a House Bank
  • Company Code
  • VDBOBEPP.MANDT == T012.MANDT
  • VDBOBEPP.HBKID == T012.HBKID
  • VDBOBEPP.BUKRS == T012.BUKRS
Customer Number
  • VDBOBEPP.MANDT == KNA1.MANDT
  • VDBOBEPP.HDN_KUNNR == KNA1.KUNNR
ID for Account Details
  • Company Code
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • VDBOBEPP.BUKRS == T012K.BUKRS
  • VDBOBEPP.HKTID == T012K.HKTID
  • VDBOBEPP.MANDT == T012K.MANDT
  • VDBOBEPP.HBKID == T012K.HBKID
Customer Number
  • VDBOBEPP.MANDT == KNA1.MANDT
  • VDBOBEPP.KUNNR == KNA1.KUNNR
Dunning Area
  • Dunning Area
  • Company Code
  • VDBOBEPP.MANDT == T047M.MANDT
  • VDBOBEPP.MABER == T047M.MABER
  • VDBOBEPP.BUKRS == T047M.BUKRS
Client VDBOBEPP.MANDT == T000.MANDT
Dunning Lock
  • VDBOBEPP.MANDT == T040S.MANDT
  • VDBOBEPP.MANSP == T040S.MANSP
Sales Tax Indicator
  • ?
  • Tax on sales/purchases code
  • VDBOBEPP.MANDT == T007A.MANDT
  • VDBOBEPP.[column in domain "KALSM_D"] == T007A.KALSM
  • VDBOBEPP.MWSKZ == T007A.MWSKZ
Bank Account
  • Company Code
  • Client
  • Bank account
  • VDBOBEPP.BUKRS == SKB1.BUKRS
  • VDBOBEPP.MANDT == SKB1.MANDT
  • VDBOBEPP.RBANKK == SKB1.SAKNR
Account Credit Posting
  • ?
  • Client
  • Account for credit posting
  • VDBOBEPP.[column in domain "KTOPL"] == SKA1.KTOPL
  • VDBOBEPP.MANDT == SKA1.MANDT
  • VDBOBEPP.RHABEN == SKA1.SAKNR
Partner
  • Business Partner Number
  • Client
  • VDBOBEPP.RPARTNR == BUT000.PARTNER
  • VDBOBEPP.MANDT == BUT000.CLIENT
Account Assignment Reference
  • Company Code
  • ?
  • Account Assignment Reference in Financial Assets Management
  • VDBOBEPP.MANDT == T037S.MANDT
  • VDBOBEPP.BUKRS == T037S.BUKRS
  • VDBOBEPP.[column in domain "RANTYP"] == T037S.RANTYP
  • VDBOBEPP.RREFKONT == T037S.RREFKONT
Account Debit Posting
  • ?
  • Client
  • Account for debit posting
  • VDBOBEPP.[column in domain "KTOPL"] == SKA1.KTOPL
  • VDBOBEPP.MANDT == SKA1.MANDT
  • VDBOBEPP.RSOLL == SKA1.SAKNR
Credit Interim Account
  • ?
  • Client
  • Credit interim account
  • VDBOBEPP.[column in domain "KTOPL"] == SKA1.KTOPL
  • VDBOBEPP.MANDT == SKA1.MANDT
  • VDBOBEPP.RZKHABE == SKA1.SAKNR
Debit Interim Account
  • ?
  • Client
  • Debit interim account
  • VDBOBEPP.[column in domain "KTOPL"] == SKA1.KTOPL
  • VDBOBEPP.MANDT == SKA1.MANDT
  • VDBOBEPP.RZKSOLL == SKA1.SAKNR
Calculation Base Reference
  • ?
  • Calculation base reference
  • VDBOBEPP.[column in domain "RANTYP"] == TZFB.RANTYP
  • VDBOBEPP.SBASIS == TZFB.SBASIS
FiMa Calculation Category VDBOBEPP.SBERFIMA == AT40.SBERFIMA
Debit Posting Key
  • VDBOBEPP.MANDT == TBSL.MANDT
  • VDBOBEPP.SBSLSOLL == TBSL.BSCHL
Posting Account Interim Account Credit
  • VDBOBEPP.MANDT == TBSL.MANDT
  • VDBOBEPP.SBSLZKHA == TBSL.BSCHL
Posting Key Interim Account Debit
  • VDBOBEPP.MANDT == TBSL.MANDT
  • VDBOBEPP.SBSLZKSO == TBSL.BSCHL
Posting Control
  • ?
  • Posting Control Key
  • VDBOBEPP.[column in domain "RANTYP"] == TZB09.RANTYP
  • VDBOBEPP.SBUST == TZB09.SBUST
Currency position
  • VDBOBEPP.MANDT == TCURC.MANDT
  • VDBOBEPP.SBWHR == TCURC.WAERS
Currency settlement
  • VDBOBEPP.MANDT == TCURC.MANDT
  • VDBOBEPP.SCWHR == TCURC.WAERS
Planning Level
  • VDBOBEPP.MANDT == T036.MANDT
  • VDBOBEPP.SFDLEV == T036.EBENE
Credit Posting Key
  • VDBOBEPP.MANDT == TBSL.MANDT
  • VDBOBEPP.SHSLHABEN == TBSL.BSCHL
Condition Type
  • Condition Type (Smallest Subdivision of Condition Records)
  • ?
  • VDBOBEPP.MANDT == TZK01.MANDT
  • VDBOBEPP.SKOART == TZK01.SKOART
  • VDBOBEPP.[column in domain "RANTYP"] == TZK01.RANTYP
Nominal Currency
  • VDBOBEPP.MANDT == TCURC.MANDT
  • VDBOBEPP.SNWHR == TCURC.WAERS
Reason for Reversal
  • VDBOBEPP.MANDT == TZST.MANDT
  • VDBOBEPP.SSTOGRD == TZST.SSTOGRD
Key for Overpayment Reason VDBOBEPP.SUSP_REASON_TYPE == TDSUSPREASON.SSUSPREASON
Payment Method Supplement
  • VDBOBEPP.MANDT == T042F.MANDT
  • VDBOBEPP.UZAWE == T042F.UZAWE
Payment Lock
  • Block Key for Payment
  • Client
  • VDBOBEPP.ZAHLS == T008.ZAHLS
  • VDBOBEPP.MANDT == T008.MANDT
Payment Method
  • Payment Method
  • ?
  • VDBOBEPP.MANDT == T042Z.MANDT
  • VDBOBEPP.ZLSCH == T042Z.ZLSCH
  • VDBOBEPP.[column in domain "LAND1"] == T042Z.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Product Type
  • Company Code
  • Product Type
  • VDBOBEPP.MANDT == TZPAB.MANDT
  • VDBOBEPP.BUKRS == TZPAB.BUKRS
  • VDBOBEPP.GSART == TZPAB.GSART