topic Re: select in Application Development and Automation Discussions

select

Former Member — Fri, 18 Apr 2008 11:14:08 GMT

In selection screen i have purchase organisation as select option..

Based on this purchase organisation i have to write a query with all the plants that is associated wid purchase organisation Can u pls tell me how 2 do??

Ekorg(PO)-T001w.

Select..........

from Marc where werks in........

how shud i get werks for the PO into select query.

Points will b rewarded....

Re: select

Former Member — Fri, 18 Apr 2008 12:08:12 GMT

hi ...

See u have to use 2 tables ....

1. Ekko -- Purchasing Document Header

2. Ekpo -- Purchasing Document Item

select-options : s_ekorg for ekko-ekorg.

Select ekorg

werks

from ekpo as a

join ekko as b

where a_{ebeln = b}ebeln

and ekorg = s_ekorg.

Re: select

Former Member — Fri, 18 Apr 2008 12:21:18 GMT

SELECT-OPTIONS : s_ekorg type T001W-EKORG.

DATA : BEGIN OF I_WERKS OCCURS 0,

werks type T001W-WERKS,

END OF I_WERKS.

Select Werks into table i_werks from T001W where EKORG in s_ekorg.

This will fetch all related data for s_ekorg in internal table i_werks

Regards,

Mohaiyuddin