ADPIC_HOLD_MPN is a standard SAP table in SAP ECC (or) S/4HANA which stores Store MPN subitems for MIGO hold / restore functionality data. There are total 33 fields in ADPIC_HOLD_MPN table.This blog post provides key technical details of SAP table ADPIC_HOLD_MPN, including its availability across SAP S/4HANA versions and the list of CDS views for ADPIC_HOLD_MPN table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | A&D Parts Interchangeability Enhancements (ADPIC) |
| Technical Component | Manufacturer Part Number (IS-AD-MPN) |
SAP ADPIC_HOLD_MPN Table Fields
The following is the list of fields that are available in SAP ADPIC_HOLD_MPN table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| GUID | GUID in ‘CHAR’ format with upper-/lowercase (!) | GUID_22 | SYSUUID_22 | CHAR (22) | |
| LINE_ID | Unique identification of document line | MB_LINE_ID | MB_LINE_ID | NUMC (6) | |
| POS_ID | Row Index of Internal Tables | SYTABIX | SYST_LONG | INT4 (10) | |
| MIGO_GLC | Unique number for one line | MIGO_GLOBAL_COUNTER | NUMC6 | NUMC (6) | |
| PARENT_ID | Link to superordinate line | MIGO_PARENT_GLC | NUMC6 | NUMC (6) | |
| INT_COUNTER | Unique number for one line | MIGO_GLOBAL_COUNTER | NUMC6 | NUMC (6) | |
| MENGE_IC | Quantity | MENGE_D | MENG13 | QUAN (13) | |
| MEINS_IC | Base Unit of Measure | MEINS | MEINS | UNIT (3) | |
| TAKE_IT_IC | Item is Adopted in Document | MB_TAKE_IT | XFELD | CHAR (1) | |
| IC_TYPE_ICON | ADCI MPN: Interchangeability Type Icon | ADPIC_D_IC_TYPE | CHAR132 | CHAR (132) | |
| MRPSET_LIGHT | Carrier field for icons | ICON_TEXT | SYCHAR132 | CHAR (132) | |
| MATNR | Material Number | MATNR | MATNR | CHAR (40) | |
| MATNR_DESCR | Material Description | MAKTX | TEXT40 | CHAR (40) | |
| PICCAT | Interchangeable parts category | PIC_PICCAT | PIC_PICCAT | CHAR (2) | |
| PICCAT_DESCR | Interchangeability Category Description | ADPIC_D_CATEGORY | ADPIC_DOM_CATEGORY | CHAR (40) | |
| PICCODE | Cause of part exchange | PIC_PICCODE | PIC_PICCODE | * | CHAR (4) |
| IMATN | FFF class | IMATN | MATNR | * | CHAR (40) |
| IMATN_DESCR | Material Description | MAKTX | TEXT40 | CHAR (40) | |
| PICNUM | Parts Interchangeability Group Number | PIC_PICNUM | PIC_PICNUM | CHAR (40) | |
| MRPGR | Parts interchangeability MPN-MRP set | PIC_MRPGR | PIC_MRPGR | CHAR (10) | |
| LMATN | Leading Part (A&D 3.0, MPN project) | LMATN | MATNR | * | CHAR (40) |
| MFRPN | Manufacturer Part Number | MFRPN | CHAR40 | CHAR (40) | |
| EMNFR | External manufacturer code name or number | EMNFR | CHAR10 | CHAR (10) | |
| WERKS | Plant | WERKS_D | WERKS | CHAR (4) | |
| LGORT | Storage location | LGORT_D | LGORT | * | CHAR (4) |
| BERID | MRP Area | BERID | BERID | * | CHAR (10) |
| CHARG | Batch Number | CHARG_D | CHARG | * | CHAR (10) |
| ATPMNG | ATP Server: ATP quantity | ATPMNG | MENGV15 | QUAN (15) | |
| MEINS | Base Unit of Measure | MEINS | MEINS | * | UNIT (3) |
| MRPSET | Indicator: MRP set comparison | MRPSET | MRPSET | NUMC (1) | |
| PICCODE_DESCR | Interchangeability Code Description | ICTEXT40 | TEXT40 | CHAR (40) | |
| DATFR | Valid from date of an interchangeable part | PIC_DATFR | DATUM | DATS (8) | |
| INTTYPE | Replacement Type | PIC_INTTYPE | PIC_INTTYPE | CHAR (1) |
Availability
The SAP table ADPIC_HOLD_MPN is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ADPIC_HOLD_MPN table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.
