SAP ABAP Table VIMI33 (Offers for a rental unit (-> VIMIMV))

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	TRANSP	Transparent table
Transparent table	VIMI33	Table Relationship Diagram
Short Description	Offers for a rental unit (-> VIMIMV)

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIMI33	BUKRS	T001	BUKRS	KEY	1	CN
2	VIMI33	GSART	TZPA	GSART	KEY	1	CN
3	VIMI33	MANDT	T000	MANDT
4	VIMI33	PARTFROM	TIVP1	PARTFROM	KEY	1	CN
5	VIMI33	PARTWAY	TIVP3	WAY	KEY	1	CN
6	VIMI33	PARTWHY	TIVP2	PARTWHY	KEY	1	CN
7	VIMI33	SMENR	VIMI01	SMENR	KEY	1	CN
8	VIMI33	SMIWUNR	VIMI12	SMIWUNR	REF	C	CN
9	VIMI33	SMVANART	TIV27	SMVANART	KEY	1	CN
10	VIMI33	SMVART	TIV26	SMVART	KEY	1	CN
11	VIMI33	SNKS	ONR00	OBJNR	KEY	1	CN
12	VIMI33	SPARTNR	SPRT1	PARTNR	KEY	1	CN
13	VIMI33	STMVA	TIV42	STMVA
14	VIMI33	SWENR	VIOB01	SWENR	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in