Skip to Content
0
Former Member
Dec 15, 2009 at 01:31 PM

shall i use inner joint for my code?

21 Views

Hi,

i written the below select statements.Can i wrote one inner joint for this below statements.

please help me regarding this

SELECT objid arbpl FROM crhd

INTO TABLE gt_chrd

WHERE arbpl in so_mdv01

AND werks in so_werks.

IF NOT gt_chrd[] IS INITIAL.

SELECT objnr ppsid FROM iflo

INTO TABLE gt_iflo

FOR ALL ENTRIES IN gt_chrd

WHERE ppsid = gt_chrd-objid.

ENDIF.

IF NOT gt_iflo[] IS INITIAL.

SELECT mpobj point FROM imptt

INTO TABLE gt_imptt

FOR ALL ENTRIES IN gt_iflo

WHERE mpobj = gt_iflo-objnr

and mptyp = 'P'.

ENDIF.