topic Re: Update statement. in Application Development and Automation Discussions

Update statement.

Former Member — Fri, 14 Mar 2008 06:58:56 GMT

Hi,

I am trying to update a DB table for a single column with the below stmt:

PERFORM enqueue_table USING l_subrc

'PA9100'.

UPDATE pa9100 SET z_nca_required = c_yes

WHERE pernr EQ wa_emp_tab-pernr AND

endda EQ c_date.

IF SY-SUBRC EQ 0.

PERFORM dequeue_table USING 'PA9100'.

COMMIT WORK.

ELSE.

PERFORM dequeue_table USING 'PA9100'.

MESSAGE i016 WITH text-010.

ENDIF.

But its showing sy-subrc = 4.

Please reply.

Regards,

Binay.

Former Member — Fri, 14 Mar 2008 07:06:17 GMT

Hi,

Check the reason for sy-subrc = 4.

No line was updated because either no line could be selected or the change would have generated lines with primary keys that already existed.

May be no data exist satisfying the condition.

Former Member — Fri, 14 Mar 2008 07:16:35 GMT

Hi Shankar,

Sy-subrc is coming 4 because no line was updated.

Check with the where condition wheter any entry exsist or not.

Former Member — Fri, 14 Mar 2008 07:36:20 GMT

Be careful with format of data of WHERE condition.

Former Member — Fri, 14 Mar 2008 07:38:16 GMT

Check if the table was enqueued first ...

check l_subrc ...

Also it's not recommended to update Infotypes directly ..

Instead use FM's ..

use : HR_INFOTYPE_OPERATION.