topic Re: Database lock related in Application Development and Automation Discussions

Database lock related

debdatta_panda — Thu, 27 Nov 2014 07:56:53 GMT

Hi Experts,

Can you please clear me one scenario??The scenario is that if I developed one report which contains VBAK and VBAP table.My report will display sales order related information.The interesting thing is that if when I want to display a sales order no 123 which is changing somebody currently.on that time Can I display the information for that sales order in my report??And on the time of commit work can I display my report information on that sales order or not??

Please clear my confusion.

Re: Database lock related

Former Member — Thu, 27 Nov 2014 08:08:32 GMT

hi debdatta,

in your report only that data will appear which is already committed. If any user is modifying data and still not committed then that data will not appear to you.

before displaying report you have to check whether any data is locked or not.

If locked you can inform the users in the report that data is being modified.