topic Re: Modify table not working in Application Development and Automation Discussions

Modify table not working

Former Member — Fri, 21 Aug 2009 08:37:21 GMT

Hi all,

I am facing a problem.

Below is the code. In this, After Modify statement I am getting sy-subrc eq 4 also not updating table t_po_item_add_data



TYPES: tt_bapiekpoa  TYPE TABLE OF bapiekpoa.

DATA: wa_po_item_add_data LIKE LINE OF t_po_item_add_data,
           t_po_item_add_data           TYPE tt_bapiekpoa.

  IF S_PO_HEADER-PUR_GROUP = '284'.
    wa_po_item_add_data-GR_NON_VAL = 'X'.
    Modify Table t_po_item_add_data from wa_po_item_add_data
             Transporting GR_NON_VAL.
  ENDIF.

Please help.

Sachin

Re: Modify table not working

RahulKeshav — Fri, 21 Aug 2009 08:44:29 GMT

try to use..

table lock before modifing the DB table.

ENQUEUE

DEQUEUE

Re: Modify table not working

Former Member — Fri, 21 Aug 2009 08:46:15 GMT

Hello


read table t_po_item_add_data into wa_po_item_add_data with key " <= set condition here
  IF S_PO_HEADER-PUR_GROUP = '284'.
    wa_po_item_add_data-GR_NON_VAL = 'X'.
    Modify t_po_item_add_data from wa_po_item_add_data Transporting GR_NON_VAL.
  ENDIF.

Re: Modify table not working

Former Member — Fri, 21 Aug 2009 08:49:10 GMT

Hi,

Try this



read table t_po_item_add_data into wa_po_item_add_data where field = some value.
IF S_PO_HEADER-PUR_GROUP = '284'.
    wa_po_item_add_data-GR_NON_VAL = 'X'.
    Modify Table t_po_item_add_data from wa_po_item_add_data
             Transporting GR_NON_VAL.
  ENDIF.

Re: Modify table not working

Former Member — Fri, 21 Aug 2009 08:56:11 GMT

Hi,

Modify Table t_po_item_add_data from wa_po_item_add_data

Transporting GR_NON_VAL.

remove that TABLE

Modify t_po_item_add_data from wa_po_item_add_data

Transporting GR_NON_VAL.

Edited by: Selva M on Aug 21, 2009 2:29 PM

Re: Modify table not working

Former Member — Fri, 21 Aug 2009 09:09:02 GMT

Use WHERE condition with Modify Table statement .

This will surely resolve your issue.

Re: Modify table not working

Former Member — Fri, 21 Aug 2009 09:13:04 GMT

The correct syntax is

Modify itab from ..............

so remove table statement from ur code

TYPES: tt_bapiekpoa TYPE TABLE OF bapiekpoa.

DATA: wa_po_item_add_data LIKE LINE OF t_po_item_add_data,

t_po_item_add_data TYPE tt_bapiekpoa.

IF S_PO_HEADER-PUR_GROUP = '284'.

wa_po_item_add_data-GR_NON_VAL = 'X'.

Modify Table t_po_item_add_data from wa_po_item_add_data "Remove table

Transporting GR_NON_VAL.

Modify t_po_item_add_data from wa_po_item_add_data "Correct statement

Transporting GR_NON_VAL.

ENDIF.

Hope this will solve ur problem.

Re: Modify table not working

Former Member — Fri, 21 Aug 2009 09:35:27 GMT

hi,

for an internal table you can just use modify itab

its better if you just put F1 on modify. read the documentation and diff between modify itab and modify table

Re: Modify table not working

Former Member — Fri, 21 Aug 2009 09:59:38 GMT

Hi Sachin,

Modify Table t_po_item_add_data from wa_po_item_add_data

Transporting GR_NON_VAL.

The system searches the internal table for the line whose table key corresponds to the key fields in <wa>.

as thr is no keyfield for the structure BAPIEKPOA the statement is unable to find a line to modify...

use index or where condition to modify the line..

if only an entry in the table is found satisfying the 'where' condition , the table gets modified.

Modify t_po_item_add_data from wa_po_item_add_data

Transporting GR_NON_VAL

where GR_NON_VAL = ' '.

Regards.

Re: Modify table not working

former_member189420 — Fri, 21 Aug 2009 10:14:00 GMT

Hello,

Instead of using MODIFY statement. You can go for using field symbols.

Read the particular record from the internal table assigning it to a field-symbol. Then make changed to the field-symbol, which automatically changes the particular record in the internal table. This is good way of modifying the internal table. Let me know if you want the code.

Hope this helps.

Regards,

Anand Patil

Re: Modify table not working

Former Member — Tue, 25 Aug 2009 10:37:57 GMT

check F1 for modify

'If the change would lead to a double entry in a unique secondary index, then it is not executed and sy-subrc is set to 4.'

Re: Modify table not working

Former Member — Tue, 25 Aug 2009 11:40:57 GMT

Sachin,

Hope your table t_po_item_add_data is not empty! As that will also return sy-subrc = 4. check it once.

Thanks,

Augustin.

Re: Modify table not working

Former Member — Fri, 08 Jan 2010 05:25:49 GMT