topic Re: Table update issue in Application Development and Automation Discussions

Table update issue

former_member423024 — Thu, 26 Nov 2009 12:03:18 GMT

Hi Gurus,

Given below is my code to update a table but it's not getting updated.

Kindlyreply me with a solution.

UPDATE ztmmmm_po_ifstg SET aufnr = ch_wa_po_one-aufnr

zprostat = ch_wa_po_one-zprostat

WHERE zifid = ch_wa_po_one-zifid

and ztimestamp = ch_wa_po_one-ztimestamp

AND zprocessno = ch_wa_po_one-zprocessno

AND zsequenceno = ch_wa_po_one-zsequenceno

AND zbundno = ch_wa_po_one-zbundno.

where ch_wa_po_one is an internal table.

thanks

Natasha SS.

Former Member — Thu, 26 Nov 2009 12:05:49 GMT

If ch_wa_po_one is a internal table, is the header getting filled when you are using the UPDATE statement?

Sandeep_Panghal — Thu, 26 Nov 2009 12:06:59 GMT

Does your "WHERE" clause meets the table entries or criteria ?

Former Member — Thu, 26 Nov 2009 12:10:13 GMT

Hi Natasa,

Please let me know your desk number. will check on the same.

Looks like strecture needs to pass to update statement instead of internal table work area.

Raman.

Cubical : 53

Edited by: Ramanji Reddy on Nov 26, 2009 1:20 PM

Former Member — Thu, 26 Nov 2009 14:09:18 GMT

Hi,

In your update statement you have to use workarea instead of internal table