12-05-2015 5:58 AM
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
12-05-2015 6:18 AM
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
12-05-2015 6:28 AM
I have runtime error , AFRU have 16700985 datas, and I can't get add data ,
how to analize it?
12-05-2015 6:43 AM
Just go to St22 and click on it
Just to know what error you have,
Regards
Ebrahim