topic Table & Structure (Urgent) in Application Development and Automation Discussions

Table & Structure (Urgent)

Former Member — Thu, 19 Jul 2007 10:40:13 GMT

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

Re: Table & Structure (Urgent)

Former Member — Thu, 19 Jul 2007 10:43:24 GMT

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

Re: Table & Structure (Urgent)

Former Member — Thu, 19 Jul 2007 10:57:36 GMT

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

Re: Table & Structure (Urgent)

Former Member — Thu, 19 Jul 2007 10:59:54 GMT

Go to the table MDTB.

YOu can join this table instead of the structure.

Regards,

Ravi

Re: Table & Structure (Urgent)

Former Member — Thu, 19 Jul 2007 11:02:59 GMT

Hi,

The structure gets populated from the values which are entered in the transaction itself.

Thanks,

Sandeep.

Re: Table & Structure (Urgent)

Former Member — Thu, 19 Jul 2007 11:45:39 GMT

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