topic Re: Code error!! in Application Development and Automation Discussions

Code error!!

Former Member — Mon, 18 Jun 2007 16:39:33 GMT

Hi All,

Can Anybody let me know what this code is supposed to do and it shows me an error with the INDEX, so please help me out.

DATA: BEGIN OF T_KNVV OCCURS 0.

INCLUDE STRUCTURE KNVV.

DATA: END OF T_KNVV.

DATA: BEGIN OF T_KNC1 OCCURS 0.

INCLUDE STRUCTURE KNC1.

DATA: END OF T_KNC1.

LOOP AT T_KNVV.

SELECT * FROM KNC1

INTO T_KNC1

ORDER BY GJAHR DESCENDING.

READ table T_KNC1 INDEX = 1.

IF T_KNC1-GJAHR GT SO_GJAHR.

EXIT.

ELSE.

ENDIF.

ENDLOOP.

Thanks!!

Re: Code error!!

Former Member — Mon, 18 Jun 2007 16:40:54 GMT

<b>READ table T_KNC1 INDEX 1.</b>

Don't mention as INDEX = 1.

Reward if its useful.

Regards,

Sail

Re: Code error!!

Former Member — Mon, 18 Jun 2007 16:47:54 GMT

It says that the SELECT SINGLE statement cannot contain the clause ORDER BY.

Re: Code error!!

Former Member — Mon, 18 Jun 2007 16:50:30 GMT

If there is any SELECT SINGLE statement it will fetch only 1 record so there is no need to mention ORDER BY . If it throws an syntax error it is correct.

ORDER BY is nothing but SORT. If there is only 1 record then no need to sort it right

Re: Code error!!

Former Member — Mon, 18 Jun 2007 16:57:18 GMT

but waht i need is to select all the records and read the ones which meet the select criteria...

so how do i write it

Re: Code error!!

Former Member — Mon, 18 Jun 2007 17:00:53 GMT

1)Better put all the conditons in where conditon of select single statement.

2)Otherwise put all data into internal table & then filter it.

1st option is good.

Reward for useful answers.

Regards,

Sail

Re: Code error!!

Former Member — Mon, 18 Jun 2007 17:03:04 GMT

Hi,

DATA: BEGIN OF T_KNVV OCCURS 0.

INCLUDE STRUCTURE KNVV.

DATA: END OF T_KNVV.

DATA: BEGIN OF T_KNC1 OCCURS 0.

INCLUDE STRUCTURE KNC1.

DATA: END OF T_KNC1.

SELECT * FROM KNC1 INTO TABLE T_KNC1 for all entries in T_KNVV

where GJAHR GT SO_GJAHR

Regards

Sudheer