topic Re: using structure in query in Application Development and Automation Discussions

using structure in query

was_wasssu — Tue, 03 Feb 2009 14:29:32 GMT

How can i use a structure into a query (writing code)? In some documents (SO, PO, etc.), some fields are into a structure. How can i use that field into a query?

Thank you.

Edited by: Was Wasssu on Feb 3, 2009 3:29 PM

Re: using structure in query

Former Member — Tue, 03 Feb 2009 14:49:15 GMT

Hi Was

You may use it like



SELECT <field1> <field2> FROM <databasetable> INTO <internaltable>
WHERE <field1> EQ <structure>-<field1>
AND   <field2> EQ <structure>-<field2>.

Pushpraj

Re: using structure in query

was_wasssu — Tue, 03 Feb 2009 14:56:36 GMT

Could you give me an example? For example, how can i retrive the field EEIND form the structure MEPO1211? (this is the delivery date of the PO for a position)

Thanks.

Re: using structure in query

Former Member — Tue, 03 Feb 2009 15:02:42 GMT

You have to find the tables being used to fill the structure. I find that using transaction ST05 is a good place to start.

Rob