SAP ABAP Table AVIAJRECORD (Change Document Structure - Adjustment Record (VIAJRECORD))

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	AVIAJRECORD	Table Relationship Diagram
Short Description	Change Document Structure - Adjustment Record (VIAJRECORD)

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

Foreign Keys

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

History

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