1. Home
  2. Resources
  3. SAP Tables
  4. ADPIC_S_MIGO_MATERIAL_LIST - ADCI MPN: List of interchangeable materials in MIGO

SAP Table ADPIC_S_MIGO_MATERIAL_LIST

ADCI MPN: List of interchangeable materials in MIGO

ADPIC_S_MIGO_MATERIAL_LIST (ADCI MPN: List of interchangeable materials in MIGO) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ADPIC_S_MIGO_MATERIAL_LIST to other SAP tables.

Source: ADPIC_S_MIGO_MATERIAL_LIST (ADCI MPN: List of interchangeable materials in MIGO)

ADPIC_S_MIGO_MATERIAL_LIST table fields

Field Data element Checktable Datatype Length Decimals
MIGO_GLOBAL_COUNTER Unique number for one line MIGO_GLOBAL_COUNTER NUMC 6 0
PARENT_ID Link to superordinate line MIGO_PARENT_GLC NUMC 6 0
INT_COUNTER Unique number for one line MIGO_GLOBAL_COUNTER NUMC 6 0
MENGE_IC Quantity MENGE_D QUAN 13 3
MEINS_IC Base Unit of Measure MEINS UNIT 3 0
TAKE_IT_IC Item is Adopted in Document MB_TAKE_IT CHAR 1 0
X Yes
NULL No
IC_TYPE_ICON ADCI MPN: Interchangeability Type Icon ADPIC_D_IC_TYPE CHAR 132 0
MRPSET_LIGHT Carrier field for icons ICON_TEXT CHAR 132 0
MATNR Material Number MATNR CHAR 18 0
MATNR_DESCR Material Description (Short Text) MAKTX CHAR 40 0
PICCAT Interchangeable parts category PIC_PICCAT CHAR 2 0
01 Interchangeability for Supersession
02 Interchangeability for Inventory-Managed MPN
03 IM-MPN Restricted Interchangeability
99 Freely-Defined Interchangeability
98 Manually Defined Interchangeability
PICCAT_DESCR Interchangeability Category Description ADPIC_D_CATEGORY CHAR 40 0
PICCODE Cause of part exchange PIC_PICCODE CHAR 4 0
IMATN FFF class IMATN CHAR 18 0
IMATN_DESCR Material Description (Short Text) MAKTX CHAR 40 0
PICNUM Parts Interchangeability Group Number PIC_PICNUM CHAR 18 0
MRPGR Parts interchangeability MPN-MRP set PIC_MRPGR CHAR 10 0
LMATN Leading Part (A&D 3.0, MPN project) LMATN CHAR 18 0
MFRPN Manufacturer Part Number MFRPN CHAR 40 0
EMNFR External manufacturer code name or number EMNFR CHAR 10 0
WERKS Plant WERKS_D CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
BERID MRP Area BERID CHAR 10 0
CHARG Batch Number CHARG_D CHAR 10 0
ATPMNG ATP Server: ATP quantity ATPMNG QUAN 15 3
MEINS Base Unit of Measure MEINS UNIT 3 0
MRPSET Indicator: MRP set comparison MRPSET NUMC 1 0
1 Same MRP set
2 Alternative MRP set
3 No MRP set maintained
4 MRP set not determinable
5 MRP Set Is Not Unique
6 Locked in MRP Set
PICCODE_DESCR Interchangeability Code Description ICTEXT40 CHAR 40 0
DATFR Valid from date of an interchangeable part PIC_DATFR DATS 8 0
INTTYPE Replacement Type PIC_INTTYPE CHAR 1 0
F Forward
I Interchangeable
ZSMX_DSBRK SMX: Drug Substitution Rank - Order Higher Rank First ZSMX_DSBRK NUMC 6 0
ZFDB_NDC SMX: FDB National Drug Code (NDC) Stored Raw ZFDB_NDC ZFDB_RNDC14 CHAR 11 0
ZSMX_UDBKD SMX: Unit Dose vs. Bulk for Display ZSMX_UDBKD CHAR 1 0
U Unit Dose
B Bulk
ZFDB_PS SMX: FDB Package Size ZFDB_PS CHAR 12 0
ZFDB_OBC SMX: FDB Orange Book Code (2-Char) ZFDB_OBC CHAR 2 0
AA Products with no known bioequivalence problems in convention
AB Products meeting necessary bioequivalence requirements.
AN Solutions and powders for aerosolization that are marketed f
AO Injectable oils with identical active ingredients, concentra
AP Injectable aqueous solutions including dry powders, concentr
AT Topical products therapeutically equivalent in same dosage f
B Products with A or B codes previously assigned; new informat
BC Controlled-release tablets, controlled-release capsules, and
BD Active ingredients and dosage forms with documented bioequiv
BE Enteric coated dosage forms unless proven otherwise to be eq
BN Products in aerosol-nebulizer drug delivery systems that are
BP Active ingredients and dosage forms with potential bioequiva
BR Suppositories or enemas for systemic use unless proven to be
BS Products having drug standard deficiencies.
BT Topical products with bioequivalence problems.
BX Insufficient data to determine therapeutic equivalence.
ZA Particular pharmaceutical entity (GCN) looked at but particu
ZB Particular pharmaceutical entity was not evaluated.
ZC Pharmaceutical entity and labeler evaluated but no therapeut
ZFDB_MFG SMX: FDB Manufacturer Name ZFDB_MFG CHAR 20 0
ZSMX_RPKKZ SMX: Drug is Repackagable ZSMX_RPKKZ CHAR 1 0
X Yes
NULL No
ZSMX_PSBKZ SMX: Previously Substituted Indicator ZSMX_PSBKZ CHAR 1 0
X Yes
NULL No
ZSMX_LAGMG SMX: PO Quantity in Base Unit ZSMX_LAGMG QUAN 13 3
ZSMX_PLIFN SMX: Primary Vendor's Account Number ZSMX_PLIFN CHAR 10 0
ZSMX_PIDNL SMX: Part Number Used by Primary Vendor ZSMX_PIDNL CHAR 22 0
ZSMX_KONNR Agreement Number EVRTN CHAR 10 0
ZSMX_KTPNR Agreement Item EVRTP NUMC 5 0
ZSMX_VRTKZ SMX: On Contract Indicator ZSMX_VRTKZ CHAR 1 0
X Yes
NULL No
ZSMX_CTRTP SMX: Contract Type ZSMX_CTRTP CHAR 4 0
NY New York
PRIM Primary
PREF Preferred
ZSMX_INFNR Number of Purchasing Info Record INFNR CHAR 10 0
ZSMX_PVPOU SMX: Vendor's Unit Price for Order UoM in Document Currency ZSMX_PVPOU CURR 15 2
ZSMX_PVPBU SMX: Vendor's Unit Price for Base UoM in Document Currency ZSMX_PVPBU CURR 11 2
ZSMX_BSTME Purchase Order Unit of Measure BSTME UNIT 3 0
ZSMX_UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
ZSMX_UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
ZSMX_MEINS Base Unit of Measure MEINS UNIT 3 0
ZSMX_WAERS Currency Key WAERS CUKY 5 0
SERID_MPN Link to serial numbers ADPIC_SERID_MPN NUMC 10 0

ADPIC_S_MIGO_MATERIAL_LIST foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ADPIC_S_MIGO_MATERIAL_LIST ZFDB_NDC SYST MANDT ZFDB_RNDC14 SMX: FDB NDC Master Data - Attributes of a Packaged Product MANDT
ADPIC_S_MIGO_MATERIAL_LIST ZFDB_NDC ADPIC_S_MIGO_MATERIAL_LIST ZFDB_NDC ZFDB_RNDC14 SMX: FDB NDC Master Data - Attributes of a Packaged Product NDC