VIMI04 SAP (Old. replaced in 3.0 with VIMIMV) Table details

Dictionary Type: Table
Description: Old. replaced in 3.0 with VIMIMV




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




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

VIMI04 is a standard SAP Table which is used to store Old. replaced in 3.0 with VIMIMV data and is available within R/3 SAP systems depending on the version and release level.

The VIMI04 table consists of various fields, each holding specific information or linking keys about Old. replaced in 3.0 with VIMIMV data available in SAP. These include BUKRS (Company Code), SMIVE (Lease-Out Number), 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: Not classified


SAP VIMI04 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 MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
SMIVELease-Out Number SMIVECHAR13ALPHAVVSMIVEMIVMRTA
SWENRSite Number SWENRCHAR8VIOB01SWENRSWENRWEHMCWE
SMENRNumber of Rental Unit SMENRCHAR8VIMI01SMENRSMENRMEHMCME
VERKT_MVLease-Out Number SMIVECHAR13ALPHAVVSMIVEMIVMRTA
VERKT_WESite Number SWENRCHAR8VIOB01SWENRSWENRWEHMCWE
VERKT_MENumber 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
AINSTLease-out interval status debit position AINSTDEC2DEC02
JMITAEmployee indicator JMITACHAR1JANEI
XMITNREmployee Number in Lease-Out XMITNRCHAR30XMBEZ
JKONZERNCorporate group ID types JKONZNUMC2TIV28JKONZ
DUNTBISDate provisional agreement from DUNBIDATS8DDAT
BRSCHIndustry key BRSCHCHAR4T016BRSCH
BKAUTIONSecurity deposit amount BKAUTCURR13(2) WRTV7
SKAUTARTType of Rental Collateral SKAUACHAR1TIV18SKAUA
DEINKUEDate of receipt of notice DEKUEDATS8DDAT
DKUEZUContract Notice Per DKUZUDATS8DDAT
SKUEARTNotice Type SKUARCHAR1SKUAR
XKUEGRUReason for notice XKUGRCHAR30XMBEZ
JMAHNSPDunning block indicator - no longer used! JMASPCHAR1JANE
DANPSAdjustment block as from DANPSDATS8DATUM
STECHEMHeating expenses settlement company evaluation group STECHEMCHAR13STECHEM
JRECHTCourt case indicator JRECHTCHAR1JANEI
ASCHLU1Number of keys 1 ASCHLU1DEC3DEC03
JMINDERRent reduction indicator JMINDERCHAR1JANEI
DMINDERDate rent reduction introduced DMINDERDATS8DDAT
DMINDABRent reduction as from DMINDABDATS8DDAT
JRATENInstalment indicator JRATENCHAR1JANEI
BGESRATETotal of the instalments still to be paid for the cash bond BGESRATEDEC10(2) DEC8_2
BRATEInstalment amount BRATEDEC10(2) DEC8_2
DERSTRATDate of first instalment payment DERSTRATDATS8DDAT
BSUMMRATTotal of instalments paid so far BSUMMRATDEC10(2) DEC8_2
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
DAKTVContract activation DAKTVDATS8DATUM
JLOESCHReal Estate Deletion Indicator/Flag JLOESCHCHAR1JLOESCH
BUSABAccounting clerk BUSABCHAR2T001SBUSAB
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
DMIETFAdjustment block until DMIETFDATS8DATUM
ANKUENNotification until (for renewal of contract) ANKUENNUMC2NUMC2
DABTRDeclaration of assignment DABTRDATS8DATUM
DFREISExemption (bank) DFREISDATS8DATUM
DABLFExpiration Date DABLFDATS8DATUM
VERLGContract renewal by ... months VERLGNUMC3NUMC3
ZUGHKEmployee VVZUGHKNUMC2TIV30VVZUGHK
ZSICHIndicator that other collateral is available VVZSICHCHAR1JANEI
JBETRSTSecurity deposit granted JBETRSTCHAR1JANEI
DBKERHCash deposit received on DBKERHDATS8DATUM
ABNNRIdentification of lease-out at settlement company ABNNRCHAR20TEXT20
ABNUNRCustomer subnumber ABNUNRNUMC3NUM3
BANKKSBank Keys BANKKCHAR15BANKKBNK
SKUEFRType of notice period SKUEFRNUMC1SKUEFR
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
KUNNRCustomer number main contract partner VVRDEBIHVPCHAR10KNA1ALPHAKUNNR
SPARTNRAlternative payer (partner number) VVRPARTABWCHAR10SPRT1SPARTNR
GSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
MADATLast dunned on MADATDATS8DATUM
MANSTDunning level MAHNS_DNUMC1MAHNS
JBKRZCash deposit instalment payment VVJBKRZCHAR1JANEI
DEINZGMove-in date VVDEINZGDATS8DATS
DAUSZGMove-out date VVDAUSZGDATS8DATS
JANPIBAdjustment being processed (indicator) VVJANPIBCHAR1JANE
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
MABERDunning Area MABERCHAR2T047MMABER
PROFLSettlement profile for costs VVAPROFCHAR6TKB1AALPHAAPROF
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
ZUSPSubsidies available, indicator VVZUSPCHAR1JANE
REFNRReference number for collateral securities VVREFNRCHAR30TEXT30
SBELEGNGRU occupancy by LO (used by third-prty/private/corp.grp) VVSBELEGNGCHAR1VVSBELEGNG
MANSPDunning block MANSPCHAR1T040SMANSP
DERSTDRDate When the Lease-Out was First Printed VVDERSTDRDATS8DATUM
DAENDDRDate When the Lease-Out was Changed and Printed Out VVDAENDDRDATS8DATUM
JMFREICondition is not checked VVJMFREICHAR1JANE
DVMUNContract signed by landlord VVDVMUNDATS8DATUM
JRMSCHPRTenant service charge settlement? VVJRMSCHPRCHAR1XFELD
TDNAMEName TDOBNAMECHAR70TDOBNAME
KBK_PARTNRPartner number SPARTNRCHAR10SPRT1SPARTNRPNN
GERSTDJurisdiction VVXGERSTDCHAR35TEXT35
NITRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO

Key field Non-key field



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

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

SELECT SINGLE *
FROM VIMI04
INTO CORRESPONDING FIELDS OF WA_VIMI04
WHERE...

How to access SAP table VIMI04

Within an ECC or HANA version of SAP you can also view further information about VIMI04 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!