Duplicate records for Sale Order Cycle Report(excluding item level detail)

[samjalees2000]

I have posted this issue in number of forums but till today no one is able to answer it correctly.Here it is:

I need to create a report which I think most of the sd consultants have also done it.It basically covers sales order cycle without item lvel detail such as:

Sale Order No -- Sales Order Date-- Delivery No-- Delivery Date

Now as we all know ,sales orders and deliveries are connected through item table which means in the output I will get duplicate rows for the report above.For Example, if a sales order share 3 items with the delivery then we will get 3 exact duplicate rows in the report.

What can be the best solution?connecting through VBFA has alos same result as it also has item level details.

I need a good solution.This a common report and there must be some solution

[former_member266852 · Accepted solution]

Hiiii,

It is standard SAP rule that system will catch the document flow (document link history) at item level.

Now your problem that you dont want to show the line item based report because of duplicacy.

Try this.

Brows table VBFA -

---

In screen selection select the following......

1. Subsiquent document category

2. Preceding item

select "J" in Subsiquent document category

and "000010" in Preceding item then execute the table.

Now system will not show multple line item based delivery report. so No duplicacy will be there

Regards

Shambhu Sarkar

[samjalees2000]

Thanx SHAMBHU.U understood the question that was the best part.

I have already tried this procedure but as we know this is a very forceful way as it will always bring a single delivery corresponding to a sales order .A delivery can be made of multiple sales order.So the method u mentioned will limit to a single sale order.

for example for delivery document 90 the data is

material 1 saleorder500

material2 saleorder700

material 3 saleorder700

ur output will be

delivery90 saleorder500

required output should be

delivery90 saleorder500

delivery90 saleorder700

Anywayz Thanx.Nice Try Friend.

[Former Member]

Hi,

I think it is only the matter of the display of the report. You have to use VBFA table to bring out the delivery number for each sales order. Ofcourse the item numbers (POSNR) is always displayed.

So, if I give it a try, I would write a logic to select all the deliveries for a particular sales order. Then, while displaying the result, I will tell the technical person (ABAPer) to display the sales order only ones and display all the delivery details related to it in the table format in front of it. I think this can be achieved by abap development. I think otherwise there is no much functional thing involved in this. I think the technial person can use ALE reporting for this and can display the results by grouping the sales orders.

Hope this helps

Thanks

Mukund S