Identify Master and Transaction table types

[Former Member]

Hi,

I am looking for a table to find the table type Master data table or Transaction data table .

I searched in DD02L and DD09L table but i couldn't find correct field to differentiate.

e.g VBRK - Master data table

VBRP - Transaction data

VBAK - Master data

VBAP - Transaction data

I want to find like the above tables differentiation.

Thanks,

Fractal

[Former Member]

Hi,

Tables are not classified as master and transaction OR header and item tables, we distinguish them using the type of data stored in them.

To clarify all of the tables you specified are transaction tables as they are used to store transaction data.

Few examples for master tables are KNA1, LFA1 which stores customer master and vendor master respectively.

In your example, VBRK and VBAK are header tables and VBRP and VBAP are Item tables as they store header and item details respectively.

Usually MM/SD tables can be identified with the letter K(header) and P(item) but not in all cases.

Examples : EKKO, EKPO.

Hope you are clear now.

Regards,

Karthik D

[Former Member]

Hi Fractal,

Hope this link may help you. http://it.toolbox.com/wiki/index.php/Find_data_in_your_SAP_system_and_know_which_tables_do_what

Regards,

Pravin

[b_saikishore]

Hi,

The Table type (whether Master data type or Transactional data type) of a database table can be seen in the technical settings (Data class) in SE11.

[clemenssss]

You can find the classification as field DD09L-TABART (APPL0 Master Data, Transparent Tables, APPL1 Transaction Data, Transparent Tables, APPL2 Organization and customizing,...).

But be aware that this is determined by the user who created the table and may not always be what one may expect.
If you give any background and/or reason for yur question, you might expect more helpful answers.
Regards, Clemens