SAP ABAP Table REXCITIRE_X (IRE data with additional fields)

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_X	Table Relationship Diagram
Short Description	IRE data with additional fields

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REXCITIRE_X	CURRENCY	TCURC	WAERS	REF
2	REXCITIRE_X	INTRENO	VICNCN	INTRENO
3	REXCITIRE_X	IRECALCTYPE	TIVXCITIRECALCP	IRECALCTYPE
4	REXCITIRE_X	MANDT	T000	MANDT	KEY
5	REXCITIRE_X	REGOFF	TIVXCITIREOF	REGOFF
6	REXCITIRE_X	TCODE1	TIVXCITIRETCODE	IRETAXCODE
7	REXCITIRE_X	TCODE2	TIVXCITIRETCODE	IRETAXCODE
8	REXCITIRE_X	TCODE3	TIVXCITIRETCODE	IRETAXCODE

History

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