SAP ABAP Table AVIMI33 (Change document structure; individually generated (VIMI33))

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	AVIMI33	Table Relationship Diagram
Short Description	Change document structure; individually generated (VIMI33)

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	Offers for a rental unit (-> VIMIMV)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	SMVANG	☐	VVSMVANG	RANL	CHAR	13	0	Lease-out - Offer
5	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
6	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
7	DMIBEG	☐	DMIBE	DDAT	DATS	8	0	Rental start date
8	DMIEND	☐	DMIEN	DDAT	DATS	8	0	Rental end date
9	DERZAHL	☐	DERZA	DDAT	DATS	8	0	Date of 1st debit position
10	SMVART	☐	SMVART	SMVART	CHAR	4	0	External Real Estate contract type	TIV26
11	SMVANART	☐	SMVAR	SMVAR	CHAR	1	0	Lease-Out Adjustment Type	TIV27
12	DUNTBIS	☐	DUNBI	DDAT	DATS	8	0	Date provisional agreement from
13	BKAUTION	☐	BKAUT	WRTV7	CURR	13	2	Security deposit amount
14	SKAUTART	☐	SKAUA	SKAUA	CHAR	1	0	Type of Rental Collateral	*
15	STECHEM	☐	STECHEM	STECHEM	CHAR	13	0	Heating expenses settlement company evaluation group
16	JRECHT	☐	JRECHT	JANEI	CHAR	1	0	Court case indicator
17	ASCHLU1	☐	ASCHLU1	DEC03	DEC	3	0	Number of keys 1
18	JRATEN	☐	JRATEN	JANEI	CHAR	1	0	Instalment indicator
19	AMELDIN	☐	AMELDIN	INTVJ	NUMC	2	0	Sales reporting interval
20	BUMSPROJ	☐	BUMSPROJ	WRTV7	CURR	13	2	Planned sales (Amount)
21	BMINUMS	☐	BUMSATZ1	WRTV7	CURR	13	2	Monetary minimum sales in the settlement period
22	PPROZ0	☐	PPROZ0	DEC3_2	DEC	5	2	Minimum percentage rate
23	STAMV	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
24	STALT	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
25	DSTAEN	☐	DSTAEN	DSTAEN	DATS	8	0	Status change date
26	JVERL	☐	JVERL	VVVERL	CHAR	1	0	Contract renewal
27	JSKUEND	☐	JSKUEND	JANEI	CHAR	1	0	Special right of notice
28	JKAUFOPT	☐	JKAUFOPT	JANEI	CHAR	1	0	Option to buy
29	DKAUFOPT	☐	DKAUFOPT	DDAT	DATS	8	0	Purchase option date
30	SNKS	☐	SNKS	J_OBJNR	CHAR	22	0	Service Charge Collector Number	ONR00
31	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
32	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
33	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
34	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
35	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
36	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
37	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
38	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
39	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
40	DKUEFR	☐	DKUEFR	NUMC2	NUMC	2	0	Notice period in months
41	ANKUEN	☐	ANKUEN	NUMC2	NUMC	2	0	Notification until (for renewal of contract)
42	VERLG	☐	VERLG	NUMC3	NUMC	3	0	Contract renewal by ... months
43	ZSICH	☐	VVZSICH	JANEI	CHAR	1	0	Indicator that other collateral is available
44	BANKKS	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
45	SKUEFR	☐	SKUEFR	SKUEFR	NUMC	1	0	Type of notice period
46	MVIMKEY	☐	VVMVIMKEY	IMKEY	CHAR	8	0	Lease-Out -Real Estate Key
47	SPARTNR	☐	SPARTNR	SPARTNR	CHAR	10	0	Partner number	SPRT1
48	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
49	BWIMKEY	☐	VVBWIMKEY	IMKEY	CHAR	8	0	Application real estate key
50	SMIWUNR	☐	SMIWUNR	SMIWUNR	NUMC	3	0	Rent request number	VIMI12
51	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
52	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
53	STMVA	☐	VVSTMVA	VVSTMVA	NUMC	4	0	Rental agreement offer status	TIV42
54	DANGST	☐	DANGST	DDAT	DATS	8	0	Offer status valid from date
55	DGBI	☐	DGBI	DDAT	DATS	8	0	Valid-to date
56	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
57	BWINTRENO	☐	BVVINTRENO	VVINTRENO	CHAR	13	0	Application key
58	MVINTRENO	☐	MVVINTRENO	VVINTRENO	CHAR	13	0	Rental agreement key
59	ARINTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
60	JMFREI	☐	VVJMFREI	JANE	CHAR	1	0	Condition is not checked
61	KONDPJ	☐	VVKONDPJ	JFLAGG	CHAR	1	0	Conditions on lease-out effective per year (display)
62	SKUEKEY	☐	SKUEKEY	SKUEKEY	CHAR	12	0	Notice rule
63	SKUEART	☐	SMVKUEART	SMVKUEART	CHAR	1	0	Notice Type of Lease-Out
64	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
65	PARTFROM	☐	VVIPARTFROM	CHAR4	CHAR	4	0	Source of Prospect	TIVP1
66	PARTWHY	☐	VVIPARTWHY	CHAR4	CHAR	4	0	Reason for Acquisition	TIVP2
67	PARTWAY	☐	VVIWAY	CHAR4	CHAR	4	0	Enquiry method	TIVP3
68	.INCLUDE	☐				0	0	Structures for generating change document update programs
69	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	AVIMI33	BUKRS	T001	BUKRS
2	AVIMI33	GSART	TZPA	GSART
3	AVIMI33	MANDT	T000	MANDT
4	AVIMI33	PARTFROM	TIVP1	PARTFROM	KEY	1	CN
5	AVIMI33	PARTWAY	TIVP3	WAY	KEY	1	CN
6	AVIMI33	PARTWHY	TIVP2	PARTWHY	KEY	1	CN
7	AVIMI33	SMENR	VIMI01	SMENR
8	AVIMI33	SMIWUNR	VIMI12	SMIWUNR
9	AVIMI33	SMVANART	TIV27	SMVANART
10	AVIMI33	SMVART	TIV26	SMVART
11	AVIMI33	SNKS	ONR00	OBJNR
12	AVIMI33	SPARTNR	SPRT1	PARTNR
13	AVIMI33	STMVA	TIV42	STMVA
14	AVIMI33	SWENR	VIOB01	SWENR

History

Last changed by/on	SAP	20110901
SAP Release Created in