SAP ABAP Table REIS_ACR_ITEM_L (Reporting: Accrual/Deferral Records)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-IS (Application Component) Information System
     ⤷ RE_IS_EX (Package) RE: External Applications Info System

Basic Data

Table Category	INTTAB	Structure
Structure	REIS_ACR_ITEM_L	Table Relationship Diagram
Short Description	Reporting: Accrual/Deferral Records

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	Line Items for Accrual Item in Accrual Engine
2	.INCLUDE	☐				0	0	Unique Key for Table ACEPSOIT (Document in Accrual Engine)
3	.INCLUDE	☐				0	0	Keys of Accrual Posting Object
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
5	COMP	☐	ACE_COMP	ACE_COMP	CHAR	4	0	Accrual Engine Application Component	*
6	BUKRS	☐	ACE_BUKRS	ACE_BUKRS	CHAR	4	0	Company Code	*
7	GJAHR	☐	ACEPS_GJAHR	GJAHR	NUMC	4	0	Fiscal Year in Accrual Engine
8	OBJID	☐	ACE_GUID	ACE_GUID	RAW	16	0	Accrual Object (Internal Display in Form of a GUID)	*
9	SUBID	☐	ACE_SUBID		NUMC	5	0	Accrual Subobject (Internal Display, Sequence Number)
10	ACRTYPE	☐	ACE_ACRTYPE	ACE_ACRTYPE	CHAR	6	0	Accrual Type	TACE_ACRTYPE
11	ACCRULE	☐	ACCOUNTING_PRINCIPLE	ACCOUNTING_PRINCIPLE	CHAR	4	0	Accounting Principle	TACC_PRINCIPLE
12	DOCNR	☐	ACEPS_DOCNR	CHAR15	CHAR	15	0	Document Number of an Accrual Engine Document
13	.INCLUDE	☐				0	0	Attributes: Accrual Item in Posting Component
14	VALCUM	☐	ACE_AMOUNT_CUMULATED		CURR	15	2	Cumulative Value (Previously Accrued)
15	VALTBP	☐	ACE_AMOUNT_TBP		CURR	15	2	Amount Currently Posted
16	CURRENCY	☐	ACEDS_VALCURRENCY	WAERS	CUKY	5	0	Currency Calculated/Posted in the Accrual Amounts	*
17	TRANSTYPE	☐	ACE_TRANSTYPE	ACE_TRANSTYPE	CHAR	1	0	Transaction in Accrual Engine
18	EFFDATE	☐	ACE_EFFDATE		DATS	8	0	Key Date/Posting Date for Accruals
19	PODATE	☐	ACE_PODATE	DATUM	DATS	8	0	Posting Date
20	POPER	☐	ACE_POPER	POPER	NUMC	3	0	Posting Period in Financial Accounting
21	POYEAR	☐	ACE_POYEAR	GJAHR	NUMC	4	0	Fiscal Year in Financial Accounting
22	RUNID	☐	ACEPS_RUNID	ACEPS_RUNID	CHAR	10	0	Number (Run ID) of a Periodic Accrual Run in the Accl Engine
23	.INCLUDE	☐				0	0	Reference to FI/CO Document
24	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
25	AWKEY	☐	ACE_AWKEY	AWKEY	CHAR	20	0	Reference Key for Accounting Document
26	AWSYS	☐	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	*
27	TIMESTMP	☐	ACE_HZSTMP	ACE_TSTMP	DEC	16	0	Time Added (Greenwich Meantime)
28	.INCLUDE	☐				0	0	Reversal Information
29	REVERSAL_DOC	☐	ACEPS_FLAG_REVERSAL_DOC	FLAG	CHAR	1	0	Indicator: Document Is a Reversal Document
30	REVERSED_DOC	☐	ACEPS_DOCNR_REVERSED	CHAR15	CHAR	15	0	Number of the Reversed Accrual Engine Document
31	AMOUNT_INV	☐	RERAACRAMOUNTINV		CURR	15	2	Amount Currently Posted (Inverse +/- Sign)
32	BELNR	☐	CO_BELNR	CO_BELNR	CHAR	10	0	Document Number	*
33	PROCESSID	☐	RECAPROCESSID	RECAPROCESSID	CHAR	16	0	Process Identification -> Accounting Reference Number
34	ACRVALIDFROM	☐	RERAACRVALIDFROM		DATS	8	0	Start of Life of an Accrual Subobject
35	ACRVALIDTO	☐	RERAACRVALIDTO		DATS	8	0	End of Life of an Accrual Subobject
36	RECNNR	☐	RECNNR	RECNNR	CHAR	13	0	Real Estate Contract Number
37	.INCLUDE	☐				0	0	RE Contract: Non-Key Fields
38	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
39	IMKEY	☐	RECAIMKEY	IMKEY	CHAR	8	0	Internal Key of Real Estate Object (FI)
40	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
41	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
42	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
43	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
44	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
45	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
46	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
47	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
48	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
49	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
50	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
51	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
52	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
53	RECNTYPE	☐	RECNCONTRACTTYPE	SMVART	CHAR	4	0	Contract Type	TIV26
54	RECNBEG	☐	RECNCNBEG	RECADATE	DATS	8	0	Date of contract start
55	RECNENDABS	☐	RECNCNENDABS	RECADATEEND	DATS	8	0	Term End Date
56	RECNTXT	☐	RECNTXT	XTEXT80	CHAR	80	0	Contract name
57	RECNDACTIV	☐	DAKTV	DATUM	DATS	8	0	Contract activation
58	RECNTLAW	☐	SMIETR	SMIETR	CHAR	5	0	Tenancy law	TIV03
59	RECNTXTOLD	☐	VVOSMIVE	VVOSMIVE	CHAR	20	0	Number of old contract
60	RECNBUKRSCOLLECT	☐	RECNBUKRSCOLLECT	BUKRS	CHAR	4	0	Company code of main contract	T001
61	RECNNRCOLLECT	☐	RECNNUMBERCOLLECT	RECNNUMBER	CHAR	13	0	Number of Real Estate Main Contract
62	RECNCNCURR	☐	RECNWAERS_CN	WAERS	CUKY	5	0	Currency for Contract	TCURC
63	INDUSTRY	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	*
64	SRRELEVANT	☐	RECNSALESRENTRELEVANT	RECABOOL	CHAR	1	0	Relevant to Sales
65	DPTARGETTYPE	☐	RECNDPTYPE	RECNDPTYPE	CHAR	4	0	Security Deposit Type	TIVCNDPTYPE
66	RECNDAT	☐	RECNDAT	DDAT	DATS	8	0	Date of Contract Conclusion
67	RECN2DAT	☐	RECN2DAT	RECADATE	DATS	8	0	Date of Second Signature
68	RECNDPO	☐	RECDCFSTARTFROM	RECADATE	DATS	8	0	Cash Flow Generated Starting On
69	RECNEND1ST	☐	RECNCNEND1ST	RECADATE	DATS	8	0	Date of First Contract End
70	RECNNOTPER	☐	RECNNTPER	RECADATE	DATS	8	0	Contract Notice Per
71	RECNNOTRECEIPT	☐	RECNNTRECEIPT	RECADATE	DATS	8	0	Date of receipt of notice
72	RECNNOTREASON	☐	RECNNTREASON	RECNNTREASON	NUMC	2	0	Reason for Notice	TIVCNNTRE
73	RECNDAKTKU	☐	RECNNTACTIVATEDON	RECADATE	DATS	8	0	Notice: Date of Activation
74	CFARCHIVEDTO	☐	RECDCFARCHIVEDTO	RECADATE	DATS	8	0	Date Up to Which the Cash Flow Is Archived
75	CFLOCKEDTO	☐	RECDCFLOCKEDTO	RECADATE	DATS	8	0	Date Until Which the Cash Flow Is Locked
76	CFPOSTINGFROM	☐	RECDCFPOSTINGFROM	RECADATE	DATS	8	0	First Posting From
77	BENOCN	☐	RECNBENOCN	REBDBENO	CHAR	8	0	Business Entity That Belongs to Contract	*
78	TRANSPOSSFROM	☐	RECNTRANSPOSSFROM	RECADATEBEG	DATS	8	0	Transfer of Possession: Start Date
79	TRANSPOSSTO	☐	RECNTRANSPOSSTO	RECADATEEND	DATS	8	0	Transfer of Possession: End Date
80	HASMULTIASSIGN	☐	REBDHASMULTIASSIGN	RECABOOL	CHAR	1	0	Multiple Assignment of Object to Group Allowed
81	POSSDATEFROM	☐	REBDPOSSDATEFROM	RECADATE	DATS	8	0	Date From Which the Object Is Made Available for Use
82	POSSDATETO	☐	REBDPOSSDATETO	RECADATE	DATS	8	0	Date Up to Which the Object Is Used
83	.INCLUDE	☐				0	0
84	.INCLU--AP	☐				0	0	Country Specific Fields for Spain
85	.INCLUDE	☐				0	0	Country-Specific Fields for Spain - Contract
86	SECDEPRELEVANT	☐	REXCESCDREL	XFELD	CHAR	1	0	Relevant to Security Deposit
87	NOTADJSDCN	☐	REXCESCDNOTADJ	RECABOOL	CHAR	1	0	No Data Update in Security Deposit Contract
88	ACROBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
89	ACROBJ	☐	RERAACROBJ	CHAR50	CHAR	50	0	Accrual Object ID
90	ASSIGNOBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
91	ASSIGNOBJ	☐	RERAASSIGNOBJ	CHAR50	CHAR	50	0	Accrual Subobject ID
92	ACROBJGUID	☐	RERAACROBJGUID	RECAGUID	RAW	16	0	GUID: Unique Key for External Accrual Object
93	REFGUID	☐	RERAREFGUID	RECAGUID	RAW	16	0	Reference GUID
94	REFGUIDORIGIN	☐	RERAGUIDORIGIN	CHAR04	CHAR	4	0	Source of GUID
95	.INCLUDE	☐				0	0	Reporting Fields: Generic Part
96	GEN_OBJTYPE	☐	RECAOBJTYPE	J_OBART	CHAR	2	0	Object Type	*
97	GEN_OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
98	GEN_CONTRACT	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
99	GEN_PARTNER1	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
100	GEN_PARTNER2	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
101	ALVROWS	☐	REISALVROWS		INT2	5	0	Number of Rows
102	.INCLUDE	☐				0	0	Reporting Fields: Main Contractual Partner
103	ROLE_BP1	☐	REBPROLE1	BU_ROLE	CHAR	6	0	First Main Contractual Partner: Role	*
104	XROLE_BP1	☐	REBPXROLE1	RECAXMDESCRIPTION	CHAR	30	0	1st Main Contractual Partner: Name of Role Category
105	PARTNER_BP1	☐	REBPPARTNER1	BU_PARTNER	CHAR	10	0	First Main Contractual Partner	*
106	XPARTNER_BP1	☐	REBPXPARTNER1	TEXT80	CHAR	80	0	Name/Address of 1st Business Partner
107	TEL_NUMBER_LONG_BP1	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
108	FAX_NUMBER_LONG_BP1	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
109	SMTP_ADDR_BP1	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
110	XNAME_BP1	☐	REBPXNAME1	BU_TEXT50	CHAR	50	0	Short Description of 1st Business Partner
111	STREET_BP1	☐	AD_STREET	TEXT60	CHAR	60	0	Street
112	HOUSE_NUM1_BP1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
113	POST_CODE1_BP1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
114	CITY1_BP1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
115	CITY2_BP1	☐	AD_CITY2	TEXT40	CHAR	40	0	District
116	REGION_BP1	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
117	PO_BOX_BP1	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
118	POST_CODE2_BP1	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
119	ROLE_BP2	☐	REBPROLE2	BU_ROLE	CHAR	6	0	Second Main Contractual Partner: Role	*
120	XROLE_BP2	☐	REBPXROLE2	RECAXMDESCRIPTION	CHAR	30	0	2nd Main Contractual Partner: Name of Role Category
121	PARTNER_BP2	☐	REBPPARTNER2	BU_PARTNER	CHAR	10	0	Second Main Contractual Partner	*
122	XPARTNER_BP2	☐	REBPXPARTNER2	TEXT80	CHAR	80	0	Name/Address of 2nd Business Partner
123	TEL_NUMBER_LONG_BP2	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
124	FAX_NUMBER_LONG_BP2	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
125	SMTP_ADDR_BP2	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
126	XNAME_BP2	☐	REBPXNAME2	BU_TEXT50	CHAR	50	0	Short Description of 2nd Business Partner
127	STREET_BP2	☐	AD_STREET	TEXT60	CHAR	60	0	Street
128	HOUSE_NUM1_BP2	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
129	POST_CODE1_BP2	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
130	CITY1_BP2	☐	AD_CITY1	TEXT40	CHAR	40	0	City
131	CITY2_BP2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
132	REGION_BP2	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
133	PO_BOX_BP2	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
134	POST_CODE2_BP2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
135	.INCLUDE	☐				0	0	Time Slot Valid in a Row in the Info System
136	RECISVALIDFROM	☐	REISRECVALIDFROM	RECADATE	DATS	8	0	Displayed Row Is Valid From
137	RECISVALIDTO	☐	REISRECVALIDTO	RECADATE	DATS	8	0	Displayed Row Is Valid Until

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REIS_ACR_ITEM_L	ACCRULE	TACC_PRINCIPLE	ACC_PRINCIPLE	KEY
2	REIS_ACR_ITEM_L	ACRTYPE	TACE_ACRTYPE	ACRTYPE	KEY
3	REIS_ACR_ITEM_L	DPTARGETTYPE	TIVCNDPTYPE	DPTYPE	REF	C	CN
4	REIS_ACR_ITEM_L	RECNBUKRSCOLLECT	T001	BUKRS	REF	C	CN
5	REIS_ACR_ITEM_L	RECNCNCURR	TCURC	WAERS	REF	1	CN
6	REIS_ACR_ITEM_L	RECNNOTREASON	TIVCNNTRE	NTREASON	REF	C	CN
7	REIS_ACR_ITEM_L	RECNTLAW	TIV03	SMIETR	REF	C	CN
8	REIS_ACR_ITEM_L	RECNTYPE	TIV26	SMVART	KEY	1	CN
9	REIS_ACR_ITEM_L	RESPONSIBLE	USR02	BNAME	REF	1	CN
10	REIS_ACR_ITEM_L	USEREXCLUSIVE	USR02	BNAME	REF	C	CN

History

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