VICDCFPAY SAP (Payment-Related Cash Flow) Table details
Dictionary Type: Table
Description: Payment-Related Cash Flow
Description: Payment-Related Cash Flow
Table field list including key, data, relationships and ABAP select examples
VICDCFPAY is a standard SAP Table which is used to store Payment-Related Cash Flow data and is available within R/3 SAP systems depending on the version and release level.
The VICDCFPAY table consists of various fields, each holding specific information or linking keys about Payment-Related Cash Flow data available in SAP. These include CFPAYGUID (GUID (RAW16) for Payment-Related Cash Flow), CONDGUID (GUID (RAW16) for Conditions), CONDVALIDFROM (Date from when condition is valid), REFGUID (GUID (RAW16) for Document References in Cash Flow).. 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 VICDCFPAY 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 | |||
CFPAYGUID | GUID (RAW16) for Payment-Related Cash Flow | RECDCFPAYGUID | RAW | 16 | RECAGUID | ||||
CONDGUID | GUID (RAW16) for Conditions | RECDCONDGUID | RAW | 16 | RECAGUID | ||||
CONDVALIDFROM | Date from when condition is valid | RECDVALIDFROM | DATS | 8 | RECADATE | ||||
REFGUID | GUID (RAW16) for Document References in Cash Flow | RECDREFGUID | RAW | 16 | RECAGUID | ||||
INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | RECAINTRENO | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
BBWHR | Amount which changes position | TFM_BBWHR | CURR | 23(2) | TFM_WRTV12 | ||||
BNWHR | Nominal amount | TFM_BNWHR | CURR | 23(2) | TFM_WRTV12 | ||||
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 | ||||
DVALUT | Calculation Date | DVALUT | DATS | 8 | DATUM | ||||
SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
SVINCL | Inclusive indicator for value date | VVSVINCL | NUMC | 1 | VVSINCL | ||||
SVULT | Month-End Indicator for Value Date | VVSVULT | CHAR | 1 | VVSULT | ||||
DFAELL | Due date | DFAELL | DATS | 8 | DATUM | ||||
SFINCL | Inclusive Indicator for Due Date | VVSFINCL | NUMC | 1 | VVSINCL | ||||
SFULT | Month-End Indicator for Due Date | SFULT | CHAR | 1 | VVSULT | ||||
DDISPO | Payment Date | DDISPO | DATS | 8 | DATUM | ||||
SINCLVERR | Inclusive Indicator for Clearing Date | VVSINCLVER | NUMC | 1 | VVSINCLVER | ||||
SULTVERR | Month-End Indicator for Clearing Date | VVSULTVERR | CHAR | 1 | VVSULT | ||||
ATAGE | Number of Days | TFMATAGE | INT4 | 10 | INT4 | ||||
ABASTAGE | Amount in floating point format for recursive determination | BITER | FLTP | 16(16) | BFLTP | ||||
APERTAGE | No. of days of a (calculation) period in cash flow | VVAPERTAGE | NUMC | 6 | INT6 | ||||
STGMETH | Daily Method | VVSTGMETH | NUMC | 1 | VVSTGMETH | ||||
STGBASIS | Base Days Method | VVSTGBASIS | NUMC | 1 | VVSTGBASIS | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
DBPERIOD | Period start | VVDBPERIOD | DATS | 8 | DATUM | ||||
SPAEXCL | Exclusive Indicator for Start Date of a Period | TFMSPAEXCL | NUMC | 1 | TFMSPAEXCL | ||||
SPAULT | Month-End Indicator for Start Date of a Period | TFMSPAULT | CHAR | 1 | VVSULT | ||||
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 | ||||
SWHRKOND | Currency of Condition Item | TFMWHRKOND | CUKY | 5 | Assigned to domain | TFM_WAERS | |||
BKOND | Condition item currency amount | TFM_BKOND | CURR | 17(2) | TFM_WRTV9 | ||||
SSTAFF | Type of Scaled Calculation | TFMSSTAFF | NUMC | 1 | TFMSSTAFF | ||||
SBASIS | Calculation Base Reference | TFM_SBASIS | CHAR | 4 | TFM_SBASIS | ||||
JSOFVERR | Indicator for Immediate Settlement (Financial Mathematics) | TFMSOFVERR | CHAR | 1 | TFMSOFVERR | ||||
AMMRHY | Frequency in months | AMMRHY | NUMC | 3 | NUMC03 | ||||
ATTRHY | Frequency in Days | ATTRHY | NUMC | 3 | NUMC03 | ||||
SSORTZIT | Sort indicator for financial mathematic calculations | TFM_SORT | NUMC | 2 | NUMC2 | ||||
SZEITANT | Indicator for Pro Rata Temporis Calculations | VVSZEITANT | NUMC | 1 | VVSZEITANT | ||||
SSALBAS | Indicator for debit position/incoming pmnt (internal FiMa) | TFMSSALBAS | CHAR | 1 | TFMSSALBAS | ||||
SKONDGRP | Condition group in cash flow calculator | SKONDGRP | NUMC | 4 | SKONDGRP | ||||
LCNETAMOUNT | Net Amount of Cash Flow Item in Local Currency | RECDCFLCVALUENET | CURR | 15(2) | RECACURR | ||||
LCGROSSAMOUNT | Gross Amount of Cash Flow Item in Local Currency | RECDCFLCVALUEGROSS | CURR | 15(2) | RECACURR | ||||
LCTAXAMOUNT | Sales/Purch. Tax Amount of Cash Flow Item in Local Currency | RECDCFLCTAXVALUE | CURR | 15(2) | RECACURR | ||||
LOCALCURR | Local Currency of Cash Flow Item | RECDCFLCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
CCNETAMOUNT | Net Amount of Cash Flow Item in Condition Currency | RECDCFVALUENET | CURR | 15(2) | RECACURR | ||||
CCGROSSAMOUNT | Gross Amount of Cash Flow Item in Condition Currency | RECDCFVALUEGROSS | CURR | 15(2) | RECACURR | ||||
CCTAXAMOUNT | Tax on Sales/Purch. of Cash Flow Item in Condition Currency | RECDCFTAXVALUE | CURR | 15(2) | RECACURR | ||||
CONDCURR | Condition Currency of Cash Flow Item | RECDCFCURR | CUKY | 5 | Assigned to domain | WAERS | |||
TAXTYPE | Tax Type | RERATAXTYPE | CHAR | 4 | TIVRATAXTYPE | RERATAXTYPE | |||
TAXGROUP | Tax Group | RERATAXGROUP | CHAR | 20 | TIVRATAXGROUP | RERATAXGROUP | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
ISGROSS | Condition Amount Is Gross Amount | RECDISGROSS | CHAR | 1 | RECABOOL | ||||
WHEREFROM | Flow Origin | RECDWHEREFROM | CHAR | 1 | RECDWHEREFROM | ||||
FLOWTYPE | Flow Type | RECDFLOWTYPE | CHAR | 4 | TIVCDFLOWTYPE | ALPHA | RECDFLOWTYPE | ||
ORIGFLOWTYPE | Original Flow Type | RECDORIGFLOWTYPE | CHAR | 4 | TIVCDFLOWTYPE | ALPHA | RECDFLOWTYPE | ||
REFFLOWREL | Type of Relationship Between Flow Type and Refer.Flow Type | RECDREFFLOWREL | CHAR | 3 | TIVCDREFFLOWREL | ALPHA | RECDREFFLOWREL | ||
CFSTATUS | Indicates Status of Flow | RECDCFSTATUS | CHAR | 1 | RECDCFSTATUS | ||||
FDLEV | Planning level | FDLEV | CHAR | 2 | Assigned to domain | FDLEV | FFE | ||
FDUPD | Flag as to whether record enters cash management + forecast | FDUPD | CHAR | 1 | KENZX | ||||
FDELETE | Deletion Indicator for Archiving | RECAARDELETEIND | CHAR | 1 | RECABOOL | ||||
ORIGDUEDATE | Original Due Date | RECDORIGDUEDATE | DATS | 8 | DATUM | ||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
PARTNEROBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
CONDTYPE | Condition Type | RECDCONDTYPE | CHAR | 4 | TIVCDCONDTYPE | ALPHA | RECDCONDTYPE | ||
TERMNOPY | Number of Posting Term | RECDTERMNOPY | CHAR | 4 | ALPHA | RETMTERMNO | |||
TERMNORH | Number of Frequency Term | RECDTERMNORH | CHAR | 4 | ALPHA | RETMTERMNO | |||
TERMNOAJ | Number of Adjustment Term | RECDTERMNOAJ | CHAR | 4 | ALPHA | RETMTERMNO | |||
TERMNOOA | Number of Organizational Assignment Term | RECDTERMNOOA | CHAR | 4 | ALPHA | RETMTERMNO | |||
TERMNOSR | Number of Sales Term | RECDTERMNOSR | CHAR | 4 | ALPHA | RETMTERMNO | |||
TERMNOMR | Number of Peak Sales Term | RECDTERMNOMR | CHAR | 4 | ALPHA | RETMTERMNO | |||
TERMNOWT | Number of Withholding Tax Term | RECDTERMNOWT | CHAR | 4 | ALPHA | RETMTERMNO | |||
ORIGEXDUEDATE | Original Due Date | RECDORIGDUEDATE | DATS | 8 | DATUM | ||||
SEAPSTATUS | Status of Advance Payment Relevant to SCS | RERASEAPSTATUS | CHAR | 1 | RERASEAPSTATUS | ||||
POSTINGDATE | Posting Date | RECDPOSTINGDATE | DATS | 8 | RECADATE | ||||
DOCUMENTDATE | Document Date | RECDDOCUMENTDATE | DATS | 8 | RECADATE | ||||
VALUATIONDATE | Date for Translation of Contract Currency to Local Currency | RECDVALUATIONDATE | DATS | 8 | RECADATE | ||||
REVERSAL_FOR | GUID (RAW16) for 'Reversal for' References | RECDREVERSALFORGUID | RAW | 16 | RECAGUID | ||||
REVERSAL_BY | GUID (RAW16) for 'Reversed by' References | RECDREVERSALBYGUID | RAW | 16 | RECAGUID | ||||
FOLLOWUP_FOR | GUID (RAW16) for 'Follow-Up Posting for' References | RECDFOLLOWUPFORGUID | RAW | 16 | RECAGUID | ||||
BOOK_FLOWTYPE | Flow Type | RECDFLOWTYPE | CHAR | 4 | TIVCDFLOWTYPE | ALPHA | RECDFLOWTYPE | ||
BOOK_REFFLOWREL | Type of Relationship Between Flow Type and Refer.Flow Type | RECDREFFLOWREL | CHAR | 3 | TIVCDREFFLOWREL | ALPHA | RECDREFFLOWREL | ||
TAXDATE | Date of Calculation of Sales/Purchase Tax | RECDTAXDATE | DATS | 8 | RECADATE | ||||
MODDUEDATE | Modified Due Date | RECDMODDUEDATE | DATS | 8 | DATUM | ||||
CALCDUEDATE | Calculated Due Date | RECDCALCDUEDATE | DATS | 8 | DATUM | ||||
CFSPLITFORGUID | GUID (RAW16) of Cash Flow Record That Was Split | RECDCFSPLITFORGUID | RAW | 16 | RECAGUID | ||||
CFSPLITBASIS | Cash Flow Record Was Basis for Split | RECDCFSPLITBASIS | CHAR | 1 | RECABOOL | ||||
CDSPLITNO | Number of Condition Split | RETMCDSPLITNO | NUMC | 4 | NUMC4 | ||||
COMPANYCODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
CMCFGROUP | Planning Group | FDGRP | CHAR | 10 | Assigned to domain | ALPHA | FDGRP | FFG | |
CTRULE | Currency Translation Rule | RECACTRULE | CHAR | 20 | Assigned to domain | RECACTRULE | |||
CTLCNETAMOUNT | Net Amount in Local Currency | RECACTLCNETAMOUNT | CURR | 15(2) | RECACURR | ||||
CTLCGROSSAMOUNT | Gross Amount in Local Currency | RECACTLCGROSSAMOUNT | CURR | 15(2) | RECACURR | ||||
CTLCTAXAMOUNT | Tax Amount in Local Currency | RECACTLCTAXAMOUNT | CURR | 15(2) | RECACURR | ||||
CTRATE | Exchange Rate | RECACTRATE | DEC | 9(5) | EXCRT | KURSF | |||
CTRATEORIG | Exchange Rate | RECACTRATE | DEC | 9(5) | EXCRT | KURSF | |||
CTPOSTCDCURR | Post in Condition Currency | RECACTPOSTCDCURR | CHAR | 1 | RECABOOL | ||||
CTDATEREQ | Planned Translation Date | RECACTDATEREQ | DATS | 8 | DATS | ||||
CTDATEACT | Actual Translation Date | RECACTDATEACT | DATS | 8 | DATS | ||||
CTDATEACTORIG | Actual Translation Date | RECACTDATEACT | DATS | 8 | DATS | ||||
CTDATEFROMCFPOS | Use Translation Date from Cash Flow | RECDCTDATEFROMCFPOS | CHAR | 1 | RECABOOL |
Key field | Non-key field |
How do I retrieve data from SAP table VICDCFPAY using ABAP code
The following ABAP code Example will allow you to do a basic selection on VICDCFPAY to SELECT all data from the tableDATA: WA_VICDCFPAY TYPE VICDCFPAY.
SELECT SINGLE *
FROM VICDCFPAY
INTO CORRESPONDING FIELDS OF WA_VICDCFPAY
WHERE...
How to access SAP table VICDCFPAY
Within an ECC or HANA version of SAP you can also view further information about VICDCFPAY 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