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
⤷ 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 |