SAP ABAP Table VIMI12 (Rental requests in an application)

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	VIMI12	Table Relationship Diagram
Short Description	Rental requests in an application

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	SBWNR	☑	SBWNR	SBWNR	NUMC	7	0	Application number	VIMI11
3	SMIWUNR	☑	SMIWUNR	SMIWUNR	NUMC	3	0	Rent request number
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	SNUNR	☐	SNUNR	SNUNR	NUMC	4	0	Rental unit external usage type	TIV01
6	SVERKEHR	☐	SVERKEHR	SVERKEHR	CHAR	1	0	Transport Connections of Business Entity	TIV44
7	SOBJLAGE	☐	RESOBJLAGE	RESOBJLAGE	NUMC	2	0	Indicator: District Location of Object	TIV45
8	RGEBART	☐	RGEBART	SOBJART	NUMC	2	0	Type of building	TIV5A
9	AZIMMV	☐	AZIMMV	DEC2_1	DEC	3	1	Number of rooms from
10	AZIMMB	☐	AZIMMB	DEC2_1	DEC	3	1	Number of rooms up to
11	FGROESA	☐	FGROES	FLAE	DEC	8	2	Total area from
12	FGROESB	☐	FGROESB	FLAE	DEC	8	2	Total area to
13	SALTNEU	☐	SALTNEU	SALTNEU	CHAR	1	0	Indicator old-/new building/initial occupancy
14	JLIFT	☐	JLIFT	JANEI	CHAR	1	0	Indicator: Elevator required
15	DBEZUA	☐	DBEZUA	DDAT	DATS	8	0	Date for occupation as from
16	DBEZUB	☐	DBEZUB	DDAT	DATS	8	0	Move-in by date
17	ASTELL	☐	ASTELL	DEC3	DEC	3	0	Number of parking spaces
18	BGESMIET	☐	BGESMIET	WRTV6	CURR	11	2	Rent total amount
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	SGWENR	☐	SGWENR	SWENR	CHAR	8	0	Requested business entity	VIOB01
21	SGME	☐	SGME	SMENR	CHAR	8	0	Rental unit requested	VIMI01
22	DEING	☐	DEING	DDAT	DATS	8	0	Date of receipt of rental request
23	DABSAG	☐	DABSAG	DDAT	DATS	8	0	Rejection date
24	AANGEB	☐	AANGEB	DEC3	DEC	3	0	Number of first-time offers
25	JMAXG	☐	JMAXG	JANEIX10	CHAR	1	0	Indicator: Only top floor requested
26	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
27	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
28	DENDB	☐	VVDENDB	DDAT	DATS	8	0	Application valid to

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIMI12	BUKRS	T001	BUKRS
2	VIMI12	FEINS	T006	MSEHI	KEY	1	CN
3	VIMI12	MANDT	T000	MANDT	KEY	1	CN
4	VIMI12	RGEBART	TIV5A	SOBJART
5	VIMI12	SBWNR	VIMI11	SBWNR	KEY	1	CN
6	VIMI12	SGME	VIMI01	SMENR
7	VIMI12	SGWENR	VIOB01	SWENR
8	VIMI12	SNUNR	TIV01	SNUNR	REF	1	CN
9	VIMI12	SOBJLAGE	TIV45	SOBJLAGE	KEY	1	CN
10	VIMI12	SVERKEHR	TIV44	SVERKEHR	KEY	1	CN
11	VIMI12	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in