1. Home
  2. Resources
  3. SAP Tables
  4. KOMGG - Material Listing/Exclusion-Communication Block (Dialog)

SAP Table KOMGG

Material Listing/Exclusion-Communication Block (Dialog)

KOMGG (Material Listing/Exclusion-Communication Block (Dialog)) 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 KOMGG to other SAP tables.

KOMGG table fields

Field Data element Checktable Datatype Length Decimals
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
KDGRP Customer group KDGRP T151 CHAR 2 0
ALAND Departure country (country from which the goods are sent) ALAND T005 CHAR 3 0
WKREG Region in which plant is located WKREG T005S CHAR 3 0
WKCOU County in which plant is located WKCOU CHAR 3 0
WKCTY City in which plant is located WKCTY CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
KUNNR Customer number KUNNR_V KNA1 CHAR 10 0
KNRZE Payer KUNRG KNA1 CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
INCO1 Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
LAND1 Country of Destination LLAND T005 CHAR 3 0
REGIO Region (State, Province, County) REGIO T005S CHAR 3 0
COUNC County Code COUNC T005E CHAR 3 0
CITYC City Code CITYC T005G CHAR 4 0
AUART Sales Document Type AUART TVAK CHAR 4 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
LIFRE Different Invoicing Party LIFRE LFA1 CHAR 10 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
KUNAG Sold-to party KUNAG KNA1 CHAR 10 0
KUNWE Ship-to party KUNWE KNA1 CHAR 10 0
SPDNR Forwarding agent SPDNR CHAR 10 0
VRTNR Sales employee VRTNR NUMC 8 0
DUMMYK Dummy function in length 1 DUMMY CHAR 1 0
HIENR01 Customer hierarchy 1 HIENR01 CHAR 10 0
HIENR02 Customer hierarchy 2 HIENR02 CHAR 10 0
HIENR03 Customer hierarchy 3 HIENR03 CHAR 10 0
HIENR04 Customer hierarchy 4 HIENR04 CHAR 10 0
HIENR05 Customer hierarchy 5 HIENR05 CHAR 10 0
HIENR06 Customer hierarchy 6 HIENR06 CHAR 10 0
HIENR07 Customer hierarchy 7 HIENR07 CHAR 10 0
HIENR08 Customer hierarchy 8 HIENR08 CHAR 10 0
HIENR09 Customer heirarchy 9 HIENR09 CHAR 10 0
HIENR10 Customer hierarchy 10 HIENR10 CHAR 10 0
HIENR11 Customer hierarchy 11 HIENR11 CHAR 10 0
HIENR12 Customer hierarchy 12 HIENR12 CHAR 10 0
HIENR13 Customer hierarchy 13 HIENR13 CHAR 10 0
HIENR14 Customer hierarchy 14 HIENR14 CHAR 10 0
HIENR15 Customer hierarchy 15 HIENR15 CHAR 10 0
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

