Number Range Query

[Former Member]

Hi,

I have a requirement that number range for sales order and delivery to be same but it is not possible in SAP. Request if anyone can guide for solution like maybe prefix etc.

The requirement is that when we look at delivery number we should know the sales order number but without any document flow or report but by just viewing the delivery number the sales order number to be guessed correctly.

kindly help.

[Former Member]

Hi Krishna

If yor reason for having the same number range for order and delivery is just to identify one based on the other, then there is a simple solution.

Possible Solution:

Define number range starting from 1 for your sales order and for delivery keep it as 8000000001. This way you can identify your sales order number from the delivery.

However there are certain limitations in doing so.

1. When you cancel a delivery document for an order and create another delivery then the numbers will differ.

2. If there are different sales document types then definig number ranges in the above way might be difficult.

So its left to your decision how you want to go about it.

Regards

Madhu

[jignesh_mehta3]

Firstly the idea of suffix like "S" for Sales Order, "D" for Delivery seems good...

But practically speaking it would be very hard, infact impossible to continue with same numbers for Sales Orders & Deliveries.

The main reason behind this Sales Orders may be blocked, cancelled, deleted. Similarly, Deliveries may be reversed or blocked & so on...

So over a period of time Sales Order & Delivery number ranges may not run in same sequence, no matter how hard you try... This is my practical experience.

The client can anytime see the Document flow & know the preceeding / suceeding number document numbers.

Hope this helps...

Thanks,

Jignesh Mehta

[Shiva_Ram]

Why you need same number range when you can see the sales order number in the delivery line item ->Predecessor data tab?

Regards,

[former_member184555]

Hi

Your idea of maintaining prefix sounds good. The prefix can be like 'S' for the sales order number and 'D' for the delivery number. But, you should also consider the issues like, delivery split, creating multiple deliveries for the same sales order at different intervals etc.,

Thanks,

Ravi