SAP VIAJRULE Contract/Rental Object: Adjustment Rule Table
Overview
VIAJRULE is a standard SAP S/4HANA table that stores Contract/Rental Object: Adjustment Rule data. There are total 63 fields in the VIAJRULE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIAJRULE belongs to Rent Adjustment (RE-FX-AJ) module and is located in the package RE: Terms - Adjustment (RE_AJ_TM).
In addition, following links provide an overview of foreign key relationships, if any, that link VIAJRULE to other SAP tables and standard CDS views available based on VIAJRULE table in S/4HANA 2020.
Techincal Settings of VIAJRULE
Below are technical details of the table VIAJRULE
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIAJRULE Fields
The following table gives you an overview of the fields available in VIAJRULE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| TERMNO | Term Number | RETMTERMNO | CHAR | 4 | |
| ADJMRULE | Adjustment Rule | REAJADJMRULE | TIVAJRULE | CHAR | 10 |
| ADJMSUBRULE | Elementary Adjustment Rule (Part of Comb. Rule) | REAJADJMSUBRULE | TIVAJRULE | CHAR | 10 |
| VALIDFROM | Valid-From Date of Term | RETMTERMVALIDFROM | DATS | 8 | |
| VALIDTO | Valid-To Date of Term | RETMTERMVALIDTO | DATS | 8 | |
| ADJMMETH | Adjustment Method | REAJADJMMETH | TIVAJMETH | CHAR | 4 |
| ISRULECOMB | Indicator: Adjustment Rule Is Combined Rule | REAJISRULECOMB | CHAR | 1 | |
| ISPARTCOMB | Adjustment Rule Is Usable Only As Part of Combined Rule | REAJISPARTCOMB | CHAR | 1 | |
| APPROVAL | Indicator: Approval for Adjustment Required? | REAJAPPROVAL | CHAR | 1 | |
| ACTIFNOAPPR | Indicator: Activation Without Approval Possible | REAJACTIFNOAPPR | CHAR | 1 | |
| DTCHANGEABLE | Indicator: Is valid-from date manually changeable? | REAJDTCHANGEABLE | CHAR | 1 | |
| PERCENTAGEPASS | Percentage with Which the Adjustment Amount Is Passed-On | REAJPERCENTAGEPASS | DEC | 5 | |
| USERORATEINC | Consider Percentage Rate of Increase of Rental Object | REAJUSERORATEINC | CHAR | 1 | |
| ADJMDIRECTION | In which direction (+/-/=) can the amount change? | REAJADJMDIRECTION | CHAR | 1 | |
| CHANGEDIRECTION | How (+/-/=) Can the Amount Be Changed After Adjustment | REAJCHANGEDIRECTION | CHAR | 1 | |
| RHYTHM | Adjustment Frequency | REAJRHYTHM | NUMC | 3 | |
| RHYTHMUNIT | Adjustment Frequency: Unit | REAJRHYTHMUNIT | NUMC | 1 | |
| RHYTHMBEGIN | Indicator: Calculate Minimum Interval from Frequency Start? | REAJRHYTHMBEGIN | CHAR | 1 | |
| SIMULATIONRULE | Indicator: Adjustment Rule Is Allowed for Simulation Only | REAJSIMULATIONRULE | CHAR | 1 | |
| NODOCUMENT | Indicator: No Adjustment Document | REAJNODOCUMENT | CHAR | 1 | |
| RULECHANGEABLE | Is the rule data in the contract/rental object modifiable? | REAJRULECHANGEABLE | NUMC | 1 | |
| FADJMDIRECTION | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| FPERCENTAGEPASS | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| FUSERORATEINC | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| FRHYTHM | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| FRHYTHMUNIT | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| FRHYTHMBEGIN | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| FSIMULATIONRULE | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| FNODOCUMENT | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| FAPPROVAL | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| FACTIFNOAPPR | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| FDTCHANGEABLE | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| FCHANGEDIRECTION | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| RULEEXPAND | Expanded display of rule data in contract/rental object? | REAJRULEEXPAND | NUMC | 1 | |
| ADJMCOTYPE | Influence on Subsequent Conditions | REAJADJMCOTYPE | CHAR | 1 | |
| FADJMCOTYPE | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| NEXTADJMNOTICE | Adjustment on Next Possible Notice Date | REAJNEXTADJMNOTICE | CHAR | 1 | |
| FNEXTADJMNOTICE | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| ADJMBASE | Adjustment Basis | REAJADJMBASE | NUMC | 1 | |
| FADJMBASE | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| ISRHYTHMMINDIST | Obsolete: Adjustment Frequency Is Minimum Interval | REAJISRHYTHMMINDIST | CHAR | 1 | |
| FISRHYTHMMINDIST | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| SIMDISABLED | Simulation Not Allowed in Dialog | REAJSIMDISABLED | CHAR | 1 | |
| EXEDISABLED | Not Allowed to Be Executed Online | REAJEXEDISABLED | CHAR | 1 | |
| REVDISABLED | Reversal Not Allowed in Dialog | REAJREVDISABLED | CHAR | 1 | |
| AUTODEFAULT | Automatic Default Only | REAJAUTODEFAULT | CHAR | 1 | |
| ANNOUNCE | Notification Required for Adjustment? | REAJANNOUNCE | CHAR | 1 | |
| FANNOUNCE | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| BLOCKREASON | Reason for Adjustment Lock | REAJBLOCKREASON | TIVAJBLOCKREAS | CHAR | 10 |
| FBLOCKREASON | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| RULEORDER | Sort Sequence of Rules for Adjustment Process | REAJRULEORDER | NUMC | 3 | |
| CTRULE | Currency Translation Rule | RECACTRULE | TIVCACTRULE | CHAR | 20 |
| FCTRULE | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| TIMEDEPTYPE | Consideration of Time-Dependency | REAJTIMEDEPTYPE | CHAR | 1 | |
| FTIMEDEPTYPE | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| DDUPMANDATORY | Due Date Required for Follow-Up Postings | REAJDUEDATEUPMANDATORY | CHAR | 1 | |
| DEPCONDTYPE | Condition Type of Dependent Condition | REAJDEPCONDTYPE | TIVCDCONDTYPE | CHAR | 4 |
| FDEPCONDTYPE | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| NORETROACTIVE | No Retroactive Adjustment | REAJNORETROACTIVEADJM | CHAR | 1 | |
| FNORETROACTIVE | Entry Status in Contract/Rental Object | REAJFIELDCHANGEABLE | NUMC | 1 | |
| SPECIFICFIELD | Indicator: Specific Fields Exist | REAJSPECIFICFIELD | 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 VIAJRULE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIAJRULE | ADJMMETH | 1: CN | TIVAJMETH |
| VIAJRULE | ADJMRULE | 1: CN | TIVAJRULE |
| VIAJRULE | ADJMSUBRULE | 1: CN | TIVAJRULE |
| VIAJRULE | BLOCKREASON | 1: CN | TIVAJBLOCKREAS |
| VIAJRULE | CTRULE | 1: CN | TIVCACTRULE |
| VIAJRULE | DEPCONDTYPE | 1: CN | TIVCDCONDTYPE |