SAP ADPIC_HOLD_MPN Store MPN subitems for MIGO hold / restore functionality Table
Overview
ADPIC_HOLD_MPN is a standard SAP S/4HANA table that stores Store MPN subitems for MIGO hold / restore functionality data. There are total 33 fields in the ADPIC_HOLD_MPN table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ADPIC_HOLD_MPN belongs to Manufacturer Part Number (IS-AD-MPN) module and is located in the package A&D Parts Interchangeability Enhancements (ADPIC).
In addition, following links provide an overview of foreign key relationships, if any, that link ADPIC_HOLD_MPN to other SAP tables and standard CDS views available based on ADPIC_HOLD_MPN table in S/4HANA 2020.
Techincal Settings of ADPIC_HOLD_MPN
Below are technical details of the table ADPIC_HOLD_MPN
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ADPIC_HOLD_MPN Fields
The following table gives you an overview of the fields available in ADPIC_HOLD_MPN
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| GUID | GUID in 'CHAR' format with upper-/lowercase (!) | GUID_22 | CHAR | 22 | |
| LINE_ID | Unique identification of document line | MB_LINE_ID | NUMC | 6 | |
| POS_ID | Row Index of Internal Tables | SYTABIX | INT4 | 10 | |
| MIGO_GLC | Unique number for one line | MIGO_GLOBAL_COUNTER | NUMC | 6 | |
| PARENT_ID | Link to superordinate line | MIGO_PARENT_GLC | NUMC | 6 | |
| INT_COUNTER | Unique number for one line | MIGO_GLOBAL_COUNTER | NUMC | 6 | |
| MENGE_IC | Quantity | MENGE_D | QUAN | 13 | |
| MEINS_IC | Base Unit of Measure | MEINS | UNIT | 3 | |
| TAKE_IT_IC | Item is Adopted in Document | MB_TAKE_IT | CHAR | 1 | |
| IC_TYPE_ICON | ADCI MPN: Interchangeability Type Icon | ADPIC_D_IC_TYPE | CHAR | 132 | |
| MRPSET_LIGHT | Carrier field for icons | ICON_TEXT | CHAR | 132 | |
| MATNR | Material Number | MATNR | CHAR | 40 | |
| MATNR_DESCR | Material Description | MAKTX | CHAR | 40 | |
| PICCAT | Interchangeable parts category | PIC_PICCAT | CHAR | 2 | |
| PICCAT_DESCR | Interchangeability Category Description | ADPIC_D_CATEGORY | CHAR | 40 | |
| PICCODE | Cause of part exchange | PIC_PICCODE | * | CHAR | 4 |
| IMATN | FFF class | IMATN | * | CHAR | 40 |
| IMATN_DESCR | Material Description | MAKTX | CHAR | 40 | |
| PICNUM | Parts Interchangeability Group Number | PIC_PICNUM | CHAR | 40 | |
| MRPGR | Parts interchangeability MPN-MRP set | PIC_MRPGR | CHAR | 10 | |
| LMATN | Leading Part (A&D 3.0, MPN project) | LMATN | * | CHAR | 40 |
| MFRPN | Manufacturer Part Number | MFRPN | CHAR | 40 | |
| EMNFR | External manufacturer code name or number | EMNFR | CHAR | 10 | |
| WERKS | Plant | WERKS_D | CHAR | 4 | |
| LGORT | Storage location | LGORT_D | * | CHAR | 4 |
| BERID | MRP Area | BERID | * | CHAR | 10 |
| CHARG | Batch Number | CHARG_D | * | CHAR | 10 |
| ATPMNG | ATP Server: ATP quantity | ATPMNG | QUAN | 15 | |
| MEINS | Base Unit of Measure | MEINS | * | UNIT | 3 |
| MRPSET | Indicator: MRP set comparison | MRPSET | NUMC | 1 | |
| PICCODE_DESCR | Interchangeability Code Description | ICTEXT40 | CHAR | 40 | |
| DATFR | Valid from date of an interchangeable part | PIC_DATFR | DATS | 8 | |
| INTTYPE | Replacement Type | PIC_INTTYPE | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ADPIC_HOLD_MPN