ADPIC_HOLD_MPN SAP (Store MPN subitems for MIGO hold / restore functionality) Table details
Description: Store MPN subitems for MIGO hold / restore functionality
Related tables to ADPIC_HOLD_MPN
Access table ADPIC_HOLD_MPN
Table field list including key, data, relationships and ABAP select examples
ADPIC_HOLD_MPN is a standard SAP Table which is used to store Store MPN subitems for MIGO hold / restore functionality data and is available within R/3 SAP systems depending on the version and release level.
The ADPIC_HOLD_MPN table consists of various fields, each holding specific information or linking keys about Store MPN subitems for MIGO hold / restore functionality data available in SAP. These include LINE_ID (Unique identification of document line), POS_ID (Row Index of Internal Tables), MIGO_GLC (Unique number for one line), PARENT_ID (Link to superordinate line).. 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 ADPIC_HOLD_MPN 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 |
GUID | GUID in 'CHAR' format with upper-/lowercase (!) | GUID_22 | CHAR | 22 | SYSUUID_22 | ||||
LINE_ID | Unique identification of document line | MB_LINE_ID | NUMC | 6 | MB_LINE_ID | ||||
POS_ID | Row Index of Internal Tables | SYTABIX | INT4 | 10 | SYST_LONG | ||||
MIGO_GLC | Unique number for one line | MIGO_GLOBAL_COUNTER | NUMC | 6 | NUMC6 | ||||
PARENT_ID | Link to superordinate line | MIGO_PARENT_GLC | NUMC | 6 | NUMC6 | ||||
INT_COUNTER | Unique number for one line | MIGO_GLOBAL_COUNTER | NUMC | 6 | NUMC6 | ||||
MENGE_IC | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
MEINS_IC | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TAKE_IT_IC | Item is Adopted in Document | MB_TAKE_IT | CHAR | 1 | XFELD | ||||
IC_TYPE_ICON | ADCI MPN: Interchangeability Type Icon | ADPIC_D_IC_TYPE | CHAR | 132 | CHAR132 | ||||
MRPSET_LIGHT | Carrier field for icons | ICON_TEXT | CHAR | 132 | SYCHAR132 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MATNR_DESCR | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
PICCAT | Interchangeable parts category | PIC_PICCAT | CHAR | 2 | PIC_PICCAT | ||||
PICCAT_DESCR | Interchangeability Category Description | ADPIC_D_CATEGORY | CHAR | 40 | ADPIC_DOM_CATEGORY | ||||
PICCODE | Cause of part exchange | PIC_PICCODE | CHAR | 4 | Assigned to domain | PIC_PICCODE | |||
IMATN | FFF class | IMATN | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
IMATN_DESCR | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
PICNUM | Parts Interchangeability Group Number | PIC_PICNUM | CHAR | 18 | ALPHA | PIC_PICNUM | PIC_PICNUM | ||
MRPGR | Parts interchangeability MPN-MRP set | PIC_MRPGR | CHAR | 10 | PIC_MRPGR | ||||
LMATN | Leading Part (A&D 3.0, MPN project) | LMATN | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
MFRPN | Manufacturer Part Number | MFRPN | CHAR | 40 | CHAR40 | ||||
EMNFR | External manufacturer code name or number | EMNFR | CHAR | 10 | CHAR10 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
BERID | MRP Area | BERID | CHAR | 10 | Assigned to domain | BERID | BERID | ||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
ATPMNG | ATP Server: ATP quantity | ATPMNG | QUAN | 15(3) | MENGV15 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MRPSET | Indicator: MRP set comparison | MRPSET | NUMC | 1 | MRPSET | ||||
PICCODE_DESCR | Interchangeability Code Description | ICTEXT40 | CHAR | 40 | TEXT40 | ||||
DATFR | Valid from date of an interchangeable part | PIC_DATFR | DATS | 8 | DATUM | ||||
INTTYPE | Replacement Type | PIC_INTTYPE | CHAR | 1 | PIC_INTTYPE |
Key field | Non-key field |
How do I retrieve data from SAP table ADPIC_HOLD_MPN using ABAP code
The following ABAP code Example will allow you to do a basic selection on ADPIC_HOLD_MPN to SELECT all data from the tableDATA: WA_ADPIC_HOLD_MPN TYPE ADPIC_HOLD_MPN.
SELECT SINGLE *
FROM ADPIC_HOLD_MPN
INTO CORRESPONDING FIELDS OF WA_ADPIC_HOLD_MPN
WHERE...
How to access SAP table ADPIC_HOLD_MPN
Within an ECC or HANA version of SAP you can also view further information about ADPIC_HOLD_MPN 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