SAP VIMI17 RE: Adjustment Run Header Table data and field list

VIMI17 is a standard SAP Table which is used to store RE: Adjustment Run Header data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VIMI17 table consists of various fields, each holding specific information or linking keys about RE: Adjustment Run Header data available in SAP. These include BUKRS (Company Code), DGUELAB (Rental Adjustment Date Planned For), SANPNR (Rent Adjustment Method), XIDENT (Identification of adjustment run)... 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. .

VIMI17 table Technical Details:

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 VIMI17 table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VIMI17 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
DGUELABRental Adjustment Date Planned For DANPASSDATS8DATUMIDG
SANPNRRent Adjustment Method SANPNRNUMC3TIV11SANPNR
XIDENTIdentification of adjustment run XIDENT1CHAR16XBLNR1IDT
DBATCHProgram run date for rent adjustment DBATCHDATS8DDAT
TUHRBATTime of batch run for rent adjustment TUHRBATTIMS6T
BUSABAccounting clerk BUSABCHAR2Assigned to domainBUSAB
BERHABSIncrease amount per area unit BERHABSCURR13(2) WRTV7
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FEINSArea unit FEINSUNIT3Assigned to domainCUNITMEINSFEH
PERHRELRelative increase in amount (in percentage) PERHRELDEC5(2) DECV3_2
NSPONRSpool request number RSPOIDINT410RSPOID
BGESBMPTotal costs for modernization planned VVBGESBMPCURR13(2) WRTV7
BGESBMIActual total costs of modernization VVBGESBMICURR13(2) WRTV7
BJMZUGBMYearly rental surcharge in accordance with §3 MHG VVBJMZUGBMCURR13(2) WRTV7
BMANPBMMonthly adjustment in accordance with §3 MHG VVBMANPBMCURR13(2) WRTV7
BQMANPBMMonthly adjustment per apportionment unit in acc.with §3 MHG VVBQMANPBMCURR13(2) WRTV7
RGESWFAll calculation units of apportionment factor VVRGESWFDEC8(2) DEC6_2
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8PRPSKONPRPS_POSNR
SABRGApportionment unit SABRGNUMC4TIV07SABRGARG
DBEGBMScheduled start date of modernization VVDBEGBMDATS8DDAT
DANZWODuration of modernization in weeks VVDANZWONUMC2NUMC2
XBEZBMDescription of modernization measures VVXBEZBMCHAR60XLBEZ
DENDBMScheduled end date of modernization VVDENDBMPDATS8DDAT
DBEGBMIActual start date of modernization VVDBEGBMIDATS8DDAT
DENDBMIActual end date of modernization VVDENDBMIDATS8DDAT
SIHMAModernization Measure VVSIHMACHAR20Assigned to domainVVSIHMAMMA
JZUSCHIndicator: Create surcharge from rent adjustment VVJZUSCHCHAR1JANE
SKOARTCondition Type (Smallest Subdivision of Condition Records) SKOARTNUMC4TZK01SKOART
JFUTANPAdjust conditions already determined for the future ? VVJFUTANPCHAR1XFELD
JZUSTPFLSelect contracts subject to approval ? VVJZUSTPFLCHAR1XFELD
JOHNEZUSSelect contracts which are not subject to approval ? VVJOHNEZUSCHAR1XFELD
BRDBRTKDMarginal Gross Yield VVBRDBRTKDDEC10(7) DECV3_7
JORTSUEBCH rent adjustment: Adjustment rent typical for locality ? VVJORTSUEBCHAR1XFELD
BERHGESIncrease amount in full (not referring to the area) VVBERHGESCURR13(2) WRTV7
JBASOUECH rent adj.: Adjustment on basis of typical local rent VVJBASOUECHAR1XFELD
JANPOBRent can only be adjusted on an upward basis (indicator) JIXANPOBCHAR1XFELD
SBSANPCHCH rent adjustment: Adjustment basis VVSBSANPCHNUMC2VVSBSANPCH
JANPMZRCH rent adjustment: Adjust rent reserve from appreciation? VVJANPMZRCHAR1XFELD
JSENKMZRPass decreases on to rent reserves ? VVJSENKMZRCHAR1XFELD
VVABBLNSettlement Identification ->Accounting Ref. Doc.Number VVABBLN1CHAR16XBLNR1IAB
PROTNAMEFile name of rent adjustment log VVPRNAMEMACHAR60FILENAME
SADJRSNReason for rent adjustment VVADJRSNCHAR10TIVM1CHAR10
SGUTAExpert report identification VVSGUTACHAR20Assigned to domainVVSGUTAGUT
JCHBASMODCH rent adj: Adj. on basis overhaul/appr.surch. investment VVCHBASMODCHAR1XFELD
JCHBASBMRRent adj. CH: Adj. on basis reserves from modernizations VVCHBASBMRCHAR1XFELD
BNEUMIETTotal new amount (not relative to the area) VVBNEUGESCURR13(2) WRTV7
BNEUABSNew amount per area unit VVBNEUFECURR13(2) WRTV7
DZUBISDate up to which approval has to be given DZUBISDATS8DDAT
SDICNAMEABAP/4 Dictionary: name of SDIC log PROTNAMECHAR40PROTNAME
JCHSNKRULPass on reductions to reserves by single settlement VVJCHSNKRULCHAR1XFELD
SANPMESpecifies Adjustment Object (Only LO/Only RU/both) VVSANPMECHAR1VVSANPME
WBSWENRSite Number SWENRCHAR8Assigned to domainSWENRSWENRWEHMCWE
WBDATUMDate of Cost Efficiency Analysis VVWBDATDATS8DDAT
JADJSRCMVBase Object is Lease-Out VVADJSRCMVCHAR1XFELD
JADJSRCMEBase object is rental unit VVADJSRCMECHAR1XFELD
JADJSRCALSeparate Calculation VVADJSRCALCHAR1XFELD
JCUTMEVALAlso cap amount for rental unit? VVCUTMEVALCHAR1XFELD
JNEWCONMVGenerate new conditions on lease-out? VVNEWCONMVCHAR1XFELD
JNEWCONMECreate new conditions on rental unit? VVNEWCONMECHAR1XFELD
JADJME_NEAlso adjust RU if no LO exists? VVADJME_NECHAR1XFELD
JADJME_NAAlso adjust RU if related LO is not active? VVADJME_NACHAR1XFELD
JADJME_LKAlso adjust RU if related LO is blocked? VVADJME_LKCHAR1XFELD
SWBNR VVWBNRCHAR8VIWB00VVWBNRHWB
SWBIND VVWBINDCHAR8VIWB01VVWBINDTWB
DWBBISDate 'Valid to' VVDGUEBISDATS8DATE

Key field Non-key field



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

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

SELECT SINGLE *
FROM VIMI17
INTO CORRESPONDING FIELDS OF WA_VIMI17
WHERE...

How to access SAP table VIMI17

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

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