on 04-04-2008 11:20 AM
Hi, is there any way to search for sales orders using the ship to customer number without the use of tables?
As this needs to be carried out by the user, we are looking for some report or transaction search which can find the sales order numbers using the SHIP TO detail.
Mothish Babu
Hi mothish
As you want to get the list of orders using ship to party , i think there is no standard report. So as VA05 is for the list of sales orders there you can write a report asking your ABAP'er to enter a feild for ship to party in VA05 .that is one option
Another option is , we can create our own report through Logistics Information System(LIS) .there you give the ship to party feild name and the other required tabled as per your requirement
Reward if useful
Regards
Srinath
Edited by: sri nath on Apr 6, 2008 1:03 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Babu,
Go to transaction VA02 then press F4 in the Order field system will give the options to find out the sales orders in that screen you select Sales document by Customer tab then enter the Customer number that is Ship to party number in the Partner field or enter the Partner function as 'SH' in the partner function field.
Then Execute system will give the all Sales orders which are belongs to that Partner or partner function.
I hope it will help you
Regards,
Murali.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am not sure if this is what you are asking but we can always get a hard copy of list of sales orders by ship to party by following these steps:
1. Go to VA02
2. Take teh dropdown at the order, Sleect teh tab "Sales Documents by Customer"
3. Select the partner function as SH.
4. Enter the partner number(SH number in your case).
5. Click on print locally button to get a hard copy.
Hope this helps,
Swapna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Have you tried the configuration I have mentioned above. It meets your requirement.
Thanks,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
You can add any partner functions in the VA05 - partner functions tab. This can be customised in IMG.
Use the path - IMG-Sales & Distribution - Sales - Lists -Update partner Index - execute
Here goto new entries and under the Transaction Group- 0, you can add SH and save it.
Now if you goto VA05 and look at the partner functions tab, you can see the SH also.
Thanks,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Motish,
since the VBAK table - sales order header data does not include ship to party we have to use mutiple tables to find the orders. Since its the user who is going to do this, with abapers help we can write a program to findthe required sales orders.
so the logic would be
1) find the deliveries in likp with ship to.
2) Go to VBFA tabes and input the deliveries and find the preceding document ie order with category 'C'
regards
sadhu kishore
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So, can we conclude that there are no standard SAP reports for this? If thats the case, we can close this call. Looking for few more inputs.
mothish babu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nitish, thanks for your inputs. I would like to see creating a custom report to be an last option. Before that I would like to make sure that there are no such standard report which can help us in this.
mothish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Babu,
without going into Tables..i don't think so you can do that...otherwise you can create a report which will have ship to and other parameters as input fields and based on that you will get your desired output.
Reward Points if it helps,
Regards,
N
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
14 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.