SAP MPES_BOM_MIGRATION_ITEMS Table in S/4 HANA - BOM Migration Item
MPES_BOM_MIGRATION_ITEMS is a standard SAP Table which is used to store BOM Migration Item data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP MPES_BOM_MIGRATION_ITEMS table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: MPES_BOM_MIGRATION_ITEMS
MPES_BOM_MIGRATION_ITEMS table structure field list
Below is the full MPES_BOM_MIGRATION_ITEMS field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
BOM_VERSN | BOM Version | CS_VERSN | CHAR | 4(0) | CS_VERSN | |||||
MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
MATNR | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
STLTY | BOM category | STLTY | CHAR | 1(0) | STLTY | |||||
STLAL | Alternative BOM | STLAL | CHAR | 2(0) | ALPHA | ALTNR | ||||
STLNR | Bill of Material | STNUM | CHAR | 8(0) | NUMCV | STNUM | STLNR | STLNR | ||
STLKN | BOM item node number | STLKN | NUMC | 8(0) | KNTNR | |||||
STPOZ | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
DATUV | Valid-From Date | DATUV | DATS | 8(0) | DATUM | |||||
TECHV | Technical status from | TECHV | CHAR | 12(0) | TECHS | |||||
AENNR | Change Number | AENNR | CHAR | 12(0) | AENR | AENNR | AENNR | AEN | ||
LKENZ | Deletion Indicator | LKENZ | CHAR | 1(0) | XFELD | |||||
VGKNT | Predecessor Node | VGKNT | NUMC | 8(0) | KNTNR | |||||
VGPZL | Previous item counter | VGPZL | NUMC | 8(0) | CIM_COUNT | |||||
ANDAT | Date Record Created On | ANDAT | DATS | 8(0) | DATUM | |||||
ANNAM | User who created record | ANNAM | CHAR | 12(0) | USNAM | |||||
AEDAT | Date of Last Change | AEDAT | DATS | 8(0) | DATUM | |||||
AENAM | Name of person who changed object | AENAM | CHAR | 12(0) | USNAM | |||||
IDNRK | BOM component | IDNRK | CHAR | 40(0) | MATN1 | MATNR | ||||
PSWRK | Issuing Plant | PSWRK | CHAR | 4(0) | T001W | WERKS | ||||
POSTP | Item category (bill of material) | POSTP | CHAR | 1(0) | T418 | POSTP | ||||
POSNR | BOM Item Number | SPOSN | CHAR | 4(0) | NUMCV | SPOSN | ||||
SORTF | Sort String | SORTP | CHAR | 10(0) | CHAR10 | |||||
MEINS | Component Unit of Measure | KMPME | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
MENGE | Component Quantity | KMPMG | QUAN | 13(3) | MENGV13 | |||||
FMENG | Fixed qty | FMNGE | CHAR | 1(0) | XFELD | |||||
AUSCH | Component Scrap in Percent | KAUSF | DEC | 5(2) | DEC3_2 | |||||
AVOAU | Operation Scrap | AVOAU | DEC | 5(2) | DEC3_2 | |||||
NETAU | Net Scrap Indicator | NETAU | CHAR | 1(0) | XFELD | |||||
SCHGT | Indicator: bulk material | SCHGT | CHAR | 1(0) | XFELD | |||||
BEIKZ | Material Provision Indicator | BEIKZ | CHAR | 1(0) | T417 | BEIKZ | ||||
ERSKZ | Indicator: Spare Part | ERSKZ | CHAR | 1(0) | T413 | ERSKZ | ||||
RVREL | Indicator: item relevant to sales | RVREL | CHAR | 1(0) | TVRL | RVREL | ||||
SANFE | Indicator: item relevant to production | SANFE | CHAR | 1(0) | XFELD | |||||
SANIN | Indicator: item relevant to plant maintenance | SANIN | CHAR | 1(0) | XFELD | |||||
SANKA | Indicator for relevancy to costing | CS_SANKA | CHAR | 1(0) | TCK08 | CK_SELKZ | ||||
SANKO | Indicator: item relevant to engineering | SANKO | CHAR | 1(0) | XFELD | |||||
SANVS | Indicator: high-level configuration | SANVS | CHAR | 1(0) | XFELD | |||||
STKKZ | PM assembly indicator | STKKZ | CHAR | 1(0) | XFELD | |||||
REKRI | Indicator: BOM is recursive | REKRI | CHAR | 1(0) | XFELD | |||||
REKRS | Indicator: recursiveness allowed | REKRS | CHAR | 1(0) | XFELD | |||||
CADPO | CAD Indicator | CADPO | CHAR | 1(0) | XFELD | |||||
NFMAT | Follow-up material in BOM item - NOT IN USE | CS_NFMAT | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | ||
NLFZT | Lead-time offset | NLFZT | DEC | 3(0) | NLFZT | |||||
VERTI | Distribution key for component consumption | SA_VERTI | CHAR | 4(0) | T437V | SA_VERTL | ||||
ALPOS | Indicator: alternative item | ALPOS | CHAR | 1(0) | XFELD | |||||
EWAHR | Usage Probability in % (Alternative Item) | EWAHR | DEC | 3(0) | DEC3 | |||||
EKGRP | Purchasing Group | EKGRP | CHAR | 3(0) | T024 | EKGRP | EKG | |||
LIFZT | Delivery time in days | LIFZT | DEC | 3(0) | DEC3 | |||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | LFA1 | ALPHA | LIFNR | LIF | KRED_C | LIFNR |
PREIS | Price | CPREI | CURR | 11(2) | WERT11 | |||||
PEINH | Price unit | PEINH | DEC | 5(0) | PACK3 | |||||
WAERS | Currency Key | WAERS | CUKY | 5(0) | TCURC | WAERS | FWS | |||
SAKTO | Cost element | SAKTO | CHAR | 10(0) | ALPHA | SAKNR | ||||
ROANZ | Number of variable-size items | ROANZ | QUAN | 13(3) | MENG13 | |||||
ROMS1 | Size 1 | ROMS1 | QUAN | 13(3) | MENG13 | |||||
ROMS2 | Size 2 | ROMS2 | QUAN | 13(3) | MENG13 | |||||
ROMS3 | Size 3 | ROMS3 | QUAN | 13(3) | MENG13 | |||||
ROMEI | Unit of measure for sizes 1 to 3 | ROMEI | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
ROMEN | Quantity of variable-size item | ROMEN | QUAN | 13(3) | MENG13 | |||||
RFORM | Formula Key for Variable-Size Items | RFORM | CHAR | 2(0) | T418F | RFORM | ||||
UPSKZ | Indicator: sub-items exist | UPSKZ | CHAR | 1(0) | XFELD | |||||
VALKZ | Indicator: item in more than one alternative | VALKZ | CHAR | 1(0) | XFELD | |||||
LTXSP | Long Text Language, for Creation of a Change Document | LTXSP_CP | LANG | 1(0) | T002 | ISOLA | SPRAS | |||
POTX1 | BOM Item Text (Line 1) | POTX1 | CHAR | 40(0) | TEXT40 | |||||
POTX2 | BOM Item Text (Line 2) | POTX2 | CHAR | 40(0) | TEXT40 | |||||
OBJTY | Object type (BOM item) | OBJTY | CHAR | 1(0) | OBJTY | |||||
MATKL | Material Group | MATKL | CHAR | 9(0) | T023 | MATKL | MKL | S_WBWG | MATKL | |
WEBAZ | Goods receipt processing time in days | WEBAZ | DEC | 3(0) | DEC3 | |||||
DOKAR | Document Type | DOKAR | CHAR | 3(0) | TDWA | DOKAR | CV2 | |||
DOKNR | Document number | DOKNR | CHAR | 25(0) | ALPHA | DOKNR | CV1 | |||
DOKVR | Document version | DOKVR | CHAR | 2(0) | DOKVR | CV3 | ||||
DOKTL | Document part | DOKTL_D | CHAR | 3(0) | DOKTL | CV4 | ||||
CSSTR | Average material purity in % | CSSTR | DEC | 5(2) | DEC3_2 | |||||
CLASS | Class number | KLASSE_D | CHAR | 18(0) | KLASSE | KLA | ||||
KLART | Class Type | KLASSENART | CHAR | 3(0) | TCLA | KLASSENART | KAR | |||
POTPR | Resulting item category | POTPR | CHAR | 1(0) | T418 | POSTP | ||||
AWAKZ | Selection indicator for configurable BOMs | AWAKZ | CHAR | 1(0) | AWAKZ | |||||
INSKZ | Instance indicator | INSKZ | CHAR | 1(0) | X | |||||
VCEKZ | Indicator: not displayed in configuration editor | VCEKZ | CHAR | 1(0) | X | |||||
VSTKZ | Indicator: not displayed in single-level configuration | VSTKZ | CHAR | 1(0) | X | |||||
VACKZ | Indicator: not displayed in automatic configuration | VACKZ | CHAR | 1(0) | X | |||||
EKORG | Purchasing organization | EKORG | CHAR | 4(0) | T024E | EKORG | EKO | |||
CLOBK | Required Component | CLOBK | CHAR | 1(0) | XFELD | |||||
CLMUL | Multiple Selection Allowed | CLMULT | CHAR | 1(0) | XFELD | |||||
CLALT | Alternative Display Format | CLALT | CHAR | 1(0) | XFELD | |||||
CVIEW | Organizational Area | ABTEILUNG | CHAR | 10(0) | CHAR10 | VIEW | ||||
KNOBJ | Number of Object with Assigned Dependencies | KNOBJ | NUMC | 18(0) | KNOBJ | |||||
LGORT | Issue Location for Production Order | CSLGO | CHAR | 4(0) | T001L | LGORT | LAG | |||
KZKUP | Indicator: co-product | KZKUP | CHAR | 1(0) | XFELD | |||||
INTRM | Intra Material | INTRM | CHAR | 40(0) | MATN1 | MATNR | ||||
TPEKZ | Indicator: restrictions exist | TPEKZ | CHAR | 1(0) | XFELD | |||||
STVKN | Inherited node number of BOM item | STVKN | NUMC | 8(0) | KNTNR | |||||
DVDAT | Date of last date shift | DVDAT | DATS | 8(0) | DATUM | |||||
DVNAM | Name of the user who carried out the date shift | DVNAM | CHAR | 12(0) | USNAM | |||||
DSPST | Explosion type | CS_DISPO | CHAR | 2(0) | T414 | CS_DISPO | ||||
ALPST | Alternative item: strategy | CS_ALPST | CHAR | 1(0) | CS_ALPST | |||||
ALPRF | Alternative item: ranking order | CS_ALPRF | NUMC | 2(0) | NUM2 | |||||
ALPGR | Alternative item: group | CS_ALPGR | CHAR | 2(0) | CHAR2 | |||||
KZNFP | Indicator: Follow-Up Item | CS_KZNFP | CHAR | 1(0) | XFELD | |||||
NFGRP | Follow-up group | CS_NFGRP | CHAR | 2(0) | CHAR2 | |||||
NFEAG | Discontinuation group | CS_NFEAG | CHAR | 2(0) | CHAR2 | |||||
KNDVB | Indicator: manual change to sales order BOM | CS_KNDVB | CHAR | 1(0) | CHAR1 | |||||
KNDBZ | Indicator: BOM item changed/selected via obj. dependencies | CS_KNDBZ | CHAR | 1(0) | CHAR1 | |||||
KSTTY | BOM category of original sales order BOM item | CS_KSTTY | CHAR | 1(0) | STLTY | |||||
KSTNR | Bill of material for original sales order BOM item | CS_KSTNR | CHAR | 8(0) | NUMCV | STNUM | ||||
KSTKN | Node number of original sales order BOM item | CS_KSTKN | NUMC | 8(0) | KNTNR | |||||
KSTPZ | Counter for original sales order BOM item | CS_KSTPZ | NUMC | 8(0) | CIM_COUNT | |||||
CLSZU | Classification number | CS_CLSZU | NUMC | 8(0) | NUM8 | |||||
KZCLB | Indicator: classification as selection condition | CS_KZCLB | CHAR | 1(0) | XFELD | |||||
AEHLP | Date Shift Hierarchy Indicator | CC_AEHLP | NUMC | 2(0) | CC_AEHLP | |||||
PRVBE | Production Supply Area | PRVBE | CHAR | 10(0) | PVBE | PRVBE | PVB | |||
NLFZV | Lead-time offset for operation | CS_NLFZV | DEC | 3(0) | NLFZT | |||||
NLFMV | Unit for lead-time offset for operation | CS_NLFMV | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
IDPOS | Item group | CS_IDPOS | CHAR | 20(0) | CS_IDPOS | |||||
IDHIS | History counter | CS_IDHIS | NUMC | 5(0) | NUMC5 | |||||
IDVAR | Component Variant | CS_IDVAR | CHAR | 5(0) | CS_IDVAR | |||||
ALEKZ | ALE indicator | CS_ALEKZ | CHAR | 1(0) | XFELD | |||||
ITMID | External identification of an item | CS_ITMID | CHAR | 8(0) | CHAR8 | |||||
GUID | Temporarily not used | CS_CHAR22 | CHAR | 22(0) | SYCHAR22 | |||||
ITSOB | Special Procurement Type for BOM Item | CS_SOBSL | CHAR | 2(0) | SOBSL | |||||
RFPNT | Reference point for BOM transfer | CN_RFPNT | CHAR | 20(0) | TCNRFP | CN_RFPNT | ||||
GUIDX | Global identification of an item's change status | CS_GUID | RAW | 16(0) | SYSUUID | |||||
SGT_CMKZ | Segmentation Maintained for BOM Components | SGT_CMKZ | CHAR | 1(0) | CHAR1 | |||||
SGT_CATV | Segmentation Value | SGT_CATV | CHAR | 40(0) | SGT_SRCA | |||||
VALID_TO | Valid-to date | DATUB | DATS | 8(0) | DATUM | |||||
VALID_TO_RKEY | Valid-to date | DATUB | DATS | 8(0) | DATUM | |||||
ECN_TO | Change Number To | AENRA | CHAR | 12(0) | AENNR | AENNR | ||||
ECN_TO_RKEY | Change Number To | AENRA | CHAR | 12(0) | AENNR | AENNR | ||||
STVKN_VERSN | Inherited node number of BOM item | STVKN | NUMC | 8(0) | KNTNR | |||||
SFWIND | Indicator: Software component | CS_SFWIND | CHAR | 1(0) | XFELD | |||||
DUMMY_STPO_INCL_EEW_PS | Data Element for Extensibility of Maintain BOM Item | STPO_INCL_EEW | CHAR | 1(0) | STPO_INCL_EEW | |||||
CUFACTOR | CU: Number of CU Instances | /CUM/CUFACTOR | NUMC | 6(0) | /CUM/CUFACTOR | |||||
/SAPMP/MET_LRCH | Length Calculation Method | /SAPMP/MET_LRCH | CHAR | 2(0) | /SAPMP/MET_LRCH | |||||
/SAPMP/MAX_FERTL | Maximum Production Length | /SAPMP/MAX_FERTL | QUAN | 13(3) | /SAPMP/MAX_FERTL | |||||
/SAPMP/FIX_AS_J | Fixed Scrap - Any Length | /SAPMP/FIX_AS_J | QUAN | 13(3) | /SAPMP/FIX_AS_J | |||||
/SAPMP/FIX_AS_E | Fixed Scrap - First Length | /SAPMP/FIX_AS_E | QUAN | 13(3) | /SAPMP/FIX_AS_E | |||||
/SAPMP/FIX_AS_L | Fixed Scrap - Last Length | /SAPMP/FIX_AS_L | QUAN | 13(3) | /SAPMP/FIX_AS_L | |||||
/SAPMP/ABL_ZAHL | Number of Run-In Lengths | /SAPMP/ABL_ZAHL | NUMC | 6(0) | NUMC6 | |||||
/SAPMP/RUND_FAKT | Rounding Value | /SAPMP/RUND_FAKT | QUAN | 13(3) | /SAPMP/RUND_FAKT | |||||
FSH_VMKZ | Deviation Values Maintained for Component at Variant Level | FSH_VMKZ | CHAR | 1(0) | CHAR1 | |||||
FSH_PGQR | Quantity Distribution Profile | FSH_QD_PROFILE | CHAR | 18(0) | FSH_QD_PROFILE | FSH_SH_QDP | FSH_QD_PROFILE | |||
FSH_PGQRRF | Reference to Quantity Distribution Profile | FSH_PGQRRF | CHAR | 1(0) | CHAR1 | |||||
FSH_CRITICAL_COMP | Critical Component Indicator | FSH_CRITICAL_COMP | CHAR | 1(0) | FSH_CRITICAL_COMP | |||||
FSH_CRITICAL_LEVEL | Crtical Level of a Component in BoM | FSH_CRITICAL_LEVEL | DEC | 2(0) | FSH_CRITICAL_LEVEL | |||||
FUNCID | Function Identifier | CCC_FUNCID | CHAR | 40(0) | CHAR40 |
Search for further information about these or an SAP related objects