topic Re: Reg : select & endselect in Application Development and Automation Discussions

Reg : select & endselect

Former Member — Thu, 06 Sep 2007 06:55:59 GMT

Hi experts ,

Having Doubt in select & endselect Statement

SELECT matnr

kwmeng

werks

lgort

UP TO l_index ROWS

FROM vbap

INTO tp_vbap

WHERE vbeln = com_kbv1-vbeln.

ENDSELECT.

In the above select Query l_index contains 2 Line items.

When i try to execute this Select Query?

It is reading only the First Line item Only..

Its not going to second Line item.

Regs,

Murthy

Re: Reg : select & endselect

Former Member — Thu, 06 Sep 2007 06:59:11 GMT

Hi,

dont use the select and endselect as it a loop on the data base

SELECT matnr

kwmeng

werks

lgort

UP TO l_index ROWS

FROM vbap

INTO table tp_vbap

WHERE vbeln = com_kbv1-vbeln.

and your answer.

SELECT matnr

kwmeng

werks

lgort

UP TO l_index ROWS

FROM vbap

INTO tp_vbap

WHERE vbeln = com_kbv1-vbeln.

l_index = l_index + 1.

if l_index > 2.

exit.

endif.

ENDSELECT.

thanks & regards,

Venkatesh

Re: Reg : select & endselect

Former Member — Thu, 06 Sep 2007 06:59:43 GMT

hi narayana

your select statement should be like this

SELECT matnr

kwmeng

werks

lgort

UP TO l_index ROWS

FROM vbap

INTO table tp_vbap

WHERE vbeln = com_kbv1-vbeln.

ENDSELECT.

tp_vbap should be a table then only it can accomodate all the entries . and into table clause has to be putten on the select statement

Reward if helpfull

Thanks

rohit

Re: Reg : select & endselect

Former Member — Thu, 06 Sep 2007 07:01:10 GMT

sory correction in my previous reply plz remove the endselect statement

Re: Reg : select & endselect

Former Member — Thu, 06 Sep 2007 07:01:36 GMT

I hope tp_vbap is an internal table,

SELECT matnr

kwmeng

werks

lgort

UP TO l_index ROWS

FROM vbap

INTO tp_vbap

WHERE vbeln = com_kbv1-vbeln.

APPEND tp_vbap.

CLEAR tp_vbap.

ENDSELECT.

regards,

Prabhu

reward if it is helpful

Re: Reg : select & endselect

varma_narayana — Thu, 06 Sep 2007 07:03:51 GMT

Hi..

here what is the Value of l_index (If it is 1 then it will read only one row)

So check the value of l_index...

Then try like this to see the No of rows using SY-DBCNT.

SELECT matnr

kwmeng

werks

lgort

UP TO l_index ROWS

FROM vbap

INTO tp_vbap

WHERE vbeln = com_kbv1-vbeln.

write:/ SY-DBCNT, TP_VBAP-MATNR.

ENDSELECT.

REWARD IF HELPFUL.