SAP ABAP Table HIKOLA_IFLOS (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure HIKOLA_IFLOS   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 AUFNR AUFNR_H AUFNR_H CHAR 12   0   Order number historical *
3 AUART AUFART AUFART CHAR 4   0   Order Type T003O
4 AUTYP AUFTYP AUFTYP NUMC 2   0   Order category  
5 KTEXT AUFTEXT TEXT40 CHAR 40   0   Description  
6 LTEXT AUFLTEXT XFELD CHAR 1   0   Long Text Exists  
7 LOEKZ AUFLOEKZ XFELD CHAR 1   0   Deletion flag  
8 MAUFNR MAUFNR_H AUFNR_H CHAR 12   0   Number of superior order historical HIKO
9 LEAD_AUFNR LAUFNR_H AUFNR_H CHAR 12   0   Number of leading order historical HIKO
10 PLVAR PLVAR PLVAR CHAR 2   0   Plan Version T778P
11 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number ONR00
12 VAPLZ GEWRK ARBPL CHAR 8   0   Main work center for maintenance tasks  
13 VAWRK WERGW WERKS CHAR 4   0   Plant associated with main work center T001W
14 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
15 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
16 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
17 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
18 WAERS AUFWAERS WAERS CUKY 5   0   Order Currency TCURC
19 GLTRP CO_GLTRP DATUM DATS 8   0   Basic finish date  
20 GSTRP CO_GSTRP DATUM DATS 8   0   Basic start date  
21 GSTRI CO_GSTRI DATUM DATS 8   0   Actual start date  
22 GETRI CO_GETRI DATUM DATS 8   0   Confirmed Order Finish Date  
23 PSPEL PS_PSP_ELE PS_POSNR NUMC 8   0   Work breakdown structure element (WBS element) PRPS
24 PLNTY PLNTY PLNTY CHAR 1   0   Task List Type TCA01
25 PLNNR PLNNR PLNNR CHAR 8   0   Key for Task List Group  
26 PLNAL PLNAL ALTNR CHAR 2   0   Group Counter  
27 ZAEHL CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
28 ERNAM AUFERFNAM USNAM CHAR 12   0   Entered by  
29 ERDAT AUFERFDAT DATUM DATS 8   0   Created on  
30 AENAM AUFAENAM USNAM CHAR 12   0   Last changed by  
31 AEDAT AUFAEDAT DATUM DATS 8   0   Change date for Order Master  
32 ARTPR ARTPR ARTPR CHAR 2   0   Priority Type T356A
33 PRIOK PRIOK PRIOK CHAR 1   0   Priority T356
34 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number EQUI
35 BAUTL BAUTL MATNR CHAR 18   0   Assembly MARA
36 ILOAN ILOAN ILOAN CHAR 12   0   Location and account assignment for technical object ILOA
37 ILOAI ILOAI X CHAR 1   0   ILOA Individual  
38 ANLZU ANLZU ANLZU CHAR 1   0   Syst.Condition T357M
39 IWERK IWERK WERKS CHAR 4   0   Maintenance Planning Plant T001W
40 INGPR INGRP INGRP CHAR 3   0   Planner Group for Customer Service and Plant Maintenance T024I
41 APGRP VAGRP VAGRP CHAR 3   0   Responsible planner group/department T024A
42 PM_OBJTY PM_OBJTY CR_OBJTY CHAR 2   0   Object Type of CIM Resources for Work Center  
43 GEWRK LGWID CR_OBJID NUMC 8   0   Object ID of the Work Center CRID
44 KUNUM KUNUM KUNNR CHAR 10   0   Customer Number KNA1
45 ANING ANING USNAM CHAR 12   0   Name of Person Reponsible for System  
46 GAUZT GAUZT FLTP FLTP 16   16   Planned downtime in hours  
47 GAUEH MAUEH MEINS UNIT 3   0   Unit for Breakdown Duration T006
48 ANLBD ANLBD DATUM DATS 8   0   Date until which the system is available  
49 ANLVD ANLVD DATUM DATS 8   0   Date from which the system is available  
50 ANLBZ ANLBZ UHRZT TIMS 6   0   Time until which the system is available  
51 ANLVZ ANLVZ UHRZT TIMS 6   0   Time from Which System is Available  
52 INSPK INSPK USNAM CHAR 12   0   Name of Person Responsible for Technical Inspection  
53 DATAN DATAN DATUM DATS 8   0   Date of Technical Inspection  
54 WARPL WARPL WARPL CHAR 12   0   Maintenance Plan MPLA
55 ABNUM ABNUM ABNUM INT4 10   0   Maintenance Plan Call Number  
56 WAPOS WAPOS POSNU CHAR 16   0   Maintenance item  
57 LAUFN LAUFN_H AUFNR_H CHAR 12   0   Order number historical HIKO
58 OBKNR OBJKNR OBJKN INT4 10   0   Object list number *
59 REVNR REVNI REVNI CHAR 8   0   Revision of Plant Maintenance and Customer Service T352R
60 ADDAT ADDAT DATUM DATS 8   0   PM Order: Reference Date  
61 ADUHR ADUHR UZEIT TIMS 6   0   Time of Reference Date  
62 IPHAS PM_PHASE PM_PHASE CHAR 1   0   Maintenance Processing Phase  
63 ILART ILA ILART CHAR 3   0   Maintenance activity type T353I
64 QMNUM QMNUM QMNUM CHAR 12   0   Message Number QMEL
65 HISDA HISDA DATUM DATS 8   0   PM request: History date  
66 AKKNZ AKKNZ AKKNZ CHAR 1   0   Order Category Indicator Plant Maintenance  
67 PLKNZ AUF_PLKNZ AUF_PLKNZ CHAR 1   0   Maintenance order planning indicator  
68 USER4 AUFUSER4 AUFUSER4 CURR 11   2   Estimated total costs of order  
69 SERIALNR GERNR GERNR CHAR 18   0   Serial Number  
70 SERMAT MATNR MATNR CHAR 18   0   Material Number MARA
71 DEVICEID DEVICEID DEVICEID CHAR 40   0   Additional Device Data  
72 SCREENTY SCRTP SCRTP CHAR 4   0   Scenario or Subscreen Category TQBT
73 UII UII_CHAR72 UII_CHAR72 CHAR 72   0   Unique Item Identifier  
74 TPLNR ILOM_STRNO ILOM_STRNO CHAR 40   0   Functional location label  
75 ABCKZ ABCKZ ABCKZ CHAR 1   0   ABC Indicator for Technical Object T370C
76 ABCKZI INH_ABCKZI INHER CHAR 1   0   Data origin for ABC indicator field  
77 EQFNR EQFNR CHAR30 CHAR 30   0   Sort Field  
78 EQFNRI INH_EQFNRI INHER CHAR 1   0   Data origin for sort field  
79 SWERK SWERK WERKS CHAR 4   0   Maintenance Plant T001W
80 SWERKI INH_SWERKI INHER CHAR 1   0   Data origin for maintenance plant field  
81 STORT PMLOC AP_STAND CHAR 10   0   Location of maintenance object T499S
82 STORTI INH_STORTI INHER CHAR 1   0   Data origin for location field  
83 MSGRP RAUMNR CHAR8 CHAR 8   0   Room  
84 MSGRPI INH_MSGRPI INHER CHAR 1   0   Data origin for room number field  
85 BEBER BEBER BEBER CHAR 3   0   Organizational Area T357
86 BEBERI INH_BEBERI INHER CHAR 1   0   Data origin for company area field  
87 CR_OBJTY CR_OBJTY CR_OBJTY CHAR 2   0   Object types of the CIM resource  
88 PPSID PPSID CR_OBJID NUMC 8   0   Object ID of PP work center CRID
89 PPSIDI INH_PPSIDI INHER CHAR 1   0   Data origin for PP work center field  
90 IGSBER GSBER GSBER CHAR 4   0   Business Area TGSB
91 GSBERI INH_GSBERI INHER CHAR 1   0   Data origin for business area field  
92 IKOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
93 KOKRSI INH_KOKRSI INHER CHAR 1   0   Data origin for controlling area field  
94 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
95 KOSTLI INH_KOSTLI INHER CHAR 1   0   Data origin for cost center field  
96 PROID PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) PRPS
97 PROIDI INH_PROIDI INHER CHAR 1   0   Data origin for WBS element field  
98 IBUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
99 BUKRSI INH_BUKRSI INHER CHAR 1   0   Data origin for company code field  
100 ANLNR ANLN1 ANLN1 CHAR 12   0   Main Asset Number ANLH
101 ANLNRI INH_ANLNRI INHER CHAR 1   0   Data origin for asset main no./sub-no. fields  
102 ANLUN ANLN2 ANLN2 CHAR 4   0   Asset Subnumber ANLA
103 ANLUNI INHER INHER CHAR 1   0   Data origin indicator  
104 DAUFN DAUFN AUFNR CHAR 12   0   Standing order number AUFK
105 DAUFNI INH_DAUFNI INHER CHAR 1   0   Data origin of standing order number field  
106 IAUFNR ILOM_ORDST AUFNR CHAR 12   0   Settlement order AUFK
107 AUFNRI INH_AUFNRI INHER CHAR 1   0   Data origin for settlement order field  
108 TPLNRI INH_TPLNRI INHER CHAR 1   0   Data origin for functional location field  
109 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
110 VKORGI INH_VKORGI INHER CHAR 1   0   Data origin for sales organization field  
111 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVKOV
112 VTWEGI INH_VTWEGI INHER CHAR 1   0   Data origin of distribution channel field  
113 SPART SPART SPART CHAR 2   0   Division TVTA
114 SPARTI INH_SPARTI INHER CHAR 1   0   Data origin for division field  
115 ADRNR AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number ADRC
116 ADRNRI INH_ADRNRI INHER CHAR 1   0   Data origin for address field  
117 OWNER ILOM_OWNER ILOM_OWNER CHAR 1   0   Object reference indicator  
118 ALKEY ILOM_ALKEY ILOM_ALKEY CHAR 1   0   Labeling system for functional locations IFLOALT
119 VERSN ILOM_VERSN NUMC3 NUMC 3   0   Version of functional location label  
120 TPLNR_INT TPLNR TPLNR CHAR 30   0   Functional Location IFLOT
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 HIKOLA_IFLOS ABCKZ T370C ABCKZ REF C CN
2 HIKOLA_IFLOS ADRNR ADRC ADDRNUMBER REF 1 CN
3 HIKOLA_IFLOS ALKEY IFLOALT ALKEY KEY 1 CN
4 HIKOLA_IFLOS ANLNR ANLH ANLN1 REF C CN
5 HIKOLA_IFLOS ANLUN ANLA ANLN2 REF C CN
6 HIKOLA_IFLOS ANLZU T357M ANLZU REF C CN
7 HIKOLA_IFLOS APGRP T024A FEVOR REF C CN
8 HIKOLA_IFLOS ARTPR T356A ARTPR REF C CN
9 HIKOLA_IFLOS AUART T003O AUART REF 1 CN
10 HIKOLA_IFLOS BAUTL MARA MATNR REF C CN
11 HIKOLA_IFLOS BEBER T357 BEBER REF C CN
12 HIKOLA_IFLOS BUKRS T001 BUKRS REF 1 CN
13 HIKOLA_IFLOS DAUFN AUFK AUFNR REF C CN
14 HIKOLA_IFLOS EQUNR EQUI EQUNR REF C CN
15 HIKOLA_IFLOS GAUEH T006 MSEHI REF C CN
16 HIKOLA_IFLOS GEWRK CRID OBJID REF C CN
17 HIKOLA_IFLOS GSBER TGSB GSBER REF 1 CN
18 HIKOLA_IFLOS IAUFNR AUFK AUFNR REF C CN
19 HIKOLA_IFLOS IBUKRS T001 BUKRS REF C CN
20 HIKOLA_IFLOS IGSBER TGSB GSBER REF C CN
21 HIKOLA_IFLOS IKOKRS TKA01 KOKRS REF C CN
22 HIKOLA_IFLOS ILART T353I ILART    
23 HIKOLA_IFLOS ILOAN ILOA ILOAN REF C CN
24 HIKOLA_IFLOS INGPR T024I INGRP REF C CN
25 HIKOLA_IFLOS IWERK T001W WERKS REF C CN
26 HIKOLA_IFLOS KOKRS TKA01 KOKRS REF 1 CN
27 HIKOLA_IFLOS KOSTL CSKS KOSTL REF C CN
28 HIKOLA_IFLOS KUNUM KNA1 KUNNR REF C CN
29 HIKOLA_IFLOS LAUFN HIKO AUFNR REF C CN
30 HIKOLA_IFLOS LEAD_AUFNR HIKO AUFNR    
31 HIKOLA_IFLOS MANDT T000 MANDT KEY 1 CN
32 HIKOLA_IFLOS MAUFNR HIKO AUFNR REF C CN
33 HIKOLA_IFLOS OBJNR ONR00 OBJNR    
34 HIKOLA_IFLOS PLNTY TCA01 PLNTY REF C CN
35 HIKOLA_IFLOS PLVAR T778P PLVAR REF C CN
36 HIKOLA_IFLOS PPSID CRID OBJID REF C CN
37 HIKOLA_IFLOS PRIOK T356 PRIOK REF C CN
38 HIKOLA_IFLOS PROID PRPS PSPNR C CN
39 HIKOLA_IFLOS PSPEL PRPS PSPNR REF C CN
40 HIKOLA_IFLOS QMNUM QMEL QMNUM    
41 HIKOLA_IFLOS REVNR T352R REVNR    
42 HIKOLA_IFLOS SCREENTY TQBT SCREENTY    
43 HIKOLA_IFLOS SERMAT MARA MATNR    
44 HIKOLA_IFLOS SPART TVTA SPART REF 1 CN
45 HIKOLA_IFLOS STORT T499S STAND REF C CN
46 HIKOLA_IFLOS SWERK T001W WERKS REF 1 CN
47 HIKOLA_IFLOS TPLNR_INT IFLOT TPLNR KEY 1 CN
48 HIKOLA_IFLOS VAWRK T001W WERKS    
49 HIKOLA_IFLOS VKORG TVKO VKORG REF 1 CN
50 HIKOLA_IFLOS VTWEG TVKOV VTWEG REF 1 CN
51 HIKOLA_IFLOS WAERS TCURC WAERS REF 1 CN
52 HIKOLA_IFLOS WARPL MPLA WARPL REF C CN
53 HIKOLA_IFLOS WERKS T001W WERKS REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in