Difference between “Insert”, “Update” and “Modify”

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

(Continued from previous question...)

Difference between “Insert”, “Update” and “Modify”

INSERT - Add a new record into the database table.
MODIFY - If record is available it modifies otherwise it wont modify.
UPDATE - If record is available its update the record otherwise it creates a new record.

(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?