SAP TABLES | Financial Services | Loans Management(FS-CML) SAP FS

VDCFWAREHOUSE SAP Cash Flow Management Table and data







VDCFWAREHOUSE is a standard SAP Table which is used to store Cash Flow Management data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP VDCFWAREHOUSE Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP VDCFWAREHOUSE Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3
*
Client
RBOKEYRBOCHAR15 Business Operation Number (Loans)
SCFTYPTB_SCFTYPCHAR2 Cash Flow Category History
DTRANSVVDTRANSDATS8 Flow data key: System date
TTRANSVVTTRANSTIMS6 Transaction data key: system time
NTRANSVVNTRANSNUMC4 Transaction data key: Consecutive number
BUKRSBUKRSCHAR4
*
Company Code
RANLRANLCHAR13 Contract NumberALPHA
RBORBOCHAR15 Business Operation Number (Loans)
SBEWARTSBEWARTCHAR4
*
Flow Type
.INCLUDERTRDC_REC_FIELDS Include for Fields in Table TRDC_REC
SPLANISTSPLANISTCHAR1 Plan/actual record/record to be released indicator
SREFBEWSREFBEWCHAR4
*
Reference flow type
SBEWZITISBEWZITICHAR4
*
Flow category
SREFZITIVVSREFZITICHAR4
*
Refer.flow category in accrual/deferral flow records
S_SSDREFVVS_SSDREFCHAR4
*
Reference flow category in borrower's note loan flow records
SREVALEXCLVVSREVALEXCLCHAR1 Price gains w/o proportionate gains from deferral write-back
SWOHERSWOHERCHAR1 Source of flow record
DGUEL_KKDGUELDATS8 Date Condition Effective from
SKOARTSKOARTNUMC4
*
Condition Type (Smallest Subdivision of Condition Records)
SVORGANGSVORFALLCHAR4 Business Operation (Activity)
ACENVACENV_LONUMC4 Source in TR-LO posting area
DGUEL_KPDGUEL_KPDATS8 Condition Item Valid From
NSTUFENSTUFENUMC2 Level number of condition item for recurring payments
SVORGKZVVSVORGKZNUMC2 Activity indicator for debit/credit control
SSOLHABVVSSOLHABCHAR1 Debit/credit indicator
SBERFIMASBEWFIMACHAR4
*
Calculation category for cash flow calculator
SSTCKKZSSTCKKZCHAR1 Accrued interest method
SZBMETHSZBMETHCHAR1 Interest Calculation Method
STGMETHVVSTGMETHNUMC1 Daily Method
STGBASISVVSTGBASISNUMC1 Base Days Method
ABASTAGEABASTAGENUMC6 Number of base days in a calculation period
PKONDPKONDDEC10(7) Percentage rate for condition items
DPKONDVVDPKONDDATS8 Determination date for percentage rate of condition items
SBASISSBASISCHAR4
*
Calculation base indicator
JSOFVERRJSOFVERRCHAR1 Immediate settlement
DVALUTDVALUTDATS8 Calculation Date
SINCLVVSINCLNUMC1 Inclusive indicator for beginning and end of a period
SVULTVVSVULTCHAR1 Month-End Indicator for Value Date


DBERVONDBERVONDATS8 Start of Calculation Period
SEXCLVONVVSEXCLVONNUMC1 Exclusive Indicator for the Start of a Calculation Period
SULTVONVVSULTVONCHAR1 Month-End Indicator for Start of a Calculation Period
DBERBISDBERBISDATS8 End of Calculation Period
SINCLBISVVSINCLBISNUMC1 Inclusive Indicator for the End of a Calculation Period
SULTBISVVSULTBISCHAR1 Month-End Indicator for the End of a Calculation Period
ATAGEVVATAGENUMC6 Number of days
DFAELLDFAELLDATS8 Due date
DDISPODDISPODATS8 Payment Date
DEPERIODVVDEPERIODDATS8 Period End
SPEINCLTFMSPEINCLNUMC1 Inclusive Indicator for End Date of a Period
SPEULTTFMSPEULTCHAR1 Month-End Indicator for End of a Period
DVERRECHVVDVERRECHDATS8 Settlement date
SINCLVERRVVSINCLVERNUMC1 Inclusive Indicator for Clearing Date
SULTVERRVVSULTVERRCHAR1 Month-End Indicator for Clearing Date
DBUDATBUDATDATS8 Posting Date in the Document
SNWHRSNWHRCUKY5
*
Currency of nominal amount
BNWHRBNWHRCURR13(2) Nominal amount
SBWHRSBWHRCUKY5
*
Position Currency (Currency of Position Amount)
BBWHRBBWHRCURR13(2) Amount in position currency
SCWHRSCWHRCUKY5
*
Settlement Currency
BCWHRBCWHRCURR13(2) Settlement Amount
BHWHRBHWHRCURR13(2) Amount in local currency
BBASISBBASISCURR13(2) Calculation base amount
PEFFZINSPEFFZINSDEC10(7) Effective Interest Rate
SEFFMETHSEFFMETHNUMC1 Effective Interest Method (Financial Mathematics)
DBPERIODVVDBPERIODDATS8 Period start
ZUONRDZUONRCHAR18 Assignment Number
SGTXTSGTXTCHAR50 Item Text
KOSTLKOSTLCHAR10
*
Cost CenterALPHA
KUNNRKUNNRCHAR10
*
Customer NumberALPHA
BVTYPBVTYPCHAR4 Partner Bank Type
ZLSCHDZLSCHCHAR1
*
Payment Method
MABERMABERCHAR2
*
Dunning Area
RPARTNRBP_PARTNR_NEWCHAR10
*
Business Partner NumberALPHA
SZEGENSZEGENNUMC2
*
Generate incoming payment immediately
HDN_KUNNRHDN_KUNNRCHAR10
*
Main Borrower Customer NumberALPHA
SZARTTB_SZARTCHAR1 Payment transaction
JONLAENJONLAENCHAR1 Indicator for fixing a flow record


VORGTYPVORGTYP_LOCHAR4 Activity Category (Posting Area)
REBZJREBZJNUMC4 Fiscal Year of the Relevant Invoice (for Credit Memo)GJAHR
REBZGREBZGCHAR10 Number of the Invoice the Transaction Belongs toALPHA
REBZZREBZZNUMC3 Line Item in the Relevant Invoice
DFAELL_OLD_EXTTB_EXTENS_DFAELL_OLDDATS8 Old Due Date
DDISPO_OLD_EXTTB_EXTENS_DDISPO_OLDDATS8 Old Payment Date
RBO_EXTRBOCHAR15 Business Operation Number (Loans)
MANSPMANSPCHAR1
*
Dunning block
ZAHLSDZAHLSCHAR1
*
Block Key for Payment
.INCLUDERSEPA_INFO Payment Notes Info
REMIT_INFOTB_REMIT_INFOCHAR140 Payment Notes Info
MNDIDSEPA_MNDIDCHAR35 Unique Referene to Mandate per Payment Recipient



Key field
Non-key field