topic Re: Need Help! in Application Development and Automation Discussions

Need Help!

Former Member — Wed, 28 Nov 2007 14:29:47 GMT

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,

Re: Need Help!

Former Member — Wed, 28 Nov 2007 14:35:13 GMT

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

Re: Need Help!

Former Member — Wed, 28 Nov 2007 15:20:22 GMT

Hi Abhay,

You can not get the data from structure.

Regards,

Satish