topic Re: run time error in Application Development and Automation Discussions

run time error

former_member210823 — Sat, 05 Dec 2015 05:58:31 GMT

I have Run time error in each select from AFRU. I used package size, index but even I can not select with packing size 10 !!!!

SELECT AFRU~AUFNR AFRU~VORNR MAX( AFRU~BUDAT )

INTO TABLE IT_OR PACKAGE SIZE 100

FROM AFRU JOIN AFKO ON AFRU~AUFNR = AFKO~AUFNR

"JOIN AUFK ON AFKO~AUFNR = AUFK~AUFNR

WHERE ( AFKO~PLNTY EQ 'N' OR AFKO~PLNTY EQ 'R' OR AFKO~PLNTY EQ 'S' OR AFKO~PLNTY EQ 'M') AND

AFRU~AUERU = 'X' AND AFRU~VORNR IN OPAND afru~budat GE DAT-LOW AND afru~budat LE DAT-HIGH AND AFKO~PLNBEZ IN MATERIAL

GROUP BY AFRU~AUFNR AFRU~VORNR .

plz help mee

Re: run time error

former_member184158 — Sat, 05 Dec 2015 06:18:30 GMT

Hi,

you have syntax error or run time error?

if you have run time error, could you just please paste the Error analysis

could you try this code and complate it.

data it_or TYPE TABLE OF Afru.

SELECT AFRU~AUFNR AFRU~VORNR MAX( AFRU~BUDAT )
    into TABLE IT_OR PACKAGE SIZE 100
      FROM AFRU JOIN AFKO ON AFRU~AUFNR = AFKO~AUFNR
                "JOIN AUFK ON AFKO~AUFNR = AUFK~AUFNR
         WHERE ( AFKO~PLNTY EQ 'N' OR AFKO~PLNTY EQ 'R' OR AFKO~PLNTY EQ 'S' OR AFKO~PLNTY EQ 'M') AND
                AFRU~AUERU = 'X'

          GROUP BY   AFRU~AUFNR AFRU~VORNR .
ENDSELECT.
BREAK-POINT.

Regards

Ebrahim

Re: run time error

former_member210823 — Sat, 05 Dec 2015 06:28:53 GMT

I have runtime error , AFRU have 16700985 datas, and I can't get add data ,

how to analize it?

Re: run time error

former_member184158 — Sat, 05 Dec 2015 06:43:51 GMT

Just go to St22 and click on it

Execute ST22 > Double click on any entries
Go to Source Code Extract

Just to know what error you have,

Regards

Ebrahim