topic Re: selecting Process orders and work orders in Application Development and Automation Discussions

selecting Process orders and work orders

Former Member — Mon, 23 Jul 2007 14:43:45 GMT

Hi,

My requirement is to list Process Orders and Work Orders based on date started and equipment name.

Associated data for process orders :

date started , process order number and user id of the person who entered phase confirmation.

Associated data for work orders :

date started , work order number, operation center, maintenance history text.

How to select process orders and work orders since they both have same field name AUFNR .Do i need to write separate select statements and different internal tables or is there any table where i can relate these fields.

Any guidance is appreciated and points are rewarded.

thx.

Raghu

Re: selecting Process orders and work orders

Pawan_Kesari — Mon, 23 Jul 2007 15:03:06 GMT

Master table is AUFK.

I guess the field on which you can differenciate is AUFK-AUTYP

Re: selecting Process orders and work orders

Former Member — Mon, 23 Jul 2007 15:16:54 GMT

In the where condition if i give AUTYP = 40 , it list process orders.

How to list work orders then? do i need to write two select statements first for work orders without specifying AUTYP and second to list process orders based on AUTYP = 40.

thx.

Raghu

Re: selecting Process orders and work orders

Pawan_Kesari — Mon, 23 Jul 2007 15:26:38 GMT

Select records without specifying AUTYP.

Then inside program loop on the internal table in which you stored all the records specifying AUTYP.

Re: selecting Process orders and work orders

Former Member — Mon, 23 Jul 2007 15:29:41 GMT

Thx Pavan, i wil try that .