topic Re: problem with read statement in Application Development and Automation Discussions

problem with read statement

Former Member — Wed, 19 Aug 2009 11:32:35 GMT

Hi Friends,

I have one internal table gt_ekpo in which fields such as ebeln, ebelp, mblnr, mjahr and budat are present.

I want to to delete all the records which have values present in budat(date) so i have tried following statement:-

LOOP AT gt_ekpo INTO ls_ekpo.

READ TABLE gt_ekpo INTO ls_ekpo WITH TABLE KEY budat = ls_ekpo-budat TRANSPORTING ebeln budat.

ENDLOOP.

READ TABLE gt_ekpo into ls_ekpo WITH TABLE KEY budat = ls_ekpo-budat transporting ebeln budat."ebeln = ls_ekpo-ebeln ebelp = ls_ekpo-ebelp mblnr = ls_ekpo-mblnr mjahr = ls_ekpo-mjahr

IF sy-subrc = 0.

DELETE gt_ekpo INDEX sy-tabix.

ENDIF.

it is giving me syntax error as declaration of ebeln key field is missing.........

one more thing if we use loop at for read then it will read multipple lines...rught?

Thanx

Former Member — Wed, 19 Aug 2009 11:36:26 GMT

Hi,

Try like this


LOOP AT gt_ekpo.
if gt_ekpo-budat is not initial.
DELETE gt_ekpo INDEX sy-tabix.
endif.
ENDLOOP.

You wont require the read statement here.

Regards,

Vik

Edited by: vikred on Aug 19, 2009 5:08 PM

former_member188827 — Wed, 19 Aug 2009 11:39:50 GMT

delete gt_ekpo where budat is not initial.

Former Member — Wed, 19 Aug 2009 11:40:58 GMT

Hai

You can Use Like this:

Just use after Fetching data:

Delete GT_EKPO where budat is not initial.

Former Member — Wed, 19 Aug 2009 13:08:45 GMT

I would say do the way Vikred said:

LOOP AT gt_ekpo.

if gt_ekpo-budat is not initial.

DELETE gt_ekpo INDEX sy-tabix.

endif.

ENDLOOP.