VDCFWAREHOUSE SAP table for – Cash Flow Management

Here we would like to draw your attention to VDCFWAREHOUSE table in SAP. As we know it is being mainly used with the SAP FS-CML (Loans Management in FS) component which is coming under FS module (Financial Services). VDCFWAREHOUSE is a SAP standard transp table used for storing Cash Flow Management related data in SAP. It comes under the package FVVD_REP.

SAP VDCFWAREHOUSE table

Table VDCFWAREHOUSE technical data

TableVDCFWAREHOUSE
Data storingCash Flow Management
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD_REP
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDCFWAREHOUSE Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VDCFWAREHOUSE table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RBOKEY : Business Operation Number (Loans)
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • SCFTYP : Cash Flow Category History
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • DTRANS : Flow data key: System date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TTRANS : Transaction data key: system time
    Its a key field. Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • NTRANS : Transaction data key: Consecutive number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RANL : Contract Number
    Its data type is CHAR (Character String) with field length 13
  • RBO : Business Operation Number (Loans)
    Its data type is CHAR (Character String) with field length 15
  • SBEWART : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Include for Fields in Table TRDC_REC
  • SPLANIST : Plan/actual record/record to be released indicator
    Its data type is CHAR (Character String) with field length 1
  • SREFBEW : Reference flow type
    Its data type is CHAR (Character String) with field length 4
  • SBEWZITI : Flow category
    Its data type is CHAR (Character String) with field length 4
  • SREFZITI : Refer.flow category in accrual/deferral flow records
    Its data type is CHAR (Character String) with field length 4
  • S_SSDREF : Reference flow category in borrower’s note loan flow records
    Its data type is CHAR (Character String) with field length 4
  • SREVALEXCL : Price gains w/o proportionate gains from deferral write-back
    Its data type is CHAR (Character String) with field length 1
  • SWOHER : Source of flow record
    Its data type is CHAR (Character String) with field length 1
  • DGUEL_KK : Date Condition Effective from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SKOART : Condition Type (Smallest Subdivision of Condition Records)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SVORGANG : Business Operation (Activity)
    Its data type is CHAR (Character String) with field length 4
  • ACENV : Source in TR-LO posting area
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DGUEL_KP : Condition Item Valid From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NSTUFE : Level number of condition item for recurring payments
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SVORGKZ : Activity indicator for debit/credit control
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SSOLHAB : Debit/credit indicator
    Its data type is CHAR (Character String) with field length 1
  • SBERFIMA : Calculation category for cash flow calculator
    Its data type is CHAR (Character String) with field length 4
  • SSTCKKZ : Accrued interest method
    Its data type is CHAR (Character String) with field length 1
  • SZBMETH : Interest Calculation Method
    Its data type is CHAR (Character String) with field length 1
  • STGMETH : Daily Method
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • STGBASIS : Base Days Method
    Its data type is CHAR (Character String) with field length 1
  • ABASTAGE : Number of base days in a calculation period
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • PKOND : Percentage rate for condition items
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • DPKOND : Determination date for percentage rate of condition items
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SBASIS : Calculation base indicator
    Its data type is CHAR (Character String) with field length 4
  • JSOFVERR : Immediate settlement
    Its data type is CHAR (Character String) with field length 1
  • DVALUT : Calculation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SINCL : Inclusive indicator for beginning and end of a period
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SVULT : Month-End Indicator for Value Date
    Its data type is CHAR (Character String) with field length 1
  • DBERVON : Start of Calculation Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SEXCLVON : Exclusive Indicator for the Start of a Calculation Period
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SULTVON : Month-End Indicator for Start of a Calculation Period
    Its data type is CHAR (Character String) with field length 1
  • DBERBIS : End of Calculation Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SINCLBIS : Inclusive Indicator for the End of a Calculation Period
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SULTBIS : Month-End Indicator for the End of a Calculation Period
    Its data type is CHAR (Character String) with field length 1
  • ATAGE : Number of days
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • DFAELL : Due date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DDISPO : Payment Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DEPERIOD : Period End
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SPEINCL : Inclusive Indicator for End Date of a Period
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SPEULT : Month-End Indicator for End of a Period
    Its data type is CHAR (Character String) with field length 1
  • DVERRECH : Settlement date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SINCLVERR : Inclusive Indicator for Clearing Date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SULTVERR : Month-End Indicator for Clearing Date
    Its data type is CHAR (Character String) with field length 1
  • DBUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SNWHR : Currency of nominal amount
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BNWHR : Nominal amount
    Its data type is CURR (Currency Field) with field length 13
  • SBWHR : Position Currency (Currency of Position Amount)
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BBWHR : Amount in position currency
    Its data type is CURR (Currency Field) with field length 13
  • SCWHR : Settlement Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BCWHR : Settlement Amount
    Its data type is CURR (Currency Field) with field length 13
  • BHWHR : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • BBASIS : Calculation base amount
    Its data type is CURR (Currency Field) with field length 13
  • PEFFZINS : Effective Interest Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • SEFFMETH : Effective Interest Method (Financial Mathematics)
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • DBPERIOD : Period start
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ZUONR : Assignment number
    Its data type is CHAR (Character String) with field length 18
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • BVTYP : Partner bank type
    Its data type is CHAR (Character String) with field length 4
  • ZLSCH : Payment method
    Its data type is CHAR (Character String) with field length 1
  • MABER : Dunning Area
    Its data type is CHAR (Character String) with field length 2
  • RPARTNR : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • SZEGEN : Generate incoming payment immediately
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • HDN_KUNNR : Main Borrower Customer Number
    Its data type is CHAR (Character String) with field length 10
  • SZART : Payment transaction
    Its data type is CHAR (Character String) with field length 1
  • JONLAEN : Indicator for fixing a flow record
    Its data type is CHAR (Character String) with field length 1
  • VORGTYP : Activity Category (Posting Area)
    Its data type is CHAR (Character String) with field length 4
  • REBZJ : Fiscal Year of the Relevant Invoice (for Credit Memo)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REBZG : Number of the Invoice the Transaction Belongs to
    Its data type is CHAR (Character String) with field length 10
  • REBZZ : Line Item in the Relevant Invoice
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DFAELL_OLD_EXT : Old Due Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DDISPO_OLD_EXT : Old Payment Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RBO_EXT : Business Operation Number (Loans)
    Its data type is CHAR (Character String) with field length 15
  • MANSP : Dunning block
    Its data type is CHAR (Character String) with field length 1
  • ZAHLS : Block Key for Payment
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : SEPA Remittance Information
  • REMIT_INFO : SEPA Payment Notes Information
    Its data type is CHAR (Character String) with field length 140
  • MNDID : Unique Referene to Mandate per Payment Recipient
    Its data type is CHAR (Character String) with field length 35