topic Insert entries into Ztable in Application Development and Automation Discussions

Insert entries into Ztable

Former Member — Wed, 06 Aug 2008 15:01:56 GMT

Dear all,

I have a customize program that will perform records insertion into Ztable.

Program will be executed into background with more than one job due to different variant.

My concerns:

1. Since the program running in background for different variant at the same time, and the program is doing the data insertion(for different company code) into same table(Ztable). Will in cause any record insertion failure?

2. How should i declare the lock?

Please comment.

Re: Insert entries into Ztable

former_member189629 — Wed, 06 Aug 2008 15:06:05 GMT

refer to Enque/Deque help

Re: Insert entries into Ztable

andreas_mann3 — Wed, 06 Aug 2008 15:22:47 GMT

use fm ENQUEUE_E_TABLE:

example:

...

sptab-tabname = c_sperr.

sptab-varkey = sy-mandt.

CALL FUNCTION 'ENQUEUE_E_TABLE'

EXPORTING

tabname = sptab-tabname

varkey = sptab-varkey

EXCEPTIONS

foreign_lock = 1

system_failure = 2

OTHERS = 3.

IF sy-subrc <> 0.

MESSAGE x001(000) WITH ...

ENDIF.

hope that helps

Andreas

Re: Insert entries into Ztable

Former Member — Wed, 06 Aug 2008 15:41:56 GMT

Hi,

Thanks for your reply. However I'm not looking for a full table locking. For my case, same program running at the same time during the update into same Ztable, full table locking will cause rest of the job fail.

Thanks.

Re: Insert entries into Ztable

Former Member — Wed, 06 Aug 2008 15:49:53 GMT

Write Do 9999 times ..enddo.

enque the table and once the insertion is done ,deque the table.

Ashok