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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MGW (Package) Application development R/3 material master Retail

Basic Data

Table Category	INTTAB	Structure
Structure	MGEINE	Table Relationship Diagram
Short Description	EINE Extended to Include Full Key for Material Master Maint.

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Key of Structure MGEINE = Logical Key of EINE
2	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
3	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
4	EKORG_MG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
5	WERKS_MG	☐	EWERK	WERKS	CHAR	4	0	Plant	*
6	.INCLUDE	☐				0	0	Purchasing Info Record: Purchasing Organization Data
7	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
8	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
9	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
10	ESOKZ	☐	ESOKZ	ESOKZ	CHAR	1	0	Purchasing info record category
11	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
12	LOEKZ	☐	ILOEE	XFELD	CHAR	1	0	Purch. info: Purch. organization data flagged for deletion
13	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
14	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
15	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
16	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
17	BONUS	☐	WRBON	XFELD	CHAR	1	0	Indicator: Volume-Based Rebate
18	MGBON	☐	MGBON	XFELD	CHAR	1	0	Indicator: Quantity-Based Volume Rebate
19	MINBM	☐	MINBM	MENG13	QUAN	13	3	Minimum Purchase Order Quantity
20	NORBM	☐	NORBM	MENG13	QUAN	13	3	Standard Purchase Order Quantity
21	APLFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
22	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
23	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
24	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
25	ANGNR	☐	ANGNR	ANGNR	CHAR	10	0	Quotation Number
26	ANGDT	☐	ANGDT	DATUM	DATS	8	0	Quotation Validity Date
27	ANFNR	☐	ANFNR	EBELN	CHAR	10	0	RFQ Number	EKKO
28	ANFPS	☐	ANFPS	EBELP	NUMC	5	0	Item Number of RFQ	EKPO
29	ABSKZ	☐	ABSKZ	XFELD	CHAR	1	0	Rejection Indicator
30	AMODV	☐	AMODV	DATUM	DATS	8	0	Amortization period from
31	AMODB	☐	AMODB	DATUM	DATS	8	0	Amortization period to
32	AMOBM	☐	AMOBM	MENG15	QUAN	15	3	Amortized planned quantity
33	AMOBW	☐	AMOBW	WERT15	CURR	15	2	Amortized planned value
34	AMOAM	☐	AMOAM	MENG15	QUAN	15	3	Amortized actual quantity
35	AMOAW	☐	AMOAW	WERT15	CURR	15	2	Amortized actual value
36	AMORS	☐	AMORS	XFELD	CHAR	1	0	Indicator: Amortization reset
37	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
38	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
39	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
40	DATLB	☐	DATLB	DATUM	DATS	8	0	Date of Last PO or Sched. Agreement Document in Info Record
41	NETPR	☐	IPREI	WERT11	CURR	11	2	Net Price in Purchasing Info Record
42	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
43	BPRME	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
44	PRDAT	☐	PRGBI	DATUM	DATS	8	0	Price Valid Until
45	BPUMZ	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
46	BPUMN	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
47	MTXNO	☐	MTXNO	XFELD	CHAR	1	0	Material Master Record PO Text Not Relevant
48	WEBRE	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
49	EFFPR	☐	EFFPR	WERT11	CURR	11	2	Effective Price in Purchasing Info Record
50	EKKOL	☐	EKKOG	CHAR4	CHAR	4	0	Condition Group with Vendor
51	SKTOF	☐	ESKTOF	XFELD	CHAR	1	0	Item Does Not Qualify for Cash Discount
52	KZABS	☐	KZABS	XFELD	CHAR	1	0	Order Acknowledgment Requirement
53	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
54	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
55	EBONU	☐	EBONU	EBONU	CHAR	2	0	Settlement Group 1 (Purchasing)
56	EVERS	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	T027A
57	EXPRF	☐	EXPRF	EXPRF	CHAR	8	0	Export/Import Procedure for Foreign Trade	T616
58	BSTAE	☐	BSTAE	BSTAE	CHAR	4	0	Confirmation Control Key	T163L
59	MEPRF	☐	MEPRF	MEPRF	CHAR	1	0	Price Determination (Pricing) Date Control
60	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
61	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
62	XERSN	☐	XERSN	XFELD	CHAR	1	0	No Evaluated Receipt Settlement (ERS)
63	EBON2	☐	EBON2	EBONU	CHAR	2	0	Settlement Group 2 (Rebate Settlement, Purchasing)
64	EBON3	☐	EBON3	EBONU	CHAR	2	0	Settlement Group 3 (Rebate Settlement, Purchasing)
65	EBONF	☐	EBONF	XFELD	CHAR	1	0	Item Not Relevant to Subseq. (Period-End Rebate) Settlement
66	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
67	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
68	BSTMA	☐	MAXBM	MENG13	QUAN	13	3	Maximum Purchase Order Quantity
69	RDPRF	☐	RDPRF	RDPRF	CHAR	4	0	Rounding Profile	RDPR
70	MEGRU	☐	MEGRU	MEGRU	CHAR	4	0	Unit of Measure Group	TWMEG
71	J_1BNBM	☐	J_1BNBMCO1	STEUC	CHAR	16	0	Brazilian NCM Code	T604F
72	SPE_CRE_REF_DOC	☐	/SPE/CRE_REF_DOC	XFELD	CHAR	1	0	Create Purchase Order for Delivery Without Reference
73	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
74	CO_ORDER	☐	ME_IR_CO_ORDER	XFELD	CHAR	1	0	Real-Time Consumption Posting of Subcontracting Components
75	VENDOR_RMA_REQ	☐	MSR_VRMA_REQ_EINE	MSR_VRMA_REQ_EINE	CHAR	1	0	Vendor RMA Number Required
76	DIFF_INVOICE	☐	DIFF_INVOICE	DIFF_INVOICE	CHAR	2	0	Differential Invoicing
77	.INCLU--AP	☐				0	0	Addition of Fields to EINE -Retail Localization for India
78	.INCLUDE	☐				0	0	Additional Filed for Retail Localization for India
79	MRPIND	☐	J_1IRMRPIND	J_1IRMRPIND	CHAR	1	0	Max. Retail Price Relevant
80	.INCLU--AP	☐				0	0	Addition of Fields to EINE - Seasonal Procurement
81	.INCLUDE	☐				0	0	Addition of Fields to EINE - Seasonal Procurement
82	TRANSPORT_CHAIN	☐	WRF_PSCD_TC_ID	WRF_PSCD_TC_ID	CHAR	10	0	Transportation Chain	WRF_PSCD_TCHAINH
83	STAGING_TIME	☐	WRF_PSCD_MST	WRF_PSCD_MST	DEC	3	0	Staging Time in Days
84	BUNGN	☐	BUNGN	XFELD	CHAR	1	0	Indicator: Gross price not equal to net price
85	NOPRS	☐	NOPRS	XFELD	CHAR	1	0	Indicator: No price entry allowed for vendor

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MGEINE	ANFNR	EKKO	EBELN	REF	1	N
2	MGEINE	ANFPS	EKPO	EBELP	REF	1	N
3	MGEINE	BPRME	T006	MSEHI	REF	1	CN
4	MGEINE	BSTAE	T163L	BSTAE	REF	1	CN
5	MGEINE	BWTAR	T149D	BWTAR	REF	1	N
6	MGEINE	EBELN	EKKO	EBELN	REF	1	N
7	MGEINE	EBELP	EKPO	EBELP	REF	1	N
8	MGEINE	EKGRP	T024	EKGRP	REF	1	1
9	MGEINE	EKORG	T024E	EKORG	KEY	1	1
10	MGEINE	EVERS	T027A	EVERS	REF	1	N
11	MGEINE	EXPRF	T616	EXPRF	REF	1	CN
12	MGEINE	INCO1	TINC	INCO1	REF	1	N
13	MGEINE	INFNR	EINA	INFNR	KEY	1	CN
14	MGEINE	J_1BNBM	T604F	STEUC
15	MGEINE	MANDT	T000	MANDT	KEY	1	1
16	MGEINE	MEGRU	TWMEG	MEGRU	KEY	C	CN
17	MGEINE	MWSKZ	T007A	MWSKZ	KEY	1	CN
18	MGEINE	RDPRF	RDPR	RDPRF	KEY	C	CN
19	MGEINE	TRANSPORT_CHAIN	WRF_PSCD_TCHAINH	TC_ID
20	MGEINE	VERID	MKAL	VERID	REF	1	N
21	MGEINE	WAERS	TCURC	WAERS	REF	1	1
22	MGEINE	WERKS	T001W	WERKS	KEY	1	1

History

Last changed by/on	SAP	20130529
SAP Release Created in