Skip to Content
0
Former Member
Nov 19, 2008 at 06:59 AM

Inner Join vs For all entries

160 Views

Hi Forum,

Can i use a INNER JOIN and FOR ALL ENTRIES clause in a single statement ?

I have a join condition over MCH1 and MCHB.

SELECT amatnr acharg averab avfdat azusch ahsdat alifnr acuobj_bm bwerks blgort b~clabs

INTO CORRESPONDING FIELDS OF TABLE lt_batch2

FROM mch1 AS a INNER JOIN mchb AS b ON

bmatnr = amatnr AND

bcharg = acharg AND

b~matnr = i_material AND

b~werks = i_plant AND

b~lgort = i_storage_location AND

b~ersda > lc_date AND

b~lvorm NE 'X' .

Now, i want this join to be happened only for few entries which i already have in a normal internal table.

Is it possible to use FOR ALL ENTRIES here ?

Thanks,

Srini.