VDCFWAREHOUSE SAP (Cash Flow Management) Table details
Dictionary Type: Table
Description: Cash Flow Management
Description: Cash Flow Management
ABAP Code to SELECT data from VDCFWAREHOUSE
Related tables to VDCFWAREHOUSE
Access table VDCFWAREHOUSE
Related tables to VDCFWAREHOUSE
Access table VDCFWAREHOUSE
Table field list including key, data, relationships and ABAP select examples
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.
The VDCFWAREHOUSE table consists of various fields, each holding specific information or linking keys about Cash Flow Management data available in SAP. These include RBOKEY (Business Operation Number (Loans)), SCFTYP (Cash Flow Category History), DTRANS (Flow data key: System date), TTRANS (Transaction data key: system time).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VDCFWAREHOUSE table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
RBOKEY | Business Operation Number (Loans) | RBO | CHAR | 15 | RBO | ||||
SCFTYP | Cash Flow Category History | TB_SCFTYP | CHAR | 2 | T_SCFTYP | ||||
DTRANS | Flow data key: System date | VVDTRANS | DATS | 8 | DATUM | ||||
TTRANS | Transaction data key: system time | VVTTRANS | TIMS | 6 | UZEIT | ||||
NTRANS | Transaction data key: Consecutive number | VVNTRANS | NUMC | 4 | NUMC4 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
RBO | Business Operation Number (Loans) | RBO | CHAR | 15 | RBO | ||||
SBEWART | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
SPLANIST | Plan/actual record/record to be released indicator | SPLANIST | CHAR | 1 | SPLANIST | ||||
SREFBEW | Reference flow type | SREFBEW | CHAR | 4 | Assigned to domain | SBEWART | |||
SBEWZITI | Flow category | SBEWZITI | CHAR | 4 | Assigned to domain | SBEWZITI | |||
SREFZITI | Refer.flow category in accrual/deferral flow records | VVSREFZITI | CHAR | 4 | Assigned to domain | SBEWZITI | |||
S_SSDREF | Reference flow category in borrower's note loan flow records | VVS_SSDREF | CHAR | 4 | Assigned to domain | SBEWZITI | |||
SREVALEXCL | Price gains w/o proportionate gains from deferral write-back | VVSREVALEXCL | CHAR | 1 | XFELD | ||||
SWOHER | Source of flow record | SWOHER | CHAR | 1 | CHAR1 | ||||
DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | DATUM | ||||
SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 4 | Assigned to domain | SKOART | |||
SVORGANG | Business Operation (Activity) | SVORFALL | CHAR | 4 | SVORFALL | ||||
ACENV | Source in TR-LO posting area | ACENV_LO | NUMC | 4 | ACENV_LO | ||||
DGUEL_KP | Condition Item Valid From | DGUEL_KP | DATS | 8 | DATUM | ||||
NSTUFE | Level number of condition item for recurring payments | NSTUFE | NUMC | 2 | NUMC2 | ||||
SVORGKZ | Activity indicator for debit/credit control | VVSVORGKZ | NUMC | 2 | VVSVORGKZ | ||||
SSOLHAB | Debit/credit indicator | VVSSOLHAB | CHAR | 1 | VVSSOLHAB | ||||
SBERFIMA | Calculation category for cash flow calculator | SBEWFIMA | CHAR | 4 | Assigned to domain | SBEWFIMA | |||
SSTCKKZ | Accrued interest method | SSTCKKZ | CHAR | 1 | SSTCKKZ | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
STGMETH | Daily Method | VVSTGMETH | NUMC | 1 | VVSTGMETH | ||||
STGBASIS | Base Days Method | VVSTGBASIS | NUMC | 1 | VVSTGBASIS | ||||
ABASTAGE | Number of base days in a calculation period | ABASTAGE | NUMC | 6 | INT6 | ||||
PKOND | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
DPKOND | Determination date for percentage rate of condition items | VVDPKOND | DATS | 8 | DATUM | ||||
SBASIS | Calculation base indicator | SBASIS | CHAR | 4 | Assigned to domain | VVSBASIS | |||
JSOFVERR | Immediate settlement | JSOFVERR | CHAR | 1 | TFMSOFVERR | ||||
DVALUT | Calculation Date | DVALUT | DATS | 8 | DATUM | ||||
SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
SVULT | Month-End Indicator for Value Date | VVSVULT | CHAR | 1 | VVSULT | ||||
DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | DATUM | ||||
SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | VVSEXCLVON | NUMC | 1 | VVSEXCLVON | ||||
SULTVON | Month-End Indicator for Start of a Calculation Period | VVSULTVON | CHAR | 1 | VVSULT | ||||
DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | DATUM | ||||
SINCLBIS | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | NUMC | 1 | VVSINCLBIS | ||||
SULTBIS | Month-End Indicator for the End of a Calculation Period | VVSULTBIS | CHAR | 1 | VVSULT | ||||
ATAGE | Number of days | VVATAGE | NUMC | 6 | INT6 | ||||
DFAELL | Due date | DFAELL | DATS | 8 | DATUM | ||||
DDISPO | Payment Date | DDISPO | DATS | 8 | DATUM | ||||
DEPERIOD | Period End | VVDEPERIOD | DATS | 8 | DATUM | ||||
SPEINCL | Inclusive Indicator for End Date of a Period | TFMSPEINCL | NUMC | 1 | TFMSPEINCL | ||||
SPEULT | Month-End Indicator for End of a Period | TFMSPEULT | CHAR | 1 | VVSULT | ||||
DVERRECH | Settlement date | VVDVERRECH | DATS | 8 | DATUM | ||||
SINCLVERR | Inclusive Indicator for Clearing Date | VVSINCLVER | NUMC | 1 | VVSINCLVER | ||||
SULTVERR | Month-End Indicator for Clearing Date | VVSULTVERR | CHAR | 1 | VVSULT | ||||
DBUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
SNWHR | Currency of nominal amount | SNWHR | CUKY | 5 | Assigned to domain | WAERS | |||
BNWHR | Nominal amount | BNWHR | CURR | 13(2) | WERTV7 | ||||
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
BBWHR | Amount in position currency | BBWHR | CURR | 13(2) | WERTV7 | ||||
SCWHR | Settlement Currency | SCWHR | CUKY | 5 | Assigned to domain | WAERS | |||
BCWHR | Settlement Amount | BCWHR | CURR | 13(2) | WERTV7 | ||||
BHWHR | Amount in local currency | BHWHR | CURR | 13(2) | WERTV7 | ||||
BBASIS | Calculation base amount | BBASIS | CURR | 13(2) | WERTV7 | ||||
PEFFZINS | Effective Interest Rate | PEFFZINS | DEC | 10(7) | DEC3_7 | ||||
SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
DBPERIOD | Period start | VVDBPERIOD | DATS | 8 | DATUM | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
MABER | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
RPARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
SZEGEN | Generate incoming payment immediately | SZEGEN | NUMC | 2 | Assigned to domain | SZEGEN | |||
HDN_KUNNR | Main Borrower Customer Number | HDN_KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
SZART | Payment transaction | TB_SZART | CHAR | 1 | XFELD | ||||
JONLAEN | Indicator for fixing a flow record | JONLAEN | CHAR | 1 | VVSONLAEN | ||||
VORGTYP | Activity Category (Posting Area) | VORGTYP_LO | CHAR | 4 | VORGTYP_LO | ||||
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | BUZEI | ||||
DFAELL_OLD_EXT | Old Due Date | TB_EXTENS_DFAELL_OLD | DATS | 8 | DATUM | ||||
DDISPO_OLD_EXT | Old Payment Date | TB_EXTENS_DDISPO_OLD | DATS | 8 | DATUM | ||||
RBO_EXT | Business Operation Number (Loans) | RBO | CHAR | 15 | RBO | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | Assigned to domain | MANSP | |||
ZAHLS | Block Key for Payment | DZAHLS | CHAR | 1 | Assigned to domain | ZAHLS | |||
REMIT_INFO | Payment Notes Info | TB_REMIT_INFO | CHAR | 140 | T_REMIT_INFO | ||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 |
Key field | Non-key field |
How do I retrieve data from SAP table VDCFWAREHOUSE using ABAP code
The following ABAP code Example will allow you to do a basic selection on VDCFWAREHOUSE to SELECT all data from the tableDATA: WA_VDCFWAREHOUSE TYPE VDCFWAREHOUSE.
SELECT SINGLE *
FROM VDCFWAREHOUSE
INTO CORRESPONDING FIELDS OF WA_VDCFWAREHOUSE
WHERE...
How to access SAP table VDCFWAREHOUSE
Within an ECC or HANA version of SAP you can also view further information about VDCFWAREHOUSE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects