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

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FA_ILM (Package) Information Lifecycle Management

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_VIMI33	Table Relationship Diagram
Short Description	Offers for a rental unit (-> VIMIMV)

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	BKAUTION_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
69	BMINUMS_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
70	BUMSPROJ_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in	606