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
What are the advantages/ dis-advantages of logical databases?
What is your approach to find exit and BAdi?
What is the difference between synchronous and asynchronous update? : abap bdc
What are the page windows? How many main windows will be there in a page window?
What are the difference between tables and structures?
How can we create callable modules of program code within one abap/4 program?
How do you use tab sets in layout sets?
What is database utility?
Control Break statements- At new...endat.
how can you display data say "your name"in sap script without print program or driver program??
Tell me a scenario where did you use secondary index?
What is web dynpro for abap?
What is static attribute
How to call other programs?
How do we handle multiple line items in BDC's.