cancel
Showing results for 
Search instead for 
Did you mean: 

Production Order List

Former Member
0 Kudos

Hi Friends,

I want to get the list of production orders that were released on perticluar date by a perticular user.

I have tried transactions COOIS and Header tables AFKO but i do not find user who has released the order.

Please help.

Regards,

Rohit

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member533946
Active Contributor
0 Kudos

Hi dear,

Refer below link

[http://www.sap-basis-abap.com/sappp016.htm]

Former Member
0 Kudos
      • Pls Ignore ***

Edited by: Rohit Singh on Mar 4, 2011 7:02 PM

Former Member
0 Kudos

Thanks Shankaran / Deepak,

Both of your replies were very useful.

@Shankaran: I cant create a query as i am working in production system but thanks for the helping out in giving relevant tables.

@deepak : i checked your link found that the the object status for release is I0002.

Following is the method I used to get the desired result.

Go to table JCDS table - Change Documents for System/User Statuses (tcode SE11 or SE16)

Enter status as I0002, Name as SAP user ID and Date as the "required date" and execute.

Select all the orders starting from OR*, this will gine the list of Production orders for a user on a particular date.

Thanks for quick response.

Regards,

Rohit

muthusamy_sankaran
Active Contributor
0 Kudos

Hi rohit,

The Quick Viewer ( SQVI ) can be used to generate simple report without any programming.

You can create & use in production system under your user id. the other users will not see your query.

You select fields according to your data source that determine the structure of your report. The report can be executed in basis mode with standard layout or may be edited using drag and drop.

However, only transparent table are allow to be use in SQVI.

pls refer below link

http://www.erpgenie.com/sap-technical/utilities/using-the-sqvi-transaction

regards,

sankaran

muthusamy_sankaran
Active Contributor
0 Kudos

Hi,

COOIS will not possile to get your requirments

Create a simple Query (SQVI) or ALV report using below tables

AUFK, JCDS, JEST

link fields

AUFK-objnr = JCDS-objnr

JCDS (fields objnr, stat, inact, udate, utime)

regards,

sankaran