using structure in query

[was_wasssu]

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

[Former Member]

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

[was_wasssu]

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.

[Former Member]

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