topic Re: Regarding PP Module tables, join condition in Application Development and Automation Discussions

Regarding PP Module tables, join condition

Former Member — Tue, 18 Mar 2008 12:18:06 GMT

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

Re: Regarding PP Module tables, join condition

Jelena_Perfiljeva — Fri, 21 Mar 2008 21:47:35 GMT

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

Re: Regarding PP Module tables, join condition

Former Member — Sat, 22 Mar 2008 12:45:39 GMT

That is not my requirement, actually i want the on conditon on which fields should be given for the tables i mentioned earlier

Re: Regarding PP Module tables, join condition

Former Member — Sat, 22 Mar 2008 13:03:07 GMT

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.