SAP table VIMHIO (Generated Table for View)

SAP table VIMHIO has 60 primary key fields being MANDT,WAPOS,WARPL,WSTRA,PSTXT,EQUNR,OBKNR,ERNAM,ERSDT,AEDAT,AENAM,PLNTY,PLNNR,PLNAL,STATUS,LTKNZ,WPGRP,OBJTY,GEWRK,IWERK,ILOAN,LAUFN,BAUTL,ANLZU,AUART,ILART,IND_ABRVO,PSPEL,KDAUF,KDPOS,MITYP,BSTNR,BSTPO,APFKT,SERIALNR,SERMAT,DEVICEID,TPLNR,ABCKZ,EQFNR,SWERK,STORT,MSGRP,BEBER,PPSID,GSBER,KOKRS,KOSTL,PROID,BUKRS,ANLNR,ANLUN,DAUFN,VKORG,VTWEG,SPART,ADRNR,OWNER,ABNUM,WPPOS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

VIMHIO foreign key relationships

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