1. SAP Tutorial
  2. Real Estate Management

VIAJRECORD SAP table for – Adjustment record

Here we would like to draw your attention to VIAJRECORD 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). VIAJRECORD is a SAP standard transp table used for storing Adjustment record related data in SAP. It comes under the package RE_AJ_PR.

SAP VIAJRECORD table

Table VIAJRECORD technical data

TableVIAJRECORD
Data storingAdjustment record
ModuleRE
Sub ModuleRE-FX-AJ
SAP PackageRE_AJ_PR
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VIAJRECORD 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 VIAJRECORD table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Adjustment Record: Key Fields
    Its a key field.
  • RECORDGUID : Generic Key of Adjustment Record
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Adjustment Record: Non-Key Fields
  • PROCESSGUID : Generic Key of Process
    Its data type is RAW (Byte string) with field length 16
  • INTRENO : Internal Key of Real Estate Object
    Its data type is CHAR (Character String) with field length 13
  • TERMNO : Term Number
    Its data type is CHAR (Character String) with field length 4
  • ADJMRULE : Adjustment Rule
    Its data type is CHAR (Character String) with field length 10
  • ADJMSUBRULE : Elementary Adjustment Rule (Part of Comb. Rule)
    Its data type is CHAR (Character String) with field length 10
  • ADJMSUBMETH : Adjustment Method
    Its data type is CHAR (Character String) with field length 4
  • ADJMDRECORDSTAT : Status of an Adjustment Record
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • ADJMRULEDEFAULT : Alternative Adjustment Rule
    Its data type is CHAR (Character String) with field length 10
  • ADJMRECSTEPNO : Sequential Number of Adjustment Step
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • FDELETE : Deletion Indicator for Archiving
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Fields of Adjustment Record for the Method
  • CONDGUIDOLD : GUID (RAW16) for Conditions
    Its data type is RAW (Byte string) with field length 16
  • CONDGUIDNEW : GUID (RAW16) for Conditions
    Its data type is RAW (Byte string) with field length 16
  • CONDGUIDREF : GUID (RAW16) for Conditions
    Its data type is RAW (Byte string) with field length 16
  • ADJMFROMOLD : Valid-From Date of New Condition Item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMFROMCALC : Valid-From Date of New Condition Item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMFROMMOD : Valid-From Date of New Condition Item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UNITPRICEOLD : Unit Price
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 19
  • UNITPRICECALC : Unit Price
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 19
  • UNITPRICEMOD : Unit Price
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 19
  • ADJMCONDDELETE : Condition Is Deleted
    Its data type is CHAR (Character String) with field length 1
  • METHREFGUID : Reference to Process-Specific Data for Adjustment Record
    Its data type is RAW (Byte string) with field length 16
  • ADJMFROMMODDATE : Valid-From Date Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMFROMMODUSER : Valid-From Date Changed By
    Its data type is CHAR (Character String) with field length 12
  • UNITPRICEMODDATE : Valid-From Date Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UNITPRICEMODUSER : Price Changed By
    Its data type is CHAR (Character String) with field length 12
  • CONDVALIDTOOLD : Date up to when condition is valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMCONDNEW : New Condition on Target
    Its data type is CHAR (Character String) with field length 1
  • UPBEFORECAPPING : Unit Price Before Capping
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 19
  • MONTHCAPPING : Time in Months
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DISSOLVEINGUID : Reference to Condition That Contains the Cancellation
    Its data type is RAW (Byte string) with field length 16
  • ADJMREASON : Adjustment Reason
    Its data type is CHAR (Character String) with field length 10
  • CHGREASON : Reason for Change
    Its data type is CHAR (Character String) with field length 10
  • CHGREASONOLD : Reason for Change
    Its data type is CHAR (Character String) with field length 10
  • CARRYFROMGUID : Reference to Transferred Condition
    Its data type is RAW (Byte string) with field length 16
  • CARRYOVERCT : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • RECGROUPGUID : GUID for Grouping Adjustment Records
    Its data type is RAW (Byte string) with field length 16
  • INTRENODEPEND : Internal Key of Real Estate Object
    Its data type is CHAR (Character String) with field length 13
  • RECORDUPDATE : Record Was Updated
    Its data type is CHAR (Character String) with field length 1
  • UNITPRICEANN : Unit Price
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 19
  • ADJMFROMANN : Valid-From Date of New Condition Item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CONDPURPOSENEW : Conditions – External Purpose
    Its data type is CHAR (Character String) with field length 4
  • CONDTYPECEA : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • CONDTYPENEW : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • TERMNOAJNEW : Term Number
    Its data type is CHAR (Character String) with field length 4
  • TAKETERMNO : Copy Terms
    Its data type is CHAR (Character String) with field length 1
  • MAXINCREL : Maximum Increase in Percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • UPLESSCAPMONTH : Unit Price
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 19
  • ADJMFROMLESSCM : Valid-From Date of New Condition Item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPPOSMARGIN : Unit Price
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 19
  • UPPOSMARGINUSED : Unit Price
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 19
  • UPINCALLOWED : Unit Price
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 19
  • .INCLUDE : Fields of Adjustment Record for Activation
  • ADJMACTIVDATE : Activated On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMACTIVUSER : Activated By
    Its data type is CHAR (Character String) with field length 12
  • DUEDATEUP : Due Date for Follow-Up Postings
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DUEDATEUPOLD : Due Date for Follow-Up Postings
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Adjustment Record Fields for Notification/Approval/Rejection
  • ADJMANNOUNCETO : Date Reply to Notification Is Required
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMANNOUNCEDATE : Notification Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMANNOUNCEUSER : Notified By
    Its data type is CHAR (Character String) with field length 12
  • ADJMAPPROVALTO : Date Up to Which the Approval Must Occur
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMAPPROVALDATE : Approval On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMAPPROVALUSER : Approved By
    Its data type is CHAR (Character String) with field length 12
  • ADJMDECLINEDATE : Rejected On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMDECLINEUSER : Rejected By
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Fields of Adjustment Record for the Reversal
  • ADJMREVERSALDATE : Reversed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMREVERSALUSER : Reversed by
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Fields of Adjustment Record for Correspondence
  • ADJMDOCDATE : Adjustment Letter On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMDOCCOUNT : Number of Adjustment Letters
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • ADJMDUNLEVEL : Dunning Level
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • ADJMDUNDATE : Reminder Letter On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMDUNCOUNT : Number of Reminder Letters
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • ADJMAPPDATE : Approval Confirmation Letter On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMAPPCOUNT : Number of Approval Confirmation Letters
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • ADJMANNDATE : Date of Last Notification Letter
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMANNCOUNT : Number of Notification Letters
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • .INCLUDE : Adjustment Record Field for Deactivation
  • ADJMDEACTIVDATE : Deactivated On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMDEACTIVUSER : Deactivated By
    Its data type is CHAR (Character String) with field length 12

    • VIAJRECORD related tables

    • VIAJRECORD : Adjustment record

    VIAJRECORD related transaction codes under SAP package RE_AJ_PR

    • REAJCH : Continue Adjustment
    • REAJAHSCSE : Service Charge Settlemt Adjustments
    • REAJAHRO : Adjustments on Rental Objects
    • REAJSH : Display Adjustments
    • REAJPRTASK : Determine Adjustments – TASK
    • REAJRV : Reverse Adjustments
    • REAJEDIT : Process Adjustments Directly
    • REAJPRCEA : Specify Adjustments – CEA
    • REAJCHCEA : Continue with Adjustments – CEA
    • REAJPR : Specify Adjustments
    • REAJAHCN : Adjustments on Contracts
    • REAJSHCEA : Display Adjustments – CEA
    • REAJRVCEA : Reverse Adjustments – CEA

    Related References

    Related Tutorials

    VISCAJROSU SAP table for – Adjustment Record SCSE per RO and SU

    VISCAJROSU table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIXCAJRECCH01 SAP table for – Adjustment Record CH01

    VIXCAJRECCH01 table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VISCAJRO SAP table for – Adjustment Record SCSE per Rental Object

    VISCAJRO table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIAJRECRLRA SAP table for – Adjustment Record RLRA

    VIAJRECRLRA table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIAJRECINDX SAP table for – Adjustment Record INDX

    VIAJRECINDX table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIAJRECRLRAFF SAP table for – Adjustment Record RLRAFF

    VIAJRECRLRAFF table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIAJCEAPRESTG SAP table for – Prestage Adjustment Record

    VIAJCEAPRESTG table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    «
    »