Skip to Content
0
Former Member
Jul 22, 2008 at 08:05 AM

Reg : selection of fields

42 Views

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