Sales by ship to

[Former Member]

Hi ,

My client requires a report on sales orders where he will enter the sold to party but they want in the report how much total sales made for this sold to per different ship tos. like the following one :

sold to ship to total sales

123 456 10000.00

123 768 2000.00

123 987 7500.00

Is there any std report ? if sales orders are shown then it is ok.

Thanks,rajib

Edited by: Rajib Sarkar on Feb 2, 2010 7:46 AM

[Former Member · Accepted solution]

Hi,

There is no standard Report with SOLD TO & SHIP TO.

You have to write a query in SQVI with all the field you require

regards,

santosh

[Lakshmipathi]

The easiest way to achieve is that you can generate VF05 based on Ship To Party

thanks

G. Lakshmipathi

[former_member183879]

Rajib,

You can very well do this by means of ABAP query. If you are not aware of this, please discuss with a developer. They should be able to create a Query in no time. It is also possible to total the net value for the sales order for every sold to party.

Please discuss with your developer, if you don tknow how to create a query

[Former Member]

Dear Mr Sarkar,

Kindly prefer to create an LIS information structure with both the sold-to-party as well as the ship-to-party for the purpose.

Trust you find the suggestion useful.

Regards,

K Gopidas.

[Former Member]

Hi

you can use standard SAP report - MCSI etc

you will get sold to party, ship to party wise details of the sales done

thank you

[Former Member]

Hi Anirudh ,

Thanks for your reply . I was trying MCSI but I am not seeing the ship to in the selection screen or std drilldown , so how to add ship to in the report output .

Thanks,rajib