SAP ABAP Table AVIMI16 (Change doc. structure; indiv.generated (VIMI16 -> no chg.doc)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	INTTAB	Structure
Structure	AVIMI16	Table Relationship Diagram
Short Description	Change doc. structure; indiv.generated (VIMI16 -> no chg.doc

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	RE: Records of a Rent Adjustment Run
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
5	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
6	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
7	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
8	DGUELAB	☐	DGUELAB	DATUM	DATS	8	0	Date when the rent adjustment becomes valid
9	DANPASS	☐	DANPASS	DATUM	DATS	8	0	Rental Adjustment Date Planned For
10	SANPNR	☐	SANPNR	SANPNR	NUMC	3	0	Rent Adjustment Method	TIV11
11	XIDENT	☐	XIDENT1	XBLNR1	CHAR	16	0	Identification of adjustment run
12	SWHRKOND	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	*
13	BKONDALT	☐	BKONDALT	WRTV7	CURR	13	2	Previous condition amount
14	BANPASS	☐	BANPASS	WRTV7	CURR	13	2	New condition amount (total)
15	BAUTANP	☐	BAUTANP	WRTV7	CURR	13	2	New Total Condition Amount (Original)
16	BGESZUL	☐	BGESZUL	WRTV7	CURR	13	2	New legally permitted amount per area unit
17	BVGLAVG	☐	BVGLAVG	WRTV7	CURR	13	2	Average rent per area unit
18	BINDPKT	☐	BINDPKT	DEC5_3	DEC	8	3	Index marker status at last rent adjustment
19	BINDALT	☐	BINDALT	DEC5_3	DEC	8	3	Previous index marker (from VIMI06)
20	BMSPVON	☐	BBETRV	WRTV6	CURR	11	2	Lower limit for rent per area unit acc. to rep.list of rents
21	BMSPBIS	☐	BBETRB	WRTV6	CURR	11	2	Upper limit for rent per area unit acc. to rep.list rents
22	BMSPGRD	☐	BGRBTR	WRTV6	CURR	11	2	Mean value of rent per area unit acc. to rep.list of rents
23	BMSPZUA	☐	BMSPZUA	WRTV7	CURR	13	2	Rent adj.acc.to rep.rent list: Total surch./reduct./tot.pnts
24	JZUSCHLAG	☐	JZUSCHLAG	JANE	CHAR	1	0	Surcharge contained in new basic rent
25	JZUSTIM	☐	JZUSTIM	JANE	CHAR	1	0	Approval indicator
26	DZUSTIM	☐	DZUSTIM	DDAT	DATS	8	0	Approval date of rent adjustment
27	DZUBIS	☐	DZUBIS	DDAT	DATS	8	0	Date up to which approval has to be given
28	DSTORNO	☐	DSTORNO	DDAT	DATS	8	0	Reversal date of rent adjustment
29	DAKTIV	☐	VVDAKTIV	DDAT	DATS	8	0	Activation date of rental adjustment
30	DGUELBI	☐	VVDINDPKT	DATUM	DATS	8	0	Date when index markers are valid for this rent adjustment
31	BANPBM	☐	VVBANPBM	WRTV7	CURR	13	2	Total pro rata modernization costs for the rental unit
32	BMZUGBM	☐	VVBMZUGBM	WRTV7	CURR	13	2	Monthly surcharge planned in acc. with German tenancy law
33	RANTWF	☐	VVRANTWF	DEC6_2	DEC	8	2	Apportionment factor calculation units
34	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
35	PERHREL	☐	PERHREL	DECV3_2	DEC	5	2	Relative increase in amount (in percentage)
36	BERHABS	☐	BERHABS	WRTV7	CURR	13	2	Increase amount per area unit
37	BERHGES	☐	VVBERHGES	WRTV7	CURR	13	2	Increase amount in full (not referring to the area)
38	BNEUMIET	☐	VVBNEUGES	WRTV7	CURR	13	2	Total new amount (not relative to the area)
39	SFUTANP	☐	VVSFUTANP	VVSFUTANP	CHAR	1	0	Subsequent adjustment ? (No, initial adj., subsequent adj.)
40	FQMFLART	☐	VVBFLART	VVBFLART	QUAN	14	4	Area of area type
41	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
42	BPKTSUM	☐	VVBPKTSUM	VVDECV5_2	DEC	7	2	Total number of points for feature class or object
43	PERHPROZ	☐	VVPERWEIT	DEC3_2	DEC	5	2	Percentage rate of calculated increase to be passed on
44	PERHHPZS	☐	VVPERHHPZS	DECV3_3	DEC	6	3	Percent.increase on the basis of a mortg.rate loan change
45	PERHUTBK	☐	VVPERHUTBK	DECV3_3	DEC	6	3	Percent.incr. on basis of maintenance/operating costs change
46	PERHTEUR	☐	VVPERHTEUR	DECV3_3	DEC	6	3	Percent.incr.on basis of change in standard of living index
47	PERHGES	☐	VVPERHGES	DECV3_3	DEC	6	3	Percent increase on basis of all relative/an absolute factor
48	SANPME	☐	VVSANPME	VVSANPME	CHAR	1	0	Specifies Adjustment Object (Only LO/Only RU/both)
49	DHPZS	☐	VVDHPZS	DATUM	DATS	8	0	CH rent adj.:Date of mortgage rate loan status for new rent
50	DUTBK	☐	VVDUTBK	DATUM	DATS	8	0	CH rnt adj.:Dte maint./oper.csts index status for new rent
51	DTEUR	☐	VVDTEUR	DATUM	DATS	8	0	CH rent adj.:Date of standard of living status for new rent
52	DHPZSALT	☐	VVDHPZSAKT	DATUM	DATS	8	0	CH rent adj.:Date of mort.loan rate status for current rent
53	DUTBKALT	☐	VVDUTBKAKT	DATUM	DATS	8	0	CH rnt adj.:Dte maint./oper.costs index status for new rent
54	DTEURALT	☐	VVDTEURAKT	DATUM	DATS	8	0	CH rnt adj.:Dte of living stndrd index status for curr.rent
55	BRDBRTZZ	☐	VVBRDBRTZZ	DECV3_7	DEC	10	7	CH rent adj: Actual gross yield earned
56	SBSANPCH	☐	VVSBSANPCH	VVSBSANPCH	NUMC	2	0	CH rent adjustment: Adjustment basis
57	BRDBRTKD	☐	VVBRDBRTKD	DECV3_7	DEC	10	7	Marginal Gross Yield
58	SSTDORT	☐	VVSSTDORT	VVSSTDORT	CHAR	10	0	Regional location	TIV35
59	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
60	MFACH	☐	VVMFACH	CHAR10	CHAR	10	0	Rent table field
61	SANPSTAF	☐	VVSANPSTAF	VVSANPSTAF	CHAR	1	0	Scope of adjustment (conditions, sales grading, both)
62	SIHMA	☐	VVSIHMA	VVSIHMA	CHAR	20	0	Modernization Measure	*
63	JCHBASMOD	☐	VVCHBASMOD	XFELD	CHAR	1	0	CH rent adj: Adj. on basis overhaul/appr.surch. investment
64	JCHBASBMR	☐	VVCHBASBMR	XFELD	CHAR	1	0	Rent adj. CH: Adj. on basis reserves from modernizations
65	BCHBASMOD	☐	VVBGESBMI	WRTV7	CURR	13	2	Actual total costs of modernization
66	BMSPBAS	☐	VVBMSPBAS	WRTV6	CURR	11	2	Base rent per area unit acc. to rep.list of rents
67	BNEUABS	☐	VVBNEUFE	WRTV7	CURR	13	2	New amount per area unit
68	NDOCCNT	☐	VVNDOCCNT	NUMC3	NUMC	3	0	Number of printed letters for an adjustment
69	CURR_GS	☐	VVCURR_GS	WRTV7	CURR	13	2	Total amount as basis for adjustment without roundings
70	AREA_GS	☐	VVAREA_GS	VVBFLART	QUAN	14	4	Total area as base for adjustment without rounding errors
71	SMIETSP	☐	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment	TIV20
72	SBAUAKL	☐	SBAUALT	SBAUALT	NUMC	2	0	Building age category	TIV21
73	SLAGEKL	☐	SLAGK	SLAGK	NUMC	2	0	Location class	TIV22
74	SGROEKL	☐	SGROEKL	SGROEKL	NUMC	3	0	Size class	TIV19
75	SAUSTKL	☐	SAUSKL	SAUSKL	NUMC	2	0	Fixtures and fittings category	TIV23
76	DBAUALT	☐	VVDBAUALT	DATE	DATS	8	0	Building age for rental unit relevant for rep.list of rents
77	JAREA	☐	VVJAREA	XFELD	CHAR	1	0	Rental on basis of area?
78	BKONDALTFE	☐	BKONDQM	WRTV7	CURR	13	2	Currency amount per area unit
79	SKOPO	☐	VVSKOPO	VVSKOPO	NUMC	2	0	Detailed identification for condition items	TZK07
80	SCOMMIT	☐	VVSRACOMMIT	NUMC02	NUMC	2	0	Reservation for approval for a rent adjustment	TIVM4
81	SREJECT	☐	VVSRAREJECT	NUM02	NUMC	2	0	Reason for rejecting a rent adjustment	TIVM5
82	DREJECT	☐	VVDRAREJECT	DDAT	DATS	8	0	Rejection date of a rent adjustment
83	NDUNLEV	☐	VVRADUNLEVEL	NUMC02	NUMC	2	0	Reminder level for reminders for rnt adjs not subj.to appr.
84	DLASTDC	☐	VVRADLASTDUN	DATUM	DATS	8	0	Date of last dunning due to missing tenant approval
85	DADJPRN	☐	VVDADJPRN	DATS	DATS	8	0	Letter date of adjustment correspondence
86	BANPASSFE	☐	VVBANPASSFE	WRTV7	CURR	13	2	New condition amount for each area unit (changeable)
87	BAUTANPFE	☐	VVBAUTANPFE	WRTV7	CURR	13	2	New condition amount for each area unit (original)
88	BVGLAVGGS	☐	VVBAVGGSMT	WRTV7	CURR	13	2	Average total rent
89	BGESZULGS	☐	VVBGESZULGS	WRTV7	CURR	13	2	Legally permitted total amount
90	SINDART_OLD	☐	WBIND	WBIND	CHAR	5	0	Index series for replacement values	*
91	YBASISJ_OLD	☐	BASJHR	BASJHR	NUMC	4	0	Index series base year	*
92	BINDPKT_OLD	☐	BINDPKT	DEC5_3	DEC	8	3	Index marker status at last rent adjustment
93	BINDPKT1_OLD	☐	BINDPKT1	DEC5_3	DEC	8	3	Index status as base for first rental adjustment
94	BPKTERH_OLD	☐	VVBPKTERH	DEC4_2	DEC	6	2	Absolute change of index points for rent adjustment
95	PPKTERH_OLD	☐	PPKTERH	DEC03_2	DEC	5	2	Minimum change of index series change in percentage terms
96	SINDART_NEW	☐	WBIND	WBIND	CHAR	5	0	Index series for replacement values	*
97	YBASISJ_NEW	☐	BASJHR	BASJHR	NUMC	4	0	Index series base year	*
98	BINDPKT_NEW	☐	BINDPKT	DEC5_3	DEC	8	3	Index marker status at last rent adjustment
99	BINDPKT1_NEW	☐	BINDPKT1	DEC5_3	DEC	8	3	Index status as base for first rental adjustment
100	BPKTERH_NEW	☐	VVBPKTERH	DEC4_2	DEC	6	2	Absolute change of index points for rent adjustment
101	PPKTERH_NEW	☐	PPKTERH	DEC03_2	DEC	5	2	Minimum change of index series change in percentage terms
102	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
103	ATTRHY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
104	JBMONAT	☐	JBMONAT	JANEI	CHAR	1	0	Indicator for calculating amount per month
105	JADJRHY	☐	JADJRHY	JANE	CHAR	1	0	Rent Adjustment Dependent on Condition Frequency
106	JNULLKON	☐	JNULLKON	SKONDF	CHAR	1	0	Condition Form
107	.INCLUDE	☐				0	0	Structures for generating change document update programs
108	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	AVIMI16	BUKRS	T001	BUKRS	KEY	1	CN
2	AVIMI16	FEINS	T006	MSEHI
3	AVIMI16	MANDT	T000	MANDT	KEY	1	CN
4	AVIMI16	SANPNR	TIV11	SANPNR	KEY	1	CN
5	AVIMI16	SAUSTKL	TIV23	SMKLASS	KEY	1	CN
6	AVIMI16	SBAUAKL	TIV21	SBAUALT	KEY	1	CN
7	AVIMI16	SCOMMIT	TIVM4	SCOMMIT	KEY	1	CN
8	AVIMI16	SGROEKL	TIV19	SGROEKL	KEY	1	CN
9	AVIMI16	SKOART	TZK01	SKOART	KEY	1	CN
10	AVIMI16	SKOPO	TZK07	SKOPO	KEY	1	CN
11	AVIMI16	SLAGEKL	TIV22	SLAGK	KEY	1	CN
12	AVIMI16	SMENR	VIMI01	SMENR	KEY	1	CN
13	AVIMI16	SMIETSP	TIV20	SMIETSP	KEY	1	CN
14	AVIMI16	SREJECT	TIVM5	SREJECT	KEY	1	CN
15	AVIMI16	SSTDORT	TIV35	SSTDORT	KEY	1	CN
16	AVIMI16	SWENR	VIOB01	SWENR	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in