SAP ABAP Table VIXCITIREDATA (IRE master data)

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	TRANSP	Transparent table
Transparent table	VIXCITIREDATA	Table Relationship Diagram
Short Description	IRE master data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	Key for IRE master data (VIXCITIREDATA)
3	INTRENO	☑	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object	VICNCN
4	BILLDATE	☑	REXCITBILLDATE		DATS	8	0	IRE Date
5	.INCLUDE	☐				0	0	IRE data - data fields
6	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
7	IRECALCTYPE	☐	REXCITIRECALCTYPE		CHAR	2	0	IRE Calculation Type ID	TIVXCITIRECALCP
8	RENTAL	☐	REXCITRENTAL	RECACURR	CURR	15	2	IRE Monthly Rental Amount
9	RTAXAMOUNT	☐	REXCITRENTTAX	RECACURR	CURR	15	2	IRE Rental Taxable Amount
10	IREPERCENT	☐	REXCITIREPER	REXCITRATE	DEC	5	2	IRE Tax Rate
11	REDPERCENT	☐	REXCITREDUC	REXCITRATE	DEC	5	2	IRE Reduction Percentage
12	IREAMOUNT	☐	REXCITIREAMOUNT	RECACURR	CURR	15	2	IRE Tax Amount
13	ISPAYB	☐	REXCITISPAYB	RECABOOL	CHAR	1	0	IRE Pay Back Indicator
14	IREPAYB	☐	REXCITEXPPAY	REXCITCURR	CURR	15	2	IRE Expenses Pay-Back
15	PERCENPAYB	☐	REXCITPAYBACK	REXCITRATE	DEC	5	2	IRE Pay-Back Percentage
16	XACCPOS	☐	REXCITXACCPOS	RECAXLDESCRIPTION	CHAR	60	0	IRE Accounting position description
17	ISACTIVE	☐	REXCITISACTIVE	RECABOOL	CHAR	1	0	IRE Record active for posting
18	PSTDATE	☐	RERAPSTNGDATE	RECADATE	DATS	8	0	Posting Date
19	TCODE1	☐	REXCITIRETAXCODE	REXCITIRETAXCODE	CHAR	4	0	IRE Tax Code	TIVXCITIRETCODE
20	TYEAR	☐	REXCITTYEAR	REXCITYEARTYPE	CHAR	1	0	IRE Status of Contract
21	TCODE2	☐	REXCITIRETAXCODE	REXCITIRETAXCODE	CHAR	4	0	IRE Tax Code	TIVXCITIRETCODE
22	TCODE3	☐	REXCITIRETAXCODE	REXCITIRETAXCODE	CHAR	4	0	IRE Tax Code	TIVXCITIRETCODE
23	TYEARX	☐	REXCITTPYEAR	RECABOOL	CHAR	1	0	IRE Type of year handled as intermediate year
24	IREOFFVALUE	☐	REXCITIREOFFVALUE	RECACURR	CURR	15	2	Register Office Charges
25	REFDOCTYPE	☐	RERAREFDOCTYPE	AWTYP	CHAR	5	0	Reference to Document Class	*
26	REFDOCID	☐	RERAREFDOCID	CHAR20	CHAR	20	0	Reference Key of Document
27	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
28	ISCANCELED	☐	REXCITISCANCELED	RECABOOL	CHAR	1	0	Indicator if the posting is canceled
29	TERMMONTHS	☐	REXCITTERMMONTHS	NUMC4	NUMC	4	0	IRE Period in months
30	.INCLUDE	☐				0	0	Additional Tax Codes for IRE
31	TAXCODE2AMOUNT	☐	REXCITIREADDTC2A	RECACURR	CURR	15	2	Amount for IRE Tax Code 2
32	TAXCODE3AMOUNT	☐	REXCITIREADDTC3A	RECACURR	CURR	15	2	Amount for IRE Tax Code 3
33	ISPAYB_2	☐	REXCITISPAYB	RECABOOL	CHAR	1	0	IRE Pay Back Indicator
34	ISPAYB_3	☐	REXCITISPAYB	RECABOOL	CHAR	1	0	IRE Pay Back Indicator
35	ISPAYB_OFF_VALUE	☐	REXCITISPAYB	RECABOOL	CHAR	1	0	IRE Pay Back Indicator
36	ISSUMM_1	☐	REXCITISSUM	RECABOOL	CHAR	1	0	Contributes to IRE Sum
37	ISSUMM_2	☐	REXCITISSUM	RECABOOL	CHAR	1	0	Contributes to IRE Sum
38	ISSUMM_3	☐	REXCITISSUM	RECABOOL	CHAR	1	0	Contributes to IRE Sum
39	ISSUMM_OFF_VALUE	☐	REXCITISSUM	RECABOOL	CHAR	1	0	Contributes to IRE Sum
40	IRERENTAXAMOUNT	☐	REXCITRETTAXAM	RECACURR	CURR	15	2	IRE Total Tax Amount
41	PAYBACK1RATE	☐	REXCITPAYBACK1	REXCITRATE	DEC	5	2	IRE Payback Percentage for Main Tax Code
42	PAYBACK2RATE	☐	REXCITPAYBACK2	REXCITRATE	DEC	5	2	IRE Payback Percentage for Tax Code 2
43	PAYBACK3RATE	☐	REXCITPAYBACK3	REXCITRATE	DEC	5	2	IRE Payback Percentage for Tax Code 3
44	PAYBACKRRATE	☐	REXCITPAYBACKR	REXCITRATE	DEC	5	2	IRE Payback Percentage for Reg. Office Value
45	TRANSFER	☐	REXCITTRANSFER	REXCITTRANSFER	CHAR	1	0	Transfer of Ownership
46	OBJRENTALCODE	☐	REXCITIREOBJRENTALCODE	REXCITIREOBJRENTALCODE	CHAR	2	0	Rental Object Code
47	ONETIMEDEDUCAM	☐	REXCITIREONETIMEDEDUCAM	REXCITIREONETIMEDEDUCAM	CURR	13	2	Amount of One-Time Payment Deduction
48	ISONETIMEPYMNT	☐	REXCITIREISONETIMEPYMNT	RECABOOL	CHAR	1	0	Indicator for one-time payment for IRE
49	CFPAYGUID_PB1	☐	REXCITIRECFPAYGUID1	RECAGUID	RAW	16	0	IRE Payback - Cashflow GUID for Taxcode 1
50	CFPAYGUID_PB2	☐	REXCITIRECFPAYGUID2	RECAGUID	RAW	16	0	IRE Payback - Cashflow GUID for Taxcode 2
51	CFPAYGUID_PB3	☐	REXCITIRECFPAYGUID3	RECAGUID	RAW	16	0	IRE Payback - Cashflow GUID for Taxcode 3
52	CFPAYGUID_PB_RO	☐	REXCITIRECFPAYGUIDRO	RECAGUID	RAW	16	0	IRE Payback - Cashflow GUID for Reg. Off. Value
53	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
54	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
55	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
56	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
57	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
58	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
59	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
60	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
61	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source

Foreign Keys

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

History

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