1. SAP Tutorial
  2. Real Estate Management

VIAJAT SAP table for – Adjustment Measure

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

SAP VIAJAT table

Table VIAJAT technical data

TableVIAJAT
Data storingAdjustment Measure
ModuleRE
Sub ModuleRE-FX-AJ
SAP PackageRE_AJ_BD
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : Adjustment Measure: Key Fields
  • ADJMTASKID : Adjustment Measure
    Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : Adjustment Measure: Non-Key Fields
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • CREATIONTYPE : How the Object Was Created
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Field String for Maintenance of User Data
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • 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
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10
  • RESPONSIBLE : Person Responsible
    Its data type is CHAR (Character String) with field length 12
  • USEREXCLUSIVE : User with Exclusive Change Authorization
    Its data type is CHAR (Character String) with field length 12
  • AUTHGRP : Authorization Group
    Its data type is CHAR (Character String) with field length 40
  • VALIDFROM : Adjustment Measure Valid From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO : Adjustment Measure Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJMTASKTYPE : Type of Adjustment Measure
    Its data type is CHAR (Character String) with field length 2
  • XADJMTASK : Name of Adjustment Measure
    Its data type is CHAR (Character String) with field length 60
  • SUPERADJMTASKID : Higher-Level Adjustment Measure
    Its data type is CHAR (Character String) with field length 20
  • ADJMRULE : Adjustment Rule
    Its data type is CHAR (Character String) with field length 10
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • VALIDFROMPLAN : Plan – Start Date of Adjustment Measure
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTOPLAN : Plan – End Date of Adjustment Measure
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDFROMACT : Actual – Start Date of Adjustment Measure
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTOACT : Actual – End Date of Adjustment Measure
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BENO : Business Entity that Adjustment Measure Is For
    Its data type is CHAR (Character String) with field length 8
  • ACTIVATEONPLAN : Plan – Activation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ACTIVATEONACT : Actual – Activation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AFFCNIND : Adjustment Type
    Its data type is CHAR (Character String) with field length 1
  • DOWAIVERCD : Set Up Waiver Condition in Case of Capping
    Its data type is CHAR (Character String) with field length 1
  • ATMEAS : Measurement Type
    Its data type is CHAR (Character String) with field length 4
  • ATMEASUNIT : Measurement Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • AMMULMEAS : Measurement Type for Amenities Level Factor
    Its data type is CHAR (Character String) with field length 4
  • AMMULMEASUNIT : Unit of Measurement for Amenities Level Factor
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ISCOSTSPOSA : Are Costs Items Active?
    Its data type is CHAR (Character String) with field length 1
  • ISSUPERADJMTASK : Measure Is Higher-Level Measure
    Its data type is CHAR (Character String) with field length 1
  • ISPLANFILLED : Plan Values Filled
    Its data type is CHAR (Character String) with field length 1
  • HASMULTIASSIGN : Multiple Assignment of Object to Group Allowed
    Its data type is CHAR (Character String) with field length 1
  • USAGEGROUP : Usage Group
    Its data type is CHAR (Character String) with field length 4
  • TASKSTATUS : Status of Adjustment Measure
    Its data type is CHAR (Character String) with field length 2
  • EARMARKING : Earmarking of Adjustment Measure
    Its data type is CHAR (Character String) with field length 2
  • RRLPERCENT : Percentage Rate of Risk of Rent Loss
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • WBAUPRG : Public Housing Program
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • XNUTZWERK : Plant/Partner with Right of Occupancy for Rental Object
    Its data type is CHAR (Character String) with field length 30
  • XIHMA : Measure (Such As Modernization, New Construction)
    Its data type is CHAR (Character String) with field length 30
  • DBINDBIS : Earmarked Until
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BEZFERTIG : Completion for Occupancy
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ATFIRSTADJMFROM : First Adjustment Begins On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PROCESSCEAGUID : Key for CEA Adjustment
    Its data type is RAW (Byte string) with field length 16
  • PERCENTINCR : Percentage Surcharge
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • PSARCHIVEDTO : Date up to Which the Prestage Adjustments Are Archived
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • VIAJAT related tables

    • TIVAJEXPGRPCD : Condition Type for Expense Item Group
    • TIVAJTASKSTATT : Texts for Status of Adjustment Measure
    • TIVAJFSVAR : Field Status Variant for Adjustment Measure
    • TIVAJEXPPOSGRPT : Texts for Expense Item Group
    • VIAJCOMPGRP : Comparative Group of Apartments
    • TIVAJMEASAT : Measurement: Settings per Adjustment Rule
    • TIVAJEARMARK : Earmarking of Adjustment Measure
    • TIVAJEXPPOS : Expense Item
    • TIVAJFINPOSGRPT : Texts for Financing Item Group
    • VIAJATOBJ : Object and Costs for Adjustment Measure
    • TIVAJEARMARKT : Texts for Earmarking of an Adjustment Measure
    • TIVAJFINPOSGRP : Financing Item Group
    • TIVAJATTYPE : Type of Adjustment Measure
    • VIAJAT : Adjustment Measure
    • TIVAJEPCRTD : Time-Dependent Calculation Formula for Expense Item
    • VIAJFINPLAN : Financing Plan
    • TIVAJEXPPOSGRP : Expense Item Group
    • TIVAJTASKSTAT : Status of Adjustment Measure
    • VIAJCEAPRESTG : Prestage Adjustment Record
    • TIVAJEPYROCC : Expense Item and Years Ready for Occupancy

    VIAJAT related transaction codes under SAP package RE_AJ_BD

    • REATFSVARFM : Field Modific. Field Status Variant
    • REAT0003 : AM: Views
    • REAJCG0019 : CG: Feldmod. per Activity (Control)
    • REAJCG0104 : CG: Screen Configuration
    • REAT0002 : AM: Field Groups
    • REAT0018 : AM: Activities
    • REAJEPCRTD : WB: Calc. Formula – Expense Item
    • REAT0106 : AM:Assignment Object Part –> MemoID
    • REAJCG0016 : CG: Tables
    • REAJCG0105 : CG: Fld Mod. per Ext. Application
    • REAJCG0011 : CG: Assignment Screen Fld->DB Field
    • REAT0001 : AM: Applications
    • REAJCG0005 : CG: Screens
    • REAT0022 : AM: Where-Used List: Structure
    • REAT0107 : AM: Where-Used List: Views
    • REAJAT : Edit Adjustment Measure
    • REAJCGCHECK : Mass Check: Comparative Apartments
    • REAT0008 : AM: CUA Standard Functions
    • REAJCG0106 : CG: Assignmt Object Part –> Memo ID
    • REAT0017 : AM: External Applications

    Related References

    Related Tutorials

    TIVAJATTYPET SAP table for – Type of Adjustment Measure (Text)

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

    TIVAJEARMARK SAP table for – Earmarking of Adjustment Measure

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

    TIVAJTASKSTAT SAP table for – Status of Adjustment Measure

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

    TIVAJFSVAR SAP table for – Field Status Variant for Adjustment Measure

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

    TIVAJTASKSTATT SAP table for – Texts for Status of Adjustment Measure

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

    TIVAJEARMARKT SAP table for – Texts for Earmarking of an Adjustment Measure

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

    VIAJATOBJ SAP table for – Object and Costs for Adjustment Measure

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

    «
    »