SAP ABAP Table REXA_GUI_ACCT_SHEET_ITEM_L (Contract Account Sheet Items)

Hierarchy

☛

FI-CA (Software Component) FI-CA
⤷

FI-CA (Application Component) Contract Accounts Receivable and Payable
⤷

RE_XA_FC (Package) Real Estate Master Data/Customizing in Contract AP/AR

Basic Data

Table Category	INTTAB	Structure
Structure	REXA_GUI_ACCT_SHEET_ITEM_L	Table Relationship Diagram
Short Description	Contract Account Sheet Items

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	STATUS_ICON	RERASTATUSICON	RECAICON	CHAR	137	0	Line Item Status
2	DOCNUMBER	OPBEL_KK2	OPBEL_KK	CHAR	12	0	Number of document in Contract A/R + A/P	*
3	CNACCT	REXACNACCT	VKONT_KK	CHAR	12	0	Contract Account Number	*
4	ITEMNO	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
5	.INCLUDE				0	0	Tenant Account Sheet Item with Additional Data
6	.INCLUDE				0	0	Tenant Account Sheet Item
7	DOCITEMID	RERADOCITEMID	RERADOCITEMID	CHAR	30	0	Coded Key of FI Document Item for RE Internal Use
8	CUSTOMER	RERACUSTOMERNO	RERAPARTNERNO	CHAR	10	0	Customer Number
9	OIACCOUNTTYPE	RERAOIACCOUNTTYPE	RERAOIACCOUNTTYPE	CHAR	1	0	Account Type
10	OIACCOUNT	RERAOIACCOUNT	RERAOIACCOUNT	CHAR	20	0	Open Item Account
11	PARTNER	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
12	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
13	CONTRACT	RECNNUMBER	RECNNUMBER	CHAR	13	0	Contract Number
14	OBJNR	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
15	OBJNRCALC	RECDOBJNRCALC	J_OBJNR	CHAR	22	0	Object Number for Calculation	*
16	FISCALYEAR	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
17	PSTNGPERIOD	RERAPSTNGPERIOD	RERAFISCALPERIOD	NUMC	2	0	Posting Period
18	PROCESSID	RECAPROCESSID	RECAPROCESSID	CHAR	16	0	Process Identification -> Accounting Reference Number
19	PSTNGPROCEDURE	RERAPROCEDURE	RERAPROCEDURE	CHAR	4	0	Posting Procedure	*
20	REFDOCID	RERAREFDOCID	CHAR20	CHAR	20	0	Reference Key of Document
21	REFITEMNO	RERAREFITEMNO	POSNR_ACC	NUMC	10	0	Reference to Other Item Number of Document
22	LOGSYSTEM	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
23	CONDTYPE	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	*
24	ISADVANCEPAYMENT	RECDADVANCEPAYMENT	RECABOOL	CHAR	1	0	Condition Is Advance Payment Condition
25	FLOWTYPE	RECDFLOWTYPE	RECDFLOWTYPE	CHAR	4	0	Flow Type	*
26	PSTNGDATE	RERAPSTNGDATE	RECADATE	DATS	8	0	Posting Date
27	CLEARINGDATE	RERACLRNGDATE	RECADATE	DATS	8	0	Clearing Date
28	CLRDOCID	RERACLRDOCID	CHAR20	CHAR	20	0	Reference Key of Clearing Document
29	DOCDATE	RERADOCDATE	RECADATE	DATS	8	0	Document Date
30	BLINEDATE	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
31	DCDEBITAMOUNT	RERADCDEBITAMOUNT	RECACURR	CURR	15	2	Debit Amount in Local Currency
32	DCCREDITAMOUNT	RERADCCREDITAMOUNT	RECACURR	CURR	15	2	Credit Amount in Local Currency
33	DCBALANCE	RERADCBALANCE	RECACURR	CURR	15	2	Balance in Local Currency
34	TAXAMOUNT	RERADCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Local Currency
35	CURRENCY	WAERS	WAERS	CUKY	5	0	Currency Key	*
36	TCDEBITAMOUNT	RERATCDEBITAMOUNT	RECACURR	CURR	15	2	Debit Amount in Document Currency (Transaction Currency)
37	TCCREDITAMOUNT	RERATCCREDITAMOUNT	RECACURR	CURR	15	2	Credit Amount in Document Currency (Transaction Currency)
38	TCBALANCE	RERATCBALANCE	RECACURR	CURR	15	2	Balance in Document Currency (Transaction Currency)
39	TCTAXAMOUNT	RERATCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Document Currency (Transaction Currency)
40	TCCURRKEY	RERATCCURRKEY	WAERS	CUKY	5	0	Document Currency (Transaction Currency)	*
41	FCDEBITAMOUNT	RERAFCDEBITAMOUNT	RECACURR	CURR	15	2	Debit Amount in Condition Currency
42	FCCREDITAMOUNT	RERAFCCREDITAMOUNT	RECACURR	CURR	15	2	Credit Amount in Condition Currency
43	FCBALANCE	RERAFCBALANCE	RECACURR	CURR	15	2	Balance in Condition Currency
44	FCTAXAMOUNT	RERAFCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Condition Currency
45	FCCURRKEY	RERAFCCURRKEY	WAERS	CUKY	5	0	Condition Currency	*
46	TAXTYPE	RERATAXTYPE	RERATAXTYPE	CHAR	4	0	Tax Type	*
47	TAXGROUP	RERATAXGROUP	RERATAXGROUP	CHAR	20	0	Tax Group	*
48	CLEARINGSTATUS	RERACLEARINGSTATUS	CHAR02	CHAR	2	0	Clearing status
49	XMACCTSHEETITEM	RERAXLACCTSHEETITEM	RECAXLDESCRIPTION	CHAR	60	0	Name of Contract Account Sheet Item
50	XMACCTSHEETHDR	RERAXLACCTSHEETHDR	RECAXLDESCRIPTION	CHAR	60	0	Name from Document Header
51	OBJ_TYPE	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
52	OBJ_KEY	AWKEY	AWKEY	CHAR	20	0	Object key
53	DUNNBLOCK	RERADUNNBLOCK	CHAR4	CHAR	4	0	Dunning Block
54	DUNNKEY	RERADUNNKEY	CHAR4	CHAR	4	0	Dunning Keys
55	DUNNDATE	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
56	DUNNLEVEL	RERADUNNLEVEL	MAHNS	NUMC	1	0	Dunning Level
57	DUNNAREA	RERADUNNAREA	CHAR4	CHAR	4	0	Dunning Area
58	PYMTMETH	RERAPYMTMETH	CHAR4	CHAR	4	0	Payment Method
59	PYMTTERM	RERAPYMTTERM	ZTERM	CHAR	4	0	Terms of Payment Key
60	PYMTBLOCK	RERAPYMTBLOCK	CHAR4	CHAR	4	0	Payment block key
61	XPYMTBLOCK	TEXTL_008	TEXT20	CHAR	20	0	Explanation of the Reason for Payment Block
62	NETDT	NETDT	DATUM	DATS	8	0	Due Date for Net Payment
63	CALCFROM	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
64	CALCTO	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
65	REVID	RERAREVID	RERAREVID	CHAR	1	0	Indicator for Reversed Documents
66	DOCTYPE	RERADOCTYPE	BLART	CHAR	2	0	Document Type	*
67	TAXAMTINDETERMINABLE	RERATAXAMTINDETERMINABLE	RECABOOL	CHAR	1	0	Not Possible to Determine Unique Tax Amount
68	SPLGIND	RERASPLGIND		CHAR	1	0	Special G/L Indicator
69	TAXRATE	RERATAXRATE	PRZ43V	DEC	7	3	Tax Rate
70	TAXDATE	RERATAXDATE	RECADATE	DATS	8	0	Date of Tax Calculation
71	TXJCD	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
72	HOUSEBKID	RERAHOUSEBKID	CHAR15	CHAR	15	0	Key for House Bank
73	HOUSEBKACC	RERAHOUSEBKACC	CHAR15	CHAR	15	0	Key for House Bank Account
74	BANKDETAILID	RERABANKDETAILID	CHAR15	CHAR	15	0	Bank Details ID
75	CTRULE	RECACTRULE	RECACTRULE	CHAR	20	0	Currency Translation Rule	*
76	CTRATE	RECACTRATE	KURSF	DEC	9	5	Exchange Rate
77	POSTCDCURR	RECACTPOSTCDCURR	RECABOOL	CHAR	1	0	Post in Condition Currency
78	CTDATEREQ	RECACTDATEREQ	DATS	DATS	8	0	Planned Translation Date
79	CTDATEACT	RECACTDATEACT	DATS	DATS	8	0	Actual Translation Date
80	EXTREF1	RERAEXTREF1		CHAR	60	0	External Reference 1 (Line Item)
81	EXTREF2	RERAEXTREF2		CHAR	60	0	External Reference 2 (Line Item)
82	EXTREF3	RERAEXTREF3		CHAR	60	0	External Reference 3 (Line Item)
83	EXTREF4	RERAEXTREF4		CHAR	60	0	External Reference 4 (Line Item)
84	INVREFNUMBER	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
85	INVREFYEAR	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
86	INVREFITEM	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
87	SEPAMNDID	RETMSEPAMNDID	RETMSEPAMNDID	CHAR	35	0	SEPA Mandate: Unique Reference to Mandate per Vendor
88	SEPARECCRDID	RETMSEPARECCRDID	RETMSEPACRDID	CHAR	35	0	SEPA Mandate: Creditor ID
89	XCONDTYPEM	RECDXCONDTYPEM	TEXT20	CHAR	20	0	Name of Condition Type
90	XFLOWTYPE	RECDXFLOWTYPE	TEXT30	CHAR	30	0	Name of Flow Type
91	XTAXTYPE	RERAXMTAXTYPE	RECAXMDESCRIPTION	CHAR	30	0	Name of Tax Type
92	XTAXGROUP	RERAXMTAXGROUP	RECAXMDESCRIPTION	CHAR	30	0	Name of Tax Group
93	IDENTCALC	RECAIDENT	CHAR50	CHAR	50	0	Complete Object Identification, for Example BE 1000/123
94	PROCESSTITLE	RECAPROCESSTITLE	RECAXMDESCRIPTION	CHAR	30	0	Process Name
95	XDUNNBLOCK	TEXT1_040T	TEXT50	CHAR	50	0	Reason for dunning block text
96	XDUNNKEY	RERAXDUNNKEY	RECAXLDESCRIPTION	CHAR	60	0	Name of Dunning Key
97	XDUNNAREA	RERAXDUNNAREA	RECAXLDESCRIPTION	CHAR	60	0	Name of Dunning Area
98	XPYMTMETH	TEXT1_042Z	TEXT30	CHAR	30	0	Name of Payment Method in Language of the Country
99	XPYMTTERM	TEXT1_052	TEXT50	CHAR	50	0	Own Explanation of Term of Payment
100	XREVID	RERAXMREVID	RECAXMDESCRIPTION	CHAR	30	0	Indicator for Reversed Documents
101	XPSTNGPER	REEXPSTNGPERIOD6	REEXPSTNGPERIOD6	NUMC	6	0	Posting Period in MM/YYYY Format