topic Re: delete itab in Application Development and Automation Discussions

delete itab

Former Member — Mon, 20 Mar 2006 04:23:23 GMT

Hi experts,

Iam having itab like this.


VBELN      VKBUR KUNNR      AUART AUDAT    FBUDA   
                                                   
100000001|9003 |0000110065|ZR01 |20060207|20060208|
100000001|9003 |0000110065|ZR01 |20060207|00000000|
100000006|9003 |0000110065|ZR01 |20060208|00000000|
100000007|9003 |0000110065|ZR01 |20060207|20060208|
100000008|9003 |0000110065|ZR01 |20060207|20060208|
100000009|9003 |0000110065|ZR01 |20060208|20060208|

If any one of the FBUDA is not having value i want to delete all VBELNs.

So my output should be like this.


100000007|9003 |0000110065|ZR01 |20060207|20060208|
100000008|9003 |0000110065|ZR01 |20060207|20060208|
100000009|9003 |0000110065|ZR01 |20060208|20060208|

For example

I have values


 VBELN                                     FBUDA
100000001|9003 |0000110065|ZR01 |20060207|20060208|
100000001|9003 |0000110065|ZR01 |20060207|00000000|

since 100000001 having FBUDA value 00000000, i want to delete <b>all 100000001</b>.

Can any one tell me how can i do this?

Reward guaranteed

thanks

kaki

Re: delete itab

Former Member — Mon, 20 Mar 2006 04:26:53 GMT

Kaki,

Did you try

Delete itab where FBUDA is initial.

If this doesn't work

DELETE ITABE where FBUDA = '00000000'.

Regards,

Ravi

Re: delete itab

Former Member — Mon, 20 Mar 2006 04:28:47 GMT

DATA: BEGIN OF itab OCCURS 0,
vbeln LIKE vbak-vbeln,
END OF itab.

LOOP AT itab.
IF FBUDA IS INITIAL.
itab1-vbeln = itab-vbeln.
APPEND itab1.
DELETE ADJACENT DUPLICATES FROM itab1.
ENDLOOP.

LOOP AT itab1.
DELETE itab WHERE vbeln = itab1-vbeln.
ENDLOOP.

Re: delete itab

Former Member — Mon, 20 Mar 2006 04:31:27 GMT

Hi kaki,

i think you cannot use

<b> delete itab where ..</b>

for initial values..

loop at itab.
 if itab-FBUDA is initial.
 delete itab where vbeln eq itab-vbeln.
endif.
endloop.

regards

satesh

Re: delete itab

former_member186741 — Mon, 20 Mar 2006 04:39:30 GMT

Loop at itab where fbuda = '00000000'.

delete itab where vbeln = itab-vbeln.

endloop.

Re: delete itab

Former Member — Mon, 20 Mar 2006 05:05:06 GMT

Thanks for all the replies...

points alloted.

kaki