Skip to Content
author's profile photo Former Member
Former Member

HEADER & DETAIL ITEM TABLE

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2007 at 05:21 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 22, 2007 at 05:22 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.