11-28-2007 2:29 PM
Dear All,
I have three table mara (matkl), mseg (kostl, lgort, kostl,dmbtr,waers), mkpf (budat) and one structure CSKSZ.(ktext).
I have declared one ITAB in the program. Now I want that all the data of these three tables and structure should come in itab. What will be the select statment.
Please guide me as i want to display all these data through my itab.
Thanks & Regards,
11-28-2007 3:20 PM
11-28-2007 2:35 PM
data: wa like line of itab.
select matkl
from mara
into corresponding fields of wa
where YOUR_CONDITIONS.
select kostl lgort dmbtr waers
from mseg
into corresponding fields of wa
where YOUR_CONDITIONS.
select budat
from mkpf
into corresponding fields of wa
where YOUR_CONDITIONS.
append wa to itab.
just make sure in your conditions you fill those key fields which are needed to get from mara to mseg and mkpf.
you could do this in ONE join as well.
Message was edited by:
Florian Kemmer
11-28-2007 3:20 PM