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

Dictionary Type: Table
Description: Offers for a rental unit (-> VIMIMV)




ABAP Code to SELECT data from VIMI33
Related tables to VIMI33
Access table VIMI33




Table field list including key, data, relationships and ABAP select examples

VIMI33 is a standard SAP Table which is used to store Offers for a rental unit (-> VIMIMV) data and is available within R/3 SAP systems depending on the version and release level.

The VIMI33 table consists of various fields, each holding specific information or linking keys about Offers for a rental unit (-> VIMIMV) data available in SAP. These include BUKRS (Company Code), SMVANG (Lease-out - Offer), SWENR (Site Number), SMENR (Number of Rental Unit).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VIMI33 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
SMVANGLease-out - Offer VVSMVANGCHAR13ALPHARANLMIAMVAN
SWENRSite Number SWENRCHAR8VIOB01SWENRSWENRWEHMCWE
SMENRNumber of Rental Unit SMENRCHAR8VIMI01SMENRSMENRMEHMCME
DMIBEGRental start date DMIBEDATS8DDAT
DMIENDRental end date DMIENDATS8DDAT
DERZAHLDate of 1st debit position DERZADATS8DDAT
SMVARTExternal Real Estate contract type SMVARTCHAR4TIV26SMVARTRECNTYPE
SMVANARTLease-Out Adjustment Type SMVARCHAR1TIV27SMVAR
DUNTBISDate provisional agreement from DUNBIDATS8DDAT
BKAUTIONSecurity deposit amount BKAUTCURR13(2) WRTV7
SKAUTARTType of Rental Collateral SKAUACHAR1Assigned to domainSKAUA
STECHEMHeating expenses settlement company evaluation group STECHEMCHAR13STECHEM
JRECHTCourt case indicator JRECHTCHAR1JANEI
ASCHLU1Number of keys 1 ASCHLU1DEC3DEC03
JRATENInstalment indicator JRATENCHAR1JANEI
AMELDINSales reporting interval AMELDINNUMC2INTVJ
BUMSPROJPlanned sales (Amount) BUMSPROJCURR13(2) WRTV7
BMINUMSMonetary minimum sales in the settlement period BUMSATZ1CURR13(2) WRTV7
PPROZ0Minimum percentage rate PPROZ0DEC5(2) DEC3_2
STAMVStatus of data record SSTATINUMC2Assigned to domainSTATI
STALTStatus of data record SSTATINUMC2Assigned to domainSTATI
DSTAENStatus change date DSTAENDATS8DSTAEN
JVERLContract renewal JVERLCHAR1VVVERL
JSKUENDSpecial right of notice JSKUENDCHAR1JANEI
JKAUFOPTOption to buy JKAUFOPTCHAR1JANEI
DKAUFOPTPurchase option date DKAUFOPTDATS8DDAT
SNKSService Charge Collector Number SNKSCHAR22ONR00J_OBJNR
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
DKUEFRNotice period in months DKUEFRNUMC2NUMC2
ANKUENNotification until (for renewal of contract) ANKUENNUMC2NUMC2
VERLGContract renewal by ... months VERLGNUMC3NUMC3
ZSICHIndicator that other collateral is available VVZSICHCHAR1JANEI
BANKKSBank Keys BANKKCHAR15BANKKBNK
SKUEFRType of notice period SKUEFRNUMC1SKUEFR
MVIMKEYLease-Out -Real Estate Key VVMVIMKEYCHAR8IMKEY
SPARTNRPartner number SPARTNRCHAR10SPRT1SPARTNRPNN
GSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
BWIMKEYApplication real estate key VVBWIMKEYCHAR8IMKEY
SMIWUNRRent request number SMIWUNRNUMC3VIMI12SMIWUNROUK
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
JLOESCHReal Estate Deletion Indicator/Flag JLOESCHCHAR1JLOESCH
STMVARental agreement offer status VVSTMVANUMC4TIV42VVSTMVA
DANGSTOffer status valid from date DANGSTDATS8DDAT
DGBIValid-to date DGBIDATS8DDAT
INTRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
BWINTRENOApplication key BVVINTRENOCHAR13VVINTRENO
MVINTRENORental agreement key MVVINTRENOCHAR13VVINTRENO
ARINTRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
JMFREICondition is not checked VVJMFREICHAR1JANE
KONDPJConditions on lease-out effective per year (display) VVKONDPJCHAR1JFLAGG
SKUEKEYNotice rule SKUEKEYCHAR12SKUEKEY
SKUEARTNotice Type of Lease-Out SMVKUEARTCHAR1SMVKUEART
BERGRPAuthorization group VVBERGRPCHAR40VVBERGRP
PARTFROMSource of Prospect VVIPARTFROMCHAR4TIVP1CHAR4
PARTWHYReason for Acquisition VVIPARTWHYCHAR4TIVP2CHAR4
PARTWAYEnquiry method VVIWAYCHAR4TIVP3CHAR4

Key field Non-key field



How do I retrieve data from SAP table VIMI33 using ABAP code

The following ABAP code Example will allow you to do a basic selection on VIMI33 to SELECT all data from the table
DATA: WA_VIMI33 TYPE VIMI33.

SELECT SINGLE *
FROM VIMI33
INTO CORRESPONDING FIELDS OF WA_VIMI33
WHERE...

How to access SAP table VIMI33

Within an ECC or HANA version of SAP you can also view further information about VIMI33 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!