VIMI04 SAP (Old. replaced in 3.0 with VIMIMV) Table details
Dictionary Type: Table
Description: Old. replaced in 3.0 with VIMIMV
Description: Old. replaced in 3.0 with VIMIMV
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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
SMIVE | Lease-Out Number | SMIVE | CHAR | 13 | ALPHA | VVSMIVE | MIV | MRTA | |
SWENR | Site Number | SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | MCWE |
SMENR | Number of Rental Unit | SMENR | CHAR | 8 | VIMI01 | SMENR | SMENR | MEH | MCME |
VERKT_MV | Lease-Out Number | SMIVE | CHAR | 13 | ALPHA | VVSMIVE | MIV | MRTA | |
VERKT_WE | Site Number | SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | MCWE |
VERKT_ME | Number of Rental Unit | SMENR | CHAR | 8 | VIMI01 | SMENR | SMENR | MEH | MCME |
DMIBEG | Rental start date | DMIBE | DATS | 8 | DDAT | ||||
DMIEND | Rental end date | DMIEN | DATS | 8 | DDAT | ||||
DERZAHL | Date of 1st debit position | DERZA | DATS | 8 | DDAT | ||||
SMVART | External Real Estate contract type | SMVART | CHAR | 4 | TIV26 | SMVART | RECNTYPE | ||
SMVANART | Lease-Out Adjustment Type | SMVAR | CHAR | 1 | TIV27 | SMVAR | |||
AINST | Lease-out interval status debit position | AINST | DEC | 2 | DEC02 | ||||
JMITA | Employee indicator | JMITA | CHAR | 1 | JANEI | ||||
XMITNR | Employee Number in Lease-Out | XMITNR | CHAR | 30 | XMBEZ | ||||
JKONZERN | Corporate group ID types | JKONZ | NUMC | 2 | TIV28 | JKONZ | |||
DUNTBIS | Date provisional agreement from | DUNBI | DATS | 8 | DDAT | ||||
BRSCH | Industry key | BRSCH | CHAR | 4 | T016 | BRSCH | |||
BKAUTION | Security deposit amount | BKAUT | CURR | 13(2) | WRTV7 | ||||
SKAUTART | Type of Rental Collateral | SKAUA | CHAR | 1 | TIV18 | SKAUA | |||
DEINKUE | Date of receipt of notice | DEKUE | DATS | 8 | DDAT | ||||
DKUEZU | Contract Notice Per | DKUZU | DATS | 8 | DDAT | ||||
SKUEART | Notice Type | SKUAR | CHAR | 1 | SKUAR | ||||
XKUEGRU | Reason for notice | XKUGR | CHAR | 30 | XMBEZ | ||||
JMAHNSP | Dunning block indicator - no longer used! | JMASP | CHAR | 1 | JANE | ||||
DANPS | Adjustment block as from | DANPS | DATS | 8 | DATUM | ||||
STECHEM | Heating expenses settlement company evaluation group | STECHEM | CHAR | 13 | STECHEM | ||||
JRECHT | Court case indicator | JRECHT | CHAR | 1 | JANEI | ||||
ASCHLU1 | Number of keys 1 | ASCHLU1 | DEC | 3 | DEC03 | ||||
JMINDER | Rent reduction indicator | JMINDER | CHAR | 1 | JANEI | ||||
DMINDER | Date rent reduction introduced | DMINDER | DATS | 8 | DDAT | ||||
DMINDAB | Rent reduction as from | DMINDAB | DATS | 8 | DDAT | ||||
JRATEN | Instalment indicator | JRATEN | CHAR | 1 | JANEI | ||||
BGESRATE | Total of the instalments still to be paid for the cash bond | BGESRATE | DEC | 10(2) | DEC8_2 | ||||
BRATE | Instalment amount | BRATE | DEC | 10(2) | DEC8_2 | ||||
DERSTRAT | Date of first instalment payment | DERSTRAT | DATS | 8 | DDAT | ||||
BSUMMRAT | Total of instalments paid so far | BSUMMRAT | DEC | 10(2) | DEC8_2 | ||||
AMELDIN | Sales reporting interval | AMELDIN | NUMC | 2 | INTVJ | ||||
BUMSPROJ | Planned sales (Amount) | BUMSPROJ | CURR | 13(2) | WRTV7 | ||||
BMINUMS | Monetary minimum sales in the settlement period | BUMSATZ1 | CURR | 13(2) | WRTV7 | ||||
PPROZ0 | Minimum percentage rate | PPROZ0 | DEC | 5(2) | DEC3_2 | ||||
STAMV | Status of data record | SSTATI | NUMC | 2 | Assigned to domain | STATI | |||
STALT | Status of data record | SSTATI | NUMC | 2 | Assigned to domain | STATI | |||
DSTAEN | Status change date | DSTAEN | DATS | 8 | DSTAEN | ||||
DAKTV | Contract activation | DAKTV | DATS | 8 | DATUM | ||||
JLOESCH | Real Estate Deletion Indicator/Flag | JLOESCH | CHAR | 1 | JLOESCH | ||||
BUSAB | Accounting clerk | BUSAB | CHAR | 2 | T001S | BUSAB | |||
JVERL | Contract renewal | JVERL | CHAR | 1 | VVVERL | ||||
JSKUEND | Special right of notice | JSKUEND | CHAR | 1 | JANEI | ||||
JKAUFOPT | Option to buy | JKAUFOPT | CHAR | 1 | JANEI | ||||
DKAUFOPT | Purchase option date | DKAUFOPT | DATS | 8 | DDAT | ||||
SNKS | Service Charge Collector Number | SNKS | CHAR | 22 | ONR00 | J_OBJNR | |||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
DKUEFR | Notice period in months | DKUEFR | NUMC | 2 | NUMC2 | ||||
DMIETF | Adjustment block until | DMIETF | DATS | 8 | DATUM | ||||
ANKUEN | Notification until (for renewal of contract) | ANKUEN | NUMC | 2 | NUMC2 | ||||
DABTR | Declaration of assignment | DABTR | DATS | 8 | DATUM | ||||
DFREIS | Exemption (bank) | DFREIS | DATS | 8 | DATUM | ||||
DABLF | Expiration Date | DABLF | DATS | 8 | DATUM | ||||
VERLG | Contract renewal by ... months | VERLG | NUMC | 3 | NUMC3 | ||||
ZUGHK | Employee | VVZUGHK | NUMC | 2 | TIV30 | VVZUGHK | |||
ZSICH | Indicator that other collateral is available | VVZSICH | CHAR | 1 | JANEI | ||||
JBETRST | Security deposit granted | JBETRST | CHAR | 1 | JANEI | ||||
DBKERH | Cash deposit received on | DBKERH | DATS | 8 | DATUM | ||||
ABNNR | Identification of lease-out at settlement company | ABNNR | CHAR | 20 | TEXT20 | ||||
ABNUNR | Customer subnumber | ABNUNR | NUMC | 3 | NUM3 | ||||
BANKKS | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
SKUEFR | Type of notice period | SKUEFR | NUMC | 1 | SKUEFR | ||||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
KUNNR | Customer number main contract partner | VVRDEBIHVP | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
SPARTNR | Alternative payer (partner number) | VVRPARTABW | CHAR | 10 | SPRT1 | SPARTNR | |||
GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
MADAT | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
MANST | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
JBKRZ | Cash deposit instalment payment | VVJBKRZ | CHAR | 1 | JANEI | ||||
DEINZG | Move-in date | VVDEINZG | DATS | 8 | DATS | ||||
DAUSZG | Move-out date | VVDAUSZG | DATS | 8 | DATS | ||||
JANPIB | Adjustment being processed (indicator) | VVJANPIB | CHAR | 1 | JANE | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
MABER | Dunning Area | MABER | CHAR | 2 | T047M | MABER | |||
PROFL | Settlement profile for costs | VVAPROF | CHAR | 6 | TKB1A | ALPHA | APROF | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
ZUSP | Subsidies available, indicator | VVZUSP | CHAR | 1 | JANE | ||||
REFNR | Reference number for collateral securities | VVREFNR | CHAR | 30 | TEXT30 | ||||
SBELEGNG | RU occupancy by LO (used by third-prty/private/corp.grp) | VVSBELEGNG | CHAR | 1 | VVSBELEGNG | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
DERSTDR | Date When the Lease-Out was First Printed | VVDERSTDR | DATS | 8 | DATUM | ||||
DAENDDR | Date When the Lease-Out was Changed and Printed Out | VVDAENDDR | DATS | 8 | DATUM | ||||
JMFREI | Condition is not checked | VVJMFREI | CHAR | 1 | JANE | ||||
DVMUN | Contract signed by landlord | VVDVMUN | DATS | 8 | DATUM | ||||
JRMSCHPR | Tenant service charge settlement? | VVJRMSCHPR | CHAR | 1 | XFELD | ||||
TDNAME | Name | TDOBNAME | CHAR | 70 | TDOBNAME | ||||
KBK_PARTNR | Partner number | SPARTNR | CHAR | 10 | SPRT1 | SPARTNR | PNN | ||
GERSTD | Jurisdiction | VVXGERSTD | CHAR | 35 | TEXT35 | ||||
NITRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | VVINTRENO |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects