MHIS_UNPACKED SAP (Copy of DB table MHIS (Data category INT4 replaced by NUMC)) Table details
Description: Copy of DB table MHIS (Data category INT4 replaced by NUMC)
Related tables to MHIS_UNPACKED
Access table MHIS_UNPACKED
Table field list including key, data, relationships and ABAP select examples
MHIS_UNPACKED is a standard SAP Table which is used to store Copy of DB table MHIS (Data category INT4 replaced by NUMC) data and is available within R/3 SAP systems depending on the version and release level.
The MHIS_UNPACKED table consists of various fields, each holding specific information or linking keys about Copy of DB table MHIS (Data category INT4 replaced by NUMC) data available in SAP. These include WARPL (Maintenance Plan), ABNUM (Copy of data element ABNUM with category NUMC), ZAEHL (Maintenance Package Number), NPLDA (Next planned date).. 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: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP MHIS_UNPACKED table 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 | Assigned to domain | MANDT | |||
WARPL | Maintenance Plan | WARPL | CHAR | 12 | MPLA | ALPHA | WARPL | MPL | MPLAL |
ABNUM | Copy of data element ABNUM with category NUMC | ABNUM_UNPACKED | NUMC | 10 | |||||
ZAEHL | Maintenance Package Number | PAKETZAEHL | NUMC | 2 | Assigned to domain | PAKZAE | |||
NPLDA | Next planned date | NPLDA | DATS | 8 | DATUM | ||||
TERMA | Scheduling type | TERMA | CHAR | 1 | CHAR1 | ||||
STADT | Start date | STADT | DATS | 8 | DATUM | ||||
LRMDT | Date of last completion in maintenance plan | LRMDT | DATS | 8 | DATUM | ||||
OFFZE | Offset in current cycle | OFFZE | FLTP | 16(16) | FLTP | ||||
OFFZO | Previous offset | OFFZO | FLTP | 16(16) | FLTP | ||||
ABRUD | Date of the call | ABRUD | DATS | 8 | DATUM | ||||
ABRNA | Name of the person who made the call | ABRNA | CHAR | 12 | USNAM | ||||
SFAKT | Cycle modification factor | SFAKT | DEC | 3(2) | SFAKT | ||||
TERMK | Scheduling indicator | TERMKNZ | CHAR | 1 | TERMKNZ | ||||
VERSCH | Shift Factor for Late Completion | VERSCHPLUS | NUMC | 3 | NUM3 | ||||
TOLER | Tolerance for Late Completion (%) | TOLERPLUS | NUMC | 3 | NUM3 | ||||
KNNRM | Indicator for negative completion confirmation | KNNRM | CHAR | 1 | XFLAG | ||||
KNPRM | Indicator: planned counter reading set manually | KNPRM | CHAR | 1 | XFLAG | ||||
NPLDO | Last planned date | NPLDO | DATS | 8 | DATUM | ||||
NPLDZ | Completion for Predecessor | NPLDZ | DATS | 8 | DATUM | ||||
MANDA | Manual call date | MANDA | DATS | 8 | DATUM | ||||
OFFLE | Estimated annual performance | OFFLE | FLTP | 16(16) | FLTP | ||||
OFFLO | Shift factor | OFFLO | FLTP | 16(16) | FLTP | ||||
KNAUT | Reserved | KNZABR | CHAR | 1 | FLAG | ||||
KNASR | Indicator for leading cycle (multi-counter plan) -> internal | KNZSTILL | CHAR | 1 | FLAG | ||||
TSABR | Scheduling status: planned date called | TSABR | CHAR | 1 | XFLAG | ||||
TSVBT | Scheduling status: call outstanding | TSVBT | CHAR | 1 | XFLAG | ||||
TSENQ | Scheduling status: call horizon not reached | TSENQ | CHAR | 1 | XFLAG | ||||
TSENM | Scheduling status: stopped manually | TSENM | CHAR | 1 | XFLAG | ||||
HORDA | Call date | HORDA | DATS | 8 | DATUM | ||||
TSTAT | Scheduling status | TSTAT | CHAR | 1 | FLAG | ||||
FIXDU | Fixed or skipped by | FIXDU | CHAR | 12 | USNAM | ||||
FIXDA | Fixed/skipped on | FIXDA | DATS | 8 | DATUM | ||||
VGNUM | Copy of data element VGNUM with category NUMC | VGNUM_UNPACKED | NUMC | 10 | |||||
ZYKZT | Maintenance package cycle/offset | DZYK_ZEIT | FLTP | 16(16) | FLTP | ||||
ZYKLS | Total counter reading on call date | DZYK_LEIST | FLTP | 16(16) | FLTP | ||||
PUFFP | Lead Float in Days | PUFF_VORL | NUMC | 3 | NUM3 | ||||
PUFFN | Follow-up float in days | PUFF_NACHL | NUMC | 3 | NUM3 | ||||
SZAEH | Start counter reading | SZAEH | FLTP | 16(16) | FLTP | ||||
RZAEH | Counter reading confirmation | RZAEH | FLTP | 16(16) | FLTP | ||||
NZAEH | Next planned counter reading | NZAEH | FLTP | 16(16) | FLTP | ||||
USERMOD | Scheduling determined by user | USERMOD | CHAR | 1 | CHAR1 | ||||
CYCLESEQIND | Cycle set sequence | CYCLESEQIND | NUMC | 2 | NUMC2 | ||||
ADPOINT | Measuring Point | IMRC_POINT | CHAR | 12 | Assigned to domain | ALPHA | IMRC_POINT | IPT | IMPM |
ADANDOR | Indicator for OR or AND link | ANDOR | CHAR | 1 | RADIO | ||||
ADTGOON | Scheduling to reoccur when lead float reached | TGON | NUMC | 3 | NUM3 |
Key field | Non-key field |
How do I retrieve data from SAP table MHIS_UNPACKED using ABAP code
The following ABAP code Example will allow you to do a basic selection on MHIS_UNPACKED to SELECT all data from the tableDATA: WA_MHIS_UNPACKED TYPE MHIS_UNPACKED.
SELECT SINGLE *
FROM MHIS_UNPACKED
INTO CORRESPONDING FIELDS OF WA_MHIS_UNPACKED
WHERE...
How to access SAP table MHIS_UNPACKED
Within an ECC or HANA version of SAP you can also view further information about MHIS_UNPACKED 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