MFHM_TMP SAP (File for Incorrect Data in Direct Input) Table details
Dictionary Type: Table
Description: File for Incorrect Data in Direct Input
Description: File for Incorrect Data in Direct Input
Table field list including key, data, relationships and ABAP select examples
MFHM_TMP is a standard SAP Table which is used to store File for Incorrect Data in Direct Input data and is available within R/3 SAP systems depending on the version and release level.
The MFHM_TMP table consists of various fields, each holding specific information or linking keys about File for Incorrect Data in Direct Input data available in SAP. These include ID (Job ID (direct input)), TRANC (Transaction counter for data transfer), D_IND (Which number within a transaction must be reset?), MATNR (Material Number).. 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: Not classified
SAP MFHM_TMP 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 | |||
ID | Job ID (direct input) | BIJOBID | CHAR | 32 | Assigned to domain | BIJOBID | |||
TRANC | Transaction counter for data transfer | TRANSCOUNT | NUMC | 10 | NUMC10 | ||||
D_IND | Which number within a transaction must be reset? | M_DELIND | NUMC | 10 | NUMC10 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
OBJID | Object ID of the resource | CR_OBJID | NUMC | 8 | Assigned to domain | CR_OBJID | |||
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
OBJTY_V | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
OBJID_V | Object ID of the resource | CR_OBJID | NUMC | 8 | Assigned to domain | CR_OBJID | |||
KZKBL | Indicator: Create load records for prod. resources/tools | KZKBL | CHAR | 1 | XFELD | ||||
STEUF | Control key for management of production resources/tools | STEUF | CHAR | 4 | Assigned to domain | STEUF | |||
STEUF_REF | Control key cannot be changed | CF_STKZR | CHAR | 1 | XFELD | ||||
FGRU1 | Grouping key 1 for production resources/tools | FGRUA | CHAR | 4 | Assigned to domain | FGRUA | |||
FGRU2 | Grouping key 2 for production resources/tools | FGRUB | CHAR | 4 | Assigned to domain | FGRUA | |||
PLANV | Production resource/tool usage | FH_PLANV | CHAR | 3 | Assigned to domain | AP_PLANV | |||
KTSCH | Standard text key for production resources/tools | CF_KTSCH | CHAR | 7 | Assigned to domain | KTSCH | |||
KTSCH_REF | Reference Key Cannot be Changed | CF_KTKZR | CHAR | 1 | XFELD | ||||
BZOFFB | Reference date to start of production resource/tool usage | BZOFFB | CHAR | 2 | Assigned to domain | CP_BZOFF | |||
BZOFFB_REF | Start reference date cannot be changed | CF_BBKZR | CHAR | 1 | XFELD | ||||
OFFSTB | Offset to start of production resource/tool usage | OFFSTB | QUAN | 5 | VNZTV | ||||
EHOFFB | Offset unit for start of prod. resource/tool usage | EHOFFB | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OFFSTB_REF | Offset to start cannot be changed | CF_OBKZR | CHAR | 1 | XFELD | ||||
BZOFFE | Reference date for end of production resource/tool usage | BZOFFE | CHAR | 2 | Assigned to domain | CP_BZOFF | |||
BZOFFE_REF | End reference date cannot be changed | CF_BEKZR | CHAR | 1 | XFELD | ||||
OFFSTE | Offset to finish of production resource/tool usage | OFFSTE | QUAN | 5 | VNZTV | ||||
EHOFFE | Offset unit for end of production resource/tool usage | EHOFFE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OFFSTE_REF | Offset to end cannot be changed | CF_OEKZR | CHAR | 1 | XFELD | ||||
MGFORM | Formula for calculating the total quantity of PRT | CF_MGFORM | CHAR | 6 | Assigned to domain | AP_FORMEL | |||
MGFORM_REF | Formula for calculating the total quantity cannot be changed | CF_MFKZR | CHAR | 1 | XFELD | ||||
EWFORM | Formula for calculating the total usage value of PRT | CF_EWFORM | CHAR | 6 | Assigned to domain | AP_FORMEL | |||
EWFORM_REF | Formula to calculate entire usage value cannot be changed | CF_EFKZR | CHAR | 1 | XFELD | ||||
PAR01 | First parameter (for formulas) | CF_PAR01 | CHAR | 6 | Assigned to domain | PARAMID | |||
PAR02 | Second parameter (for formulas) | CF_PAR02 | CHAR | 6 | Assigned to domain | PARAMID | |||
PAR03 | Third parameter (for formulas) | CF_PAR03 | CHAR | 6 | Assigned to domain | PARAMID | |||
PAR04 | Fourth parameter (for formulas) | CF_PAR04 | CHAR | 6 | Assigned to domain | PARAMID | |||
PAR05 | Fifth parameter (for formulas) | CF_PAR05 | CHAR | 6 | Assigned to domain | PARAMID | |||
PAR06 | Sixth parameter (for formulas) | CF_PAR06 | CHAR | 6 | Assigned to domain | PARAMID | |||
PARU1 | Parameter unit | CF_PARUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PARU2 | Parameter unit | CF_PARUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PARU3 | Parameter unit | CF_PARUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PARU4 | Parameter unit | CF_PARUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PARU5 | Parameter unit | CF_PARUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PARU6 | Parameter unit | CF_PARUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PARV1 | Parameter value | CF_PARVAL | QUAN | 9(3) | VGWRT | ||||
PARV2 | Parameter value | CF_PARVAL | QUAN | 9(3) | VGWRT | ||||
PARV3 | Parameter value | CF_PARVAL | QUAN | 9(3) | VGWRT | ||||
PARV4 | Parameter value | CF_PARVAL | QUAN | 9(3) | VGWRT | ||||
PARV5 | Parameter value | CF_PARVAL | QUAN | 9(3) | VGWRT | ||||
PARV6 | Parameter value | CF_PARVAL | QUAN | 9(3) | VGWRT |
Key field | Non-key field |
How do I retrieve data from SAP table MFHM_TMP using ABAP code
The following ABAP code Example will allow you to do a basic selection on MFHM_TMP to SELECT all data from the tableDATA: WA_MFHM_TMP TYPE MFHM_TMP.
SELECT SINGLE *
FROM MFHM_TMP
INTO CORRESPONDING FIELDS OF WA_MFHM_TMP
WHERE...
How to access SAP table MFHM_TMP
Within an ECC or HANA version of SAP you can also view further information about MFHM_TMP 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