topic joins in Application Development and Automation Discussions

joins

Former Member — Sat, 25 Apr 2009 06:40:36 GMT

hi experts...

my question is ...

i have only one seletion criteria called PROJECT_ID, table for that- proj and field- pspid

and i have to obtain from that a report .

for that there is two tables-ekpo and mseg

and there are many fields ....

but no common field

i checked the threetable and find a common field named werks which is common in all ...

so my problem is that how to fetch the data using werks ...

my structure is like that

project_id

pr po po header

please guide me or give some link of that type mof problem...

thanks

Use meaningful subject line for your future questions

Edited by: Vijay Babu Dudla on Apr 25, 2009 3:00 AM

Re: joins

Former Member — Sat, 25 Apr 2009 06:47:38 GMT

hi ,

BSEG,MSEG are cluster tables you can not use joins inbetween them..

so fetch data using for all entries or from selction criteria and use read under loop.

Regards,

Prabhudas

Re: joins

Former Member — Sat, 25 Apr 2009 06:51:17 GMT

I dont understand the requirement, but, technically you can try this to connect the three tables based on PROJECT_ID. Go to the table PROJ and give the user input project ID and fetch the corresponding documents. You would get WERKS from the records fetched. Now, go to the table EKPO and based on WERKS as the selection criteria, fetch all the corresponding purchasing docs. But, there would be a lot of documents corresponding to the plants you selected from PROJ, as it is a broader selection criteria.

Re: joins

Former Member — Sat, 25 Apr 2009 08:35:11 GMT

This message was moderated.