topic Re: diff between transparent table and master table in Application Development and Automation Discussions

diff between transparent table and master table

Former Member — Wed, 30 Aug 2006 04:36:30 GMT

hi all,

Can anyone tell me the difference between transparent table and master table?????

thnks

Re: diff between transparent table and master table

dani_mn — Wed, 30 Aug 2006 04:42:22 GMT

HI,

Transparent table is used to store data. other types are Pooled tables and cluster tables.

Master table is category of table. if you are storing master data of some application then you can can choose master table.

for transactin data type is 'Transaction'.

There is no direct differences between these two things. they don't directly relate to each other.

Regards,

Re: diff between transparent table and master table

Former Member — Wed, 30 Aug 2006 04:45:34 GMT

Hi,

Logically you cannot make such comparision. For tables are of ONLY three types : transparent, cluster and pooled tables.

Of this whatever table you create in SE11 is only created as a transparent table and they are stored in the same in the Database Server. Now Master tables are tables which are transparent tables whose data are largely used in various business transactions. Further more, the data stored in these tables are very rarely changed and since these records serve as the master data for various business applications, they are classified as master data and master tables.

Hope by now you would have got your answer.

Reward if convinced.

Regards

Re: diff between transparent table and master table

Former Member — Wed, 30 Aug 2006 04:46:25 GMT

Hello,

Give me ur mail Id.

I have document related to this topic which may help u.

Regards,

Re: diff between transparent table and master table

Former Member — Wed, 30 Aug 2006 04:49:22 GMT

hi,

my mail id is madhujainy@yahoo.com