SAP ABAP Table AVIXCITIREDATA (Change Document Structure IRE master data (VIXCITIREDATA))

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	AVIXCITIREDATA	Table Relationship Diagram
Short Description	Change Document Structure IRE master data (VIXCITIREDATA)

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 master data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	.INCLUDE	☐				0	0	Key for IRE master data (VIXCITIREDATA)
4	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object	VICNCN
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	Field String for Maintenance of User Data
55	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
56	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
57	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
58	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
59	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
60	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
61	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
62	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
63	.INCLUDE	☐				0	0	Structures for generating change document update programs
64	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

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

History

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