SAP ABAP Table VIMHIO (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure VIMHIO   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 WAPOS WAPOS POSNU CHAR 16   0   Maintenance item  
3 WARPL WARPL WARPL CHAR 12   0   Maintenance Plan MPLA
4 WSTRA STRAT WSTRA CHAR 6   0   Maintenance strategy T351
5 PSTXT POSTXT TEXT40 CHAR 40   0   Item Short Text  
6 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number EQUI
7 OBKNR OBJKNR OBJKN INT4 10   0   Object list number  
8 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
9 ERSDT EDATUM DATUM DATS 8   0   Date of creation  
10 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
11 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
12 PLNTY PLNTY PLNTY CHAR 1   0   Task List Type TCA01
13 PLNNR PLNNR PLNNR CHAR 8   0   Key for Task List Group  
14 PLNAL PLNAL ALTNR CHAR 2   0   Group Counter  
15 STATUS MPSTAT FLAG CHAR 1   0   Maintenance Item Status  
16 LTKNZ MPLTX XFELD CHAR 1   0   Long Text Indicator  
17 WPGRP INGRP INGRP CHAR 3   0   Planner Group for Customer Service and Plant Maintenance T024I
18 OBJTY CR_OBJTY CR_OBJTY CHAR 2   0   Object types of the CIM resource  
19 GEWRK LGWID CR_OBJID NUMC 8   0   Object ID of the Work Center CRID
20 IWERK IWERK WERKS CHAR 4   0   Maintenance Planning Plant T399I
21 ILOAN ILOAN ILOAN CHAR 12   0   Location and account assignment for technical object ILOA
22 LAUFN LAUFN AUFNR CHAR 12   0   Order number AUFK
23 BAUTL BAUTL MATNR CHAR 18   0   Assembly MARA
24 ANLZU ANLZU ANLZU CHAR 1   0   Syst.Condition  
25 AUART AUFART AUFART CHAR 4   0   Order Type T003O
26 ILART ILA ILART CHAR 3   0   Maintenance activity type T353I
27 IND_ABRVO IND_ABRVO CHAR01 CHAR 1   0   Indicator showing settlement rule maintained  
28 PSPEL PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element)  
29 KDAUF VBELN_VA VBELN CHAR 10   0   Sales Document  
30 KDPOS POSNR_VA POSNR NUMC 6   0   Sales Document Item  
31 MITYP MITYP CHAR2 CHAR 2   0   Maintenance item category T399P
32 BSTNR BSTNR EBELN CHAR 10   0   Purchase order number  
33 BSTPO BSTPO EBELP NUMC 5   0   Purchase order item number  
34 APFKT APFKT AFAKT DEC 3   0   Execution factor for whole task list  
35 SERIALNR GERNR GERNR CHAR 18   0   Serial Number  
36 SERMAT MATNR MATNR CHAR 18   0   Material Number MARA
37 DEVICEID DEVICEID DEVICEID CHAR 40   0   Additional Device Data  
38 TPLNR TPLNR TPLNR CHAR 30   0   Functional Location IFLOT
39 ABCKZ ABCKZ ABCKZ CHAR 1   0   ABC Indicator for Technical Object T370C
40 EQFNR EQFNR CHAR30 CHAR 30   0   Sort Field  
41 SWERK SWERK WERKS CHAR 4   0   Maintenance Plant T001W
42 STORT PMLOC AP_STAND CHAR 10   0   Location of maintenance object T499S
43 MSGRP RAUMNR CHAR8 CHAR 8   0   Room  
44 BEBER BEBER BEBER CHAR 3   0   Organizational Area T357
45 PPSID PPSID CR_OBJID NUMC 8   0   Object ID of PP work center  
46 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
47 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
48 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
49 PROID PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) PRPS
50 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
51 ANLNR ANLN1 ANLN1 CHAR 12   0   Main Asset Number ANLH
52 ANLUN ANLN2 ANLN2 CHAR 4   0   Asset Subnumber ANLA
53 DAUFN DAUFN AUFNR CHAR 12   0   Standing order number AUFK
54 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
55 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVKOV
56 SPART SPART SPART CHAR 2   0   Division TVTA
57 ADRNR AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number ADRC
58 OWNER ILOM_OWNER ILOM_OWNER CHAR 1   0   Object reference indicator  
59 ABNUM ABNUM ABNUM INT4 10   0   Maintenance Plan Call Number  
60 WPPOS WAPOS POSNU CHAR 16   0   Maintenance item  
61 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
62 ADDAT MHIO_ADDAT DATUM DATS 8   0   Completion Date for Call Object  
63 LBLNI LBLNI LBLNI CHAR 10   0   Entry Sheet Number  
64 TSENQ TSENQ XFLAG CHAR 1   0   Scheduling status: call horizon not reached  
65 TSTAT TSTAT FLAG CHAR 1   0   Scheduling status  
66 GSTRP CO_GSTRP DATUM DATS 8   0   Basic start date  
67 QMNUM QMNUM QMNUM CHAR 12   0   Message Number QMEL
68 QMART QMART QMART CHAR 2   0   Message Type TQ80
69 PLAN_SORT PLAN_SORT CHAR20 CHAR 20   0   Sort field for maintenance plans T399G
70 MHIO_WARPL WARPL WARPL CHAR 12   0   Maintenance Plan MPLA
71 PRUEFLOS QPLOS QPLOS NUMC 12   0   Inspection Lot Number  
72 PHYNR QPHYSPRNR QPHYSPRNR CHAR 12   0   Physical Sample Number  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VIMHIO ABCKZ T370C ABCKZ REF C CN
2 VIMHIO ADRNR ADRC ADDRNUMBER REF 1 CN
3 VIMHIO ANLNR ANLH ANLN1 REF C CN
4 VIMHIO ANLUN ANLA ANLN2 REF C CN
5 VIMHIO AUART T003O AUART REF C CN
6 VIMHIO AUFNR AUFK AUFNR REF C CN
7 VIMHIO BAUTL MARA MATNR REF C CN
8 VIMHIO BEBER T357 BEBER REF C CN
9 VIMHIO BUKRS T001 BUKRS REF C CN
10 VIMHIO DAUFN AUFK AUFNR REF C CN
11 VIMHIO EQUNR EQUI EQUNR REF C CN
12 VIMHIO GEWRK CRID OBJID REF C CN
13 VIMHIO GSBER TGSB GSBER REF C CN
14 VIMHIO ILART T353I ILART REF C CN
15 VIMHIO ILOAN ILOA ILOAN REF C CN
16 VIMHIO IWERK T399I IWERK REF C CN
17 VIMHIO KOKRS TKA01 KOKRS REF C CN
18 VIMHIO KOSTL CSKS KOSTL REF C CN
19 VIMHIO LAUFN AUFK AUFNR REF C CN
20 VIMHIO MANDT T000 MANDT KEY 1 CN
21 VIMHIO MHIO_WARPL MPLA WARPL KEY 1 CN
22 VIMHIO MITYP T399P MITYP    
23 VIMHIO PLAN_SORT T399G PLAN_SORT KEY 1 CN
24 VIMHIO PLNTY TCA01 PLNTY REF C CN
25 VIMHIO PROID PRPS PSPNR C CN
26 VIMHIO QMART TQ80 QMART    
27 VIMHIO QMNUM QMEL QMNUM    
28 VIMHIO SERMAT MARA MATNR    
29 VIMHIO SPART TVTA SPART REF 1 CN
30 VIMHIO STORT T499S STAND REF C CN
31 VIMHIO SWERK T001W WERKS REF 1 CN
32 VIMHIO TPLNR IFLOT TPLNR REF C CN
33 VIMHIO VKORG TVKO VKORG REF 1 CN
34 VIMHIO VTWEG TVKOV VTWEG REF 1 CN
35 VIMHIO WARPL MPLA WARPL KEY 1 CN
36 VIMHIO WPGRP T024I INGRP REF C CN
37 VIMHIO WSTRA T351 STRAT KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in