SAP ABAP Table RERA_ACCT_SHEET_ITEM (Tenant Account Sheet Item)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-RA (Application Component) Rental Accounting
     ⤷ RE_RA_CA (Package) RE: Cross Application Rental Accounting

Basic Data

Table Category	INTTAB	Structure
Structure	RERA_ACCT_SHEET_ITEM	Table Relationship Diagram
Short Description	Tenant Account Sheet Item

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	DOCITEMID	☐	RERADOCITEMID	RERADOCITEMID	CHAR	30	0	Coded Key of FI Document Item for RE Internal Use
2	CUSTOMER	☐	RERACUSTOMERNO	RERAPARTNERNO	CHAR	10	0	Customer Number
3	OIACCOUNTTYPE	☐	RERAOIACCOUNTTYPE	RERAOIACCOUNTTYPE	CHAR	1	0	Account Type
4	OIACCOUNT	☐	RERAOIACCOUNT	RERAOIACCOUNT	CHAR	20	0	Open Item Account
5	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
7	CONTRACT	☐	RECNNUMBER	RECNNUMBER	CHAR	13	0	Contract Number
8	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
9	OBJNRCALC	☐	RECDOBJNRCALC	J_OBJNR	CHAR	22	0	Object Number for Calculation	*
10	FISCALYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
11	PSTNGPERIOD	☐	RERAPSTNGPERIOD	RERAFISCALPERIOD	NUMC	2	0	Posting Period
12	PROCESSID	☐	RECAPROCESSID	RECAPROCESSID	CHAR	16	0	Process Identification -> Accounting Reference Number
13	PSTNGPROCEDURE	☐	RERAPROCEDURE	RERAPROCEDURE	CHAR	4	0	Posting Procedure	*
14	REFDOCID	☐	RERAREFDOCID	CHAR20	CHAR	20	0	Reference Key of Document
15	REFITEMNO	☐	RERAREFITEMNO	POSNR_ACC	NUMC	10	0	Reference to Other Item Number of Document
16	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
17	CONDTYPE	☐	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	*
18	ISADVANCEPAYMENT	☐	RECDADVANCEPAYMENT	RECABOOL	CHAR	1	0	Condition Is Advance Payment Condition
19	FLOWTYPE	☐	RECDFLOWTYPE	RECDFLOWTYPE	CHAR	4	0	Flow Type	*
20	PSTNGDATE	☐	RERAPSTNGDATE	RECADATE	DATS	8	0	Posting Date
21	CLEARINGDATE	☐	RERACLRNGDATE	RECADATE	DATS	8	0	Clearing Date
22	CLRDOCID	☐	RERACLRDOCID	CHAR20	CHAR	20	0	Reference Key of Clearing Document
23	DOCDATE	☐	RERADOCDATE	RECADATE	DATS	8	0	Document Date
24	BLINEDATE	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
25	DCDEBITAMOUNT	☐	RERADCDEBITAMOUNT	RECACURR	CURR	15	2	Debit Amount in Local Currency
26	DCCREDITAMOUNT	☐	RERADCCREDITAMOUNT	RECACURR	CURR	15	2	Credit Amount in Local Currency
27	DCBALANCE	☐	RERADCBALANCE	RECACURR	CURR	15	2	Balance in Local Currency
28	TAXAMOUNT	☐	RERADCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Local Currency
29	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
30	TCDEBITAMOUNT	☐	RERATCDEBITAMOUNT	RECACURR	CURR	15	2	Debit Amount in Document Currency (Transaction Currency)
31	TCCREDITAMOUNT	☐	RERATCCREDITAMOUNT	RECACURR	CURR	15	2	Credit Amount in Document Currency (Transaction Currency)
32	TCBALANCE	☐	RERATCBALANCE	RECACURR	CURR	15	2	Balance in Document Currency (Transaction Currency)
33	TCTAXAMOUNT	☐	RERATCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Document Currency (Transaction Currency)
34	TCCURRKEY	☐	RERATCCURRKEY	WAERS	CUKY	5	0	Document Currency (Transaction Currency)	*
35	FCDEBITAMOUNT	☐	RERAFCDEBITAMOUNT	RECACURR	CURR	15	2	Debit Amount in Condition Currency
36	FCCREDITAMOUNT	☐	RERAFCCREDITAMOUNT	RECACURR	CURR	15	2	Credit Amount in Condition Currency
37	FCBALANCE	☐	RERAFCBALANCE	RECACURR	CURR	15	2	Balance in Condition Currency
38	FCTAXAMOUNT	☐	RERAFCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Condition Currency
39	FCCURRKEY	☐	RERAFCCURRKEY	WAERS	CUKY	5	0	Condition Currency	*
40	TAXTYPE	☐	RERATAXTYPE	RERATAXTYPE	CHAR	4	0	Tax Type	*
41	TAXGROUP	☐	RERATAXGROUP	RERATAXGROUP	CHAR	20	0	Tax Group	*
42	CLEARINGSTATUS	☐	RERACLEARINGSTATUS	CHAR02	CHAR	2	0	Clearing status
43	XMACCTSHEETITEM	☐	RERAXLACCTSHEETITEM	RECAXLDESCRIPTION	CHAR	60	0	Name of Contract Account Sheet Item
44	XMACCTSHEETHDR	☐	RERAXLACCTSHEETHDR	RECAXLDESCRIPTION	CHAR	60	0	Name from Document Header
45	OBJ_TYPE	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
46	OBJ_KEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
47	DUNNBLOCK	☐	RERADUNNBLOCK	CHAR4	CHAR	4	0	Dunning Block
48	DUNNKEY	☐	RERADUNNKEY	CHAR4	CHAR	4	0	Dunning Keys
49	DUNNDATE	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
50	DUNNLEVEL	☐	RERADUNNLEVEL	MAHNS	NUMC	1	0	Dunning Level
51	DUNNAREA	☐	RERADUNNAREA	CHAR4	CHAR	4	0	Dunning Area
52	PYMTMETH	☐	RERAPYMTMETH	CHAR4	CHAR	4	0	Payment Method
53	PYMTTERM	☐	RERAPYMTTERM	ZTERM	CHAR	4	0	Terms of Payment Key
54	PYMTBLOCK	☐	RERAPYMTBLOCK	CHAR4	CHAR	4	0	Payment block key
55	XPYMTBLOCK	☐	TEXTL_008	TEXT20	CHAR	20	0	Explanation of the Reason for Payment Block
56	NETDT	☐	NETDT	DATUM	DATS	8	0	Due Date for Net Payment
57	CALCFROM	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
58	CALCTO	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
59	REVID	☐	RERAREVID	RERAREVID	CHAR	1	0	Indicator for Reversed Documents
60	DOCTYPE	☐	RERADOCTYPE	BLART	CHAR	2	0	Document Type	*
61	TAXAMTINDETERMINABLE	☐	RERATAXAMTINDETERMINABLE	RECABOOL	CHAR	1	0	Not Possible to Determine Unique Tax Amount
62	SPLGIND	☐	RERASPLGIND		CHAR	1	0	Special G/L Indicator
63	TAXRATE	☐	RERATAXRATE	PRZ43V	DEC	7	3	Tax Rate
64	TAXDATE	☐	RERATAXDATE	RECADATE	DATS	8	0	Date of Tax Calculation
65	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
66	HOUSEBKID	☐	RERAHOUSEBKID	CHAR15	CHAR	15	0	Key for House Bank
67	HOUSEBKACC	☐	RERAHOUSEBKACC	CHAR15	CHAR	15	0	Key for House Bank Account
68	BANKDETAILID	☐	RERABANKDETAILID	CHAR15	CHAR	15	0	Bank Details ID
69	CTRULE	☐	RECACTRULE	RECACTRULE	CHAR	20	0	Currency Translation Rule	*
70	CTRATE	☐	RECACTRATE	KURSF	DEC	9	5	Exchange Rate
71	POSTCDCURR	☐	RECACTPOSTCDCURR	RECABOOL	CHAR	1	0	Post in Condition Currency
72	CTDATEREQ	☐	RECACTDATEREQ	DATS	DATS	8	0	Planned Translation Date
73	CTDATEACT	☐	RECACTDATEACT	DATS	DATS	8	0	Actual Translation Date
74	EXTREF1	☐	RERAEXTREF1		CHAR	60	0	External Reference 1 (Line Item)
75	EXTREF2	☐	RERAEXTREF2		CHAR	60	0	External Reference 2 (Line Item)
76	EXTREF3	☐	RERAEXTREF3		CHAR	60	0	External Reference 3 (Line Item)
77	EXTREF4	☐	RERAEXTREF4		CHAR	60	0	External Reference 4 (Line Item)
78	INVREFNUMBER	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
79	INVREFYEAR	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
80	INVREFITEM	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
81	SEPAMNDID	☐	RETMSEPAMNDID	RETMSEPAMNDID	CHAR	35	0	SEPA Mandate: Unique Reference to Mandate per Vendor
82	SEPARECCRDID	☐	RETMSEPARECCRDID	RETMSEPACRDID	CHAR	35	0	SEPA Mandate: Creditor ID

History

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