Sales order

[Former Member]

Hi,

Is there any Transaction or Table which says that the Sales order is open.

Actually i want the list of materials which have open sales order?

Thanks

[Former Member]

VBUK TABLE

FIELD GBSTK.

space Not Relevant

A Not yet processed

B Partially processed

C Completely processed

these are the values for that field.

& VBUP too

regards

Srikanth

Message was edited by: Srikanth Kidambi

Message was edited by: Srikanth Kidambi

[Former Member]

transaction VA05

[Former Member]

Hi,

I did create a sales order of type RE(return order).

Whenever i am saving it, automatically the delivery is being created and i am not able to see it in VA05 (open orders)

Actually i have to see a list of open return orders in VA05.

Does anyone know how can i do this?

[RichHeilman]

Open sales orders can mean different things to different companies, so you will most likely have to build your own logic. For example, if a sales order has not been invoiced, it is open, then you can check against the document flow tables(VBFA) and/or the billing tables VBRK, VBRP.

Regards,

Regards,

Rich Heilman

[Former Member]

Since you wish to have the status info at material level you can check the VBUP table as it has info pertaining to line item, hence with material data.

Regards

Anurag

[Former Member]

Hi

I think transaction: VA05 will suit your requirement. This can give you the list of all materials, sales documents and the item number in the sales document and other details. If you can not view some of these details use Ctrl+F8 to add new fields to the display.

Thanks

Eswar

Note: Reward for helpful answers.

[Former Member]

Actually, i did create a return order (RE): 5055.

Now i am not able to see 5055 in VA05.

the order 5055 has status completed and delivery as open.

Do i have to make any changes in my order 5055 so that i can view it in va05?

[Former Member]

Sales returns means: u are getting the goods into ur Stock ? So u need not to consider this Order is as a Open SO ? and how can u consider this order ?.

Regards

Prabhu

[Former Member]

Hi,

I dont think the status can be set to 'open' if the delivery is done with the total quantity,

Rgds,

[Former Member]

Can you be more clear with your requirement. Is it that you want to display Order with no Sub-Sequent Documents or Order cycle is not totally completed.

Thanks

Eswar

Note: Reward for helpful Answers

[Former Member]

Currently, i do have delivery for this order.

I did goods issue to this delivery.

Currently the status of Returns delivery says being processed.....

Do i have to create a billing document for this delivery?

[Former Member]

Hi,

Yes, you can create the billing document if the PGI is done for the delivery,

Rgds,

[Former Member]

In VF01, i am getting error:

For object RV_BELEG,number range interval EZ does not exist.

Just wondering if I create a billing document, will i able to see sales order in va05 with open orders selected?

[Former Member]

Hi,

You need to maintain the number ranges for the billing document type in SNUM/SNRO transaction, the number range object for which you will have to maintain interval is RV_BELEG, after you maintain the number ranges, the billing document would be created,

Check with your Functional consultant about the range to be maintained, or if you know yourself, you can create the same,

Rgds,