Insert entries into Ztable

[Former Member]

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.

[Former Member]

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.

[former_member189629]

refer to Enque/Deque help

[andreas_mann3]

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

[Former Member]

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.

[Former Member]

Write Do 9999 times ..enddo.

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

Ashok