VIAJRULE SAP table for – Contract/Rental Object: Adjustment Rule

Here we would like to draw your attention to VIAJRULE table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VIAJRULE is a SAP standard transp table used for storing Contract/Rental Object: Adjustment Rule related data in SAP. It comes under the package RE_AJ_TM.

SAP VIAJRULE table

Table VIAJRULE technical data

TableVIAJRULE
Data storingContract/Rental Object: Adjustment Rule
ModuleRE
Sub ModuleRE-FX-AJ
SAP PackageRE_AJ_TM
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VIAJRULE Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VIAJRULE table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Contract/Rental Object: Adjustment Rule – Key Fields
    Its a key field.
  • .INCLUDE : Contract/Rental Object: Adjustment Term – Key Fields
    Its a key field.
  • INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • TERMNO : Term Number
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • ADJMRULE : Adjustment Rule
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • ADJMSUBRULE : Elementary Adjustment Rule (Part of Comb. Rule)
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • VALIDFROM : Valid-From Date of Term
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Contract/Rental Object: Adjustment Rule – Non-Key Fields
  • VALIDTO : Valid-To Date of Term
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Adjustment Rule: Non-Key Fields
  • ADJMMETH : Adjustment Method
    Its data type is CHAR (Character String) with field length 4
  • ISRULECOMB : Indicator: Adjustment Rule Is Combined Rule
    Its data type is CHAR (Character String) with field length 1
  • ISPARTCOMB : Adjustment Rule Is Usable Only As Part of Combined Rule
    Its data type is CHAR (Character String) with field length 1
  • APPROVAL : Indicator: Approval for Adjustment Required?
    Its data type is CHAR (Character String) with field length 1
  • ACTIFNOAPPR : Indicator: Activation Without Approval Possible
    Its data type is CHAR (Character String) with field length 1
  • DTCHANGEABLE : Indicator: Is valid-from date manually changeable?
    Its data type is CHAR (Character String) with field length 1
  • PERCENTAGEPASS : Percentage with Which the Adjustment Amount Is Passed-On
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • USERORATEINC : Consider Percentage Rate of Increase of Rental Object
    Its data type is CHAR (Character String) with field length 1
  • ADJMDIRECTION : In which direction (+/-/=) can the amount change?
    Its data type is CHAR (Character String) with field length 1
  • CHANGEDIRECTION : How (+/-/=) Can the Amount Be Changed After Adjustment
    Its data type is CHAR (Character String) with field length 1
  • RHYTHM : Adjustment Frequency
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RHYTHMUNIT : Adjustment Frequency: Unit
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • RHYTHMBEGIN : Indicator: Calculate Minimum Interval from Frequency Start?
    Its data type is CHAR (Character String) with field length 1
  • SIMULATIONRULE : Indicator: Adjustment Rule Is Allowed for Simulation Only
    Its data type is CHAR (Character String) with field length 1
  • NODOCUMENT : Indicator: No Adjustment Document
    Its data type is CHAR (Character String) with field length 1
  • RULECHANGEABLE : Is the rule data in the contract/rental object modifiable?
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FADJMDIRECTION : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FPERCENTAGEPASS : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FUSERORATEINC : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FRHYTHM : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FRHYTHMUNIT : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FRHYTHMBEGIN : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FSIMULATIONRULE : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FNODOCUMENT : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FAPPROVAL : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FACTIFNOAPPR : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FDTCHANGEABLE : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FCHANGEDIRECTION : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • RULEEXPAND : Expanded display of rule data in contract/rental object?
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • ADJMCOTYPE : Influence on Subsequent Conditions
    Its data type is CHAR (Character String) with field length 1
  • FADJMCOTYPE : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • NEXTADJMNOTICE : Adjustment on Next Possible Notice Date
    Its data type is CHAR (Character String) with field length 1
  • FNEXTADJMNOTICE : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • ADJMBASE : Adjustment Basis
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FADJMBASE : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • ISRHYTHMMINDIST : Obsolete: Adjustment Frequency Is Minimum Interval
    Its data type is CHAR (Character String) with field length 1
  • FISRHYTHMMINDIST : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SIMDISABLED : Simulation Not Allowed in Dialog
    Its data type is CHAR (Character String) with field length 1
  • EXEDISABLED : Not Allowed to Be Executed Online
    Its data type is CHAR (Character String) with field length 1
  • REVDISABLED : Reversal Not Allowed in Dialog
    Its data type is CHAR (Character String) with field length 1
  • AUTODEFAULT : Automatic Default Only
    Its data type is CHAR (Character String) with field length 1
  • ANNOUNCE : Notification Required for Adjustment?
    Its data type is CHAR (Character String) with field length 1
  • FANNOUNCE : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • BLOCKREASON : Reason for Adjustment Lock
    Its data type is CHAR (Character String) with field length 10
  • FBLOCKREASON : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • RULEORDER : Sort Sequence of Rules for Adjustment Process
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CTRULE : Currency Translation Rule
    Its data type is CHAR (Character String) with field length 20
  • FCTRULE : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • TIMEDEPTYPE : Consideration of Time-Dependency
    Its data type is CHAR (Character String) with field length 1
  • FTIMEDEPTYPE : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • DDUPMANDATORY : Due Date Required for Follow-Up Postings
    Its data type is CHAR (Character String) with field length 1
  • DEPCONDTYPE : Condition Type of Dependent Condition
    Its data type is CHAR (Character String) with field length 4
  • FDEPCONDTYPE : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • NORETROACTIVE : No Retroactive Adjustment
    Its data type is CHAR (Character String) with field length 1
  • FNORETROACTIVE : Entry Status in Contract/Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SPECIFICFIELD : Indicator: Specific Fields Exist
    Its data type is CHAR (Character String) with field length 1