SAP ABAP Question: Download SAP ABAP PDF
What is the difference between a pool table and a transparent table and how they are stored at the database level?
Answer:
Pool Table -
1) Many to One Relationship.
2) Table in the Dictionary has the different name, different number of fields, and the fields have the different name as in the R3 Table definition.
3) It can hold only pooled tables.
Transparent Table –
1) One to One relationship.
2) Table in the Dictionary has the same name, same number of fields, and the fields have the same name as in the R3 Table definition.
3) It can hold Application data.
1) Many to One Relationship.
2) Table in the Dictionary has the different name, different number of fields, and the fields have the different name as in the R3 Table definition.
3) It can hold only pooled tables.
Transparent Table –
1) One to One relationship.
2) Table in the Dictionary has the same name, same number of fields, and the fields have the same name as in the R3 Table definition.
3) It can hold Application data.