SAP table MGEINE (EINE Extended to Include Full Key for Material Master Maint.)

Field Description Data Type Length Decimals Checktable Data Element
MATNR Material Number CHAR 40 0 MATNR
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
EKORG_MG Purchasing organization CHAR 4 0 * EKORG
WERKS_MG Plant CHAR 4 0 * EWERK
MANDT Client CLNT 3 0 T000 MANDT
INFNR Number of purchasing info record CHAR 10 0 EINA INFNR
EKORG Purchasing organization CHAR 4 0 T024E EKORG
ESOKZ Purchasing info record category CHAR 1 0 ESOKZ
0 Standard
1 Chargeable
2 Consignment
3 Subcontracting
P Pipeline
WERKS Plant CHAR 4 0 T001W EWERK
LOEKZ Purch. info: Purch. organization data flagged for deletion CHAR 1 0 ILOEE
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
EKGRP Purchasing Group CHAR 3 0 T024 BKGRP
WAERS Currency Key CUKY 5 0 TCURC WAERS
BONUS Indicator: Volume-Based Rebate CHAR 1 0 WRBON
MGBON Indicator: Quantity-Based Volume Rebate CHAR 1 0 MGBON
MINBM Minimum Purchase Order Quantity QUAN 13 3 MINBM
NORBM Standard Purchase Order Quantity QUAN 13 3 NORBM
APLFZ Planned Delivery Time in Days DEC 3 0 PLIFZ
UEBTO Overdelivery Tolerance DEC 3 1 UEBTO
UEBTK Unlimited Overdelivery Allowed CHAR 1 0 UEBTK
UNTTO Underdelivery Tolerance DEC 3 1 UNTTO
ANGNR Quotation Number CHAR 10 0 ANGNR
ANGDT Quotation Validity Date DATS 8 0 ANGDT
ANFNR RFQ Number CHAR 10 0 EKKO ANFNR
ANFPS Item Number of RFQ NUMC 5 0 EKPO ANFPS
ABSKZ Rejection Indicator CHAR 1 0 ABSKZ
AMODV Amortization period from DATS 8 0 AMODV
AMODB Amortization period to DATS 8 0 AMODB
AMOBM Amortized planned quantity QUAN 15 3 AMOBM
AMOBW Amortized planned value CURR 15 2 AMOBW
AMOAM Amortized actual quantity QUAN 15 3 AMOAM
AMOAW Amortized actual value CURR 15 2 AMOAW
AMORS Indicator: Amortization reset CHAR 1 0 AMORS
BSTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
DATLB Date of Last PO or Sched. Agreement Document in Info Record DATS 8 0 DATLB
NETPR Net Price in Purchasing Info Record CURR 11 2 IPREI
PEINH Price unit DEC 5 0 EPEIN
BPRME Order Price Unit (Purchasing) UNIT 3 0 T006 BBPRM
PRDAT Price Valid Until DATS 8 0 PRGBI
BPUMZ Numerator for Conversion of Order Price Unit into Order Unit DEC 5 0 BPUMZ
BPUMN Denominator for Conv. of Order Price Unit into Order Unit DEC 5 0 BPUMN
MTXNO Material Master Record PO Text Not Relevant CHAR 1 0 MTXNO
WEBRE Indicator: GR-Based Invoice Verification CHAR 1 0 WEBRE
EFFPR Effective Price in Purchasing Info Record CURR 11 2 EFFPR
EKKOL Condition Group with Supplier CHAR 4 0 EKKOG
SKTOF Item Does Not Qualify for Cash Discount CHAR 1 0 ESKTOF
KZABS Order Acknowledgment Requirement CHAR 1 0 KZABS
MWSKZ Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
TXDAT_FROM Valid-From Date of the Tax Rate DATS 8 0 FOT_TXDAT_FROM
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 T005 FOT_TAX_COUNTRY
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
EBONU Settlement Group 1 (Purchasing) CHAR 2 0 EBONU
EVERS Shipping Instructions CHAR 2 0 T027A EVERS
EXPRF Procedure CHAR 8 0 T616 EXPRF
BSTAE Confirmation Control Key CHAR 4 0 T163L BSTAE
MEPRF Price Determination (Pricing) Date Control CHAR 1 0 MEPRF
No Control
1 Purchase Order Date
2 Delivery Date
3 Current Date
4 Manual
5 GR/Post. Date
6 GR/Doc. Date
INCO1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
XERSN No Evaluated Receipt Settlement (ERS) CHAR 1 0 XERSN
EBON2 Settlement Group 2 (Rebate Settlement, Purchasing) CHAR 2 0 EBON2
EBON3 Settlement Group 3 (Rebate Settlement, Purchasing) CHAR 2 0 EBON3
EBONF Item Not Relevant to Subseq. (Period-End Rebate) Settlement CHAR 1 0 EBONF
MHDRZ Minimum Remaining Shelf Life DEC 4 0 MHDRZ
VERID Production Version CHAR 4 0 MKAL VERID
BSTMA Maximum Purchase Order Quantity QUAN 13 3 MAXBM
RDPRF Rounding Profile CHAR 4 0 RDPR RDPRF
MEGRU Unit of Measure Group CHAR 4 0 TWMEG MEGRU
J_1BNBM Brazilian NCM Code CHAR 16 0 T604F J_1BNBMCO1
SPE_CRE_REF_DOC Create Purchase Order for Delivery Without Reference CHAR 1 0 /SPE/CRE_REF_DOC
IPRKZ Period Indicator for Shelf Life Expiration Date CHAR 1 0 DATTP
Day
1 Week
2 Month
3 Year
CO_ORDER Real-Time Consumption Posting of Subcontracting Components CHAR 1 0 ME_IR_CO_ORDER
VENDOR_RMA_REQ Supplier RMA Number Required CHAR 1 0 MSR_VRMA_REQ_EINE
Supplier RMA Not Required
V Information from Supplier Master Record
X Supplier RMA Required
DIFF_INVOICE Differential Invoicing CHAR 2 0 DIFF_INVOICE
01 Not Relevant
02 Relevant
INCOV Incoterms Version CHAR 4 0 TINCV INCOV
INCO2_L Incoterms Location 1 CHAR 70 0 INCO2_L
INCO3_L Incoterms Location 2 CHAR 70 0 INCO3_L
AUT_SOURCE Relevant for Automatic Sourcing CHAR 1 0 AUT_SOURCE
Not Relevant for Automatic Sourcing
X Relevant for Automatic Sourcing
DUMMY_EINE_INCL_EEW_PS EINE_INCL_EEW CHAR 1 0 EINE_INCL_EEW
ISEOPBLOCKED Business Purpose Completed CHAR 1 0 EOPBLOCKED
Ongoing Business, Active Purpose
X Business Purpose Completed, End of Purpose Reached
FSH_DCI_CORR Delivery Completion Indicator Correlation CHAR 1 0 FSH_DCI_CORRELATION
FSH_RLT Replenishment Lead Time for Raw Material DEC 3 0 FSH_PDT_RLT
FSH_MLT Manufacturing Lead Time DEC 3 0 FSH_PDT_MLT
FSH_PLT Packing Lead time DEC 3 0 FSH_PDT_PLT
FSH_TLT Transportation Lead Time DEC 3 0 FSH_PDT_TLT
MRPIND Max. Retail Price Relevant CHAR 1 0 J_1IRMRPIND
Non Maximum Retail Price relevant.
X Maximum Retail Price relevant.
SGT_SSREL Stock Segment Relevant Indicator CHAR 1 0 SGT_SSREL
TRANSPORT_CHAIN Transportation Chain CHAR 10 0 WRF_PSCD_TCHAINH WRF_PSCD_TC_ID
STAGING_TIME Staging Time in Days DEC 3 0 WRF_PSCD_MST
BUNGN Indicator: Gross price not equal to net price CHAR 1 0 BUNGN
NOPRS No Price Entry Allowed for Supplier CHAR 1 0 NOPRS

