SAP Table VDCFWAREHOUSE - Cash Flow Management

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
RBOKEY X RBO CHAR 3 15 0 Business Operation Number (Loans)
SCFTYP X TB_SCFTYP CHAR 18 2 0 Cash Flow Category History
DTRANS X VVDTRANS DATS 20 8 0 Flow data key: System date
TTRANS X VVTTRANS TIMS 28 6 0 Transaction data key: system time
NTRANS X VVNTRANS NUMC 34 4 0 Transaction data key: Consecutive number
BUKRS BUKRS CHAR 38 4 0 T001 Company Code
RANL RANL CHAR 42 13 0 Contract Number
RBO RBO CHAR 55 15 0 Business Operation Number (Loans)
SBEWART SBEWART CHAR 70 4 0 TZB0A Flow Type
SPLANIST SPLANIST CHAR 74 1 0 Plan/actual record/record to be released indicator
SREFBEW SREFBEW CHAR 75 4 0 TZB0A Reference flow type
SBEWZITI SBEWZITI CHAR 79 4 0 TZB03 Flow category
SREFZITI VVSREFZITI CHAR 83 4 0 TZB03 Refer.flow category in accrual/deferral flow records
S_SSDREF VVS_SSDREF CHAR 87 4 0 TZB03 Reference flow category in borrower's note loan flow records
SREVALEXCL VVSREVALEXCL CHAR 91 1 0 Price gains w/o proportionate gains from deferral write-back
SWOHER SWOHER CHAR 92 1 0 Source of flow record
DGUEL_KK DGUEL DATS 93 8 0 Date Condition Effective from
SKOART SKOART NUMC 101 4 0 TZK01 Condition Type (Smallest Subdivision of Condition Records)
SVORGANG SVORFALL CHAR 105 4 0 Business Operation (Activity)
ACENV ACENV_LO NUMC 109 4 0 Source in TR-LO posting area
DGUEL_KP DGUEL_KP DATS 113 8 0 Condition Item Effecitve from
NSTUFE NSTUFE NUMC 121 2 0 Level number of condition item for recurring payments
SVORGKZ VVSVORGKZ NUMC 123 2 0 Activity indicator for debit/credit control
SSOLHAB VVSSOLHAB CHAR 125 1 0 Debit/credit indicator
SBERFIMA SBEWFIMA CHAR 126 4 0 Calculation Category for Cash Flow Calculator
SSTCKKZ SSTCKKZ CHAR 130 1 0 Accrued interest method
SZBMETH SZBMETH CHAR 131 1 0 Interest Calculation Method
STGMETH VVSTGMETH NUMC 132 1 0 Daily Method
STGBASIS VVSTGBASIS NUMC 133 1 0 Base Days Method
ABASTAGE ABASTAGE NUMC 134 6 0 Number of base days in a calculation period
PKOND PKOND DEC 140 10 7 Percentage rate for condition items
DPKOND VVDPKOND DATS 146 8 0 Determination date for percentage rate of condition items
SBASIS SBASIS CHAR 154 4 0 TZFB Calculation base indicator
JSOFVERR JSOFVERR CHAR 158 1 0 Immediate settlement
DVALUT DVALUT DATS 159 8 0 Calculation Date
SINCL VVSINCL NUMC 167 1 0 Inclusive indicator for beginning and end of a period
SVULT VVSVULT CHAR 168 1 0 Month-End Indicator for Value Date
DBERVON DBERVON DATS 169 8 0 Start of Calculation Period
SEXCLVON VVSEXCLVON NUMC 177 1 0 Exclusive Indicator for the Start of a Calculation Period
SULTVON VVSULTVON CHAR 178 1 0 Month-End Indicator for Start of a Calculation Period
DBERBIS DBERBIS DATS 179 8 0 End of Calculation Period
SINCLBIS VVSINCLBIS NUMC 187 1 0 Inclusive Indicator for the End of a Calculation Period
SULTBIS VVSULTBIS CHAR 188 1 0 Month-End Indicator for the End of a Calculation Period
ATAGE VVATAGE NUMC 189 6 0 Number of days
DFAELL DFAELL DATS 195 8 0 Due date
DDISPO DDISPO DATS 203 8 0 Payment Date
DEPERIOD VVDEPERIOD DATS 211 8 0 Period End
SPEINCL TFMSPEINCL NUMC 219 1 0 Inclusive Indicator for End Date of a Period
SPEULT TFMSPEULT CHAR 220 1 0 Month-End Indicator for End of a Period
DVERRECH VVDVERRECH DATS 221 8 0 Settlement date
SINCLVERR VVSINCLVER NUMC 229 1 0 Inclusive Indicator for Clearing Date
SULTVERR VVSULTVERR CHAR 230 1 0 Month-End Indicator for Clearing Date
DBUDAT BUDAT DATS 231 8 0 Posting Date in the Document
SNWHR SNWHR CUKY 239 5 0 TCURC Currency of nominal amount
BNWHR BNWHR CURR 244 13 2 Nominal amount
SBWHR SBWHR CUKY 251 5 0 TCURC Position Currency (Currency of Position Amount)
BBWHR BBWHR CURR 256 13 2 Amount in position currency
SCWHR SCWHR CUKY 263 5 0 TCURC Settlement Currency
BCWHR BCWHR CURR 268 13 2 Settlement Amount
BHWHR BHWHR CURR 275 13 2 Amount in local currency
BBASIS BBASIS CURR 282 13 2 Calculation base amount
PEFFZINS PEFFZINS DEC 289 10 7 Effective Interest Rate
SEFFMETH SEFFMETH NUMC 295 1 0 Effective Interest Method (Financial Mathematics)
DBPERIOD VVDBPERIOD DATS 296 8 0 Period start
ZUONR DZUONR CHAR 304 18 0 Assignment Number
SGTXT SGTXT CHAR 322 50 0 Item Text
KOSTL KOSTL CHAR 372 10 0 Cost Center
KUNNR KUNNR CHAR 382 10 0 KNA1 Customer Number
BVTYP BVTYP CHAR 392 4 0 Partner Bank Type
ZLSCH DZLSCH CHAR 396 1 0 T042E Payment Method
MABER MABER CHAR 397 2 0 T047M Dunning Area
RPARTNR BP_PARTNR_NEW CHAR 399 10 0 Business Partner Number
SZEGEN SZEGEN NUMC 409 2 0 TD21 Generate incoming payment immediately
HDN_KUNNR HDN_KUNNR CHAR 411 10 0 KNA1 Main Borrower Customer Number
SZART TB_SZART CHAR 421 1 0 Payment transaction
JONLAEN JONLAEN CHAR 422 1 0 Indicator for fixing a flow record
VORGTYP VORGTYP_LO CHAR 423 4 0 Activity Category (Posting Area)
REBZJ REBZJ NUMC 427 4 0 Fiscal Year of the Relevant Invoice (for Credit Memo)
REBZG REBZG CHAR 431 10 0 Number of the Invoice the Transaction Belongs to
REBZZ REBZZ NUMC 441 3 0 Line Item in the Relevant Invoice
DFAELL_OLD_EXT TB_EXTENS_DFAELL_OLD DATS 444 8 0 Old Due Date
DDISPO_OLD_EXT TB_EXTENS_DDISPO_OLD DATS 452 8 0 Old Payment Date
RBO_EXT RBO CHAR 460 15 0 Business Operation Number (Loans)
MANSP MANSP CHAR 475 1 0 T040S Dunning Block
ZAHLS DZAHLS CHAR 476 1 0 Block Key for Payment
REMIT_INFO TB_REMIT_INFO CHAR 477 140 0 SEPA Payment Notes Information
MNDID SEPA_MNDID CHAR 617 35 0 SEPA Mandate: Unique Referene to Mandate per Vendor