SAP table KOMPG (Material Listing/Exclusion - Item)
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MATNR | Material Number | CHAR | 40 | 0 | MARA | MATNR | |
| CHARG | Batch Number | CHAR | 10 | 0 | MCHA | CHARG_D | |
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| EAN11 | International Article Number (EAN/UPC) | CHAR | 18 | 0 | EAN11 | ||
| WAGRP | Material group | CHAR | 9 | 0 | WAGRP | ||
| KONDM | Material Price Group | CHAR | 2 | 0 | T178 | KONDM | |
| MATKL | Material Group | CHAR | 9 | 0 | T023 | MATKL | |
| INFNR | Number of purchasing info record | CHAR | 10 | 0 | EINA | INFNR | |
| PRODH | Product hierarchy | CHAR | 18 | 0 | T179 | PRODH_D | |
| PMATN | Pricing Reference Material | CHAR | 40 | 0 | MARA | PMATN | |
| VKGRU | Repair Processing: Classification of Items | CHAR | 3 | 0 | VKGRU | ||
| VKAUS | Unused - Reserve Length 3 | CHAR | 3 | 0 | VKAUS | ||
| MTART | Material type | CHAR | 4 | 0 | T134 | MTART | |
| MATWA | Material Entered | CHAR | 40 | 0 | MARA | MATWA | |
| MEINA | Unit of measure | UNIT | 3 | 0 | T006 | MEINA | |
| MBRSH | Industry Sector | CHAR | 1 | 0 | T137 | MBRSH | |
| EDATU | Schedule line date | DATS | 8 | 0 | EDATU | ||
| DUMMY2 | Dummy function in length 1 | CHAR | 1 | 0 | DUMMY |
KOMPG foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 KOMPG | CHARG | MCHA | Batches | MANDT |
| 0 KOMPG | CHARG | MCHA | Batches | WERKS |
| 0 KOMPG | CHARG | MCHA | Batches | CHARG |
| 1 KOMPG | INFNR | EINA | Purchasing Info Record: General Data | INFNR |
| 0 KOMPG | KONDM | T178 | Conditions: Groups for Materials | MANDT |
| 0 KOMPG | KONDM | T178 | Conditions: Groups for Materials | KONDM |
| 1 KOMPG | MATKL | T023 | Material Groups | MATKL |
| 0 KOMPG | MATNR | MARA | General Material Data | MANDT |
| 0 KOMPG | MATNR | MARA | General Material Data | MATNR |
| 1 KOMPG | MATWA | MARA | General Material Data | MANDT |
| 1 KOMPG | MATWA | MARA | General Material Data | MATNR |
| 0 KOMPG | MBRSH | T137 | Industries for materials | MANDT |
| 1 KOMPG | MEINA | T006 | Units of Measurement | MANDT |
| 1 KOMPG | MEINA | T006 | Units of Measurement | MSEHI |
| 0 KOMPG | MTART | T134 | Material Types | MANDT |
| 0 KOMPG | MTART | T134 | Material Types | MTART |
| 1 KOMPG | PMATN | MARA | General Material Data | MANDT |
| 1 KOMPG | PMATN | MARA | General Material Data | MATNR |
| 0 KOMPG | PRODH | T179 | Materials: Product Hierarchies | PRODH |
| 1 KOMPG | WERKS | T001W | Plants/Branches | MANDT |
| 1 KOMPG | WERKS | T001W | Plants/Branches | WERKS |