SAP ABAP Table RVIMI33_ZS (RE: Offer - Master data and Additional Fields)

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	RVIMI33_ZS	Table Relationship Diagram
Short Description	RE: Offer - Master data and Additional Fields

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	XMVARTK	☐	XMVARTK	XKBEZ	CHAR	15	0	Short description of RE contract type
69	XMVARTM	☐	XMVARTM	XMBEZ	CHAR	30	0	Description of type of RE contract type
70	XMVANARTK	☐	XMVANARTK	XKBEZ	CHAR	15	0	Short description of LO adjustment type
71	XMVANARTM	☐	XMVANARTM	XMBEZ	CHAR	30	0	Description of LO adjustment type
72	XKAUAK	☐	XKAUAK	XKBEZ	CHAR	15	0	Short description of type of rental collateral
73	XKAUAM	☐	XKAUAM	XMBEZ	CHAR	30	0	Description of type of rental collateral
74	XKUEFR	☐	XKUEFR	AS4TEXT	CHAR	60	0	Description of period of notice type
75	XMSTMA	☐	VVXMSTMA	XMBEZ	CHAR	30	0	Status Long Text for a Lease-Out Offer
76	XKSTMA	☐	VVXKSTMA	XKBEZ	CHAR	15	0	Status Short Text for a Lease-Out Offer
77	.INCLUDE	☐				0	0	Amounts from VIMI33 in second currency
78	BKAUTCUK	☐	BKAUTCUK	WRTV7	CURR	13	2	Sec.deposit amount in second currency
79	SWHRKNDCUK	☐	SWHRKNDCUK	WAERS	CUKY	5	0	Second Currency for Correspondence	*

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in