topic Identify Master and Transaction table types in Application Development and Automation Discussions

Identify Master and Transaction table types

Former Member — Thu, 27 May 2010 03:34:35 GMT

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

Re: Identify Master and Transaction table types

Former Member — Thu, 27 May 2010 04:04:11 GMT

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

Re: Identify Master and Transaction table types

Former Member — Thu, 27 May 2010 04:08:24 GMT

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

Re: Identify Master and Transaction table types

b_saikishore — Mon, 05 Feb 2024 10:09:31 GMT

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.

Re: Identify Master and Transaction table types

clemenssss — Mon, 05 Feb 2024 10:51:45 GMT

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