SAP ABAP Table REXCITIRE_L (IRE List reporting)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_XC_RA_IT (Package) RE: XC - Localisation of Flexible Real Estate for Italy

Basic Data

Table Category	INTTAB	Structure
Structure	REXCITIRE_L	Table Relationship Diagram
Short Description	IRE List reporting

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	RECNNR	☐	RECNNUMBER	RECNNUMBER	CHAR	13	0	Contract Number
2	RECNTYPE	☐	RECNCONTRACTTYPE	SMVART	CHAR	4	0	Contract Type	*
3	BENOCN	☐	RECNBENOCN	REBDBENO	CHAR	8	0	Business Entity That Belongs to Contract	*
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
5	.INCLUDE	☐				0	0	IRE data with additional fields
6	.INCLUDE	☐				0	0	IRE data
7	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
8	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object	VICNCN
9	.INCLUDE	☐				0	0	IRE data without Register Office data
10	BILLDATE	☐	REXCITBILLDATE		DATS	8	0	IRE Date
11	.INCLUDE	☐				0	0	IRE data - data fields
12	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
13	IRECALCTYPE	☐	REXCITIRECALCTYPE		CHAR	2	0	IRE Calculation Type ID	TIVXCITIRECALCP
14	RENTAL	☐	REXCITRENTAL	RECACURR	CURR	15	2	IRE Monthly Rental Amount
15	RTAXAMOUNT	☐	REXCITRENTTAX	RECACURR	CURR	15	2	IRE Rental Taxable Amount
16	IREPERCENT	☐	REXCITIREPER	REXCITRATE	DEC	5	2	IRE Tax Rate
17	REDPERCENT	☐	REXCITREDUC	REXCITRATE	DEC	5	2	IRE Reduction Percentage
18	IREAMOUNT	☐	REXCITIREAMOUNT	RECACURR	CURR	15	2	IRE Tax Amount
19	ISPAYB	☐	REXCITISPAYB	RECABOOL	CHAR	1	0	IRE Pay Back Indicator
20	IREPAYB	☐	REXCITEXPPAY	REXCITCURR	CURR	15	2	IRE Expenses Pay-Back
21	PERCENPAYB	☐	REXCITPAYBACK	REXCITRATE	DEC	5	2	IRE Pay-Back Percentage
22	XACCPOS	☐	REXCITXACCPOS	RECAXLDESCRIPTION	CHAR	60	0	IRE Accounting position description
23	ISACTIVE	☐	REXCITISACTIVE	RECABOOL	CHAR	1	0	IRE Record active for posting
24	PSTDATE	☐	RERAPSTNGDATE	RECADATE	DATS	8	0	Posting Date
25	TCODE1	☐	REXCITIRETAXCODE	REXCITIRETAXCODE	CHAR	4	0	IRE Tax Code	TIVXCITIRETCODE
26	TYEAR	☐	REXCITTYEAR	REXCITYEARTYPE	CHAR	1	0	IRE Status of Contract
27	TCODE2	☐	REXCITIRETAXCODE	REXCITIRETAXCODE	CHAR	4	0	IRE Tax Code	TIVXCITIRETCODE
28	TCODE3	☐	REXCITIRETAXCODE	REXCITIRETAXCODE	CHAR	4	0	IRE Tax Code	TIVXCITIRETCODE
29	TYEARX	☐	REXCITTPYEAR	RECABOOL	CHAR	1	0	IRE Type of year handled as intermediate year
30	IREOFFVALUE	☐	REXCITIREOFFVALUE	RECACURR	CURR	15	2	Register Office Charges
31	REFDOCTYPE	☐	RERAREFDOCTYPE	AWTYP	CHAR	5	0	Reference to Document Class	*
32	REFDOCID	☐	RERAREFDOCID	CHAR20	CHAR	20	0	Reference Key of Document
33	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
34	ISCANCELED	☐	REXCITISCANCELED	RECABOOL	CHAR	1	0	Indicator if the posting is canceled
35	TERMMONTHS	☐	REXCITTERMMONTHS	NUMC4	NUMC	4	0	IRE Period in months
36	.INCLUDE	☐				0	0	Additional Tax Codes for IRE
37	TAXCODE2AMOUNT	☐	REXCITIREADDTC2A	RECACURR	CURR	15	2	Amount for IRE Tax Code 2
38	TAXCODE3AMOUNT	☐	REXCITIREADDTC3A	RECACURR	CURR	15	2	Amount for IRE Tax Code 3
39	ISPAYB_2	☐	REXCITISPAYB	RECABOOL	CHAR	1	0	IRE Pay Back Indicator
40	ISPAYB_3	☐	REXCITISPAYB	RECABOOL	CHAR	1	0	IRE Pay Back Indicator
41	ISPAYB_OFF_VALUE	☐	REXCITISPAYB	RECABOOL	CHAR	1	0	IRE Pay Back Indicator
42	ISSUMM_1	☐	REXCITISSUM	RECABOOL	CHAR	1	0	Contributes to IRE Sum
43	ISSUMM_2	☐	REXCITISSUM	RECABOOL	CHAR	1	0	Contributes to IRE Sum
44	ISSUMM_3	☐	REXCITISSUM	RECABOOL	CHAR	1	0	Contributes to IRE Sum
45	ISSUMM_OFF_VALUE	☐	REXCITISSUM	RECABOOL	CHAR	1	0	Contributes to IRE Sum
46	IRERENTAXAMOUNT	☐	REXCITRETTAXAM	RECACURR	CURR	15	2	IRE Total Tax Amount
47	PAYBACK1RATE	☐	REXCITPAYBACK1	REXCITRATE	DEC	5	2	IRE Payback Percentage for Main Tax Code
48	PAYBACK2RATE	☐	REXCITPAYBACK2	REXCITRATE	DEC	5	2	IRE Payback Percentage for Tax Code 2
49	PAYBACK3RATE	☐	REXCITPAYBACK3	REXCITRATE	DEC	5	2	IRE Payback Percentage for Tax Code 3
50	PAYBACKRRATE	☐	REXCITPAYBACKR	REXCITRATE	DEC	5	2	IRE Payback Percentage for Reg. Office Value
51	TRANSFER	☐	REXCITTRANSFER	REXCITTRANSFER	CHAR	1	0	Transfer of Ownership
52	OBJRENTALCODE	☐	REXCITIREOBJRENTALCODE	REXCITIREOBJRENTALCODE	CHAR	2	0	Rental Object Code
53	ONETIMEDEDUCAM	☐	REXCITIREONETIMEDEDUCAM	REXCITIREONETIMEDEDUCAM	CURR	13	2	Amount of One-Time Payment Deduction
54	ISONETIMEPYMNT	☐	REXCITIREISONETIMEPYMNT	RECABOOL	CHAR	1	0	Indicator for one-time payment for IRE
55	CFPAYGUID_PB1	☐	REXCITIRECFPAYGUID1	RECAGUID	RAW	16	0	IRE Payback - Cashflow GUID for Taxcode 1
56	CFPAYGUID_PB2	☐	REXCITIRECFPAYGUID2	RECAGUID	RAW	16	0	IRE Payback - Cashflow GUID for Taxcode 2
57	CFPAYGUID_PB3	☐	REXCITIRECFPAYGUID3	RECAGUID	RAW	16	0	IRE Payback - Cashflow GUID for Taxcode 3
58	CFPAYGUID_PB_RO	☐	REXCITIRECFPAYGUIDRO	RECAGUID	RAW	16	0	IRE Payback - Cashflow GUID for Reg. Off. Value
59	.INCLUDE	☐				0	0	IRE office data - data fields
60	DTREG	☐	REXCITIREREGD	RECADATE	DATS	8	0	IRE Registration Date
61	SERIE	☐	REXCITIRESERIE		CHAR	2	0	IRE Serial Number
62	NRREG	☐	REXCITREGNO		CHAR	13	0	IRE Registration Number
63	REGOFF	☐	REXCITREGOFF		CHAR	3	0	IRE Register Office Code	TIVXCITIREOF
64	IRESTART	☐	REXCITIRESTARTD	DATS	DATS	8	0	Start Date for IRE calculation
65	IRECALC	☐	REXCITIRECALC	RECABOOL	CHAR	1	0	Calculate IRE
66	XREGOFF	☐	REXCITXREGOFF	RECAXLDESCRIPTION	CHAR	60	0	IRE Register Office description
67	XIRETAXCODE1	☐	REXCITXIRETAXCODE	RECAXLDESCRIPTION	CHAR	60	0	IRE Tax Code description
68	XIRETAXCODE2	☐	REXCITXIRETAXCODE	RECAXLDESCRIPTION	CHAR	60	0	IRE Tax Code description
69	XIRETAXCODE3	☐	REXCITXIRETAXCODE	RECAXLDESCRIPTION	CHAR	60	0	IRE Tax Code description
70	XIRECALCTYPE	☐	REXCITXIRECALCTYPE	RECAXLDESCRIPTION	CHAR	60	0	IRE Calculation Type ID Description
71	XTYEAR	☐	REXCITXTYEAR	RECAXLDESCRIPTION	CHAR	60	0	Status of Contract Description
72	ALVROWS	☐	REXCITALVROWS		INT2	5	0	ALV rows
73	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
74	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
75	RERATAXTYPE	☐	RERATAXTYPE	RERATAXTYPE	CHAR	4	0	Tax Type	TIVRATAXTYPE
76	RERATAXGROUP	☐	RERATAXGROUP	RERATAXGROUP	CHAR	20	0	Tax Group	TIVRATAXGROUP
77	RECDFLOWTYPE	☐	RECDFLOWTYPE	RECDFLOWTYPE	CHAR	4	0	Flow Type	TIVCDFLOWTYPE
78	HEADERTXT	☐	RERAHEADERTXT	TEXT25	CHAR	25	0	Document Header Text
79	CHECKBOX	☐	CHECKBOX	FUNC	CHAR	1	0	Checkbox in Reporting

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REXCITIRE_L	CURRENCY	TCURC	WAERS
2	REXCITIRE_L	INTRENO	VICNCN	INTRENO
3	REXCITIRE_L	IRECALCTYPE	TIVXCITIRECALCP	IRECALCTYPE
4	REXCITIRE_L	MANDT	T000	MANDT	KEY
5	REXCITIRE_L	RECDFLOWTYPE	TIVCDFLOWTYPE	FLOWTYPE
6	REXCITIRE_L	REGOFF	TIVXCITIREOF	REGOFF
7	REXCITIRE_L	RERATAXGROUP	TIVRATAXGROUP	TAXGROUP
8	REXCITIRE_L	RERATAXTYPE	TIVRATAXTYPE	TAXTYPE
9	REXCITIRE_L	TCODE1	TIVXCITIRETCODE	IRETAXCODE
10	REXCITIRE_L	TCODE2	TIVXCITIRETCODE	IRETAXCODE
11	REXCITIRE_L	TCODE3	TIVXCITIRETCODE	IRETAXCODE

History

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