How many types of tables exists and what are they in data dictionary?
Answer Posted / nitish sharma
4 types of tables in data dictionary.
i) Transparent tables - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields. Both Opensql and Nativesql can be used.
ii) Pool tables- It is a database table with a special structure that enables the data of many R/3 tables to be stored within it.
iii) Cluster tables - These are logical tables that are arranged as records of transparent tables. one cannot use native sql on these tables (only open sql). They are not manageable directly using database system tools.
iv) Internal tables - Internal table is a temporary table gets created in the memory of application.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can multiple abap systems connect to abap database?
Explain how is batch input process different from processing on line?
What are the client dependant objects in abap / sap?
Proxy Programming with ABAP - How to develop the Proxy identification through programming
Difference between Insert, Update and Modify?
What is a table attribute? : abap data dictionary
How do I find the output type of a table or a program?
In selection screen I have three fields, plant mat no and material group. If I input plant how do I get the mat no and material group based on plant dynamically?
What is an internal table?
What is time constraint ? : abap hr
How will you define org structure in MM?
What are screen painter? Menu painter? Gui status?
What’s value table?
Kindly help me to Know the process of mapping in EDI from R/3 to a convertor(third party which translates IDoc flatfile to EDIFACT /XML / FTP /HTTP ) ?
Difference between open sql and native sql? : abap data dictionary