‎2007 Nov 15 7:18 AM
Hi All,
What is header table (EKKO Purchasing Document Header) and Item table (EKPO Purchasing Document Item).
thanks & regds,
srinivas.
‎2007 Nov 15 7:19 AM
‎2007 Nov 15 7:21 AM
HI
Header will be always a single time data in a transaction
where as Item data is Multiple lines of data
Item data in most of the times consists of more number of lines.
see the header and Item related tables for some Tcodes
Tcode Header Item
ME21N EKKO EKPO Pur order
‎2007 Nov 15 7:22 AM
Hi
In most of the SAP application documents like Sales order, Pur order, Quotation, Material doc
there will be header data(with the partner no, total value etc--one single record) and corresponding to that single header there will be multiple records with the details of products/material and qty
so for each application doc there will be header and item data and accordingly they are stored in different tables
both header and Item tables are linked with the key field(first field)
Regards
Anji
‎2007 Nov 15 7:22 AM
As u must be knowing that a puchase order has a list of PO items that belong to it..its a 1 to many relationship..
so EKKO table has the information pertaining to PO
while EKPO table has data pertaining to the Line items in the PO
Hope dis helps..reward if it does
‎2007 Nov 15 7:23 AM
Hi..
The Master entries will store in the header table (EKKO).Which are not change .
Eg: Purchase order number.Date , Vendor..
The line items for the particluar purchase order items are stored in (EKPO).
Eg : Quantity(menge),Meins,Matnr..
Regards
Bala..
‎2007 Nov 15 7:24 AM
Hi Srinivas,
A purchase order is basically a document used by a company to buy some items. So one purchase order can have multiple materials to purchase. Each of these items are called line items. So a given purchase order can have certain information multiple times, for ex: materials, and some information only once, for example, vendor to whom the purchase order is directed to. So SAP saves all these data of purchase order basically in two tables such as repetitive details in one table and info coming once in another table. In SAP terminology its item table and header table respectively. So EKKO is the header table for PO and EKPO is item table for PO.
Pls assign points if found useful.