topic Re: Header,Item in Application Development and Automation Discussions

Header,Item

Former Member — Thu, 15 Nov 2007 07:18:17 GMT

Hi All,

What is header table (EKKO Purchasing Document Header) and Item table (EKPO Purchasing Document Item).

thanks & regds,

srinivas.

Re: Header,Item

former_member386202 — Thu, 15 Nov 2007 07:19:45 GMT

Hi,

These tables related to purchse order.

Regards,

Prashant

Re: Header,Item

Former Member — Thu, 15 Nov 2007 07:21:32 GMT

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

Re: Header,Item

Former Member — Thu, 15 Nov 2007 07:22:28 GMT

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

Re: Header,Item

Former Member — Thu, 15 Nov 2007 07:22:36 GMT

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

Re: Header,Item

Former Member — Thu, 15 Nov 2007 07:23:35 GMT

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..

Re: Header,Item

Former Member — Thu, 15 Nov 2007 07:24:34 GMT

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.