What is Header Data and What is Item Data ?

[Former Member]

Suppose I in SE11. I have typed MARA and press F7. So it will show me the table.From this can I determine Whether it is header level data or itam level data ?

[Former Member]

Hi,

All vendor tables start with L such as LFA1.

All customer tables start with K such as KNA1, KONV.

All sales tables start with V such as VBAK VBAP.

All master data tables start with T such as T001, T001W.

All bank tables start with B such as BKNF, BKPF.

All purchasing tables start with E such as EKKO, EKPO.

All material tables start with M such as MARA, MAKT, and MARC.

And in sales, delivery, billing, purchasing. If the tables name contains K it is Header data such as VBAK, LIKP, VBRK, EKKO.

If the tables name contains P it is Item data such as VBAP, LIPS, VBRP, EKPO.

Coming to FI tables... there are only 6 important tables in whole Finance module which are mostly used by abapers.

They can be remember by:

if the table name contains I, that is open item

if the table name contains A, that is closed item

if the table name ends with S, that is GL account

exp BSIS- GL master open items

BSAS- GL master closed items

like wise...

if the table name ends with D, that is customer

if the table name ends with K, that is vendor

Regards,

Omkar.

[Former Member]

Hi Jyotirmoy,

each document ( like quote, in, order . ro) are divided into three parts in R/3 1.header , 2.item level, 3.schedule lines.

header data talks about the characteristics of the document if it is a sales order how a sales order should behave will be defined here. how the customers are identified, the payment terms how this particular document should be raised and how the materials here are determined are declared here.

where as coming to the item data the characteristics of th ematerial or items will be customised here , to wich category it belongs to it could be a service item , deliverable item, package goods , semifinished etc. apart from this different conditions pertaining to this material said here.

coming to schedule line data the delivery characteristicsa are declared here when whome to etc.

For eg See EKKO which is Purchase Order header data and PO Item data is stored in EKPO.

So you would have to go through the detailed data of the table MARA to analyse which is Header or Item Data.

<b>Kindly Reward points if you found the reply helpful.</b>

Cheers,

CHAITANYA.

[Former Member]

You can't determine header data or item data from a table but on tha contrary you can find out,in which table does the header or item data gets stored.

To give you an example of header and item data,consider a purchase order document.

Here you see the data like PO No,PO Date,Vendor Name,Vendor Address,Payment Terms,Inco terms etc.. which appears only once in an order and their position on document is fixed.You can call these as header data.

Where as item data appear a number of times.this include part no,Qty,UOM,Unit Price,taxes etc..

Hope you got what you wanted.

-Bhavin P Shah

[Former Member]

Every transaction caries two types of data: Header Data and Transactional/Item data.

The header data is stored in Header Tables and the Transactional data is stored in Item tables.

ex:

VBAK is header table for the Sales Documents data which stores the Sales Document number, date created, time of creation, name of the person created the Sales document and the quotation/inquiry is valid from details.

VBAP is item table for the sales document which stores the data of Sales document client, material number, sales document item and other material data for that sales document.

Rewards if useful.