This article will demonstrate the difference between Purchasing Document Category (EKKO_BSTYP) and Purchasing Document Type (EKKO_BSART) which can be found in table EKKO. The table EKKO includes the header data of all purchasing documents. Which documents are concretely concerned, will be described in the following chapters.
This is a quantity contract because the field Agreement Type is filled by the value “MK”. It is agreed here that totally 20 000 pieces to a price of 2.56 Euro per piece should be purchased.
Consideration of purchasing document categories in analyses
As already mentioned, purchase orders, inquiries, contracts and scheduling agreements are included in table EKKO. The distinctive feature is the purchase document category (field BSTYP). When analyzing data it is important that the purchase order categories are handled separate. A few examples will be listed:
If the purchase order amount per vendor should be calculated, the purchasing document must be filtered to the purchase order category F before the net value is totaled.
If the purchase orders should be compared with the corresponding contracts, two tables must be created out of table EKKO whereat one table contains the purchase orders and the other table contains the contracts. Afterwards, the purchase orders can be related to the contracts by relating the field KONNR in the purchase orders with the field EBELN in the contracts.
The article has shown that the terms “Document Category” and “Document Type” must not be mixed. Document categories represent different economic processes whereas document types serve as classifications of document categories.