Skip to Content
Former Member
Feb 25, 2007 at 03:28 PM

help required



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