SAP TABLES | Real Estate Management(RE) SAP RE

VIMI04 SAP Old. replaced in 3.0 with VIMIMV Table and data







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.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP VIMI04 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Not classified
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP VIMI04 Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3
*
Client
BUKRSBUKRSCHAR4 T001Company Code
SMIVESMIVECHAR13 Lease-Out NumberALPHA
SMENRSMENRCHAR8 VIMI01Number of Rental UnitSMENR
VERKT_MVSMIVECHAR13 Lease-Out NumberALPHA
VERKT_MESMENRCHAR8 VIMI01Number of Rental UnitSMENR
DMIBEGDMIBEDATS8 Rental start date
DMIENDDMIENDATS8 Rental end date
DERZAHLDERZADATS8 Date of 1st debit position
SMVARTSMVARTCHAR4 TIV26External Real Estate contract type
SMVANARTSMVARCHAR1 TIV27Lease-Out Adjustment Type
AINSTAINSTDEC2 Lease-out interval status debit position
JMITAJMITACHAR1 Employee indicator
XMITNRXMITNRCHAR30 Employee Number in Lease-Out
JKONZERNJKONZNUMC2 TIV28Corporate group ID types
DUNTBISDUNBIDATS8 Date provisional agreement from
BRSCHBRSCHCHAR4 T016Industry key
BKAUTIONBKAUTCURR13(2) Security deposit amount
SKAUTARTSKAUACHAR1 TIV18Type of Rental Collateral
DEINKUEDEKUEDATS8 Date of receipt of notice
DKUEZUDKUZUDATS8 Contract Notice Per
SKUEARTSKUARCHAR1 Notice Type
XKUEGRUXKUGRCHAR30 Reason for notice
JMAHNSPJMASPCHAR1 Dunning block indicator - no longer used!
DANPSDANPSDATS8 Adjustment block as from
STECHEMSTECHEMCHAR13 Heating expenses settlement company evaluation group
JRECHTJRECHTCHAR1 Court case indicator
ASCHLU1ASCHLU1DEC3 Number of keys 1
JMINDERJMINDERCHAR1 Rent reduction indicator
DMINDERDMINDERDATS8 Date rent reduction introduced
DMINDABDMINDABDATS8 Rent reduction as from
JRATENJRATENCHAR1 Instalment indicator
BGESRATEBGESRATEDEC10(2) Total of the instalments still to be paid for the cash bond
BRATEBRATEDEC10(2) Instalment amount
DERSTRATDERSTRATDATS8 Date of first instalment payment
BSUMMRATBSUMMRATDEC10(2) Total of instalments paid so far
AMELDINAMELDINNUMC2 Sales reporting interval
BUMSPROJBUMSPROJCURR13(2) Planned sales (Amount)
BMINUMSBUMSATZ1CURR13(2) Monetary minimum sales in the settlement period


PPROZ0PPROZ0DEC5(2) Minimum percentage rate
STAMVSSTATINUMC2
*
Status of data record
STALTSSTATINUMC2
*
Status of data record
DSTAENDSTAENDATS8 Status change date
DAKTVDAKTVDATS8 Contract activation
JLOESCHJLOESCHCHAR1 Real Estate Deletion Indicator/Flag
BUSABBUSABCHAR2 T001SAccounting clerk
JVERLJVERLCHAR1 Contract renewal
JSKUENDJSKUENDCHAR1 Special right of notice
JKAUFOPTJKAUFOPTCHAR1 Option to buy
DKAUFOPTDKAUFOPTDATS8 Purchase option date
SNKSSNKSCHAR22 ONR00Service Charge Collector Number
RERFRERFCHAR12 Entered by
DERFDERFDATS8 First Entered on
TERFTERFTIMS6 Time of Initial Entry
REHERREHERCHAR10 Source of initial entry
RBEARRBEARCHAR12 Employee ID
DBEARDBEARDATS8 Last Edited on
TBEARTBEARTIMS6 Last Edited at
RBHERRBHERCHAR10 Editing Source
DKUEFRDKUEFRNUMC2 Notice period in months
DMIETFDMIETFDATS8 Adjustment block until
ANKUENANKUENNUMC2 Notification until (for renewal of contract)
DABTRDABTRDATS8 Declaration of assignment
DFREISDFREISDATS8 Exemption (bank)
DABLFDABLFDATS8 Expiration Date
VERLGVERLGNUMC3 Contract renewal by ... months
ZUGHKVVZUGHKNUMC2 TIV30Employee
ZSICHVVZSICHCHAR1 Indicator that other collateral is available
JBETRSTJBETRSTCHAR1 Security deposit granted
DBKERHDBKERHDATS8 Cash deposit received on
ABNNRABNNRCHAR20 Identification of lease-out at settlement company
ABNUNRABNUNRNUMC3 Customer subnumber
BANKKSBANKKCHAR15 Bank Keys
SKUEFRSKUEFRNUMC1 Type of notice period
IMKEYIMKEYCHAR8 Internal Key for Real Estate ObjectIMKEY
KUNNRVVRDEBIHVPCHAR10 KNA1Customer number main contract partnerALPHA
SPARTNRVVRPARTABWCHAR10 SPRT1Alternative payer (partner number)
GSARTVVSARTCHAR3 TZPAProduct Type


MADATMADATDATS8 Last dunned on
MANSTMAHNS_DNUMC1 Dunning level
JBKRZVVJBKRZCHAR1 Cash deposit instalment payment
DEINZGVVDEINZGDATS8 Move-in date
DAUSZGVVDAUSZGDATS8 Move-out date
JANPIBVVJANPIBCHAR1 Adjustment being processed (indicator)
PRCTRPRCTRCHAR10 CEPCProfit CenterALPHA
MABERMABERCHAR2 T047MDunning Area
PROFLVVAPROFCHAR6 TKB1ASettlement profile for costsALPHA
KOKRSKOKRSCHAR4 TKA01Controlling Area
ZUSPVVZUSPCHAR1 Subsidies available, indicator
REFNRVVREFNRCHAR30 Reference number for collateral securities
SBELEGNGVVSBELEGNGCHAR1 RU occupancy by LO (used by third-prty/private/corp.grp)
MANSPMANSPCHAR1 T040SDunning block
DERSTDRVVDERSTDRDATS8 Date When the Lease-Out was First Printed
DAENDDRVVDAENDDRDATS8 Date When the Lease-Out was Changed and Printed Out
JMFREIVVJMFREICHAR1 Condition is not checked
DVMUNVVDVMUNDATS8 Contract signed by landlord
JRMSCHPRVVJRMSCHPRCHAR1 Tenant service charge settlement?
TDNAMETDOBNAMECHAR70 Name
KBK_PARTNRSPARTNRCHAR10 SPRT1Partner number
GERSTDVVXGERSTDCHAR35 Jurisdiction
NITRENOVVINTRENOCHAR13 Internal Real Estate Master Data Code



Key field
Non-key field

VIMI04 relationships with other tables


VIOB01-Business Entities
     VVIMI01-Generated Table for View VVIMI01
          VIMI04-Old. Replaced in 3.0 with VIMIMV
               VIKOKO-Real Estate Condition Header
                    VZZKOPO-Condition Items Table
               VIMI07-Reported Sales for Sales-Based Lease-Out
               VIMI23-Determination of Year and Percent for Sls-Bsd LO
               VIMI24-Percentage for Sales for Sales-Based Lease-Out
               VIMI25-Sales Reports
          VVIKOKO-Generated Table for View VVIKOKO
               VVZZKOP2-Generated Table for View VVZZKOP2