Skip to Content
0
Former Member
Nov 19, 2007 at 05:33 PM

Change SAP Query results

64 Views

Hi All,

I'm trying to change results in SAP Query. In InfoSet -> Extras -> Code Tab -> In Code Secitoin I put some code:

DATA:l_aufnr LIKE aufk-aufnr.

DATA:l_stat LIKE jest-stat.

l_aufnr = aufk-aufnr.

IF tj02t-txt04 = 'TECO'.

EXIT.

ENDIF.

SELECT SINGLE jest~stat INTO l_stat

FROM aufk INNER JOIN jest

ON aufkobjnr = jestobjnr

WHERE jest~stat = 'I0045'

AND aufk~aufnr = l_aufnr

AND jest~inact = SPACE.

IF sy-subrc = 0.

EXIT.

ENDIF.

I'm just beginner in ABAP things and now have no idea way this code is not working properly.

Maybe anyone have some ideas.

P.S. Only with this code:

IF tj02t-txt04 = 'TECO'.

EXIT.

ENDIF.

I have results without line in which tj02t-txt04 = 'TECO'. but with the whole code I have no results but for sure there should be some........

Thanks