2007 Jul 19 11:40 AM
Hi All,
I read one of the posts on this issue & have some understanding of what Structure is. I would like to know can i join a structure & a table? Find below the steps followed by me
1. Created an infoset, in the initial dialog box, the data source tab section, i selected 'data retrieval by program' & in the Data stucture field, entered the structure name.
2. I then added the table into my infoset, through the Extras tab. The system automatically proposed the join conditions between the table & structure.
3. I saved the infoset & asked for generation, but it gave an error saying 'Commentary <Query_head> or <Query_body> is missing'. I am not able to figure out what to do.
My requirement - To join the table MARD with Structure MDPS, so that i can have a query where i can enter the material number & plant number & view if a purchase requisition has been firmed or not (Field - FIX01).
I hope my problem is clear, await your inputs.
Vivek
2007 Jul 19 12:02 PM
Hi,
The structure gets populated from the values which are entered in the transaction itself.
Thanks,
Sandeep.
2007 Jul 19 11:43 AM
Hi Vivek,
You cannot create a Query based on a join of Tables and Structures.
You would write a select query to fetch data from tables and not from structure, as structures would not hold data until runtime.
In your case you need to find out the table from which the mentioned structure pulls the data. Once u find out ur table you can perform join on the tables mentioned.
<b>Rewards points if this info helps</b>,
Kiran
2007 Jul 19 11:57 AM
Hi Kiran,
Thanks a lot for that info, but how can i know which table is the structure MDPS pulling the information from. I am looking for the field FIX01 in MDPS structure. Await your inputs.
Vivek
2007 Jul 19 11:59 AM
Go to the table MDTB.
YOu can join this table instead of the structure.
Regards,
Ravi
2007 Jul 19 12:45 PM
Hi Ravi,
Thanks a lot for that. I checked in table MDTB, for the field FIX01, but when i do a query it does not show the item which i am looking for. But in MD04, i see a star next to the purchase requision, indicating that it has been firmed. Can you please let me know what i should do?
Vivek
2007 Jul 19 12:02 PM
Hi,
The structure gets populated from the values which are entered in the transaction itself.
Thanks,
Sandeep.