MGEINE foreign key relationships

Table Field Check Table Check Field
0 MGEINE ANFNR EKKO Purchasing Document Header MANDT
0 MGEINE ANFNR EKKO Purchasing Document Header EBELN
1 MGEINE ANFPS EKPO Purchasing Document Item MANDT
1 MGEINE ANFPS EKPO Purchasing Document Item EBELN
0 MGEINE BPRME T006 Units of Measurement MANDT
1 MGEINE BSTAE T163L Confirmation Control Keys BSTAE
0 MGEINE BWTAR T149D Global Valuation Types MANDT
0 MGEINE BWTAR T149D Global Valuation Types BWTAR
1 MGEINE EBELN EKKO Purchasing Document Header EBELN
0 MGEINE EBELP EKPO Purchasing Document Item MANDT
0 MGEINE EBELP EKPO Purchasing Document Item EBELN
1 MGEINE EKGRP T024 Purchasing Groups EKGRP
0 MGEINE EKORG T024E Purchasing Organizations EKORG
1 MGEINE EVERS T027A Shipping Instructions, Purchasing EVERS
0 MGEINE EXPRF T616 Procedure LAND1
1 MGEINE INCO1 TINC Customers: Incoterms INCO1
0 MGEINE INCOV TINCV Incoterms Versions MANDT
0 MGEINE INCOV TINCV Incoterms Versions INCOV
1 MGEINE INFNR EINA Purchasing Info Record: General Data INFNR
0 MGEINE J_1BNBM T604F Import Processing: Control Code MANDT
0 MGEINE J_1BNBM T604F Import Processing: Control Code LAND1
1 MGEINE MANDT T000 Clients MANDT
0 MGEINE MEGRU TWMEG Unit of measure group MANDT
0 MGEINE MEGRU TWMEG Unit of measure group MEGRU
0 MGEINE MEGRU TWMEG Unit of measure group MEINS
1 MGEINE MWSKZ T007A Tax Keys KALSM
1 MGEINE MWSKZ T007A Tax Keys MWSKZ
0 MGEINE RDPRF RDPR Rounding profile MANDT
0 MGEINE RDPRF RDPR Rounding profile WERKS
0 MGEINE RDPRF RDPR Rounding profile RDPRF
0 MGEINE RDPRF RDPR Rounding profile RDZAE
1 MGEINE TAX_COUNTRY T005 Countries MANDT
1 MGEINE TAX_COUNTRY T005 Countries LAND1
0 MGEINE TRANSPORT_CHAIN WRF_PSCD_TCHAINH Transportation Chain, Header MANDT
0 MGEINE TRANSPORT_CHAIN WRF_PSCD_TCHAINH Transportation Chain, Header TC_ID
1 MGEINE VERID MKAL Production Versions of Material WERKS
1 MGEINE VERID MKAL Production Versions of Material VERID
0 MGEINE WAERS TCURC Currency Codes MANDT
0 MGEINE WAERS TCURC Currency Codes WAERS
1 MGEINE WERKS T001W Plants/Branches MANDT
1 MGEINE WERKS T001W Plants/Branches WERKS