SAP VICERULE Valuation Rule Table
Overview
VICERULE is a standard SAP S/4HANA table that stores Valuation Rule data. There are total 31 fields in the VICERULE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VICERULE belongs to Flexible Real Estate Management (RE-FX) module and is located in the package RE: Terms CE (Evaluation Term) (RE_CE_TM).
In addition, following links provide an overview of foreign key relationships, if any, that link VICERULE to other SAP tables and standard CDS views available based on VICERULE table in S/4HANA 2020.
Techincal Settings of VICERULE
Below are technical details of the table VICERULE
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VICERULE Fields
The following table gives you an overview of the fields available in VICERULE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| RULEGUID | GUID (RAW16) for Valuation Rule | RECERULEGUID | RAW | 16 | |
| TERMNO | Term Number | RETMTERMNO | CHAR | 4 | |
| TERMTYPE | Term Category | RETMTERMTYPE | * | CHAR | 4 |
| VALIDFROM | Valid-From Date of Term | RETMTERMVALIDFROM | DATS | 8 | |
| VALIDTO | Valid-To Date of Term | RETMTERMVALIDTO | DATS | 8 | |
| OBJNR | Valuation Object Number | RECEOBJNR | * | CHAR | 22 |
| OBJVALIDFROM | Date: Relationship Valid From | REBDRELVALIDFROM | DATS | 8 | |
| CERULE | Valuation Rule | RECECERULE | TIVCERULE | CHAR | 10 |
| CONSBEG | Start of Consideration | RECECONSBEG | DATS | 8 | |
| POSTBEG | First Posting From | RECEPOSTBEG | DATS | 8 | |
| ASSETOBJNR | Object Number - Asset | RECEASOBJNR | * | CHAR | 22 |
| CESLTYPE | Valuation Classification | RECECESLTYPE | CHAR | 1 | |
| INTERESTRATE | Interest Rate | RECEINTERESTRATE | DEC | 15 | |
| TERMNORH | Number of Frequency Term | RECETERMNORH | CHAR | 4 | |
| DISTRULE | Distribution Formula | RECDDISTRULE | TIVCDDISTEXT | CHAR | 4 |
| PROBABLEEND | Probable End | RECEPROBABLEEND | DATS | 8 | |
| USEFULLIFEEND | End of Usage RoU | RECEUSEFULLIFEEND | DATS | 8 | |
| STATUSRULE | Status for Valuation Rule | RECESTATUSRULE | CHAR | 1 | |
| STATUSEVAL | Valuation Status | RECESTATUSEVALUATION | CHAR | 1 | |
| STATUSREASON | Status Reason for Valuation Rule | RECESTATUSREASON | CHAR | 1 | |
| PROCESSBEHAVIOR | Valuation Behavior | RECEPROCESSBEHAVIOR | CHAR | 1 | |
| TAXTYPE | Tax Type | RERATAXTYPE | TIVRATAXTYPE | CHAR | 4 |
| TAXGROUP | Tax Group | RERATAXGROUP | * | CHAR | 20 |
| ACCTOBJNR | Object Number Valuation Account Assignment | RECEACCTOBJNR | * | CHAR | 22 |
| NOTE | Valuation Note | RECENOTE | CHAR | 100 | |
| SCOPENUM | Numerator Valuation Factor | RECESCOPENUMERATOR | INT4 | 10 | |
| SCOPEDENOM | Denominator Valuation Factor | RECESCOPEDENOMINATOR | INT4 | 10 | |
| RULECURR | Valuation Rule Currency | RECERULECURR | * | CUKY | 5 |
| QUERYGUID | GUID for Questionnaire | RECEQUERYGUID | RAW | 16 |
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 VICERULE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VICERULE | CERULE | 1: CN | TIVCERULE |
| VICERULE | DISTRULE | : | TIVCDDISTEXT |
| VICERULE | TAXTYPE | C: CN | TIVRATAXTYPE |