Need Help!

[Former Member]

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,

[Former Member]

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

[Former Member]

Hi Abhay,

You can not get the data from structure.

Regards,

Satish