run time error

[former_member210823]

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

[former_member184158]

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

[former_member210823]

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

how to analize it?

[former_member184158]

Just go to St22 and click on it

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

Just to know what error you have,

Regards

Ebrahim