ADPIC_HOLD_MPN SAP (Store MPN subitems for MIGO hold / restore functionality) Table details

Dictionary Type: Table
Description: Store MPN subitems for MIGO hold / restore functionality




ABAP Code to SELECT data from ADPIC_HOLD_MPN
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 empty
Display/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
GUIDGUID in 'CHAR' format with upper-/lowercase (!) GUID_22CHAR22SYSUUID_22
LINE_IDUnique identification of document line MB_LINE_IDNUMC6MB_LINE_ID
POS_IDRow Index of Internal Tables SYTABIXINT410SYST_LONG
MIGO_GLCUnique number for one line MIGO_GLOBAL_COUNTERNUMC6NUMC6
PARENT_IDLink to superordinate line MIGO_PARENT_GLCNUMC6NUMC6
INT_COUNTERUnique number for one line MIGO_GLOBAL_COUNTERNUMC6NUMC6
MENGE_ICQuantity MENGE_DQUAN13(3) MENG13
MEINS_ICBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
TAKE_IT_ICItem is Adopted in Document MB_TAKE_ITCHAR1XFELD
IC_TYPE_ICONADCI MPN: Interchangeability Type Icon ADPIC_D_IC_TYPECHAR132CHAR132
MRPSET_LIGHTCarrier field for icons ICON_TEXTCHAR132SYCHAR132
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MATNR_DESCRMaterial Description (Short Text) MAKTXCHAR40TEXT40
PICCATInterchangeable parts category PIC_PICCATCHAR2PIC_PICCAT
PICCAT_DESCRInterchangeability Category Description ADPIC_D_CATEGORYCHAR40ADPIC_DOM_CATEGORY
PICCODECause of part exchange PIC_PICCODECHAR4Assigned to domainPIC_PICCODE
IMATNFFF class IMATNCHAR18Assigned to domainMATN1MATNR
IMATN_DESCRMaterial Description (Short Text) MAKTXCHAR40TEXT40
PICNUMParts Interchangeability Group Number PIC_PICNUMCHAR18ALPHAPIC_PICNUMPIC_PICNUM
MRPGRParts interchangeability MPN-MRP set PIC_MRPGRCHAR10PIC_MRPGR
LMATNLeading Part (A&D 3.0, MPN project) LMATNCHAR18Assigned to domainMATN1MATNR
MFRPNManufacturer Part Number MFRPNCHAR40CHAR40
EMNFRExternal manufacturer code name or number EMNFRCHAR10CHAR10
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
BERIDMRP Area BERIDCHAR10Assigned to domainBERIDBERID
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
ATPMNGATP Server: ATP quantity ATPMNGQUAN15(3) MENGV15
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
MRPSETIndicator: MRP set comparison MRPSETNUMC1MRPSET
PICCODE_DESCRInterchangeability Code Description ICTEXT40CHAR40TEXT40
DATFRValid from date of an interchangeable part PIC_DATFRDATS8DATUM
INTTYPEReplacement Type PIC_INTTYPECHAR1PIC_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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!