SAP table KOMKG (Conditions: Material Listing/Exclusion - Header)

Field Description Data Type Length Decimals Checktable Data Element
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
KDGRP Customer Group CHAR 2 0 T151 KDGRP
ALAND Departure Country/Region (from which the goods are sent) CHAR 3 0 T005 ALAND
WKREG Region in which plant is located CHAR 3 0 T005S WKREG
WKCOU County in which plant is located CHAR 3 0 WKCOU
WKCTY City in which plant is located CHAR 4 0 WKCTY
BUKRS Company Code CHAR 4 0 T001 BUKRS
KUNNR Customer number CHAR 10 0 KNA1 KUNNR_V
KNRZE Payer CHAR 10 0 KNA1 KUNRG
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
INCO1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
LAND1 Destination Country/Region CHAR 3 0 T005 LLAND
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
COUNC County Code CHAR 3 0 T005E COUNC
CITYC City Code CHAR 4 0 T005G CITYC
AUART Sales Document Type CHAR 4 0 TVAK AUART
EKORG Purchasing organization CHAR 4 0 T024E EKORG
LIFRE Different Invoicing Party CHAR 10 0 LFA1 LIFRE
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
KUNAG Sold-to Party CHAR 10 0 KNA1 KUNAG
KUNWE Ship-to Party CHAR 10 0 KNA1 KUNWE
SPDNR Forwarding Agent CHAR 10 0 * SPDNR
VRTNR Sales employee NUMC 8 0 VRTNR
DUMMYK Dummy function in length 1 CHAR 1 0 DUMMY

KOMKG foreign key relationships

Table Field Check Table Check Field
0 KOMKG ALAND T005 Countries MANDT
0 KOMKG ALAND T005 Countries LAND1
1 KOMKG AUART TVAK Sales Document Types MANDT
1 KOMKG AUART TVAK Sales Document Types AUART
0 KOMKG BUKRS T001 Company Codes BUKRS
1 KOMKG CITYC T005G City MANDT
1 KOMKG CITYC T005G City LAND1
1 KOMKG CITYC T005G City REGIO
1 KOMKG CITYC T005G City CITYC
0 KOMKG COUNC T005E County MANDT
0 KOMKG COUNC T005E County LAND1
0 KOMKG COUNC T005E County REGIO
0 KOMKG COUNC T005E County COUNC
1 KOMKG EKORG T024E Purchasing Organizations EKORG
0 KOMKG INCO1 TINC Customers: Incoterms INCO1
1 KOMKG KDGRP T151 Customers: Customer Groups MANDT
1 KOMKG KDGRP T151 Customers: Customer Groups KDGRP
0 KOMKG KNRZE KNA1 General Data in Customer Master MANDT
0 KOMKG KNRZE KNA1 General Data in Customer Master KUNNR
1 KOMKG KUNAG KNA1 General Data in Customer Master MANDT
1 KOMKG KUNAG KNA1 General Data in Customer Master KUNNR
0 KOMKG KUNNR KNA1 General Data in Customer Master MANDT
0 KOMKG KUNNR KNA1 General Data in Customer Master KUNNR
1 KOMKG KUNWE KNA1 General Data in Customer Master MANDT
1 KOMKG KUNWE KNA1 General Data in Customer Master KUNNR
0 KOMKG LAND1 T005 Countries MANDT
0 KOMKG LAND1 T005 Countries LAND1
1 KOMKG LIFNR LFA1 Supplier Master (General Section) MANDT
1 KOMKG LIFNR LFA1 Supplier Master (General Section) LIFNR
0 KOMKG LIFRE LFA1 Supplier Master (General Section) MANDT
0 KOMKG LIFRE LFA1 Supplier Master (General Section) LIFNR
1 KOMKG REGIO T005S Taxes: Region (Province) Key LAND1
0 KOMKG SPART TSPA Organizational Unit: Sales Divisions MANDT
0 KOMKG SPART TSPA Organizational Unit: Sales Divisions SPART
1 KOMKG VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 KOMKG VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 KOMKG VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 KOMKG VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
1 KOMKG WKREG T005S Taxes: Region (Province) Key LAND1