i do have the following problem , can i get a solution for this pls?
i would be very greatful.
i have 7 database tables to hit to fetch data, ekko, ekpo, mara , makt, mbew, ausp, s012.
the select options are s_mtart from mara-- material type
s_spmon from s012 -- period in months
s_ekorg from t024e - purchase organisation
the required fields for display is
1. ekorg from ekko
2.matnr from ekpo,
3.maktx from makt.
4. atwrt from ausp,
5.stprs and peinh from mbew,
6. meins from mara,
7. wemgm1 to wemgm5 from ekpo,
8. netpr1 to netpr5 from ekpo
9. peinh1 to peinh5 from ekpo,
10. bprme1 to bprme5 from ekpo
where wemgm1 = sum of purchased amt of materials in month of jan.
wemgm2 = sum of purchased amount of materials in the month of feb
peinh1 to peinh5.....=== corresponding price unit for esch month
bprme1 to bprme5 = corresponding order price unit
netpr1 to 5 = corresponding price of materials
can any one tell how to define internal tables for this and how to proceed to fetch bthis data
how can i get the sum of materials purchsed in jan in one field and put it in the final internal table .
kindly can anyone help me pls
thanks in advance