Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

diff between transparent table and master table

Former Member
0 Likes
1,349

hi all,

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

thnks

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
814

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

4 REPLIES 4
Read only

dani_mn
Active Contributor
0 Likes
814

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,

Read only

Former Member
0 Likes
815

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

Read only

Former Member
0 Likes
814

Hello,

Give me ur mail Id.

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

Regards,

Read only

0 Likes
814

hi,

my mail id is madhujainy@yahoo.com