How to identify Transaction Tables, Master Tables

[former_member222860]

Dear All,

How can we identify whether table is master table or transaction table or configuration table, do we any fieldname in global repository tables like DD02L, DD03L and etc or any other mechanism to identify the same. I would like to find out the list of transaction tables and master tables in particular module like SD, MM.

Your inputs are highly appreciated.

Thanks & Regards

Mahesh

[viquar_iqbal]

Hi

you can check that under technical settings->data class of the table.

You can select tables based on module by clicking f4 in se11 and selection information systems . Then enter the application component like SD , MM etc but i dont think we can select it based on data class.

Thanks,

Viquar Iqbal

[shaik_sajid]

Hi,

In SE11, take the table and display.

Click on Technical settings button.

Here u can see Data Class.

if Data Class is APPL0 then it is Master data table

and if Data Class is APPL1 then it is Transaction data table

Regards

Sajid

[former_member555112]

Hi,

To identify whether the table is customising or application you can check the delivery class of the table.

There is no exact field to identify between master table and transaction table.

But it is just the fact that all your business process data will be stored in a transaction table.

Master table just holds the master value for a particular field say for example the plant, sales org etc.

At best the master table can be said as the value table or check table although this statement cannot be generalised.

Regards,

Ankur Parab

[MarcinPciak]

Hi Mahesh,

I think you are looking for field CONTFLAG in table DD02L . This is delivery class which you must determine each time you create a table. It is placed on Delivery and Maintenance tab on table defitnition.

Regards

Marcin

[former_member222860]

Thanks a lot for your valuable suggestions

I think DD09L~TABART gives more info.

Thanks\

Mahesh