SAP Table EKCOM

Communications Work Area for Purchasing Document Accesses

EKCOM (Communications Work Area for Purchasing Document Accesses) 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 EKCOM to other SAP tables.

EKCOM table fields

Field Data element Checktable Datatype Length Decimals
MATNR Material Number MATNR MARA CHAR 18 0
MATKL Material Group MATKL T023 CHAR 9 0
OMATN Select only documents without material OMATN CHAR 1 0
X Yes
NULL No
EKORG Purchasing Organization EKORG T024E CHAR 4 0
EKGRP Purchasing Group EKGRP T024 CHAR 3 0
LIFNR Vendor Account Number ELIFN LFA1 CHAR 10 0
BEDAT_AB Document date from BEDAT_AB DATS 8 0
BEDAT_BIS Document date to BEDAT_BIS DATS 8 0
ZUART Access type DZUART_VB CHAR 1 0
NULL Read with items, schedule lines, and headers
A Read with items and headers
B Read items only
C Headers only
D Index only
H Read with purchase order history, items and headers
E Read with items, schedule lines, and headers
R Read accounting document
S Read accounting document and relevant purchase order
TRVOG Transaction group TRVOG CHAR 1 0
0 Sales order
1 Inquiry
2 Quotation
3 Scheduling agreement
4 Contract
5 Item proposal
6 Delivery
7 Billing documents
8 Proforma invoices
9 Sales activities
A Sales promotions
B Customer independent requirements
D Shipping notification
G Rough Goods Receipt
O Cost accounting: Variance calculation
KOPF_DAZU Indicator: Read purchasing document header also EKOPF_DAZU CHAR 1 0
X Yes
NULL No
NAME_DAZU Indicator: Read vendor name also LNAME_DAZU CHAR 1 0
X Yes
NULL No
MANDT Client MANDT T000 CLNT 3 0
BSTYF Indicator: Also display purchase orders BSTYF CHAR 1 0
X Yes
NULL No
BSTYK Indicator: Also display contracts BSTYK CHAR 1 0
X Yes
NULL No
BSTYL Indicator: Also display scheduling agreements BSTYL CHAR 1 0
X Yes
NULL No
BSTYA Indicator: Also display RFQs BSTYA CHAR 1 0
X Yes
NULL No

EKCOM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EKCOM EKGRP EKCOM MANDT T024 Purchasing Groups MANDT
EKCOM EKGRP EKCOM EKGRP T024 Purchasing Groups EKGRP
EKCOM EKORG EKCOM EKORG T024E Purchasing Organizations EKORG
EKCOM EKORG EKCOM MANDT T024E Purchasing Organizations MANDT
EKCOM LIFNR EKCOM MANDT LFA1 Vendor Master (General Section) MANDT
EKCOM LIFNR EKCOM LIFNR LFA1 Vendor Master (General Section) LIFNR
EKCOM MANDT EKCOM MANDT T000 Clients MANDT
EKCOM MATKL SYST MANDT T023 Material Groups MANDT
EKCOM MATKL EKCOM MATKL T023 Material Groups MATKL
EKCOM MATNR EKCOM MANDT MARA General Material Data MANDT
EKCOM MATNR EKCOM MATNR MARA General Material Data MATNR