SAP Table KOMPG
Material Listing/Exclusion - Item
KOMPG (Material Listing/Exclusion - Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link KOMPG to other SAP tables.
KOMPG table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
CHARG | Batch Number | CHARG_D | MCHA | CHAR | 10 | 0 | ||
WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | 0 | |||
WAGRP | Material group | WAGRP | CHAR | 9 | 0 | |||
KONDM | Material Pricing Group | KONDM | T178 | CHAR | 2 | 0 | ||
MATKL | Material Group | MATKL | T023 | CHAR | 9 | 0 | ||
INFNR | Number of Purchasing Info Record | INFNR | EINA | CHAR | 10 | 0 | ||
PRODH | Product hierarchy | PRODH_D | T179 | CHAR | 18 | 0 | ||
PMATN | Pricing Reference Material | PMATN | MARA | CHAR | 18 | 0 | ||
VKGRU | Repair Processing: Classification of Items | VKGRU | CHAR | 3 | 0 | |||
VKAUS | Unused - Reserve Length 3 | VKAUS | CHAR | 3 | 0 | |||
MTART | Material Type | MTART | T134 | CHAR | 4 | 0 | ||
MATWA | Material entered | MATWA | MARA | CHAR | 18 | 0 | ||
MEINA | Unit of measure | MEINA | T006 | UNIT | 3 | 0 | ||
MBRSH | Industry sector | MBRSH | T137 | CHAR | 1 | 0 | ||
EDATU | Schedule line date | EDATU | DATS | 8 | 0 | |||
DUMMY2 | Dummy function in length 1 | DUMMY | CHAR | 1 | 0 |
KOMPG foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
KOMPG | CHARG | SYST | MANDT | MCHA | Batches | MANDT |
KOMPG | CHARG | KOMPG | MATNR | MCHA | Batches | MATNR |
KOMPG | CHARG | KOMPG | WERKS | MCHA | Batches | WERKS |
KOMPG | CHARG | KOMPG | CHARG | MCHA | Batches | CHARG |
KOMPG | INFNR | SYST | MANDT | EINA | Purchasing Info Record: General Data | MANDT |
KOMPG | INFNR | KOMPG | INFNR | EINA | Purchasing Info Record: General Data | INFNR |
KOMPG | KONDM | SYST | MANDT | T178 | Conditions: Groups for Materials | MANDT |
KOMPG | KONDM | KOMPG | KONDM | T178 | Conditions: Groups for Materials | KONDM |
KOMPG | MATKL | SYST | MANDT | T023 | Material Groups | MANDT |
KOMPG | MATKL | KOMPG | MATKL | T023 | Material Groups | MATKL |
KOMPG | MATNR | KOMPG | MATNR | MARA | General Material Data | MATNR |
KOMPG | MATNR | SYST | MANDT | MARA | General Material Data | MANDT |
KOMPG | MATWA | SYST | MANDT | MARA | General Material Data | MANDT |
KOMPG | MATWA | KOMPG | MATWA | MARA | General Material Data | MATNR |
KOMPG | MBRSH | SYST | MANDT | T137 | Industries for materials | MANDT |
KOMPG | MBRSH | KOMPG | MBRSH | T137 | Industries for materials | MBRSH |
KOMPG | MEINA | SYST | MANDT | T006 | Units of Measurement | MANDT |
KOMPG | MEINA | KOMPG | MEINA | T006 | Units of Measurement | MSEHI |
KOMPG | MTART | KOMPG | MTART | T134 | Material Types | MTART |
KOMPG | MTART | SYST | MANDT | T134 | Material Types | MANDT |
KOMPG | PMATN | SYST | MANDT | MARA | General Material Data | MANDT |
KOMPG | PMATN | KOMPG | PMATN | MARA | General Material Data | MATNR |
KOMPG | PRODH | SYST | MANDT | T179 | Materials: Product Hierarchies | MANDT |
KOMPG | PRODH | KOMPG | PRODH | T179 | Materials: Product Hierarchies | PRODH |
KOMPG | WERKS | SYST | MANDT | T001W | Plants/Branches | MANDT |
KOMPG | WERKS | KOMPG | WERKS | T001W | Plants/Branches | WERKS |