SAP VDCFWAREHOUSE Cash Flow Management Table
Overview
VDCFWAREHOUSE is a standard SAP S/4HANA table that stores Cash Flow Management data. There are total 103 fields in the VDCFWAREHOUSE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDCFWAREHOUSE belongs to Loans Management (FS-CML) module and is located in the package Payoff (FVVD_REP).
In addition, following links provide an overview of foreign key relationships, if any, that link VDCFWAREHOUSE to other SAP tables and standard CDS views available based on VDCFWAREHOUSE table in S/4HANA 2020.
Techincal Settings of VDCFWAREHOUSE
Below are technical details of the table VDCFWAREHOUSE
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDCFWAREHOUSE Fields
The following table gives you an overview of the fields available in VDCFWAREHOUSE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| RBOKEY | Business Operation Number (Loans) | RBO | CHAR | 15 | |
| SCFTYP | Cash Flow Category History | TB_SCFTYP | CHAR | 2 | |
| DTRANS | Flow data key: System date | VVDTRANS | DATS | 8 | |
| TTRANS | Transaction data key: system time | VVTTRANS | TIMS | 6 | |
| NTRANS | Transaction data key: Consecutive number | VVNTRANS | NUMC | 4 | |
| BUKRS | Company Code | BUKRS | CHAR | 4 | |
| RANL | Contract Number | RANL | CHAR | 13 | |
| RBO | Business Operation Number (Loans) | RBO | CHAR | 15 | |
| SBEWART | Flow Type | SBEWART | CHAR | 4 | |
| SPLANIST | Plan/actual record/record to be released indicator | SPLANIST | CHAR | 1 | |
| SREFBEW | Reference flow type | SREFBEW | * | CHAR | 4 |
| SBEWZITI | Flow category | SBEWZITI | * | CHAR | 4 |
| SREFZITI | Refer.flow category in accrual/deferral flow records | VVSREFZITI | * | CHAR | 4 |
| S_SSDREF | Reference flow category in borrower's note loan flow records | VVS_SSDREF | * | CHAR | 4 |
| SREVALEXCL | Price gains w/o proportionate gains from deferral write-back | VVSREVALEXCL | CHAR | 1 | |
| SWOHER | Source of flow record | SWOHER | CHAR | 1 | |
| DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | |
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | * | NUMC | 4 |
| SVORGANG | Business Operation (Activity) | SVORFALL | CHAR | 4 | |
| ACENV | Source in TR-LO posting area | ACENV_LO | NUMC | 4 | |
| DGUEL_KP | Condition Item Valid From | DGUEL_KP | DATS | 8 | |
| NSTUFE | Level number of condition item for recurring payments | NSTUFE | NUMC | 2 | |
| SVORGKZ | Activity indicator for debit/credit control | VVSVORGKZ | NUMC | 2 | |
| SSOLHAB | Debit/credit indicator | VVSSOLHAB | CHAR | 1 | |
| SBERFIMA | Calculation category for cash flow calculator | SBEWFIMA | * | CHAR | 4 |
| SSTCKKZ | Accrued interest method | SSTCKKZ | CHAR | 1 | |
| SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | |
| STGMETH | Daily Method | VVSTGMETH | NUMC | 1 | |
| STGBASIS | Base Days Method | VVSTGBASIS | CHAR | 1 | |
| ABASTAGE | Number of base days in a calculation period | ABASTAGE | NUMC | 6 | |
| PKOND | Percentage rate for condition items | PKOND | DEC | 10 | |
| DPKOND | Fixing Date of Percentage Rate from Condition | VVDPKOND | DATS | 8 | |
| SBASIS | Calculation Base Indicator | SBASIS | * | CHAR | 4 |
| JSOFVERR | Immediate settlement | JSOFVERR | CHAR | 1 | |
| DVALUT | Calculation Date | DVALUT | DATS | 8 | |
| SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | |
| SVULT | Month-End Indicator for Value Date | VVSVULT | CHAR | 1 | |
| DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | |
| SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | VVSEXCLVON | NUMC | 1 | |
| SULTVON | Month-End Indicator for Start of a Calculation Period | VVSULTVON | CHAR | 1 | |
| DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | |
| SINCLBIS | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | NUMC | 1 | |
| SULTBIS | Month-End Indicator for the End of a Calculation Period | VVSULTBIS | CHAR | 1 | |
| ATAGE | Number of Days | VVATAGE | NUMC | 6 | |
| DFAELL | Due date | DFAELL | DATS | 8 | |
| DDISPO | Payment Date | DDISPO | DATS | 8 | |
| DEPERIOD | Period End | VVDEPERIOD | DATS | 8 | |
| SPEINCL | Inclusive Indicator for End Date of a Period | TFMSPEINCL | NUMC | 1 | |
| SPEULT | Month-End Indicator for End of a Period | TFMSPEULT | CHAR | 1 | |
| DVERRECH | Settlement date | VVDVERRECH | DATS | 8 | |
| SINCLVERR | Inclusive Indicator for Clearing Date | VVSINCLVER | NUMC | 1 | |
| SULTVERR | Month-End Indicator for Clearing Date | VVSULTVERR | CHAR | 1 | |
| DBUDAT | Posting Date in the Document | BUDAT | DATS | 8 | |
| SNWHR | Currency of nominal amount | SNWHR | * | CUKY | 5 |
| BNWHR | Nominal amount | BNWHR | CURR | 13 | |
| SBWHR | Position Currency (Currency of Position Amount) | SBWHR | * | CUKY | 5 |
| BBWHR | Amount in position currency | BBWHR | CURR | 13 | |
| SCWHR | Settlement Currency | SCWHR | * | CUKY | 5 |
| BCWHR | Settlement Amount | BCWHR | CURR | 13 | |
| BHWHR | Amount in local currency | BHWHR | CURR | 13 | |
| BBASIS | Calculation Base Amount | BBASIS | CURR | 13 | |
| PEFFZINS | Effective Interest Rate | PEFFZINS | DEC | 10 | |
| SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | |
| DBPERIOD | Period start | VVDBPERIOD | DATS | 8 | |
| ZUONR | Assignment number | DZUONR | CHAR | 18 | |
| SGTXT | Item Text | SGTXT | CHAR | 50 | |
| KOSTL | Cost Center | KOSTL | CHAR | 10 | |
| KUNNR | Customer Number | KUNNR | CHAR | 10 | |
| BVTYP | Partner bank type | BVTYP | CHAR | 4 | |
| ZLSCH | Payment Method | DZLSCH | CHAR | 1 | |
| MABER | Dunning Area | MABER | CHAR | 2 | |
| RPARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | |
| SZEGEN | Generate Incoming Payment Immediately | SZEGEN | NUMC | 2 | |
| HDN_KUNNR | Main Borrower Customer Number | HDN_KUNNR | CHAR | 10 | |
| SZART | Payment Transaction | TB_SZART | CHAR | 1 | |
| JONLAEN | Indicator for fixing a flow record | JONLAEN | CHAR | 1 | |
| VORGTYP | Activity Category (Posting Area) | VORGTYP_LO | CHAR | 4 | |
| REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | |
| REBZG | Document No. of the Invoice to Which the Transaction Belongs | REBZG | CHAR | 10 | |
| REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | |
| DFAELL_OLD_EXT | Old Due Date | TB_EXTENS_DFAELL_OLD | DATS | 8 | |
| DDISPO_OLD_EXT | Old Payment Date | TB_EXTENS_DDISPO_OLD | DATS | 8 | |
| RBO_EXT | Business Operation Number (Loans) | RBO | CHAR | 15 | |
| MANSP | Dunning Block | MANSP | CHAR | 1 | |
| ZAHLS | Block Key for Payment | DZAHLS | CHAR | 1 | |
| REMIT_INFO | Payment Notes Info | TB_REMIT_INFO | CHAR | 140 | |
| MNDID | Unique Reference to Mandate for each Payee | SEPA_MNDID | CHAR | 35 | |
| AAVGDAYS | No. of Days for Interest Calc. with Average Interest Rate | TFM_AAVGDAYS | INT4 | 10 | |
| PAVGINTEREST | Average Interest Rate | TFM_PAVGINTEREST | DEC | 15 | |
| JAVGCAP | Use Upper Limit of Average Interest Rate | TFM_JAVGCAP | CHAR | 1 | |
| PAVGCAP | Upper Limit of Average Interest Rate | TFM_PAVGCAP | DEC | 15 | |
| JAVGFLOOR | Use Lower Limit of Average Interest Rate | TFM_JAVGFLOOR | CHAR | 1 | |
| PAVGFLOOR | Lower Limit of Average Interest Rate | TFM_PAVGFLOOR | DEC | 15 | |
| PAVGSPREAD | Average Interest Rate Spread | TFM_PAVGSPREAD | DEC | 15 | |
| SROUNDAVGINTEREST | Rounding Category of Average Interest Rate | TFM_SROUNDAVGINTEREST | CHAR | 1 | |
| ROUNDDECAVGINTEREST | Number of Rounding Decimal Places for Average Interest Rate | TFM_ROUNDDECAVGINTEREST | INT1 | 3 | |
| AAVGWEIGHT | Weighting of Interest Rate | TFM_AWEIGHT | INT4 | 10 | |
| AAVGWEIGHTSUM | Cumulative Weighting of Interest Rate | TFM_AWEIGHTSUM | INT4 | 10 | |
| JEXPOINTFACTOR | Exponential Interest Calculation with Factor | TFM_JEXPOINTFACTOR | CHAR | 1 | |
| FLOWFACTOR | Flow Factor | TFM_FLOWFACTOR | D34R | 34 | |
| BASEFACTOR | Base Factor | TFM_BASEFACTOR | D34R | 34 | |
| SFACTORRESET | Event for Resetting Factor Calculation | TFM_SFACTORRESET | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VDCFWAREHOUSE