Link between plan number and Resource

Question: Hi All

Can any 1 tell me as to how can i identify a primary resource
attached to a Plan number ?
I need a list of Plan numbers where the Primary Resource
has not been maintained

Thanks in advance
Linda

Answer:
Linda - Try this table or you may have to write a small prog to query the /sapapo/plan table and this table...

Answer:
Hi

thanks for ur help but as u have suggested 2 tables ,
/sapapo/reqcap and /sapapo/plan
even if i write a query for the same what will be
the joining condition between the two
since /sapapo/plan has the plan number and
/sapapo/reqcap has a field plan number ....

These 2 fields dont seem to match ...

Thanks
Linda
Copyright ?2007 - 2008 www.jt77.com