HEADER & DETAIL ITEM TABLE

[Former Member]

hi friends,

Can anybody tell me the difference between Header table

and item detail table . for eg: EKKO(Purchasing Document Header ) and EKPO(Purchasing Document Item) TABLE.

points will be definately awarded.

Thanks & regards.

Kamal

[Former Member]

HI Kamal,

Header Table:

It is the key table for any Business Process Document. i.e. When a document is created the doc number, is stored as key in this header table.

Eg: For EKKO -- EBELN is the Key.

Other Details that relate the entire document like document creation date, document value etc are also stored along with it in the header table.

Item table:

For any document created in header table we may have 0 or more items. These individual items are stored in Item table. This item table contains Document Number and Item Number combination as key. These individual items have their own values. The combination of item values can be in header table.

Eg: EKPO - EBELN and EBELP is the key.

The net value in the header doesnot guarantee the total of item values. This may depend upon condition tables that apply on each item.

• Awrd Points if useful*

Bhupal

[kesavadas_thekkillath]

Header tables are master tables...here no transactions happens...only the master data need to be maintained(for ex addition of new material in the master).

But in transaction tables all the manipulations are stored through regular processes...and need not be maintained periodically.

for Ex: MARC - is a plant material Master.

it consists of material respective to plants.

MKPF is a document header Master....

if u want to know the production done in plants......

Firts we have to get the master details and then get the item details.

first pick the materials from MARC for the plant

Then pick the document from MKPF for a date range.

then pass these materials and documents to MSEG to get the data.

Hope this example helped you.....

A master table and transaction table will have a key field to be linked with.

For More details make a search in SDN Forums