SAP VICECFRULE Valuation Cash Flow Table
Overview
VICECFRULE is a standard SAP S/4HANA table that stores Valuation Cash Flow data. There are total 90 fields in the VICECFRULE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VICECFRULE belongs to Flexible Real Estate Management (RE-FX) module and is located in the package RE: Cash Flow CE (Evaluation and Cash Flow) (RE_CE_CF).
In addition, following links provide an overview of foreign key relationships, if any, that link VICECFRULE to other SAP tables and standard CDS views available based on VICECFRULE table in S/4HANA 2020.
Techincal Settings of VICECFRULE
Below are technical details of the table VICECFRULE
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VICECFRULE Fields
The following table gives you an overview of the fields available in VICECFRULE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | VICNCN | CHAR | 13 |
| RULEGUID | GUID (RAW16) for Valuation Rule | RECERULEGUID | VICERULE | RAW | 16 |
| PROCESSGUID | GUID (RAW16) for Valuation Process | RECEPROCESSGUID | VICEPROCESS | RAW | 16 |
| CFGUID | GUID (RAW16) for Valuation Cash Flow | RECECFGUID | RAW | 16 | |
| TERMNO | Term Number | RETMTERMNO | CHAR | 4 | |
| CERULE | Valuation Rule | RECECERULE | CHAR | 10 | |
| CFTYPE | Cash Flow Type | RECECFTYPE | CHAR | 1 | |
| CFWHEREFROM | Cash Flow Origin | RECECFWHEREFROM | CHAR | 1 | |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| ASSETOBJNR | Object Number - Asset | RECEASOBJNR | * | CHAR | 22 |
| CONDGUID | GUID (RAW16) for Conditions | RECDCONDGUID | VICDCOND | RAW | 16 |
| CONDVALIDFROM | Date from when condition is valid | RECDVALIDFROM | DATS | 8 | |
| DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | |
| DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | |
| ATAGE | Number of Days | TFMATAGE | INT4 | 10 | |
| DUEDATE | Due Date | RECEDUEDATE | DATS | 8 | |
| DFAELL | Due date | DFAELL | DATS | 8 | |
| DVALUT | Calculation Date | DVALUT | DATS | 8 | |
| BBWHR | Amount which changes position | TFM_BBWHR | CURR | 23 | |
| SWHRKOND | Currency of Condition Item | TFMWHRKOND | * | CUKY | 5 |
| INTERESTRATE | Percentage Rate for Condition Items | PKOND2 | DEC | 15 | |
| ISINITIALCOSTS | Initial? | RECEISINITIALCOSTS | CHAR | 1 | |
| ISREPAYMENTDIF | Liability Difference? | RECEISREPAYMENTDIF | CHAR | 1 | |
| ISDEFERRALSADJUSTMENT | Accrual/Deferral Adjustment? | RECEISDEFERRALSADJUSTMENT | CHAR | 1 | |
| ISRECONOBLIGATION | Asset Retirement Obligation? | RECEISRECONOBLIGATION | CHAR | 1 | |
| ISCOMPLETERETIREMENT | Complete Retirement? | RECEISCOMPLETERETIREMENT | CHAR | 1 | |
| ISRETROACTIVECHANGE | Retroactive change? | RECEISRETROACTIVECHANGE | CHAR | 1 | |
| ISREDUCTION | Reduction? | RECEISREDUCTION | CHAR | 1 | |
| REFGUID | GUID (RAW16) for Document References in Cash Flow | RECDREFGUID | RAW | 16 | |
| REFGUID2 | GUID (RAW16) for Document References in Cash Flow | RECDREFGUID | RAW | 16 | |
| REFGUID3 | GUID (RAW16) for Document References in Cash Flow | RECDREFGUID | RAW | 16 | |
| REFGUID4 | GUID (RAW16) for Document References in Cash Flow | RECDREFGUID | RAW | 16 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| ISREVERSED | Reversed? | RECEISREVERSED | CHAR | 1 | |
| SPLITFORGUID | GUID (RAW16) of Cash Flow Record That Was Split | RECDCFSPLITFORGUID | RAW | 16 | |
| SPLITBASIS | Cash Flow Record Was Basis for Split | RECDCFSPLITBASIS | CHAR | 1 | |
| EVALUATIONPOINT | Time of Valuation | RECEEVALUATIONPOINT | CHAR | 1 | |
| ASSETREDUCTION | Asset Retirement: Percentage Rate | RECEASSETREDUCTION | DEC | 5 | |
| CORRECTIONGUID | GUID (RAW16) for Valuation Correction | RECECORRECTIONGUID | RAW | 16 | |
| VALUATIONENGINE | Evaluation Core | RECEVALUATIONENGINE | CHAR | 1 | |
| LCNETAMOUNT | Net Amount of Cash Flow Item in Local Currency | RECDCFLCVALUENET | CURR | 15 | |
| LCGROSSAMOUNT | Gross Amount of Cash Flow Item in Local Currency | RECDCFLCVALUEGROSS | CURR | 15 | |
| LCTAXAMOUNT | Sales/Purch. Tax Amount of Cash Flow Item in Local Currency | RECDCFLCTAXVALUE | CURR | 15 | |
| LOCALCURR | Local Currency of Cash Flow Item | RECDCFLCCURR | * | CUKY | 5 |
| CCNETAMOUNT | Net Amount of Cash Flow Item in Condition Currency | RECDCFVALUENET | CURR | 15 | |
| CCGROSSAMOUNT | Gross Amount of Cash Flow Item in Condition Currency | RECDCFVALUEGROSS | CURR | 15 | |
| CCTAXAMOUNT | Tax on Sales/Purch. of Cash Flow Item in Condition Currency | RECDCFTAXVALUE | CURR | 15 | |
| CONDCURR | Condition Currency of Cash Flow Item | RECDCFCURR | * | CUKY | 5 |
| TAXTYPE | Tax Type | RERATAXTYPE | TIVRATAXTYPE | CHAR | 4 |
| TAXGROUP | Tax Group | RERATAXGROUP | TIVRATAXGROUP | CHAR | 20 |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| ISGROSS | Condition Amount Is Gross Amount | RECDISGROSS | CHAR | 1 | |
| TAXCOUNTRY | Alternative Tax Reporting Country | RERATAXCOUNTRY | * | CHAR | 3 |
| FLOWTYPE | Flow Type | RECDFLOWTYPE | * | CHAR | 4 |
| ORIGFLOWTYPE | Original Flow Type | RECDORIGFLOWTYPE | * | CHAR | 4 |
| REFFLOWREL | Type of Relationship Between Flow Type and Refer.Flow Type | RECDREFFLOWREL | * | CHAR | 3 |
| CFSTATUS | Indicates Status of Flow | RECDCFSTATUS | CHAR | 1 | |
| FDELETE | Deletion Indicator for Archiving | RECAARDELETEIND | CHAR | 1 | |
| ORIGDUEDATE | Original Due Date | RECDORIGDUEDATE | DATS | 8 | |
| CONDTYPE | Condition Type | RECDCONDTYPE | * | CHAR | 4 |
| POSTINGDATE | Posting Date | RECDPOSTINGDATE | DATS | 8 | |
| DOCUMENTDATE | Document Date | RECDDOCUMENTDATE | DATS | 8 | |
| VALUATIONDATE | Date for Translation of Contract Currency to Local Currency | RECDVALUATIONDATE | DATS | 8 | |
| REVERSAL_FOR | GUID (RAW16) for 'Reversal for' References | RECDREVERSALFORGUID | RAW | 16 | |
| REVERSAL_BY | GUID (RAW16) for 'Reversed by' References | RECDREVERSALBYGUID | RAW | 16 | |
| FOLLOWUP_FOR | GUID (RAW16) for 'Follow-Up Posting for' References | RECDFOLLOWUPFORGUID | RAW | 16 | |
| BOOK_FLOWTYPE | Flow Type | RECDFLOWTYPE | * | CHAR | 4 |
| BOOK_REFFLOWREL | Type of Relationship Between Flow Type and Refer.Flow Type | RECDREFFLOWREL | * | CHAR | 3 |
| TAXDATE | Date of Calculation of Sales/Purchase Tax | RECDTAXDATE | DATS | 8 | |
| MODDUEDATE | Modified Due Date | RECDMODDUEDATE | DATS | 8 | |
| CALCDUEDATE | Calculated Due Date | RECDCALCDUEDATE | DATS | 8 | |
| CTRULE | Currency Translation Rule | RECACTRULE | * | CHAR | 20 |
| CTLCNETAMOUNT | Net Amount in Local Currency | RECACTLCNETAMOUNT | CURR | 15 | |
| CTLCGROSSAMOUNT | Gross Amount in Local Currency | RECACTLCGROSSAMOUNT | CURR | 15 | |
| CTLCTAXAMOUNT | Tax Amount in Local Currency | RECACTLCTAXAMOUNT | CURR | 15 | |
| CTRATE | Exchange Rate | RECACTRATE | DEC | 9 | |
| CTRATEORIG | Exchange Rate | RECACTRATE | DEC | 9 | |
| CTPOSTCDCURR | Post in Condition Currency | RECACTPOSTCDCURR | CHAR | 1 | |
| CTDATEREQ | Planned Translation Date | RECACTDATEREQ | DATS | 8 | |
| CTDATEACT | Actual Translation Date | RECACTDATEACT | DATS | 8 | |
| CTDATEACTORIG | Actual Translation Date | RECACTDATEACT | DATS | 8 | |
| CTDATEFROMCFPOS | Use Translation Date from Cash Flow | RECDCTDATEFROMCFPOS | 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 VICECFRULE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VICECFRULE | CONDGUID | 1: CN | VICDCOND |
| VICECFRULE | INTRENO | 1: CN | VICNCN |
| VICECFRULE | PROCESSGUID | 1: CN | VICEPROCESS |
| VICECFRULE | RULEGUID | 1: CN | VICERULE |
| VICECFRULE | TAXGROUP | 1: CN | TIVRATAXGROUP |
| VICECFRULE | TAXTYPE | 1: CN | TIVRATAXTYPE |