SAP VIAJRECORD Adjustment record Table

Overview

VIAJRECORD is a standard SAP S/4HANA table that stores Adjustment record data. There are total 82 fields in the VIAJRECORD table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VIAJRECORD belongs to Rent Adjustment (RE-FX-AJ) module and is located in the package RE: Adjustment Process (RE_AJ_PR).

In addition, following links provide an overview of foreign key relationships, if any, that link VIAJRECORD to other SAP tables and standard CDS views available based on VIAJRECORD table in S/4HANA 2020.

Techincal Settings of VIAJRECORD

Below are technical details of the table VIAJRECORD

Buffering not allowed
No buffering
Storage type is Column Store

List of VIAJRECORD Fields

The following table gives you an overview of the fields available in VIAJRECORD

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT		CLNT	3
RECORDGUID	Generic Key of Adjustment Record	REAJRECORDGUID		RAW	16
PROCESSGUID	Generic Key of Process	RECAPROCESSGUID	VICAPROCESSID	RAW	16
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
ADJMSUBMETH	Adjustment Method	REAJADJMMETH	TIVAJMETH	CHAR	4
ADJMDRECORDSTAT	Status of an Adjustment Record	REAJADJMDRECORDSTAT		NUMC	1
ADJMRULEDEFAULT	Alternative Adjustment Rule	REAJADJMRULEDEFAULT	TIVAJRULE	CHAR	10
ADJMRECSTEPNO	Sequential Number of Adjustment Step	REAJADJMRECSTEPNO		NUMC	8
DERF	First Entered On	DERF		DATS	8
TERF	Time of Creation	TERF		TIMS	6
RERF	Entered By	RERF		CHAR	12
FDELETE	Deletion Indicator for Archiving	RECAARDELETEIND		CHAR	1
CONDGUIDOLD	GUID (RAW16) for Conditions	RECDCONDGUID		RAW	16
CONDGUIDNEW	GUID (RAW16) for Conditions	RECDCONDGUID		RAW	16
CONDGUIDREF	GUID (RAW16) for Conditions	RECDCONDGUID		RAW	16
ADJMFROMOLD	Valid-From Date of New Condition Item	REAJADJMVALIDFROM		DATS	8
ADJMFROMCALC	Valid-From Date of New Condition Item	REAJADJMVALIDFROM		DATS	8
ADJMFROMMOD	Valid-From Date of New Condition Item	REAJADJMVALIDFROM		DATS	8
UNITPRICEOLD	Unit Price	RECDUNITPRICE		DEC	19
UNITPRICECALC	Unit Price	RECDUNITPRICE		DEC	19
UNITPRICEMOD	Unit Price	RECDUNITPRICE		DEC	19
ADJMCONDDELETE	Condition Is Deleted	REAJADJMCONDDELETE		CHAR	1
METHREFGUID	Reference to Process-Specific Data for Adjustment Record	REAJMETHREFGUID		RAW	16
ADJMFROMMODDATE	Valid-From Date Changed On	REAJADJMFROMMODDATE		DATS	8
ADJMFROMMODUSER	Valid-From Date Changed By	REAJADJMFROMMODUSER		CHAR	12
UNITPRICEMODDATE	Valid-From Date Changed On	REAJUNITPRICEMODDATE		DATS	8
UNITPRICEMODUSER	Price Changed By	REAJUNITPRICEMODUSER		CHAR	12
CONDVALIDTOOLD	Date up to when condition is valid	RECDVALIDTO		DATS	8
ADJMCONDNEW	New Condition on Target	REAJNEWCOND		CHAR	1
UPBEFORECAPPING	Unit Price Before Capping	REAJUPBEFORECAPPING		DEC	19
MONTHCAPPING	Time in Months	REAJPERIODMONTH		NUMC	3
DISSOLVEINGUID	Reference to Condition That Contains the Cancellation	REAJDISSOLVEINGUID		RAW	16
ADJMREASON	Adjustment Reason	REAJADJMREASON	TIVAJREASON	CHAR	10
CHGREASON	Reason for Change	RECDCHGREASON	TIVCDCHGREAS	CHAR	10
CHGREASONOLD	Reason for Change	RECDCHGREASON	*	CHAR	10
CARRYFROMGUID	Reference to Transferred Condition	REAJCARRYFROMGUID		RAW	16
CARRYOVERCT	Condition Type	RECDCONDTYPE	TIVCDCONDTYPE	CHAR	4
RECGROUPGUID	GUID for Grouping Adjustment Records	REAJRECGROUPGUID		RAW	16
INTRENODEPEND	Internal Key of Real Estate Object	RECAINTRENO		CHAR	13
RECORDUPDATE	Record Was Updated	REAJRECORDUPDATE		CHAR	1
UNITPRICEANN	Unit Price	RECDUNITPRICE		DEC	19
ADJMFROMANN	Valid-From Date of New Condition Item	REAJADJMVALIDFROM		DATS	8
CONDPURPOSENEW	Conditions - External Purpose	RECDCONDPURPOSEEXT	TIVCDCOPUEXT	CHAR	4
CONDTYPECEA	Condition Type	RECDCONDTYPE	*	CHAR	4
CONDTYPENEW	Condition Type	RECDCONDTYPE	TIVCDCONDTYPE	CHAR	4
TERMNOAJNEW	Term Number	RETMTERMNO		CHAR	4
TAKETERMNO	Copy Terms	REAJTAKETERMNO		CHAR	1
MAXINCREL	Maximum Increase in Percent	REAJMAXINCREL		DEC	7
UPLESSCAPMONTH	Unit Price	RECDUNITPRICE		DEC	19
ADJMFROMLESSCM	Valid-From Date of New Condition Item	REAJADJMVALIDFROM		DATS	8
UPPOSMARGIN	Unit Price	RECDUNITPRICE		DEC	19
UPPOSMARGINUSED	Unit Price	RECDUNITPRICE		DEC	19
UPINCALLOWED	Unit Price	RECDUNITPRICE		DEC	19
UNITPRICEMODZERO	Indicator: Set Adjusted Price to Zero	REAJADJMPRICEMODZERO		CHAR	1
ADJMACTIVDATE	Activated On	REAJADJMACTIVDATE		DATS	8
ADJMACTIVUSER	Activated By	REAJADJMACTIVUSER		CHAR	12
DUEDATEUP	Due Date for Follow-Up Postings	RECDDUEDATEUP		DATS	8
DUEDATEUPOLD	Due Date for Follow-Up Postings	RECDDUEDATEUP		DATS	8
ADJMANNOUNCETO	Date Reply to Notification Is Required	REAJADJMANNOUNCETO		DATS	8
ADJMANNOUNCEDATE	Notification Date	REAJADJMANNOUNCEDATE		DATS	8
ADJMANNOUNCEUSER	Notified By	REAJADJMANNOUNCEUSER		CHAR	12
ADJMAPPROVALTO	Date Up to Which the Approval Must Occur	REAJADJMAPPROVALTO		DATS	8
ADJMAPPROVALDATE	Approval On	REAJADJMAPPROVALDATE		DATS	8
ADJMAPPROVALUSER	Approved By	REAJADJMAPPROVALUSER		CHAR	12
ADJMDECLINEDATE	Rejected On	REAJADJMDECLINEDATE		DATS	8
ADJMDECLINEUSER	Rejected By	REAJADJMDECLINEUSER		CHAR	12
ADJMREVERSALDATE	Reversed On	REAJADJMREVERSALDATE		DATS	8
ADJMREVERSALUSER	Reversed by	REAJADJMREVERSALUSER		CHAR	12
ADJMDOCDATE	Adjustment Letter On	REAJADJMDOCDATE		DATS	8
ADJMDOCCOUNT	Number of Adjustment Letters	REAJADJMDOCCOUNT		INT1	3
ADJMDUNLEVEL	Dunning Level	REAJADJMDUNLEVEL		INT1	3
ADJMDUNDATE	Reminder Letter On	REAJADJMDUNDATE		DATS	8
ADJMDUNCOUNT	Number of Reminder Letters	REAJADJMDUNCOUNT		INT1	3
ADJMAPPDATE	Approval Confirmation Letter On	REAJADJMAPPDATE		DATS	8
ADJMAPPCOUNT	Number of Approval Confirmation Letters	REAJADJMAPPCOUNT		INT1	3
ADJMANNDATE	Date of Last Notification Letter	REAJADJMANNDATE		DATS	8
ADJMANNCOUNT	Number of Notification Letters	REAJADJMANNCOUNT		INT1	3
ADJMDEACTIVDATE	Deactivated On	REAJADJMDEACTIVDATE		DATS	8
ADJMDEACTIVUSER	Deactivated By	REAJADJMDEACTIVUSER		CHAR	12

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 VIAJRECORD

Table Name	Field	Cardinality	Check Table
VIAJRECORD	ADJMREASON	1: CN	TIVAJREASON
VIAJRECORD	ADJMRULE	1: CN	TIVAJRULE
VIAJRECORD	ADJMRULEDEFAULT	1: CN	TIVAJRULE
VIAJRECORD	ADJMSUBMETH	1: CN	TIVAJMETH
VIAJRECORD	ADJMSUBRULE	1: CN	TIVAJRULE
VIAJRECORD	CARRYOVERCT	1: CN	TIVCDCONDTYPE
VIAJRECORD	CHGREASON	1: CN	TIVCDCHGREAS
VIAJRECORD	CONDPURPOSENEW	1: CN	TIVCDCOPUEXT
VIAJRECORD	CONDTYPENEW	1: CN	TIVCDCONDTYPE
VIAJRECORD	PROCESSGUID	1: CN	VICAPROCESSID

SAP VIAJRECORD Adjustment record Table

Overview

Techincal Settings of VIAJRECORD

List of VIAJRECORD Fields

Foreign Key Relationships

Other References