SAP MGEINE Table in S/4 HANA - EINE Extended to Include Full Key for Material Master Maint.
MGEINE is a standard SAP Table which is used to store EINE Extended to Include Full Key for Material Master Maint. data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MGEINE table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Structure
Database Table: MGEINE
MGEINE table structure field list
Below is the full MGEINE 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 |
MATNR | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
EKORG_MG | Purchasing organization | EKORG | CHAR | 4(0) | Assigned to domain | EKORG | EKO | |||
WERKS_MG | Plant | EWERK | CHAR | 4(0) | Assigned to domain | WERKS | WRK | |||
MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
INFNR | Number of purchasing info record | INFNR | CHAR | 10(0) | EINA | ALPHA | INFNR | INF | MEIN_C | INFNR |
EKORG | Purchasing organization | EKORG | CHAR | 4(0) | T024E | EKORG | EKO | |||
ESOKZ | Purchasing info record category | ESOKZ | CHAR | 1(0) | ESOKZ | ESO | ||||
WERKS | Plant | EWERK | CHAR | 4(0) | T001W | WERKS | WRK | |||
LOEKZ | Purch. info: Purch. organization data flagged for deletion | ILOEE | CHAR | 1(0) | XFELD | |||||
ERDAT | Date on which the record was created | ERDAT | DATS | 8(0) | DATUM | |||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12(0) | USNAM | |||||
EKGRP | Purchasing Group | BKGRP | CHAR | 3(0) | T024 | EKGRP | EKG | |||
WAERS | Currency Key | WAERS | CUKY | 5(0) | TCURC | WAERS | FWS | |||
BONUS | Indicator: Volume-Based Rebate | WRBON | CHAR | 1(0) | XFELD | |||||
MGBON | Indicator: Quantity-Based Volume Rebate | MGBON | CHAR | 1(0) | XFELD | |||||
MINBM | Minimum Purchase Order Quantity | MINBM | QUAN | 13(3) | MENG13 | |||||
NORBM | Standard Purchase Order Quantity | NORBM | QUAN | 13(3) | MENG13 | |||||
APLFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3(0) | DEC3 | |||||
UEBTO | Overdelivery Tolerance | UEBTO | DEC | 3(1) | PRZ21 | |||||
UEBTK | Indicator: Unlimited Overdelivery Allowed | UEBTK | CHAR | 1(0) | XFELD | |||||
UNTTO | Underdelivery Tolerance | UNTTO | DEC | 3(1) | PRZ21 | |||||
ANGNR | Quotation Number | ANGNR | CHAR | 10(0) | ANGNR | |||||
ANGDT | Quotation Validity Date | ANGDT | DATS | 8(0) | DATUM | |||||
ANFNR | RFQ Number | ANFNR | CHAR | 10(0) | EKKO | ALPHA | EBELN | ANF | ||
ANFPS | Item Number of RFQ | ANFPS | NUMC | 5(0) | EKPO | EBELP | ||||
ABSKZ | Rejection Indicator | ABSKZ | CHAR | 1(0) | XFELD | |||||
AMODV | Amortization period from | AMODV | DATS | 8(0) | DATUM | |||||
AMODB | Amortization period to | AMODB | DATS | 8(0) | DATUM | |||||
AMOBM | Amortized planned quantity | AMOBM | QUAN | 15(3) | MENG15 | |||||
AMOBW | Amortized planned value | AMOBW | CURR | 15(2) | WERT15 | |||||
AMOAM | Amortized actual quantity | AMOAM | QUAN | 15(3) | MENG15 | |||||
AMOAW | Amortized actual value | AMOAW | CURR | 15(2) | WERT15 | |||||
AMORS | Indicator: Amortization reset | AMORS | CHAR | 1(0) | XFELD | |||||
BSTYP | Purchasing Document Category | BSTYP | CHAR | 1(0) | BSTYP | |||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10(0) | EKKO | ALPHA | EBELN | BES | MEKK_C | EBELN |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5(0) | EKPO | EBELP | BSP | |||
DATLB | Date of Last PO or Sched. Agreement Document in Info Record | DATLB | DATS | 8(0) | DATUM | |||||
NETPR | Net Price in Purchasing Info Record | IPREI | CURR | 11(2) | WERT11 | |||||
PEINH | Price unit | EPEIN | DEC | 5(0) | DEC5 | |||||
BPRME | Order Price Unit (Purchasing) | BBPRM | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
PRDAT | Price Valid Until | PRGBI | DATS | 8(0) | DATUM | |||||
BPUMZ | Numerator for Conversion of Order Price Unit into Order Unit | BPUMZ | DEC | 5(0) | UMBSZ | |||||
BPUMN | Denominator for Conv. of Order Price Unit into Order Unit | BPUMN | DEC | 5(0) | UMBSN | |||||
MTXNO | Material Master Record PO Text Not Relevant | MTXNO | CHAR | 1(0) | XFELD | |||||
WEBRE | Indicator: GR-Based Invoice Verification | WEBRE | CHAR | 1(0) | XFELD | |||||
EFFPR | Effective Price in Purchasing Info Record | EFFPR | CURR | 11(2) | WERT11 | |||||
EKKOL | Condition Group with Supplier | EKKOG | CHAR | 4(0) | CHAR4 | |||||
SKTOF | Item Does Not Qualify for Cash Discount | ESKTOF | CHAR | 1(0) | XFELD | |||||
KZABS | Order Acknowledgment Requirement | KZABS | CHAR | 1(0) | XFELD | |||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2(0) | T007A | MWSKZ | ||||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10(0) | T149D | BWTAR | BWT | |||
EBONU | Settlement Group 1 (Purchasing) | EBONU | CHAR | 2(0) | EBONU | |||||
EVERS | Shipping Instructions | EVERS | CHAR | 2(0) | T027A | EVERS | ||||
EXPRF | Procedure | EXPRF | CHAR | 8(0) | T616 | EXPRF | ||||
BSTAE | Confirmation Control Key | BSTAE | CHAR | 4(0) | T163L | BSTAE | ||||
MEPRF | Price Determination (Pricing) Date Control | MEPRF | CHAR | 1(0) | MEPRF | |||||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3(0) | TINC | INCO1 | ||||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28(0) | INCO2 | |||||
XERSN | No Evaluated Receipt Settlement (ERS) | XERSN | CHAR | 1(0) | XFELD | |||||
EBON2 | Settlement Group 2 (Rebate Settlement, Purchasing) | EBON2 | CHAR | 2(0) | EBONU | |||||
EBON3 | Settlement Group 3 (Rebate Settlement, Purchasing) | EBON3 | CHAR | 2(0) | EBONU | |||||
EBONF | Item Not Relevant to Subseq. (Period-End Rebate) Settlement | EBONF | CHAR | 1(0) | XFELD | |||||
MHDRZ | Minimum Remaining Shelf Life | MHDRZ | DEC | 4(0) | DEC4 | |||||
VERID | Production Version | VERID | CHAR | 4(0) | MKAL | VERID | VER | |||
BSTMA | Maximum Purchase Order Quantity | MAXBM | QUAN | 13(3) | MENG13 | |||||
RDPRF | Rounding Profile | RDPRF | CHAR | 4(0) | RDPR | RDPRF | ||||
MEGRU | Unit of Measure Group | MEGRU | CHAR | 4(0) | TWMEG | MEGRU | ||||
J_1BNBM | Brazilian NCM Code | J_1BNBMCO1 | CHAR | 16(0) | T604F | STEUC | ||||
SPE_CRE_REF_DOC | Create Purchase Order for Delivery Without Reference | /SPE/CRE_REF_DOC | CHAR | 1(0) | XFELD | |||||
IPRKZ | Period Indicator for Shelf Life Expiration Date | DATTP | CHAR | 1(0) | PERKZ | DATTP | H_PERDKZ | EPRKZ | ||
CO_ORDER | Real-Time Consumption Posting of Subcontracting Components | ME_IR_CO_ORDER | CHAR | 1(0) | XFELD | |||||
VENDOR_RMA_REQ | Supplier RMA Number Required | MSR_VRMA_REQ_EINE | CHAR | 1(0) | MSR_VRMA_REQ_EINE | |||||
DIFF_INVOICE | Differential Invoicing | DIFF_INVOICE | CHAR | 2(0) | DIFF_INVOICE | |||||
INCOV | Incoterms Version | INCOV | CHAR | 4(0) | TINCV | INCOV | ||||
INCO2_L | Incoterms Location 1 | INCO2_L | CHAR | 70(0) | INCO_L | |||||
INCO3_L | Incoterms Location 2 | INCO3_L | CHAR | 70(0) | INCO_L | |||||
AUT_SOURCE | Relevant for Automatic Sourcing | AUT_SOURCE | CHAR | 1(0) | AUT_SOURCE | |||||
DUMMY_EINE_INCL_EEW_PS | EINE_INCL_EEW | EINE_INCL_EEW | CHAR | 1(0) | EINE_INCL_EEW | |||||
ISEOPBLOCKED | Business Purpose Completed | EOPBLOCKED | CHAR | 1(0) | EOPBLOCKED | |||||
.INCLU--AP | 0(0) | |||||||||
FSH_DCI_CORR | Delivery Completion Indicator Correlation | FSH_DCI_CORRELATION | CHAR | 1(0) | XFELD | |||||
.INCLU--AP | 0(0) | |||||||||
FSH_RLT | Replenishment Lead Time for Raw Material | FSH_PDT_RLT | DEC | 3(0) | DEC3 | |||||
FSH_MLT | Manufacturing Lead Time | FSH_PDT_MLT | DEC | 3(0) | DEC3 | |||||
FSH_PLT | Packing Lead time | FSH_PDT_PLT | DEC | 3(0) | DEC3 | |||||
FSH_TLT | Transportation Lead Time | FSH_PDT_TLT | DEC | 3(0) | DEC3 | |||||
.INCLU--AP | 0(0) | |||||||||
MRPIND | Max. Retail Price Relevant | J_1IRMRPIND | CHAR | 1(0) | J_1IRMRPIND | |||||
.INCLU--AP | 0(0) | |||||||||
SGT_SSREL | Stock Segment Relevant Indicator | SGT_SSREL | CHAR | 1(0) | SGT_YNSI | |||||
.INCLU--AP | 0(0) | |||||||||
TRANSPORT_CHAIN | Transportation Chain | WRF_PSCD_TC_ID | CHAR | 10(0) | WRF_PSCD_TCHAINH | WRF_PSCD_TC_ID | ||||
STAGING_TIME | Staging Time in Days | WRF_PSCD_MST | DEC | 3(0) | WRF_PSCD_MST | |||||
BUNGN | Indicator: Gross price not equal to net price | BUNGN | CHAR | 1(0) | XFELD | |||||
NOPRS | No Price Entry Allowed for Supplier | NOPRS | CHAR | 1(0) | XFELD |
Search for further information about these or an SAP related objects