Regarding PP Module tables, join condition

[Former Member]

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

[Jelena_Perfiljeva]

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

[Former Member]

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

[Former Member]

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.