Skip to Content
0
Former Member
Aug 08, 2005 at 02:07 PM

Lock table for reads...

221 Views

Hi,

I try to look a table for update.

During update I get ZERO rows in SE16 for table ZRPICE_TAB. Look at NOTE1.

sptab-TABNAME = 'ZPRICE_TAB '.

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

.

delete from ZPRICE_TAB. " empty this table " NOTE1

insert ZPRICE_TAB from table i_priceZPR13100.

insert ZPRICE_TAB from table i_priceZPR14100.

call function 'DEQUEUE_E_TABLE'

EXPORTING

TABNAME = sptab-TABNAME

VARKEY = sptab-VARKEY.

NOTE1: After this statement I get zero rows from SE16.

This should not be the case. There must always be data in the table.

I want to look the table for READ:s as well I belive...

Any pointers ?

//Martin