SAP ABAP Table REAJ_ADJM_RECORD_L (Adjustment Records Grid)

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	REAJ_ADJM_RECORD_L	Table Relationship Diagram
Short Description	Adjustment Records Grid

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 Records Including Additional Fields
2	.INCLUDE	☐				0	0	Adjustment record
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	.INCLUDE	☐				0	0	Adjustment Record: Key Fields
5	RECORDGUID	☐	REAJRECORDGUID	RECAGUID	RAW	16	0	Generic Key of Adjustment Record
6	.INCLUDE	☐				0	0	Adjustment Record: Non-Key Fields
7	PROCESSGUID	☐	RECAPROCESSGUID	RECAGUID	RAW	16	0	Generic Key of Process	VICAPROCESSID
8	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
9	TERMNO	☐	RETMTERMNO	RETMTERMNO	CHAR	4	0	Term Number
10	ADJMRULE	☐	REAJADJMRULE	REAJADJMRULE	CHAR	10	0	Adjustment Rule	TIVAJRULE
11	ADJMSUBRULE	☐	REAJADJMSUBRULE	REAJADJMRULE	CHAR	10	0	Elementary Adjustment Rule (Part of Comb. Rule)	TIVAJRULE
12	ADJMSUBMETH	☐	REAJADJMMETH	REAJADJMMETH	CHAR	4	0	Adjustment Method	TIVAJMETH
13	ADJMDRECORDSTAT	☐	REAJADJMDRECORDSTAT	REAJADJMDRECORDSTAT	NUMC	1	0	Status of an Adjustment Record
14	ADJMRULEDEFAULT	☐	REAJADJMRULEDEFAULT	REAJADJMRULE	CHAR	10	0	Alternative Adjustment Rule	TIVAJRULE
15	ADJMRECSTEPNO	☐	REAJADJMRECSTEPNO	NUMC8	NUMC	8	0	Sequential Number of Adjustment Step
16	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
17	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
18	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
19	FDELETE	☐	RECAARDELETEIND	RECABOOL	CHAR	1	0	Deletion Indicator for Archiving
20	.INCLUDE	☐				0	0	Fields of Adjustment Record for the Method
21	CONDGUIDOLD	☐	RECDCONDGUID	RECAGUID	RAW	16	0	GUID (RAW16) for Conditions
22	CONDGUIDNEW	☐	RECDCONDGUID	RECAGUID	RAW	16	0	GUID (RAW16) for Conditions
23	CONDGUIDREF	☐	RECDCONDGUID	RECAGUID	RAW	16	0	GUID (RAW16) for Conditions
24	ADJMFROMOLD	☐	REAJADJMVALIDFROM	DATUM	DATS	8	0	Valid-From Date of New Condition Item
25	ADJMFROMCALC	☐	REAJADJMVALIDFROM	DATUM	DATS	8	0	Valid-From Date of New Condition Item
26	ADJMFROMMOD	☐	REAJADJMVALIDFROM	DATUM	DATS	8	0	Valid-From Date of New Condition Item
27	UNITPRICEOLD	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
28	UNITPRICECALC	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
29	UNITPRICEMOD	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
30	ADJMCONDDELETE	☐	REAJADJMCONDDELETE	RECABOOL	CHAR	1	0	Condition Is Deleted
31	METHREFGUID	☐	REAJMETHREFGUID	RECAGUID	RAW	16	0	Reference to Process-Specific Data for Adjustment Record
32	ADJMFROMMODDATE	☐	REAJADJMFROMMODDATE	DATUM	DATS	8	0	Valid-From Date Changed On
33	ADJMFROMMODUSER	☐	REAJADJMFROMMODUSER	SYCHAR12	CHAR	12	0	Valid-From Date Changed By
34	UNITPRICEMODDATE	☐	REAJUNITPRICEMODDATE	DATUM	DATS	8	0	Valid-From Date Changed On
35	UNITPRICEMODUSER	☐	REAJUNITPRICEMODUSER	SYCHAR12	CHAR	12	0	Price Changed By
36	CONDVALIDTOOLD	☐	RECDVALIDTO	RECADATEEND	DATS	8	0	Date up to when condition is valid
37	ADJMCONDNEW	☐	REAJNEWCOND	RECABOOL	CHAR	1	0	New Condition on Target
38	UPBEFORECAPPING	☐	REAJUPBEFORECAPPING	RECDUNITPRICE	DEC	19	6	Unit Price Before Capping
39	MONTHCAPPING	☐	REAJPERIODMONTH	NUMC3	NUMC	3	0	Time in Months
40	DISSOLVEINGUID	☐	REAJDISSOLVEINGUID	RECAGUID	RAW	16	0	Reference to Condition That Contains the Cancellation
41	ADJMREASON	☐	REAJADJMREASON	REAJADJMREASON	CHAR	10	0	Adjustment Reason	TIVAJREASON
42	CHGREASON	☐	RECDCHGREASON	RECDCHGREASON	CHAR	10	0	Reason for Change	TIVCDCHGREAS
43	CHGREASONOLD	☐	RECDCHGREASON	RECDCHGREASON	CHAR	10	0	Reason for Change	*
44	CARRYFROMGUID	☐	REAJCARRYFROMGUID	RECAGUID	RAW	16	0	Reference to Transferred Condition
45	CARRYOVERCT	☐	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	TIVCDCONDTYPE
46	RECGROUPGUID	☐	REAJRECGROUPGUID	RECAGUID	RAW	16	0	GUID for Grouping Adjustment Records
47	INTRENODEPEND	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
48	RECORDUPDATE	☐	REAJRECORDUPDATE	RECABOOL	CHAR	1	0	Record Was Updated
49	UNITPRICEANN	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
50	ADJMFROMANN	☐	REAJADJMVALIDFROM	DATUM	DATS	8	0	Valid-From Date of New Condition Item
51	CONDPURPOSENEW	☐	RECDCONDPURPOSEEXT	RECDCONDPURPOSEEXT	CHAR	4	0	Conditions - External Purpose	TIVCDCOPUEXT
52	CONDTYPECEA	☐	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	*
53	CONDTYPENEW	☐	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	TIVCDCONDTYPE
54	TERMNOAJNEW	☐	RETMTERMNO	RETMTERMNO	CHAR	4	0	Term Number
55	TAKETERMNO	☐	REAJTAKETERMNO	RECABOOL	CHAR	1	0	Copy Terms
56	MAXINCREL	☐	REAJMAXINCREL	DEC5_2	DEC	7	2	Maximum Increase in Percent
57	UPLESSCAPMONTH	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
58	ADJMFROMLESSCM	☐	REAJADJMVALIDFROM	DATUM	DATS	8	0	Valid-From Date of New Condition Item
59	UPPOSMARGIN	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
60	UPPOSMARGINUSED	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
61	UPINCALLOWED	☐	RECDUNITPRICE	RECDUNITPRICE	DEC	19	6	Unit Price
62	.INCLUDE	☐				0	0	Fields of Adjustment Record for Activation
63	ADJMACTIVDATE	☐	REAJADJMACTIVDATE	DATUM	DATS	8	0	Activated On
64	ADJMACTIVUSER	☐	REAJADJMACTIVUSER	SYCHAR12	CHAR	12	0	Activated By
65	DUEDATEUP	☐	RECDDUEDATEUP	DATS	DATS	8	0	Due Date for Follow-Up Postings
66	DUEDATEUPOLD	☐	RECDDUEDATEUP	DATS	DATS	8	0	Due Date for Follow-Up Postings
67	.INCLUDE	☐				0	0	Adjustment Record Fields for Notification/Approval/Rejection
68	ADJMANNOUNCETO	☐	REAJADJMANNOUNCETO	DATUM	DATS	8	0	Date Reply to Notification Is Required
69	ADJMANNOUNCEDATE	☐	REAJADJMANNOUNCEDATE	DATUM	DATS	8	0	Notification Date
70	ADJMANNOUNCEUSER	☐	REAJADJMANNOUNCEUSER	SYCHAR12	CHAR	12	0	Notified By
71	ADJMAPPROVALTO	☐	REAJADJMAPPROVALTO	DATUM	DATS	8	0	Date Up to Which the Approval Must Occur
72	ADJMAPPROVALDATE	☐	REAJADJMAPPROVALDATE	DATUM	DATS	8	0	Approval On
73	ADJMAPPROVALUSER	☐	REAJADJMAPPROVALUSER	SYCHAR12	CHAR	12	0	Approved By
74	ADJMDECLINEDATE	☐	REAJADJMDECLINEDATE	DATUM	DATS	8	0	Rejected On
75	ADJMDECLINEUSER	☐	REAJADJMDECLINEUSER	SYCHAR12	CHAR	12	0	Rejected By
76	.INCLUDE	☐				0	0	Fields of Adjustment Record for the Reversal
77	ADJMREVERSALDATE	☐	REAJADJMREVERSALDATE	DATUM	DATS	8	0	Reversed On
78	ADJMREVERSALUSER	☐	REAJADJMREVERSALUSER	SYCHAR12	CHAR	12	0	Reversed by
79	.INCLUDE	☐				0	0	Fields of Adjustment Record for Correspondence
80	ADJMDOCDATE	☐	REAJADJMDOCDATE	DATUM	DATS	8	0	Adjustment Letter On
81	ADJMDOCCOUNT	☐	REAJADJMDOCCOUNT	INT1	INT1	3	0	Number of Adjustment Letters
82	ADJMDUNLEVEL	☐	REAJADJMDUNLEVEL	INT1	INT1	3	0	Dunning Level
83	ADJMDUNDATE	☐	REAJADJMDUNDATE	DATUM	DATS	8	0	Reminder Letter On
84	ADJMDUNCOUNT	☐	REAJADJMDUNCOUNT	INT1	INT1	3	0	Number of Reminder Letters
85	ADJMAPPDATE	☐	REAJADJMAPPDATE	DATUM	DATS	8	0	Approval Confirmation Letter On
86	ADJMAPPCOUNT	☐	REAJADJMAPPCOUNT	INT1	INT1	3	0	Number of Approval Confirmation Letters
87	ADJMANNDATE	☐	REAJADJMANNDATE	DATUM	DATS	8	0	Date of Last Notification Letter
88	ADJMANNCOUNT	☐	REAJADJMANNCOUNT	INT1	INT1	3	0	Number of Notification Letters
89	.INCLUDE	☐				0	0	Adjustment Record Field for Deactivation
90	ADJMDEACTIVDATE	☐	REAJADJMDEACTIVDATE	DATUM	DATS	8	0	Deactivated On
91	ADJMDEACTIVUSER	☐	REAJADJMDEACTIVUSER	SYCHAR12	CHAR	12	0	Deactivated By
92	ADJMSUBINDEX	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
93	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
94	XADJMDRECORDSTAT	☐	REAJXADJMDRECORDSTAT	REAJXADJMDRECORDSTAT	CHAR	60	0	Name of Status of an Adjustment Record
95	PROCESSEXTID	☐	RECAPROCESSEXTID	RECAPROCESSEXTID	CHAR	32	0	External Identification Process
96	XOBJECTID	☐	REBDOBJECTID	ABR_EMP	CHAR	35	0	Object Identification
97	XADJMSUBRULE	☐	REAJXADJMRULE	RECAXLDESCRIPTION	CHAR	60	0	Naem of Adjustment Rule
98	XCONDITIONOLD	☐	REAJXCONDITION	REAJXADJMDRECORDSTAT	CHAR	60	0	Description of Condition
99	XSCONDITIONOLD	☐	REAJXCONDITION	REAJXADJMDRECORDSTAT	CHAR	60	0	Description of Condition
100	XADJMMETH	☐	REAJXADJMMETH	RECAXLDESCRIPTION	CHAR	60	0	Name of Adjustment Method
101	XTERM	☐	REAJXADJMRULE	RECAXLDESCRIPTION	CHAR	60	0	Naem of Adjustment Rule
102	DTCHANGEABLE	☐	REAJDTCHANGEABLE	RECABOOL	CHAR	1	0	Indicator: Is valid-from date manually changeable?
103	CHANGEDIRECTION	☐	REAJCHANGEDIRECTION	REAJCHANGEDIRECTION	CHAR	1	0	How (+/-/=) Can the Amount Be Changed After Adjustment
104	CONDGROUP	☐	RECDCONDGROUP	RECDCONDGROUP	CHAR	4	0	Condition Group	TIVCDCONDGROUP
105	CONDTYPE	☐	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	*
106	CONDPURPOSE	☐	RECDCONDPURPOSEEXT	RECDCONDPURPOSEEXT	CHAR	4	0	Conditions - External Purpose	TIVCDCOPUEXT
107	XCONDPURPOSE	☐	RECDXMCONDPURPOSEEXT	RECAXMDESCRIPTION	CHAR	30	0	Name of Conditions for External Purpose
108	XCONDTYPE	☐	RECDXCONDTYPEL	RECAXMDESCRIPTION	CHAR	30	0	Name of Condition Type
109	CONDOBJ	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
110	XCONDOBJ	☐	REBDOBJECTID	ABR_EMP	CHAR	35	0	Object Identification
111	METHORDER	☐	REAJMETHORDER	NUMC3	NUMC	3	0	Sort Sequence of Methods for the Adjustment Process
112	ANNOUNCE	☐	REAJANNOUNCE	RECABOOL	CHAR	1	0	Notification Required for Adjustment?
113	APPROVAL	☐	REAJAPPROVAL	RECABOOL	CHAR	1	0	Indicator: Approval for Adjustment Required?
114	ACTIFNOAPPR	☐	REAJACTIFNOAPPR	RECABOOL	CHAR	1	0	Indicator: Activation Without Approval Possible
115	TAKEVALUE	☐	REAJTAKEVALUE	RECABOOL	CHAR	1	0	Value Transfer
116	SIMULATIONRULE	☐	REAJSIMULATIONRULE	RECABOOL	CHAR	1	0	Indicator: Adjustment Rule Is Allowed for Simulation Only
117	NEXTADJMDATE	☐	REAJNEXTADJMDATE	DATUM	DATS	8	0	Date of Next Possible Adjustment
118	FIRSTADJMDATE	☐	REAJFIRSTADJMDATE	DATUM	DATS	8	0	Date of First Adjustment
119	LASTADJMDATE	☐	REAJLASTADJMDATE	DATUM	DATS	8	0	Date of Last Adjustment
120	DISSOLVED	☐	REAJDISSOLVED	RECABOOL	CHAR	1	0	Cancelled
121	CARRYOVER	☐	REAJCARRYOVER	RECABOOL	CHAR	1	0	Carry Over
122	PERCENTAGEPASS	☐	REAJPERCENTAGEPASS	RECAPROZ3_2	DEC	5	2	Percentage with Which the Adjustment Amount Is Passed-On
123	XADJMREASON	☐	REAJXADJMREASON	RECAXLDESCRIPTION	CHAR	60	0	Name of Adjustment Reason
124	XCHGREASON	☐	RECDXCHGREASON	RECAXLDESCRIPTION	CHAR	60	0	Name of Change Reason
125	UNITPRICEDIFF	☐	REAJUNITPRICEDIFF	RECDUNITPRICE	DEC	19	6	Unit Price Difference
126	VALIDFROMEFF	☐	REAJVALIDFROMEFF	DATUM	DATS	8	0	Effective Valid-From Date of New Condition Item
127	UNITPRICEEFF	☐	REAJUNITPRICEEFF	RECDUNITPRICE	DEC	19	6	Effective Unit Price
128	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
129	ADJMACTLOCK	☐	REAJADJMACTLOCK	RECABOOL	CHAR	1	0	Activation of Adjustment Is Locked
130	ISCEARULE	☐	RECABOOL	RECABOOL	CHAR	1	0	General Yes/No Field
131	NODOCUMENT	☐	REAJNODOCUMENT	RECABOOL	CHAR	1	0	Indicator: No Adjustment Document
132	PTRBUSOBJECT	☐	IF_RECA_BUS_OBJECT		REF	0	0
133	PTRTERMMNGR	☐	IF_RETM_TERM_MNGR		REF	0	0
134	PTRADJMTERMMNGR	☐	IF_REAJ_TERM_MNGR		REF	0	0
135	PTRCONDITIONMNGR	☐	IF_RECD_CONDITION_MNGR		REF	0	0
136	PTRCONDITIONOLD	☐	IF_RECD_CONDITION		REF	0	0
137	PTROBJECTMNGR	☐	IF_REBD_OBJ_ASSIGN_MNGR		REF	0	0
138	PTRMETHOD	☐	IF_REAJ_METHOD		REF	0	0
139	PTRRHYTHMMNGR	☐	IF_RETM_RHYTHM_MNGR		REF	0	0
140	ADJMRELATIVE	☐	REAJADJMRELATIVE	REBDMEASPERC	DEC	10	2	Relative Change to Price
141	SIMULATIONRUN	☐	RECABOOL	RECABOOL	CHAR	1	0	General Yes/No Field
142	ICONADJMDRECORDSTAT	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
143	ICONUNITPRICEMOD	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
144	ICONADJMFROMMOD	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
145	ICONACTIVATE	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
146	ICONDUEDATEUP	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
147	ICONPROTOCOL	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
148	ICONSIMULATE	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
149	ICONADJMAPPROVALTO	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
150	ICONADJMAPPROVALDATE	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
151	ICONADJMANNOUNCETO	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
152	ICONADJMANNOUNCEDATE	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
153	ICONADJMDECLINEDATE	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
154	ICONADJMREVERSAL	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
155	ICONADJMDOCUMENT	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
156	COLOR	☐	LVC_T_SCOL		TTYP	0	0
157	CELL	☐	LVC_T_STYL		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REAJ_ADJM_RECORD_L	ADJMREASON	TIVAJREASON	ADJMREASON	REF	1	CN
2	REAJ_ADJM_RECORD_L	ADJMSUBMETH	TIVAJMETH	ADJMMETH	REF	1	CN
3	REAJ_ADJM_RECORD_L	CARRYOVERCT	TIVCDCONDTYPE	CONDTYPE	REF	1	CN
4	REAJ_ADJM_RECORD_L	CHGREASON	TIVCDCHGREAS	CHGREASON	REF	1	CN
5	REAJ_ADJM_RECORD_L	CONDGROUP	TIVCDCONDGROUP	CONDGROUP	REF	1	CN
6	REAJ_ADJM_RECORD_L	CONDPURPOSE	TIVCDCOPUEXT	CONDPURPOSEEXT	REF	1	CN
7	REAJ_ADJM_RECORD_L	CONDPURPOSENEW	TIVCDCOPUEXT	CONDPURPOSEEXT	KEY	1	CN
8	REAJ_ADJM_RECORD_L	CONDTYPENEW	TIVCDCONDTYPE	CONDTYPE	KEY	1	CN
9	REAJ_ADJM_RECORD_L	CURRENCY	TCURC	WAERS	REF	1	CN

History

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