I have a requirement of having to select material no.. and material type based on the plant entered on the selection screen .After getting into an internal table itab_table3 then filtering the data from mchb table for the materials obtained from the first select query .but when checked in debugging mode corresponding to the plant and material number batch is not getting populated in the internal table .thanx in advance .....
SELECT werks mtart matnr INTO CORRESPONDING FIELDS OF TABLE itab_table3
FROM ZWM_TBL_MAT_ALOG
WHERE werks IN s_werks.
SELECT werks matnr FROM MCHB
INTO CORRESPONDING FIELDS OF TABLE itab_mchb
FOR ALL ENTRIES IN itab_table3
WHERE matnr = itab_table3-matnr
AND werks in s_werks.
Edited by: Ambarish annapureddy on Jul 22, 2008 10:05 AM