SAP VIAJAT Adjustment Measure Table
Overview
VIAJAT is a standard SAP S/4HANA table that stores Adjustment Measure data. There are total 54 fields in the VIAJAT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIAJAT belongs to Rent Adjustment (RE-FX-AJ) module and is located in the package RE: Adjustment Master Data (RE_AJ_BD).
In addition, following links provide an overview of foreign key relationships, if any, that link VIAJAT to other SAP tables and standard CDS views available based on VIAJAT table in S/4HANA 2020.
Techincal Settings of VIAJAT
Below are technical details of the table VIAJAT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIAJAT Fields
The following table gives you an overview of the fields available in VIAJAT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| ADJMTASKID | Adjustment Measure | REAJADJMTASKID | CHAR | 20 | |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| CREATIONTYPE | How the Object Was Created | RECACREATIONTYPE | CHAR | 1 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| RESPONSIBLE | Person Responsible | RECARESPONSIBLE | USR02 | CHAR | 12 |
| USEREXCLUSIVE | User with Exclusive Change Authorization | RECAUSEREXCLUSIVE | USR02 | CHAR | 12 |
| AUTHGRP | Authorization Group | RECAAUTHGRP | CHAR | 40 | |
| VALIDFROM | Adjustment Measure Valid From | REAJADJMTASKVALIDFROM | DATS | 8 | |
| VALIDTO | Adjustment Measure Valid To | REAJADJMTASKVALIDTO | DATS | 8 | |
| ADJMTASKTYPE | Type of Adjustment Measure | REAJADJMTASKTYPE | TIVAJATTYPE | CHAR | 2 |
| XADJMTASK | Name of Adjustment Measure | REAJXADJMTASK | CHAR | 60 | |
| SUPERADJMTASKID | Higher-Level Adjustment Measure | REAJSUPERADJMTASKID | CHAR | 20 | |
| ADJMRULE | Adjustment Rule | REAJADJMRULE | * | CHAR | 10 |
| BUKRS | Company Code | BUKRS | CHAR | 4 | |
| VALIDFROMPLAN | Plan - Start Date of Adjustment Measure | REAJVALIDFROMPLAN | DATS | 8 | |
| VALIDTOPLAN | Plan - End Date of Adjustment Measure | REAJVALIDTOPLAN | DATS | 8 | |
| VALIDFROMACT | Actual - Start Date of Adjustment Measure | REAJVALIDFROMACT | DATS | 8 | |
| VALIDTOACT | Actual - End Date of Adjustment Measure | REAJVALIDTOACT | DATS | 8 | |
| CURRENCY | Currency Key | WAERS | TCURC | CUKY | 5 |
| BENO | Business Entity that Adjustment Measure Is For | REAJATBENO | CHAR | 8 | |
| ACTIVATEONPLAN | Plan - Activation Date | REAJACTIVATEONPLAN | DATS | 8 | |
| ACTIVATEONACT | Actual - Activation Date | REAJACTIVATEONACT | DATS | 8 | |
| AFFCNIND | Adjustment Type | REAJAFFCNIND | CHAR | 1 | |
| DOWAIVERCD | Set Up Waiver Condition in Case of Capping | REAJDOWAIVERCD | CHAR | 1 | |
| ATMEAS | Measurement Type | REAJATMEAS | CHAR | 4 | |
| ATMEASUNIT | Measurement Unit | REAJATMEASUNIT | T006 | UNIT | 3 |
| AMMULMEAS | Measurement Type for Amenities Level Factor | REAJAMMULMEAS | CHAR | 4 | |
| AMMULMEASUNIT | Unit of Measurement for Amenities Level Factor | REAJAMMULMEASUNIT | T006 | UNIT | 3 |
| ISCOSTSPOSA | Are Costs Items Active? | REAJISCOSTSPOSA | CHAR | 1 | |
| ISSUPERADJMTASK | Measure Is Higher-Level Measure | REAJISSUPERADJMTASK | CHAR | 1 | |
| ISPLANFILLED | Plan Values Filled | REAJISPLANFILLED | CHAR | 1 | |
| HASMULTIASSIGN | Multiple Assignment of Object to Group Allowed | REBDHASMULTIASSIGN | CHAR | 1 | |
| USAGEGROUP | Usage Group | REBDUSAGEGROUP | TIVBDUSGRP | CHAR | 4 |
| TASKSTATUS | Status of Adjustment Measure | REAJTASKSTATUS | * | CHAR | 2 |
| EARMARKING | Earmarking of Adjustment Measure | REAJEARMARKING | * | CHAR | 2 |
| RRLPERCENT | Percentage Rate of Risk of Rent Loss | REAJRRLPERCENT | DEC | 5 | |
| WBAUPRG | Public Housing Program | REAJWBAUPRG | NUMC | 4 | |
| XNUTZWERK | Plant/Partner with Right of Occupancy for Rental Object | REAJXNUTZWERK | CHAR | 30 | |
| XIHMA | Measure (Such As Modernization New Construction) | REAJXIHMA | CHAR | 30 | |
| DBINDBIS | Earmarked Until | REAJDBINDBIS | DATS | 8 | |
| BEZFERTIG | Completion for Occupancy | REAJBEZFERTIG | DATS | 8 | |
| ATFIRSTADJMFROM | First Adjustment Begins On | REAJATFIRSTADJMFROM | DATS | 8 | |
| PROCESSCEAGUID | Key for CEA Adjustment | REAJPROCESSCEAGUID | VICAPROCESSID | RAW | 16 |
| PERCENTINCR | Percentage Surcharge | REAJPERCENTINCR | DEC | 5 | |
| PSARCHIVEDTO | Date up to Which the Prestage Adjustments Are Archived | REAJPSARCHIVEDTO | DATS | 8 |
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 VIAJAT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIAJAT | ADJMTASKTYPE | 1: CN | TIVAJATTYPE |
| VIAJAT | AMMULMEASUNIT | 1: CN | T006 |
| VIAJAT | ATMEASUNIT | 1: CN | T006 |
| VIAJAT | CURRENCY | 1: CN | TCURC |
| VIAJAT | PROCESSCEAGUID | 1: C | VICAPROCESSID |
| VIAJAT | RESPONSIBLE | 1: CN | USR02 |
| VIAJAT | USAGEGROUP | 1: CN | TIVBDUSGRP |
| VIAJAT | USEREXCLUSIVE | C: CN | USR02 |