VDCFWAREHOUSE

Cash Flow Management | #transactional | Component: Loans Management
Column Name Description
MANDT Client
RBOKEY Business Operation Number (Loans)
SCFTYP Cash Flow Category History Show values
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 (TRDC_REC.SNWHR):
BNWHR Nominal amount
BBASIS Calculation Base Amount
💲 Position Currency (Currency of Position Amount) (TRDC_REC.SBWHR):
BBWHR Amount in position currency
💲 Settlement Currency (TRDC_REC.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
DGUEL_KK Date Condition Effective from
DGUEL_KP Condition Item Effective From
DPKOND Fixing Date of Percentage Rate from Condition
DVALUT Calculation Date
DBERVON Start of Calculation Period
DBERBIS End of Calculation Period
DFAELL Due date
DDISPO Payment Date
DEPERIOD Period End
DVERRECH Settlement date
DBUDAT Posting Date in the Document
DBPERIOD Period start
DFAELL_OLD_EXT Old Due Date
DDISPO_OLD_EXT Old Payment Date
Column Name Description
SCFTYP Cash Flow Category History Show values
SPLANIST Plan/actual record/record to be released indicator Show values
SREVALEXCL Price gains w/o proportionate gains from deferral write-back Show values
ACENV Source in TR-LO posting area Show values
SVORGKZ Activity indicator for debit/credit control Show values
SSOLHAB Debit/credit indicator Show values
SSTCKKZ Accrued interest method Show values
SZBMETH Interest Calculation Method Show values
STGMETH Daily Method Show values
STGBASIS Base Days Method Show values
JSOFVERR Immediate settlement Show values
SINCL Inclusive indicator for beginning and end of a period Show values
SVULT Month-End Indicator for Value Date 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
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
SEFFMETH Effective Interest Method (Financial Mathematics) Show values
SZART Payment Transaction Show values
JONLAEN Indicator for fixing a flow record Show values
VORGTYP Activity Category (Posting Area) 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
Column Name Description Domain name
BUKRS Company Code BUKRS
RANL Contract Number RANL
RBO Business Operation Number (Loans) RBO
SBEWART Flow Type SBEWART
SREFBEW Reference flow type SBEWART
SBEWZITI Flow category SBEWZITI
SREFZITI Refer.flow category in accrual/deferral flow records SBEWZITI
S_SSDREF Reference flow category in borrower's note loan flow records SBEWZITI
SWOHER Source of flow record CHAR1
SKOART Condition Type (Smallest Subdivision of Condition Records) SKOART
SVORGANG Business Operation (Activity) SVORFALL
NSTUFE Level number of condition item for recurring payments NUMC2
SBERFIMA Calculation category for cash flow calculator SBEWFIMA
ABASTAGE Number of base days in a calculation period INT6
PKOND Percentage rate for condition items DECV3_7
SBASIS Calculation Base Indicator VVSBASIS
ATAGE Number of Days INT6
PEFFZINS Effective Interest Rate DEC3_7
ZUONR Assignment number ZUONR
SGTXT Item Text TEXT50
KOSTL Cost Center KOSTL
KUNNR Customer Number KUNNR
BVTYP Partner bank type BVTYP
ZLSCH Payment Method ZLSCH
MABER Dunning Area MABER
RPARTNR Business Partner Number BU_PARTNER
SZEGEN Generate Incoming Payment Immediately SZEGEN
HDN_KUNNR Main Borrower Customer Number KUNNR
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
RBO_EXT Business Operation Number (Loans) RBO
MANSP Dunning Block MANSP
ZAHLS Block Key for Payment ZAHLS
REMIT_INFO Payment Notes Info T_REMIT_INFO_LC
MNDID Unique Reference to Mandate for each Payee ID035
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