topic Re: Update a Custom Table in Application Development and Automation Discussions

Update a Custom Table

Former Member — Mon, 23 Nov 2009 06:30:30 GMT

Hi,

Now I created a module pool program in which I usde following code to insert values in to custom table, but now I get a ABAP DUMP at the time of executing the Insert statement

I used the following code

*Declear an Internal Table is having the same structure of Custom Table

DATA : ty_znew_customer TYPE STANDARD TABLE OF znew_customer WITH HEADER LINE.

*Move the Values to internal Table ty_znew_customer

*Lock Table

CALL FUNCTION 'ENQUEUE_E_TABLE'

EXPORTING

mode_rstable = 'X'

tabname = 'ZNEW_CUSTOMER'

x_tabname = ' '

x_varkey = ' '

_scope = '2'

_wait = ' '

_collect = ' '

EXCEPTIONS

foreign_lock = 1

system_failure = 2

OTHERS = 3.

*Insert Records In to Custom Table

BREAK-POINT.

INSERT znew_customer FROM TABLE ty_znew_customer.

COMMIT WORK.

BREAK-POINT.

while executing that insert statement Sy-subrc is set to 4 and I get an Error

*un Lock Table

CALL FUNCTION 'DEQUEUE_E_TABLEE'

EXPORTING

mode_rstable = 'X'

tabname = 'ZNEW_CUSTOMER'

VARKEY = 'CUSTOMER'

x_tabname = ' '

x_varkey = ' '

_scope = '3'

_synchron = ' '

_collect = ' '

Please help me to solve this

Regards

Nausal

Re: Update a Custom Table

Sm1tje — Mon, 23 Nov 2009 06:32:50 GMT

And what dump would that be, or do we have to take a wild guess first?

Re: Update a Custom Table

Former Member — Mon, 23 Nov 2009 06:35:21 GMT

Hi,

Could you specify what error are you getting exactly? Insert statement gives dump if the record with the same primary key values already exists in the table.

Regards

Radhika

Re: Update a Custom Table

former_member194669 — Mon, 23 Nov 2009 06:36:50 GMT

My wild guess will that your custom table znew_customer have records with same key that you are inserting

Please make sure before inserting that same key records that already not available in custom table

a®

Re: Update a Custom Table

Former Member — Mon, 23 Nov 2009 07:21:56 GMT

Hi,

In addition to wat a®s has suggested, please check this.

I am not too sure, but may be you can just check them.

Try changing the mode of the lock to 'E'.

Re: Update a Custom Table

Former Member — Mon, 23 Nov 2009 09:09:58 GMT

Try with

Insert table name FROM TABLE itab [ACCEPTING DUPLICATE KEYS] .

Regards

Srilaxmi

Re: Update a Custom Table

Former Member — Mon, 23 Nov 2009 09:15:35 GMT

Hi,

When you use the SYNTAX ...INSERT FROM TABLE.... it will dump if for any entry in the internal table an entry already

exists in the databse....

So check for existing entries before inserting.