topic READ TABLE statement in ECC 6.0 in Application Development and Automation Discussions

READ TABLE statement in ECC 6.0

Former Member — Fri, 27 Jun 2008 17:47:06 GMT

hi,

in 4.6, my statement was

READ TABLE S_XVTTS WHERE TKNUM = S_XVTTK-TKNUM

AND NOT S_XVTTS-VSTEL IS INITIAL.

This wont work in ECC 6.0, hence I need to modify this. so i write like

READ TABLE S_XVTTS INTO wa_vttsvb WITH KEY TKNUM = S_XVTTK-TKNUM ..................................

how to accomodate the check for NOT initial of S_XVTTS-VSTEL .. how will my statement look like ? thks

Re: READ TABLE statement in ECC 6.0

Former Member — Fri, 27 Jun 2008 17:50:13 GMT

hello,

After the READ stmnt, use a CHECK stmnt for the logic that follows after ur READ stmnt.

READ... .

CHECK NOT XVTTS-VSTEL IS INITIAL.

ur logic.

Rgds,

Raghu.

Re: READ TABLE statement in ECC 6.0

marcelo_ramos1 — Fri, 27 Jun 2008 18:04:43 GMT

Hi Sdnuser1,

Try to use LOOP statement as follow.


"// This LOOP read only one line of table s_xvtt exactly as READ TABLE do.
LOOP AT s_xvtts INTO wa_vttsv WHERE tknum EQ s_xvttk-tknum AND s_xvtts-vstel IS NOT INITIAL.
  EXIT.
ENDLOOP.

IF sy-subrc IS INITIAL.
   "// You can use wa_vttsv
ELSE.
    "// Do something
ENDIF.

I hope it helps yous.

Greetings.

Marcelo Ramos

Re: READ TABLE statement in ECC 6.0

Former Member — Fri, 27 Jun 2008 18:09:48 GMT

Hi,

If the value you are checking is initial then what is the purpose to read the table...

If this is your context.

Check that particular field whether it is initial or not before reading the table..

if not then read the table..

Hope this would help you.

Regards

Narin Nandivada.

Re: READ TABLE statement in ECC 6.0

Former Member — Fri, 27 Jun 2008 18:30:02 GMT

This message was moderated.

Re: READ TABLE statement in ECC 6.0

Former Member — Fri, 27 Jun 2008 18:50:45 GMT

You can't use inequality condition in READ TABLE statement.

Try this:


S_XVTTS1[] =  S_XVTTS[].
DELETE  S_XVTTS1 where S_XVTTS-VSTEL IS NOT INITIAL. 

READ TABLE S_XVTTS1 INTO wa_vttsvb WITH KEY TKNUM = S_XVTTK-TKNUM.
IF sy-subrc = 0.

ENDIF.