Skip to Content
0
Former Member
May 14, 2008 at 10:50 AM

Pls help me in write a join for the following code.

35 Views

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