Programming Database Updates Questions Answers

1. How does Perform On Commit differ from Perform Statement?

subroutines called using on commit have no interface
subroutines called using on commit use global data only

2. What would trigger a rollback?

Your program issues a MESSAGE type 'A'.

3. How could you reset the program context of your program?

End the dialog program
Issue a termination message (type A)

4. which update request always run asynchronously?

V2.

5. With asynchronous update techniques in SAP LUW

Requests are not passed directly to the DB
You can combine update requests from consecutive dialog steps
All updates are performed or none at all

6. What function modules get generated on the activation of lock object EZMARA?

DEQUEUE_EZMARA
ENQUEUE_EZMARA

7. What order is recommended when setting and releasing a lock in your program?

lock data, read data, update database, release locks

8. If you trigger a lock object and it is already lock by another user, what exception would be raised?

01 - Foreign_Lock

9. What ABAP statement discards update task requests?

ROLLBACK WORK
Message A101

10. The scope Parameter for you lock object function module has been set to 2. what dose this imply?

The locks are automatically released when the updates complete
Locks generated in the dialog program are passed on to the update program

11. What statement would conclude a SAP LUW?

COMMIT WORK
ROLLBACK WORK

12. What order is recommended when setting and releasing locks in your program?

lock data, read data, update database, release locks

13. Valid asynchronous update bundling technique

CALL FUNCTION .. ... IN UPDATE TASK

14. How are locks removed from the lock tables?

The update task removes them at the end of the SAP LUW

15. What message type dose not implicitly trigger database commits for the table updates specified in your program?

A type MESSAGE statement

16. Which dose provides synchronous processing?

Batch Input Programs
PERFORM.. ... ON COMMIT
An update-task function module triggered with COMMIT WORK AND WAIT

17. Which dose not provides synchronous processing?

An update-task function module triggered with COMMIT WORK

ABAP Tips

Related ABAP Topics:
Table CDHDR and CDPOS Usage

SAP Books
SAP Certification, Interview Questions, Functional, Basis Administration and ABAP Programming Reference Books

More ABAP Tips

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.