SAP ABAP Table VIAJRECORD (Adjustment record)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-AJ (Application Component) Rent Adjustment
     ⤷ RE_AJ_PR (Package) RE: Adjustment Process

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VIAJRECORD	Table Relationship Diagram
Short Description	Adjustment record

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	.INCLUDE	☑				0	0	Adjustment Record: Key Fields
3	RECORDGUID	☑	REAJRECORDGUID	RECAGUID	RAW	16	0	Generic Key of Adjustment Record
4	.INCLUDE	☐				0	0	Adjustment Record: Non-Key Fields
5	PROCESSGUID	☐	RECAPROCESSGUID	RECAGUID	RAW	16	0	Generic Key of Process	VICAPROCESSID
6	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
7	TERMNO	☐	RETMTERMNO	RETMTERMNO	CHAR	4	0	Term Number
8	ADJMRULE	☐	REAJADJMRULE	REAJADJMRULE	CHAR	10	0	Adjustment Rule	TIVAJRULE
9	ADJMSUBRULE	☐	REAJADJMSUBRULE	REAJADJMRULE	CHAR	10	0	Elementary Adjustment Rule (Part of Comb. Rule)	TIVAJRULE
10	ADJMSUBMETH	☐	REAJADJMMETH	REAJADJMMETH	CHAR	4	0	Adjustment Method	TIVAJMETH
11	ADJMDRECORDSTAT	☐	REAJADJMDRECORDSTAT	REAJADJMDRECORDSTAT	NUMC	1	0	Status of an Adjustment Record
12	ADJMRULEDEFAULT	☐	REAJADJMRULEDEFAULT	REAJADJMRULE	CHAR	10	0	Alternative Adjustment Rule	TIVAJRULE
13	ADJMRECSTEPNO	☐	REAJADJMRECSTEPNO	NUMC8	NUMC	8	0	Sequential Number of Adjustment Step
14	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
15	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
16	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
17	FDELETE	☐	RECAARDELETEIND	RECABOOL	CHAR	1	0	Deletion Indicator for Archiving
18	.INCLUDE	☐				0	0	Fields of Adjustment Record for the Method
19	CONDGUIDOLD	☐	RECDCONDGUID	RECAGUID	RAW	16	0	GUID (RAW16) for Conditions
20	CONDGUIDNEW	☐	RECDCONDGUID	RECAGUID	RAW	16	0	GUID (RAW16) for Conditions
21	CONDGUIDREF	☐	RECDCONDGUID	RECAGUID	RAW	16	0	GUID (RAW16) for Conditions
22	ADJMFROMOLD	☐	REAJADJMVALIDFROM	DATUM	DATS	8	0	Valid-From Date of New Condition Item
23	ADJMFROMCALC	☐	REAJADJMVALIDFROM	DATUM	DATS	8	0	Valid-From Date of New Condition Item
24	ADJMFROMMOD	☐	REAJADJMVALIDFROM	DATUM	DATS	8	0	Valid-From Date of New Condition Item
25	UNITPRICEOLD	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
26	UNITPRICECALC	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
27	UNITPRICEMOD	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
28	ADJMCONDDELETE	☐	REAJADJMCONDDELETE	RECABOOL	CHAR	1	0	Condition Is Deleted
29	METHREFGUID	☐	REAJMETHREFGUID	RECAGUID	RAW	16	0	Reference to Process-Specific Data for Adjustment Record
30	ADJMFROMMODDATE	☐	REAJADJMFROMMODDATE	DATUM	DATS	8	0	Valid-From Date Changed On
31	ADJMFROMMODUSER	☐	REAJADJMFROMMODUSER	SYCHAR12	CHAR	12	0	Valid-From Date Changed By
32	UNITPRICEMODDATE	☐	REAJUNITPRICEMODDATE	DATUM	DATS	8	0	Valid-From Date Changed On
33	UNITPRICEMODUSER	☐	REAJUNITPRICEMODUSER	SYCHAR12	CHAR	12	0	Price Changed By
34	CONDVALIDTOOLD	☐	RECDVALIDTO	RECADATEEND	DATS	8	0	Date up to when condition is valid
35	ADJMCONDNEW	☐	REAJNEWCOND	RECABOOL	CHAR	1	0	New Condition on Target
36	UPBEFORECAPPING	☐	REAJUPBEFORECAPPING	RECDUNITPRICE	DEC	19	6	Unit Price Before Capping
37	MONTHCAPPING	☐	REAJPERIODMONTH	NUMC3	NUMC	3	0	Time in Months
38	DISSOLVEINGUID	☐	REAJDISSOLVEINGUID	RECAGUID	RAW	16	0	Reference to Condition That Contains the Cancellation
39	ADJMREASON	☐	REAJADJMREASON	REAJADJMREASON	CHAR	10	0	Adjustment Reason	TIVAJREASON
40	CHGREASON	☐	RECDCHGREASON	RECDCHGREASON	CHAR	10	0	Reason for Change	TIVCDCHGREAS
41	CHGREASONOLD	☐	RECDCHGREASON	RECDCHGREASON	CHAR	10	0	Reason for Change	*
42	CARRYFROMGUID	☐	REAJCARRYFROMGUID	RECAGUID	RAW	16	0	Reference to Transferred Condition
43	CARRYOVERCT	☐	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	TIVCDCONDTYPE
44	RECGROUPGUID	☐	REAJRECGROUPGUID	RECAGUID	RAW	16	0	GUID for Grouping Adjustment Records
45	INTRENODEPEND	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
46	RECORDUPDATE	☐	REAJRECORDUPDATE	RECABOOL	CHAR	1	0	Record Was Updated
47	UNITPRICEANN	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
48	ADJMFROMANN	☐	REAJADJMVALIDFROM	DATUM	DATS	8	0	Valid-From Date of New Condition Item
49	CONDPURPOSENEW	☐	RECDCONDPURPOSEEXT	RECDCONDPURPOSEEXT	CHAR	4	0	Conditions - External Purpose	TIVCDCOPUEXT
50	CONDTYPECEA	☐	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	*
51	CONDTYPENEW	☐	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	TIVCDCONDTYPE
52	TERMNOAJNEW	☐	RETMTERMNO	RETMTERMNO	CHAR	4	0	Term Number
53	TAKETERMNO	☐	REAJTAKETERMNO	RECABOOL	CHAR	1	0	Copy Terms
54	MAXINCREL	☐	REAJMAXINCREL	DEC5_2	DEC	7	2	Maximum Increase in Percent
55	UPLESSCAPMONTH	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
56	ADJMFROMLESSCM	☐	REAJADJMVALIDFROM	DATUM	DATS	8	0	Valid-From Date of New Condition Item
57	UPPOSMARGIN	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
58	UPPOSMARGINUSED	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
59	UPINCALLOWED	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
60	.INCLUDE	☐				0	0	Fields of Adjustment Record for Activation
61	ADJMACTIVDATE	☐	REAJADJMACTIVDATE	DATUM	DATS	8	0	Activated On
62	ADJMACTIVUSER	☐	REAJADJMACTIVUSER	SYCHAR12	CHAR	12	0	Activated By
63	DUEDATEUP	☐	RECDDUEDATEUP	DATS	DATS	8	0	Due Date for Follow-Up Postings
64	DUEDATEUPOLD	☐	RECDDUEDATEUP	DATS	DATS	8	0	Due Date for Follow-Up Postings
65	.INCLUDE	☐				0	0	Adjustment Record Fields for Notification/Approval/Rejection
66	ADJMANNOUNCETO	☐	REAJADJMANNOUNCETO	DATUM	DATS	8	0	Date Reply to Notification Is Required
67	ADJMANNOUNCEDATE	☐	REAJADJMANNOUNCEDATE	DATUM	DATS	8	0	Notification Date
68	ADJMANNOUNCEUSER	☐	REAJADJMANNOUNCEUSER	SYCHAR12	CHAR	12	0	Notified By
69	ADJMAPPROVALTO	☐	REAJADJMAPPROVALTO	DATUM	DATS	8	0	Date Up to Which the Approval Must Occur
70	ADJMAPPROVALDATE	☐	REAJADJMAPPROVALDATE	DATUM	DATS	8	0	Approval On
71	ADJMAPPROVALUSER	☐	REAJADJMAPPROVALUSER	SYCHAR12	CHAR	12	0	Approved By
72	ADJMDECLINEDATE	☐	REAJADJMDECLINEDATE	DATUM	DATS	8	0	Rejected On
73	ADJMDECLINEUSER	☐	REAJADJMDECLINEUSER	SYCHAR12	CHAR	12	0	Rejected By
74	.INCLUDE	☐				0	0	Fields of Adjustment Record for the Reversal
75	ADJMREVERSALDATE	☐	REAJADJMREVERSALDATE	DATUM	DATS	8	0	Reversed On
76	ADJMREVERSALUSER	☐	REAJADJMREVERSALUSER	SYCHAR12	CHAR	12	0	Reversed by
77	.INCLUDE	☐				0	0	Fields of Adjustment Record for Correspondence
78	ADJMDOCDATE	☐	REAJADJMDOCDATE	DATUM	DATS	8	0	Adjustment Letter On
79	ADJMDOCCOUNT	☐	REAJADJMDOCCOUNT	INT1	INT1	3	0	Number of Adjustment Letters
80	ADJMDUNLEVEL	☐	REAJADJMDUNLEVEL	INT1	INT1	3	0	Dunning Level
81	ADJMDUNDATE	☐	REAJADJMDUNDATE	DATUM	DATS	8	0	Reminder Letter On
82	ADJMDUNCOUNT	☐	REAJADJMDUNCOUNT	INT1	INT1	3	0	Number of Reminder Letters
83	ADJMAPPDATE	☐	REAJADJMAPPDATE	DATUM	DATS	8	0	Approval Confirmation Letter On
84	ADJMAPPCOUNT	☐	REAJADJMAPPCOUNT	INT1	INT1	3	0	Number of Approval Confirmation Letters
85	ADJMANNDATE	☐	REAJADJMANNDATE	DATUM	DATS	8	0	Date of Last Notification Letter
86	ADJMANNCOUNT	☐	REAJADJMANNCOUNT	INT1	INT1	3	0	Number of Notification Letters
87	.INCLUDE	☐				0	0	Adjustment Record Field for Deactivation
88	ADJMDEACTIVDATE	☐	REAJADJMDEACTIVDATE	DATUM	DATS	8	0	Deactivated On
89	ADJMDEACTIVUSER	☐	REAJADJMDEACTIVUSER	SYCHAR12	CHAR	12	0	Deactivated By

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIAJRECORD	ADJMREASON	TIVAJREASON	ADJMREASON	REF	1	CN
2	VIAJRECORD	ADJMSUBMETH	TIVAJMETH	ADJMMETH	REF	1	CN
3	VIAJRECORD	CARRYOVERCT	TIVCDCONDTYPE	CONDTYPE	REF	1	CN
4	VIAJRECORD	CHGREASON	TIVCDCHGREAS	CHGREASON	REF	1	CN
5	VIAJRECORD	CONDPURPOSENEW	TIVCDCOPUEXT	CONDPURPOSEEXT	KEY	1	CN
6	VIAJRECORD	CONDTYPENEW	TIVCDCONDTYPE	CONDTYPE	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	200