SAP VIMI17 RE: Adjustment Run Header Table
Overview
VIMI17 is a standard SAP S/4HANA table that stores RE: Adjustment Run Header data. There are total 65 fields in the VIMI17 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIMI17 belongs to Real Estate Management (RE) module and is located in the package R/3 appl.dev. for Financial Assets Management: Real estate (FVVI).
In addition, following links provide an overview of foreign key relationships, if any, that link VIMI17 to other SAP tables and standard CDS views available based on VIMI17 table in S/4HANA 2020.
Techincal Settings of VIMI17
Below are technical details of the table VIMI17
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIMI17 Fields
The following table gives you an overview of the fields available in VIMI17
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| BUKRS | Company Code | BUKRS | * | CHAR | 4 |
| DGUELAB | Rental Adjustment Date Planned For | DANPASS | DATS | 8 | |
| SANPNR | Rent Adjustment Method | SANPNR | TIV11 | NUMC | 3 |
| XIDENT | Identification of adjustment run | XIDENT1 | CHAR | 16 | |
| DBATCH | Program run date for rent adjustment | DBATCH | DATS | 8 | |
| TUHRBAT | Time of batch run for rent adjustment | TUHRBAT | TIMS | 6 | |
| BUSAB | Accounting Clerk Abbreviation | BUSAB | * | CHAR | 2 |
| BERHABS | Increase amount per area unit | BERHABS | CURR | 13 | |
| WAERS | Currency Key | WAERS | * | CUKY | 5 |
| FEINS | Area Unit | FEINS | * | UNIT | 3 |
| PERHREL | Relative increase in amount (in percentage) | PERHREL | DEC | 5 | |
| NSPONR | Spool request number | RSPOID | INT4 | 10 | |
| BGESBMP | Total costs for modernization planned | VVBGESBMP | CURR | 13 | |
| BGESBMI | Actual total costs of modernization | VVBGESBMI | CURR | 13 | |
| BJMZUGBM | Yearly rental surcharge in accordance with §3 MHG | VVBJMZUGBM | CURR | 13 | |
| BMANPBM | Monthly adjustment in accordance with §3 MHG | VVBMANPBM | CURR | 13 | |
| BQMANPBM | Monthly adjustment per apportionment unit in acc.with §3 MHG | VVBQMANPBM | CURR | 13 | |
| RGESWF | All calculation units of apportionment factor | VVRGESWF | DEC | 8 | |
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 |
| SABRG | Apportionment unit | SABRG | TIV07 | NUMC | 4 |
| DBEGBM | Scheduled start date of modernization | VVDBEGBM | DATS | 8 | |
| DANZWO | Duration of modernization in weeks | VVDANZWO | NUMC | 2 | |
| XBEZBM | Description of modernization measures | VVXBEZBM | CHAR | 60 | |
| DENDBM | Scheduled end date of modernization | VVDENDBMP | DATS | 8 | |
| DBEGBMI | Actual start date of modernization | VVDBEGBMI | DATS | 8 | |
| DENDBMI | Actual end date of modernization | VVDENDBMI | DATS | 8 | |
| SIHMA | Modernization Measure | VVSIHMA | * | CHAR | 20 |
| JZUSCH | Indicator: Create surcharge from rent adjustment | VVJZUSCH | CHAR | 1 | |
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | TZK01 | NUMC | 4 |
| JFUTANP | Adjust conditions already determined for the future ? | VVJFUTANP | CHAR | 1 | |
| JZUSTPFL | Select contracts subject to approval ? | VVJZUSTPFL | CHAR | 1 | |
| JOHNEZUS | Select contracts which are not subject to approval ? | VVJOHNEZUS | CHAR | 1 | |
| BRDBRTKD | Marginal Gross Yield | VVBRDBRTKD | DEC | 10 | |
| JORTSUEB | CH rent adjustment: Adjustment rent typical for locality ? | VVJORTSUEB | CHAR | 1 | |
| BERHGES | Increase amount in full (not referring to the area) | VVBERHGES | CURR | 13 | |
| JBASOUE | CH rent adj.: Adjustment on basis of typical local rent | VVJBASOUE | CHAR | 1 | |
| JANPOB | Rent can only be adjusted on an upward basis (indicator) | JIXANPOB | CHAR | 1 | |
| SBSANPCH | CH rent adjustment: Adjustment basis | VVSBSANPCH | NUMC | 2 | |
| JANPMZR | CH rent adjustment: Adjust rent reserve from appreciation? | VVJANPMZR | CHAR | 1 | |
| JSENKMZR | Pass decreases on to rent reserves ? | VVJSENKMZR | CHAR | 1 | |
| VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | VVABBLN1 | CHAR | 16 | |
| PROTNAME | File name of rent adjustment log | VVPRNAMEMA | CHAR | 60 | |
| SADJRSN | Reason for rent adjustment | VVADJRSN | TIVM1 | CHAR | 10 |
| SGUTA | Expert report identification | VVSGUTA | * | CHAR | 20 |
| JCHBASMOD | CH rent adj: Adj. on basis overhaul/appr.surch. investment | VVCHBASMOD | CHAR | 1 | |
| JCHBASBMR | Rent adj. CH: Adj. on basis reserves from modernizations | VVCHBASBMR | CHAR | 1 | |
| BNEUMIET | Total new amount (not relative to the area) | VVBNEUGES | CURR | 13 | |
| BNEUABS | New amount per area unit | VVBNEUFE | CURR | 13 | |
| DZUBIS | Date up to which approval has to be given | DZUBIS | DATS | 8 | |
| SDICNAME | ABAP Dictionary: Name of SDIC Log | PROTNAME | CHAR | 40 | |
| JCHSNKRUL | Pass on reductions to reserves by single settlement | VVJCHSNKRUL | CHAR | 1 | |
| SANPME | Specifies Adjustment Object (Only LO/Only RU/both) | VVSANPME | CHAR | 1 | |
| WBSWENR | Business Entity Number | SWENR | * | CHAR | 8 |
| WBDATUM | Date of Cost Efficiency Analysis | VVWBDAT | DATS | 8 | |
| JADJSRCMV | Base Object is Lease-Out | VVADJSRCMV | CHAR | 1 | |
| JADJSRCME | Base object is rental unit | VVADJSRCME | CHAR | 1 | |
| JADJSRCAL | Separate Calculation | VVADJSRCAL | CHAR | 1 | |
| JCUTMEVAL | Also cap amount for rental unit? | VVCUTMEVAL | CHAR | 1 | |
| JNEWCONMV | Generate new conditions on lease-out? | VVNEWCONMV | CHAR | 1 | |
| JNEWCONME | Create new conditions on rental unit? | VVNEWCONME | CHAR | 1 | |
| JADJME_NE | Also adjust RU if no LO exists? | VVADJME_NE | CHAR | 1 | |
| JADJME_NA | Also adjust RU if related LO is not active? | VVADJME_NA | CHAR | 1 | |
| JADJME_LK | Also adjust RU if related LO is blocked? | VVADJME_LK | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIMI17
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIMI17 | AUFNR | C: CN | AUFK |
| VIMI17 | PS_PSP_PNR | C: CN | PRPS |
| VIMI17 | SABRG | C: CN | TIV07 |
| VIMI17 | SADJRSN | : | TIVM1 |
| VIMI17 | SANPNR | 1: CN | TIV11 |
| VIMI17 | SKOART | 1: CN | TZK01 |
| VIMI17 | SWBIND | 1: CN | VIWB01 |
| VIMI17 | SWBNR | 1: CN | VIWB00 |