KOMGG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
KOMGG ALAND SYST MANDT T005 Countries MANDT
KOMGG ALAND KOMGG ALAND T005 Countries LAND1
KOMGG AUART KOMGG AUART TVAK Sales Document Types AUART
KOMGG AUART SYST MANDT TVAK Sales Document Types MANDT
KOMGG BUKRS SYST MANDT T001 Company Codes MANDT
KOMGG BUKRS KOMGG BUKRS T001 Company Codes BUKRS
KOMGG CHARG SYST MANDT MCHA Batches MANDT
KOMGG CHARG KOMGG MATNR MCHA Batches MATNR
KOMGG CHARG KOMGG WERKS MCHA Batches WERKS
KOMGG CHARG KOMGG CHARG MCHA Batches CHARG
KOMGG CITYC SYST MANDT T005G City MANDT
KOMGG CITYC KOMGG LAND1 T005G City LAND1
KOMGG CITYC KOMGG REGIO T005G City REGIO
KOMGG CITYC KOMGG CITYC T005G City CITYC
KOMGG COUNC KOMGG COUNC T005E County COUNC
KOMGG COUNC SYST MANDT T005E County MANDT
KOMGG COUNC KOMGG LAND1 T005E County LAND1
KOMGG COUNC KOMGG REGIO T005E County REGIO
KOMGG EKORG KOMGG EKORG T024E Purchasing Organizations EKORG
KOMGG EKORG SYST MANDT T024E Purchasing Organizations MANDT
KOMGG INCO1 SYST MANDT TINC Customers: Incoterms MANDT
KOMGG INCO1 KOMGG INCO1 TINC Customers: Incoterms INCO1
KOMGG INFNR SYST MANDT EINA Purchasing Info Record: General Data MANDT
KOMGG INFNR KOMGG INFNR EINA Purchasing Info Record: General Data INFNR
KOMGG KDGRP SYST MANDT T151 Customers: Customer Groups MANDT
KOMGG KDGRP KOMGG KDGRP T151 Customers: Customer Groups KDGRP
KOMGG KNRZE KOMGG KNRZE KNA1 General Data in Customer Master KUNNR
KOMGG KNRZE SYST MANDT KNA1 General Data in Customer Master MANDT
KOMGG KONDM SYST MANDT T178 Conditions: Groups for Materials MANDT
KOMGG KONDM KOMGG KONDM T178 Conditions: Groups for Materials KONDM
KOMGG KUNAG SYST MANDT KNA1 General Data in Customer Master MANDT
KOMGG KUNAG KOMGG KUNAG KNA1 General Data in Customer Master KUNNR
KOMGG KUNNR SYST MANDT KNA1 General Data in Customer Master MANDT
KOMGG KUNNR KOMGG KUNNR KNA1 General Data in Customer Master KUNNR
KOMGG KUNWE SYST MANDT KNA1 General Data in Customer Master MANDT
KOMGG KUNWE KOMGG KUNWE KNA1 General Data in Customer Master KUNNR
KOMGG LAND1 SYST MANDT T005 Countries MANDT
KOMGG LAND1 KOMGG LAND1 T005 Countries LAND1
KOMGG LIFNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
KOMGG LIFNR KOMGG LIFNR LFA1 Vendor Master (General Section) LIFNR
KOMGG LIFRE SYST MANDT LFA1 Vendor Master (General Section) MANDT
KOMGG LIFRE KOMGG LIFRE LFA1 Vendor Master (General Section) LIFNR
KOMGG MATKL SYST MANDT T023 Material Groups MANDT
KOMGG MATKL KOMGG MATKL T023 Material Groups MATKL
KOMGG MATNR SYST MANDT MARA General Material Data MANDT
KOMGG MATNR KOMGG MATNR MARA General Material Data MATNR
KOMGG MATWA SYST MANDT MARA General Material Data MANDT
KOMGG MATWA KOMGG MATWA MARA General Material Data MATNR
KOMGG MBRSH SYST MANDT T137 Industries for materials MANDT
KOMGG MBRSH KOMGG MBRSH T137 Industries for materials MBRSH
KOMGG MEINA SYST MANDT T006 Units of Measurement MANDT
KOMGG MEINA KOMGG MEINA T006 Units of Measurement MSEHI
KOMGG MTART SYST MANDT T134 Material Types MANDT
KOMGG MTART KOMGG MTART T134 Material Types MTART
KOMGG PMATN KOMGG PMATN MARA General Material Data MATNR
KOMGG PMATN SYST MANDT MARA General Material Data MANDT
KOMGG PRODH SYST MANDT T179 Materials: Product Hierarchies MANDT
KOMGG PRODH KOMGG PRODH T179 Materials: Product Hierarchies PRODH
KOMGG REGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT
KOMGG REGIO KOMGG LAND1 T005S Taxes: Region (Province) Key LAND1
KOMGG REGIO KOMGG REGIO T005S Taxes: Region (Province) Key BLAND
KOMGG SPART SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
KOMGG SPART KOMGG SPART TSPA Organizational Unit: Sales Divisions SPART
KOMGG VKORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
KOMGG VKORG KOMGG VKORG TVKO Organizational Unit: Sales Organizations VKORG
KOMGG VTWEG SYST MANDT TVTW Organizational Unit: Distribution Channels MANDT
KOMGG VTWEG KOMGG VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
KOMGG WERKS SYST MANDT T001W Plants/Branches MANDT
KOMGG WERKS KOMGG WERKS T001W Plants/Branches WERKS
KOMGG WKREG SYST MANDT T005S Taxes: Region (Province) Key MANDT
KOMGG WKREG KOMGG ALAND T005S Taxes: Region (Province) Key LAND1
KOMGG WKREG KOMGG WKREG T005S Taxes: Region (Province) Key BLAND