Skip to Content
author's profile photo Former Member
Former Member

Regarding PP Module tables, join condition

Hi friends,

my requirement is to join plaf & resb tables in PP modules so i need on condition to put on what fields either plnuf or rsnum.

another requirement is to join afko & resb tables in PP modules so i need on condition to put on what fields either aufnr or rsnum.

so i need the condition with proper reason

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Mar 21, 2008 at 09:47 PM

    There is a very useful button in SE11. It's called 'Where used'. You can find the table names where the data types are used and stuff. You might also want to check the PP tables here:

    http://www.erpgenie.com/sap/abap/tables_pp.htm

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 22, 2008 at 01:03 PM

    hi use this ...taking as the rsnum as key field...

    tables:afko,resb.

    data: begin of it_AFKO occurs 0,

    RSNUM like afko-RSNUM,

    GLTRP like afko-GLTRP,

    GSTRP like afko-GSTRP,

    GAMNG like afko-GAMNG,

    PLNBEZ like afko-PLNBEZ,

    end of it_afko.

    data:begin of it_RESB occurs 0,

    RSNUM like resb-RSNUM,

    RSPOS like resb-RSPOS,

    RSART like resb-RSART,

    BDART like resb-BDART,

    end of it_resb.

    select-options: s_rsnum for afko-rsnum.

    select RSNUM

    GLTRP

    GSTRP

    GAMNG

    PLNBEZ

    from afko

    into table it_afko

    where rsnum in s_rsnum.

    if not it_afko[] is initial.

    select RSNUM

    RSPOS

    RSART

    BDART

    from resb

    into table it_resb

    for all entries in it_afko

    where rsnum = it_afko-rsnum.

    endif.

    regards,

    venkat.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.