SAP ABAP Table VIAJRECORD_TAB (Adjustment Record: Non-Key Fields)

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	INTTAB	Structure
Structure	VIAJRECORD_TAB	Table Relationship Diagram
Short Description	Adjustment Record: Non-Key Fields

Delivery and Maintenance

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

History

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