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.