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
difference between Valuation type and valuation category?
Events that can be used in both the classical and interactive reports
What are the two levels in defining a match code? : abap data dictionary
How do you activate a function exit?
What do you mean by transparent tables in sap abap? : abap data dictionary
What is dialog module?
What is the difference between the exits created in M.M and S&D?
What is singleton pattern in OOPS?
Explain the advantages of abap query tool?
From Excel to ABAP - Is batch mode possible ?
What is the difference between a substructure and an append structure? : abap data dictionary
Explain the advantage of structures?
Explain what are the different functions used in sap script? What are the parameters used in each function?
What are the different abap editors? What is the used of different editors in abap?
What are the modes in lock objects? : sap abap data dictionary