What is the difference between transparent and non transparent database tables?

SAP Reports,SAP DB,ALE, SAP Tables questions and answers

(Continued from previous question...)

What is the difference between transparent and non transparent database tables?

Transparent tables have 1 - 1 cardinality b/w Data Dictionary and Database, and non transparent ( Cluster and Pooled) tables have Many - 1 cardinality.

Transparent table can access with using OPen & NAtive SQL stmts where as Nontransparent only OPen Sql.

Transparent trables can store Table relevent data and non transparent tables can store system data/ application data based on the transparent tables

(Continued on next question...)

Other Interview Questions

• A table is bufferd. By select statement I don't want to get the data from table buffer. I want to get thae data from database. How?
• What are user exits? What are customer exits?
• What is the difference between start_form and open_form in scripts? Why is it necessary to close a form always once it is opened?
• What is diffrence between ON Change of and At New Field ?
• When you create sales report, What you can see in that report ? What are those field names or data element names?
• How to assign multiple transaction codes in a session method to BDC_Insert function module?
• “Check” and “Continue”. What is the difference?
• At-Line selection, At user-command etc..,
• “Exit” and “Stop”. What is the difference?
• What is the reserve command?
• What are event keywords in reports?
• How can validate input values in selection screen and which event was fired?
• BDC Transaction code?
• How to navigate basic list to secondary list?
• Which is the First character of creating LockObject?
• What is the Difference between Data Element and Domain?
• How many types of standard SAP Internal Tables?
• What is the Difference Between Tablecontrols and Step Loops?
• What are the Events in Dialog Programs?
• How many ways you can create Table?
• What are the Cluster Tables?
• What are function modules in LDB?
• What are Difference Between Classical Batch Input and Call Transaction?
• How can you call the Sessions?
• Can you call Report in SAP Script?
• How to Upload Logo to Layout Set and what is Program Name?
• What are the SET Parameter and GET Parameter?
• What are Text Elements?
• What is an Interactive Report?
• What are Layout set Elements?
• Distinguish between setscreen and call screen?
• What is ABAP Memory and SAP Memory?
• Explain Check Table and Value Table ?
• How many types of Standard Internal Tables?
• What is Refresh in Internal Table?
• What is the Difference Between Collect and Sum?
• What are the ways of creating Tables?
• What are Function Modules?
• What is CAT?
• What is LDB?
• What are the EVENTS in Report Program? What are EVENTS In Interactive Report and Explain?
• What are the various techniques of BDC?
• What is SQL Trace?
• What is LUW?
• Have you worked with reading and writing data on to files?
• Have you created tables in SAP? What are client dependent and independent tables? How do you create independent tables?
• Have you used SM30 and SM31 transactions?
• How many dictionary objects are there and list all
• What is the difference between transparent and non transparent database tables?
• What is meant by BDC. How many methods of BDC are there?
• What are the difference between table controls and step loops in dialog programming?
• What is ALE, IDOC , EDI , RFC. Explain briefly.
• What is a binary search?
• Types of User Exits, what kind of work is done on these exits?
• How will you find out where the user exits are available?
• Have you created any transactions?
• Difference between Table-Controls and Step-loops?
• Import and Export
• How many interactive reports did you write?
• What is an “Unpack command”
• What are the tools used in SAP Implementation? How do you create Alert Messages?
• When spool buffer is full and new spool request is raised what happens to the request?where does the request stored?
• Whats the difference between R3trans and Tp in SAP-DBA?
• What is “Group by” in Select statement?
• Select statement to read data into internal tables. Types of Select statements
• Explain “Commit” and “Roll back”
• What happens “Update” command is used without where clause ?
• What are logical databases?
• Difference between “Insert”, “Update” and “Modify”
• “Catch” Command
• What is the difference between internel table and structure?
• Explain row type and line type concept
• Can any one give me brief explanation about internal tables, and workarea ?
• How to eliminate duplicate entries in internal tables?
• Size of the internal tables?
• What is the basic difference internal tables and database tables? How can we differentiate by looking at the tables? Handling of internal tables
• What is ALE?
• What are the benefits of ALE?
• When should ALE be used?
• What is the relationship between ALE and Middleware?
• Which ALE business processes are available?
• Which ALE services are available and what do they do?
• Synchronous vs. asynchronous links?
• Which kind of interfaces do ALE business processes use?
• Why does SAP uses ALE instead of database replication or distributed databases?
• What is the relationship between ALE and middleware?