selecting Process orders and work orders

[Former Member]

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

[Pawan_Kesari]

Master table is AUFK.

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

[Former Member]

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

[Pawan_Kesari]

Select records without specifying AUTYP.

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

[Former Member]

Thx Pavan, i wil try that .