can any one give me optimized code for the posted query..
DATA :BEGIN OF BAPITABLE OCCURS 1,
EDITELEM LIKE TOJTB-EDITELEM,
FUNCTION LIKE SBAPIS-FUNCTION,
SHORTTEXT LIKE TFTIT-STEXT,
END OF BAPITABLE.
SELECT EDITELEM INTO (BAPITABLE-EDITELEM)
FROM TOJTB
WHERE APPLIC = APPLICATIONCODE
AND MODELONLY = 'R'
and ACTIVE = 'X'.
SELECT FUNCTION INTO (BAPITABLE-FUNCTION)
FROM SBAPIS
WHERE OBJECT = JEDITELEM.
SELECT STEXT INTO (BAPITABLE-SHORTTEXT)
FROM TFTIT
WHERE SPRAS = 'EN' AND FUNCNAME = BAPITABLE-FUNCTION.
APPEND BAPITABLE.
ENDSELECT.
ENDSELECT.
ENDSELECT.
waiting for ur replies....
RESHALI