Skip to Content
avatar image
Former Member

Need Help!

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 28, 2007 at 03:20 PM

    Hi Abhay,

    You can not get the data from structure.

    Regards,

    Satish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 28, 2007 at 02: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

    Add comment
    10|10000 characters needed characters exceeded