How to find Pending orders and actual orders for a plant on particular day

[Former Member]

Hi All,

I need to find the quantity of pending orders and the actual order from a plant for a specific day...

Could you please guide how I can collate this data...

Thanks,

Sanjeet

[Former Member · Accepted solution]

Suman,

Try Tcode COOIS - Product order information system, from the output result you can filter for specific date.

Regards

Sathya

[Former Member · Accepted solution]

No access to t-code COOIS...any other idea...

Thanks,

Sanjeet

[Former Member]

In COOIS ,Enter the Plant.. and execute..You will get all the orders..

If you want to get the pending orders, ( Orders which are not delivered can be the pending orders),Then in the COOIS screen,Exclude the system status DLV...

THe result can be filtered by setting filter in the Date column..

Hope this answers....

If u dont have the authorization,u can go to tables JESt and AUFK.. u can join them in SQVI..

THe status number for Delivered is I0012..

Hope this helps....

karthick

[Lakshmipathi]

Standard TCode VA05 dont have the option to choose "Plant" which you can include as follows:-

Goto IMG - Sales & Distribution --> Sales - Lists --> Define Selection Criteria

In the screen - goto New Entries and add the following details..

1. Program Name - SAPMV75A

2. TRG (Transaction Group) - 0

3. Display Group - K

4. Event - SELK

5. It - 8

6. Field Name - WERKS

Enter the details and save the changes. Goto VA05 and you can see the field PLANT in the Fur Sel Criteria.

Select "Open Order" in VA05 and execute. Whatever order is listed out, you can conclude that those are pending orders.

thanks

G. Lakshmipathi

[Former Member]

hi

for open oders check in VBBE table

regards

[former_member188076]

Hi

You may try the T-code VA05N.

Regards

AA

[Former Member]

In SAP 4.6C, I get the message "Transaction VA05N does not exist".

Is it available in ECC 6.0 or so..

Any chance to fetch this data directly from table?

Regards,

Sanjeet