HIKOLA SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
HIKOLA is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The HIKOLA table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include AUFNR (Order number historical), AUART (Order Type), AUTYP (Order category), KTEXT (Description).. 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. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP HIKOLA table view fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| AUFNR | Order number historical | AUFNR_H | CHAR | 12 | ALPHA | AUFNR_H | ANR | ||
| AUART | Order Type | AUFART | CHAR | 4 | T003O | AUFART | AAT | ||
| AUTYP | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
| KTEXT | Description | AUFTEXT | CHAR | 40 | TEXT40 | ||||
| LTEXT | Long Text Exists | AUFLTEXT | CHAR | 1 | XFELD | ||||
| LOEKZ | Deletion flag | AUFLOEKZ | CHAR | 1 | XFELD | ||||
| MAUFNR | Number of superior order historical | MAUFNR_H | CHAR | 12 | HIKO | ALPHA | AUFNR_H | ||
| LEAD_AUFNR | Number of leading order historical | LAUFNR_H | CHAR | 12 | HIKO | ALPHA | AUFNR_H | ||
| PLVAR | Plan Version | PLVAR | CHAR | 2 | T778P | PLVAR | POP | ||
| OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
| VAPLZ | Main work center for maintenance tasks | GEWRK | CHAR | 8 | ARBPL | VAP | |||
| VAWRK | Plant associated with main work center | WERGW | CHAR | 4 | T001W | WERKS | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
| KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
| WAERS | Order Currency | AUFWAERS | CUKY | 5 | TCURC | WAERS | |||
| GLTRP | Basic finish date | CO_GLTRP | DATS | 8 | DATUM | ||||
| GSTRP | Basic start date | CO_GSTRP | DATS | 8 | DATUM | ||||
| GSTRI | Actual start date | CO_GSTRI | DATS | 8 | DATUM | ||||
| GETRI | Confirmed Order Finish Date | CO_GETRI | DATS | 8 | DATUM | ||||
| PSPEL | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
| PLNTY | Task List Type | PLNTY | CHAR | 1 | TCA01 | PLNTY | PTY | H_TCA01 | |
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
| PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
| ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
| ERNAM | Entered by | AUFERFNAM | CHAR | 12 | USNAM | ||||
| ERDAT | Created on | AUFERFDAT | DATS | 8 | DATUM | ||||
| AENAM | Last changed by | AUFAENAM | CHAR | 12 | USNAM | ||||
| AEDAT | Change date for Order Master | AUFAEDAT | DATS | 8 | DATUM | ||||
| ARTPR | Priority Type | ARTPR | CHAR | 2 | T356A | ARTPR | |||
| PRIOK | Priority | PRIOK | CHAR | 1 | T356 | PRIOK | PRIOK | ||
| EQUNR | Equipment Number | EQUNR | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | EQUI |
| BAUTL | Assembly | BAUTL | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
| ILOAN | Location and account assignment for technical object | ILOAN | CHAR | 12 | ILOA | ILOAN | |||
| ILOAI | ILOA Individual | ILOAI | CHAR | 1 | X | ||||
| ANLZU | Syst.Condition | ANLZU | CHAR | 1 | T357M | ANLZU | |||
| IWERK | Maintenance Planning Plant | IWERK | CHAR | 4 | T001W | WERKS | IWK | ||
| INGPR | Planner Group for Customer Service and Plant Maintenance | INGRP | CHAR | 3 | T024I | INGRP | IHG | ||
| APGRP | Responsible planner group/department | VAGRP | CHAR | 3 | T024A | VAGRP | H_T024A | ||
| PM_OBJTY | Object Type of CIM Resources for Work Center | PM_OBJTY | CHAR | 2 | CR_OBJTY | ||||
| GEWRK | Object ID of the Work Center | LGWID | NUMC | 8 | CRID | CR_OBJID | |||
| KUNUM | Customer Number | KUNUM | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
| ANING | Name of Person Reponsible for System | ANING | CHAR | 12 | USNAM | ||||
| GAUZT | Planned downtime in hours | GAUZT | FLTP | 16(16) | FLTP | ||||
| GAUEH | Unit for Breakdown Duration | MAUEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| ANLBD | Date until which the system is available | ANLBD | DATS | 8 | DATUM | ||||
| ANLVD | Date from which the system is available | ANLVD | DATS | 8 | DATUM | ||||
| ANLBZ | Time until which the system is available | ANLBZ | TIMS | 6 | UHRZT | ||||
| ANLVZ | Time from Which System is Available | ANLVZ | TIMS | 6 | UHRZT | ||||
| INSPK | Name of Person Responsible for Technical Inspection | INSPK | CHAR | 12 | USNAM | ||||
| DATAN | Date of Technical Inspection | DATAN | DATS | 8 | DATUM | ||||
| WARPL | Maintenance Plan | WARPL | CHAR | 12 | MPLA | ALPHA | WARPL | MPL | MPLAL |
| ABNUM | Maintenance Plan Call Number | ABNUM | INT4 | 10 | ABNUM | ||||
| WAPOS | Maintenance item | WAPOS | CHAR | 16 | ALPHA | POSNU | MPS | MPOSL | |
| LAUFN | Order number historical | LAUFN_H | CHAR | 12 | HIKO | ALPHA | AUFNR_H | ANR | |
| OBKNR | Object list number | OBJKNR | INT4 | 10 | OBJKN | ||||
| REVNR | Revision for Plant Maintenance and Customer Service | REVNI | CHAR | 8 | T352R | REVNI | |||
| ADDAT | PM Order: Reference Date | ADDAT | DATS | 8 | DATUM | ||||
| ADUHR | Time of Reference Date | ADUHR | TIMS | 6 | UZEIT | ||||
| IPHAS | Maintenance Processing Phase | PM_PHASE | CHAR | 1 | PM_PHASE | ||||
| ILART | Maintenance activity type | ILA | CHAR | 3 | T353I | ILART | H_T350I | ||
| QMNUM | Notification No | QMNUM | CHAR | 12 | QMEL | ALPHA | QMNUM | IQM | |
| HISDA | PM request: History date | HISDA | DATS | 8 | DATUM | ||||
| AKKNZ | Order Category Indicator Plant Maintenance | AKKNZ | CHAR | 1 | AKKNZ | ||||
| PLKNZ | Maintenance order planning indicator | AUF_PLKNZ | CHAR | 1 | AUF_PLKNZ | ||||
| USER4 | Estimated total costs of order | AUFUSER4 | CURR | 11(2) | AUFUSER4 | ||||
| SERIALNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
| SERMAT | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
| DEVICEID | Additional Device Data | DEVICEID | CHAR | 40 | DEVICEID | ||||
| SCREENTY | Scenario or Subscreen Category | SCRTP | CHAR | 4 | TQBT | SCRTP | |||
| DUMMY_CI_AUFK | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
| /MRSS/PL_STRU_ID | Resource planning nodes | /MRSS/T_PLAN_STRUCT_ID | NUMC | 8 | CR_OBJID | ||||
| /MRSS/PL_MAN_TYP | Assignment to resource planner or contact person | /MRSS/T_MANAGER_TYPE | CHAR | 1 | /MRSS/_MANAGER_TYPE | ||||
| /MRSS/ORDER_PROB | Order probability in percent | /MRSS/T_ORDER_PROB | CHAR | 3 | OPROB | /MRSS/_ORDER_PROB | |||
| /MRSS/ACT_TYPE | Process variant | /MRSS/T_ACTIVITY_TYPE | CHAR | 1 | /MRSS/_ACTIVITY_TYPE | ||||
| /MRSS/INIT_DONE | Internal initialization carried out once | /MRSS/T_INIT_DONE | CHAR | 1 | FLAG | ||||
| /MRSS/DATACHANGE | Data was changed in the controls on the user screen | /MRSS/T_USCREENCTL_DATACHANGED | CHAR | 1 | FLAG | ||||
| /MRSS/SALES_ORG | Sales Organization | VKORG | CHAR | 4 | VKORG | VKO | C_VKORG | ||
| /MRSS/NW_BOOKED | Network Set to 'Booked' | /MRSS/T_NW_BOOKED | CHAR | 1 | FLAG | ||||
| UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | UII_CHAR72 | UII | H_UII | ||
| TPLNR | Functional Location | TPLNR | CHAR | 30 | IFLOT | TPLNR | TPLNR | IFL | IFLM |
| ABCKZ | ABC indicator for technical object | ABCKZ | CHAR | 1 | T370C | ABCKZ | |||
| ABCKZI | Data origin for ABC indicator field | INH_ABCKZI | CHAR | 1 | INHER | ||||
| EQFNR | Sort field | EQFNR | CHAR | 30 | CHAR30 | ||||
| EQFNRI | Data origin for sort field | INH_EQFNRI | CHAR | 1 | INHER | ||||
| SWERK | Maintenance plant | SWERK | CHAR | 4 | T001W | WERKS | SWK | ||
| SWERKI | Data origin for maintenance plant field | INH_SWERKI | CHAR | 1 | INHER | ||||
| STORT | Location of maintenance object | PMLOC | CHAR | 10 | T499S | AP_STAND | |||
| STORTI | Data origin for location field | INH_STORTI | CHAR | 1 | INHER | ||||
| MSGRP | Room | RAUMNR | CHAR | 8 | CHAR8 | ||||
| MSGRPI | Data origin for room number field | INH_MSGRPI | CHAR | 1 | INHER | ||||
| BEBER | Plant section | BEBER | CHAR | 3 | T357 | BEBER | BBE | ||
| BEBERI | Data origin for plant section field | INH_BEBERI | CHAR | 1 | INHER | ||||
| CR_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
| PPSID | Object ID of PP work center | PPSID | NUMC | 8 | CRID | CR_OBJID | |||
| PPSIDI | Data origin for PP work center field | INH_PPSIDI | CHAR | 1 | INHER | ||||
| IGSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
| GSBERI | Data origin for business area field | INH_GSBERI | CHAR | 1 | INHER | ||||
| IKOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
| KOKRSI | Data origin for controlling area field | INH_KOKRSI | CHAR | 1 | INHER | ||||
| KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
| KOSTLI | Data origin for cost center field | INH_KOSTLI | CHAR | 1 | INHER | ||||
| PROID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
| PROIDI | Data origin for WBS element field | INH_PROIDI | CHAR | 1 | INHER | ||||
| IBUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| BUKRSI | Data origin for company code field | INH_BUKRSI | CHAR | 1 | INHER | ||||
| ANLNR | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
| ANLNRI | Data origin for asset main no./sub-no. fields | INH_ANLNRI | CHAR | 1 | INHER | ||||
| ANLUN | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 | |
| ANLUNI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
| DAUFN | Standing order number | DAUFN | CHAR | 12 | AUFK | ALPHA | AUFNR | ORDP | |
| DAUFNI | Data origin of standing order number field | INH_DAUFNI | CHAR | 1 | INHER | ||||
| IAUFNR | Settlement order | ILOM_ORDST | CHAR | 12 | AUFK | ALPHA | AUFNR | ORDE | |
| AUFNRI | Data origin for settlement order field | INH_AUFNRI | CHAR | 1 | INHER | ||||
| TPLNRI | Data origin for functional location field | INH_TPLNRI | CHAR | 1 | INHER | ||||
| VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
| VKORGI | Data origin for sales organization field | INH_VKORGI | CHAR | 1 | INHER | ||||
| VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVKOV | VTWEG | VTW | C_VTWEG | |
| VTWEGI | Data origin of distribution channel field | INH_VTWEGI | CHAR | 1 | INHER | ||||
| SPART | Division | SPART | CHAR | 2 | TVTA | SPART | SPA | C_SPART | |
| SPARTI | Data origin for division field | INH_SPARTI | CHAR | 1 | INHER | ||||
| ADRNR | Address number | AD_ADDRNUM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ADR | |
| ADRNRI | Data origin for address field | INH_ADRNRI | CHAR | 1 | INHER | ||||
| OWNER | Object reference indicator | ILOM_OWNER | CHAR | 1 | ILOM_OWNER |
| Key field | Non-key field |
How do I retrieve data from SAP table HIKOLA using ABAP code
The following ABAP code Example will allow you to do a basic selection on HIKOLA to SELECT all data from the tableDATA: WA_HIKOLA TYPE HIKOLA.
SELECT SINGLE *
FROM HIKOLA
INTO CORRESPONDING FIELDS OF WA_HIKOLA
WHERE...
How to access SAP table HIKOLA
Within an ECC or HANA version of SAP you can also view further information about HIKOLA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects