1. Home
  2. Resources
  3. SAP Tables
  4. VIMHIO - Generated Table for View

SAP Table VIMHIO

Generated Table for View

VIMHIO (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VIMHIO to other SAP tables.

Source: VIMHIO (Generated Table for View)

VIMHIO table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
WAPOS Maintenance item WAPOS CHAR 16 0
WARPL Maintenance Plan WARPL MPLA CHAR 12 0
WSTRA Maintenance strategy STRAT T351 CHAR 6 0
PSTXT Item Short Text POSTXT CHAR 40 0
EQUNR Equipment Number EQUNR EQUI CHAR 18 0
OBKNR Object list number OBJKNR INT4 10 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERSDT Date of creation EDATUM DATS 8 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
PLNTY Task List Type PLNTY TCA01 CHAR 1 0
PLNNR Key for Task List Group PLNNR CHAR 8 0
PLNAL Group Counter PLNAL CHAR 2 0
STATUS Maintenance Item Status MPSTAT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
LTKNZ Long Text Indicator MPLTX CHAR 1 0
X Yes
NULL No
WPGRP Planner Group for Customer Service and Plant Maintenance INGRP T024I CHAR 3 0
OBJTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
GEWRK Object ID of the Work Center LGWID CRID NUMC 8 0
IWERK Maintenance Planning Plant IWERK T399I CHAR 4 0
ILOAN Location and account assignment for technical object ILOAN ILOA CHAR 12 0
LAUFN Order number LAUFN AUFK CHAR 12 0
BAUTL Assembly BAUTL MARA CHAR 18 0
ANLZU Syst.Condition ANLZU CHAR 1 0
AUART Order Type AUFART T003O CHAR 4 0
ILART Maintenance activity type ILA T353I CHAR 3 0
IND_ABRVO Indicator showing settlement rule maintained IND_ABRVO CHAR 1 0
PSPEL Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
KDAUF Sales Document VBELN_VA CHAR 10 0
KDPOS Sales Document Item POSNR_VA NUMC 6 0
MITYP Maintenance item category MITYP T399P CHAR 2 0
BSTNR Purchase Order Number BSTNR CHAR 10 0
BSTPO Purchase Order Item Number BSTPO NUMC 5 0
APFKT Execution factor for whole task list APFKT DEC 3 0
SERIALNR Serial Number GERNR CHAR 18 0
SERMAT Material Number MATNR MARA CHAR 18 0
DEVICEID Additional Device Data DEVICEID CHAR 40 0
TPLNR Functional Location TPLNR IFLOT CHAR 30 0
ABCKZ ABC indicator for technical object ABCKZ T370C CHAR 1 0
EQFNR Sort field EQFNR CHAR 30 0
SWERK Maintenance plant SWERK T001W CHAR 4 0
STORT Location of maintenance object PMLOC T499S CHAR 10 0
MSGRP Room RAUMNR CHAR 8 0
BEBER Plant section BEBER T357 CHAR 3 0
PPSID Object ID of PP work center PPSID NUMC 8 0
GSBER Business Area GSBER TGSB CHAR 4 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
KOSTL Cost Center KOSTL CSKS CHAR 10 0
PROID Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
BUKRS Company Code BUKRS T001 CHAR 4 0
ANLNR Main Asset Number ANLN1 ANLH CHAR 12 0
ANLUN Asset Subnumber ANLN2 ANLA CHAR 4 0
DAUFN Standing order number DAUFN AUFK CHAR 12 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVKOV CHAR 2 0
SPART Division SPART TVTA CHAR 2 0
ADRNR Address number AD_ADDRNUM ADRC CHAR 10 0
OWNER Object reference indicator ILOM_OWNER CHAR 1 0
NULL Equipment, current time segment
1 Equipment, historical time segment
2 Functional location
3 Maintenance item without object reference
4 Notification, current, without object reference
5 Notification, historical
6 Order, current, without object reference
7 Order, historical
ABNUM Maintenance Plan Call Number ABNUM INT4 10 0
WPPOS Maintenance item WAPOS CHAR 16 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
ADDAT Completion Date for Call Object MHIO_ADDAT DATS 8 0
LBLNI Entry Sheet Number LBLNI CHAR 10 0
TSENQ Scheduling status: call horizon not reached TSENQ CHAR 1 0
NULL Blank
. Radio button
X Selection
TSTAT Scheduling status TSTAT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
GSTRP Basic start date CO_GSTRP DATS 8 0
QMNUM Notification No QMNUM QMEL CHAR 12 0
QMART Notification Type QMART TQ80 CHAR 2 0
PLAN_SORT Sort field for maintenance plans PLAN_SORT T399G CHAR 20 0
MHIO_WARPL Maintenance Plan WARPL MPLA CHAR 12 0
PRUEFLOS Inspection Lot Number QPLOS NUMC 12 0
PHYNR Physical Sample Number QPHYSPRNR CHAR 12 0

VIMHIO foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VIMHIO ABCKZ VIMHIO ABCKZ T370C ABC indicator for technical objects ABCKZ
VIMHIO ABCKZ VIMHIO MANDT T370C ABC indicator for technical objects MANDT
VIMHIO ADRNR VIMHIO MANDT ADRC Addresses (Business Address Services) CLIENT
VIMHIO ADRNR VIMHIO ADRNR ADRC Addresses (Business Address Services) ADDRNUMBER
VIMHIO ADRNR * ADRC Addresses (Business Address Services) DATE_FROM
VIMHIO ADRNR * ADRC Addresses (Business Address Services) NATION
VIMHIO ANLNR VIMHIO MANDT ANLH Main asset number MANDT
VIMHIO ANLNR VIMHIO BUKRS ANLH Main asset number BUKRS
VIMHIO ANLNR VIMHIO ANLNR ANLH Main asset number ANLN1
VIMHIO ANLUN VIMHIO MANDT ANLA Asset Master Record Segment MANDT
VIMHIO ANLUN VIMHIO BUKRS ANLA Asset Master Record Segment BUKRS
VIMHIO ANLUN VIMHIO ANLNR ANLA Asset Master Record Segment ANLN1
VIMHIO ANLUN VIMHIO ANLUN ANLA Asset Master Record Segment ANLN2
VIMHIO AUART VIMHIO AUART T003O Order Types AUART
VIMHIO AUART VIMHIO MANDT T003O Order Types CLIENT
VIMHIO AUFNR VIMHIO MANDT AUFK Order master data MANDT
VIMHIO AUFNR VIMHIO AUFNR AUFK Order master data AUFNR
VIMHIO BAUTL VIMHIO BAUTL MARA General Material Data MATNR
VIMHIO BAUTL VIMHIO MANDT MARA General Material Data MANDT
VIMHIO BEBER VIMHIO MANDT T357 Plant Section MANDT
VIMHIO BEBER VIMHIO BEBER T357 Plant Section BEBER
VIMHIO BEBER VIMHIO SWERK T357 Plant Section WERKS
VIMHIO BUKRS VIMHIO MANDT T001 Company Codes MANDT
VIMHIO BUKRS VIMHIO BUKRS T001 Company Codes BUKRS
VIMHIO DAUFN VIMHIO DAUFN AUFK Order master data AUFNR
VIMHIO DAUFN VIMHIO MANDT AUFK Order master data MANDT
VIMHIO EQUNR VIMHIO MANDT EQUI Equipment master data MANDT
VIMHIO EQUNR VIMHIO EQUNR EQUI Equipment master data EQUNR
VIMHIO GEWRK VIMHIO MANDT CRID CIM Resource - Entities MANDT
VIMHIO GEWRK VIMHIO OBJTY CRID CIM Resource - Entities OBJTY
VIMHIO GEWRK VIMHIO GEWRK CRID CIM Resource - Entities OBJID
VIMHIO GSBER VIMHIO MANDT TGSB Business Areas MANDT
VIMHIO GSBER VIMHIO GSBER TGSB Business Areas GSBER
VIMHIO ILART VIMHIO ILART T353I Maintenance activity types ILART
VIMHIO ILART VIMHIO MANDT T353I Maintenance activity types MANDT
VIMHIO ILOAN VIMHIO ILOAN ILOA PM Object Location and Account Assignment ILOAN
VIMHIO ILOAN VIMHIO MANDT ILOA PM Object Location and Account Assignment MANDT
VIMHIO IWERK VIMHIO IWERK T399I Planning plant parameters IWERK
VIMHIO IWERK VIMHIO MANDT T399I Planning plant parameters MANDT
VIMHIO KOKRS VIMHIO MANDT TKA01 Controlling Areas MANDT
VIMHIO KOKRS VIMHIO KOKRS TKA01 Controlling Areas KOKRS
VIMHIO KOSTL VIMHIO MANDT CSKS Cost Center Master Data MANDT
VIMHIO KOSTL VIMHIO KOKRS CSKS Cost Center Master Data KOKRS
VIMHIO KOSTL VIMHIO KOSTL CSKS Cost Center Master Data KOSTL
VIMHIO KOSTL SYST DATUM CSKS Cost Center Master Data DATBI
VIMHIO LAUFN VIMHIO MANDT AUFK Order master data MANDT
VIMHIO LAUFN VIMHIO LAUFN AUFK Order master data AUFNR
VIMHIO MANDT VIMHIO MANDT T000 Clients MANDT
VIMHIO MHIO_WARPL VIMHIO MANDT MPLA Maintenance plan MANDT
VIMHIO MHIO_WARPL VIMHIO MHIO_WARPL MPLA Maintenance plan WARPL
VIMHIO MITYP VIMHIO MANDT T399P Maintenance item category parameter MANDT
VIMHIO MITYP VIMHIO MITYP T399P Maintenance item category parameter MITYP
VIMHIO PLAN_SORT VIMHIO MANDT T399G Maintenance Plan Sort Field MANDT
VIMHIO PLAN_SORT VIMHIO PLAN_SORT T399G Maintenance Plan Sort Field PLAN_SORT
VIMHIO PLNTY VIMHIO MANDT TCA01 Task list types MANDT
VIMHIO PLNTY VIMHIO PLNTY TCA01 Task list types PLNTY
VIMHIO PROID VIMHIO MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
VIMHIO PROID VIMHIO PROID PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
VIMHIO QMART VIMHIO QMART TQ80 Notification Types QMART
VIMHIO QMART VIMHIO MANDT TQ80 Notification Types MANDT
VIMHIO QMNUM VIMHIO QMNUM QMEL Quality Notification QMNUM
VIMHIO QMNUM VIMHIO MANDT QMEL Quality Notification MANDT
VIMHIO SERMAT VIMHIO MANDT MARA General Material Data MANDT
VIMHIO SERMAT VIMHIO SERMAT MARA General Material Data MATNR
VIMHIO SPART VIMHIO VKORG TVTA Organizational Unit: Sales Area(s) VKORG
VIMHIO SPART VIMHIO SPART TVTA Organizational Unit: Sales Area(s) SPART
VIMHIO SPART VIMHIO MANDT TVTA Organizational Unit: Sales Area(s) MANDT
VIMHIO SPART VIMHIO VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
VIMHIO STORT VIMHIO SWERK T499S Location WERKS
VIMHIO STORT VIMHIO STORT T499S Location STAND
VIMHIO STORT VIMHIO MANDT T499S Location MANDT
VIMHIO SWERK VIMHIO MANDT T001W Plants/Branches MANDT
VIMHIO SWERK VIMHIO SWERK T001W Plants/Branches WERKS
VIMHIO TPLNR VIMHIO TPLNR IFLOT Functional Location (Table) TPLNR
VIMHIO TPLNR VIMHIO MANDT IFLOT Functional Location (Table) MANDT
VIMHIO VKORG VIMHIO VKORG TVKO Organizational Unit: Sales Organizations VKORG
VIMHIO VKORG VIMHIO MANDT TVKO Organizational Unit: Sales Organizations MANDT
VIMHIO VTWEG VIMHIO VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
VIMHIO VTWEG VIMHIO VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
VIMHIO VTWEG VIMHIO MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
VIMHIO WARPL VIMHIO MANDT MPLA Maintenance plan MANDT
VIMHIO WARPL VIMHIO WARPL MPLA Maintenance plan WARPL
VIMHIO WPGRP VIMHIO WPGRP T024I Maintenance planner groups INGRP
VIMHIO WPGRP VIMHIO IWERK T024I Maintenance planner groups IWERK
VIMHIO WPGRP VIMHIO MANDT T024I Maintenance planner groups MANDT
VIMHIO WSTRA VIMHIO WSTRA T351 Maintenance strategy STRAT
VIMHIO WSTRA VIMHIO MANDT T351 Maintenance strategy MANDT