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 |
Possible values
|
||||||||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||||||||
TRVOG | Transaction group | TRVOG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
KOPF_DAZU | Indicator: Read purchasing document header also | EKOPF_DAZU | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
NAME_DAZU | Indicator: Read vendor name also | LNAME_DAZU | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||||||||||||
BSTYF | Indicator: Also display purchase orders | BSTYF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
BSTYK | Indicator: Also display contracts | BSTYK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
BSTYL | Indicator: Also display scheduling agreements | BSTYL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
BSTYA | Indicator: Also display RFQs | BSTYA | CHAR | 1 | 0 |
Possible values
|
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 |