How to list incompleted sales order documents by plant or profit center

[Former Member]

Hi, Is it possible to to list incompleted sales order documents by plant or profit center? How?

Thanks very much.

[PhaniKalvagunta · Accepted solution]

Hi

You can have list of open sales orders wrt to plant and probably it may be useful to you.

This can be done with configuration so that you can add plant to the selection criteria in the T code VA05.

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

Click New Entries and enter the below fields save the changes.

Program Name - SAPMV75A

TRG (Transaction Group) - 0

Display Group - K

Event - SELK

It - 8

Field Name - WERKS

Goto VA05 and now you can see the field Plant in the Fur Sel Criteria.

Regards,

Phani Prasad

Edited by: phani.prasad on Nov 8, 2011 9:36 AM

[Former Member · Accepted solution]

Hi, Phani.

I would like to list incomplete orders. Since VA05 only list open order, all order or my order, it seems not suitable solution.

Is it possible to do the similar setting for V.02 or V_UC ?

Or is it possible to add "incomplete order" option to VA05?

Appreciate your help.

Edited by: wenyuan dong on Nov 8, 2011 5:13 AM

[Former Member · Accepted solution]

Hi wenyuan dong,

Both T.codes are used to know the list of incompletion orders,enter your sales area and status group means which data you want, like sales order or sales order and delivery or pgi.

check and revert

Regards

Ram

[PhaniKalvagunta · Accepted solution]

Hi,

You can have all the palnt wise open sales orders in VA05 and pass those values into V_UC

.Then you can have a list of all incompleted sales orders - plant wise.

Regards,

Phani Prasad

[Former Member · Accepted solution]

both reports works differently,

why not build a query report for this purpose.

[Former Member · Accepted solution]

Hi, Phani,

I'm not sure how to pass value from VA05 to V_UC. Could you kindly explain how to do it, please?

Many Thanks.

[Former Member · Accepted solution]

Hi, Alan,

I don't have access to SAP Query. That's why.

What will you do if it's implemented by Query Report?

Thanks for your suggestion.

[PhaniKalvagunta · Accepted solution]

Hi

First run the t code VA05 after entering the corresponding plant.You will get a list of documents.Copy them.

Goto V_UC and under general document data in sales document field copy this list.

Make sure that SD Doc Category under Document types is C.

Execute the report and you will get the list that meets your requirement.

Regards,

Phani Prasad

[Former Member · Accepted solution]

I Will join the tables together like

VBAKUK

VBAK

VBAP

VBAKUK-UVALL will tell incompleteness status of SO.

VBAP-WERKS will give Plant information

VBAP-PRCTR will give profit center information.

[Former Member · Accepted solution]

Thanks for all people shared valuable insight here. I followed solution by Phani, Problem Solved and Threads closed.

[Former Member]

VBUK and VBUP are Sales document header and item status tables. For example VBUK-UVALS gives you overall incompletion status of a sales document. All incompletion statuses like General, delivery, billing, pricing are there in VBUK, you can check out.

You can join VBUK with VBAK, VBAP etc to generate a report to list orders stuck in incompletion based on plant etc. This would need coding by someone who knows performance conditions well or you can try QueryViewer SQVI to create your own query without coding.

Although standard reports V.02 and V.26 are available they don't allow to list documents by plant or profit center

[Former Member]

I see what you mean. I'll give it a try first. Come back later.

Thanks very much for the input.

Edited by: wenyuan dong on Nov 8, 2011 4:59 AM