on 09-12-2009 12:01 PM
Hello thr,
Could someone please suggest a report that shows actual shipping address from orders. I am trying to find out if there is a report in SAP that shows the actual shipping address from an order along with the ship-to number that was used. Most reports appear to take the ship-to number and go to master data to obtain the name and address of the customer. However, I would like to see the actual ship-to address that was used in the order.
Could someone please suggest if there is any such report.
The requirement was met using a BW report.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Goto VBPA table and enter sales document number. system will show all the partners with numbers.
Select the ship to party and choose details, take the value from address field e.g 90000374.
Now goto ADRC table , enter address number e.g 9000000374. and choose details. System will show you ship to party address (address maintained in sales order).
Regards,
Chandrasekhar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Swetha,
With reference to each order, to get the ship to party in a report is not available in standard SAP.However to get the customer wise address is possible in the report VCUST.Hope this will meet your requirement.
Regards,
Nithin.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Better to join two Tables as KNA1 - Name1 & LIKP - KUNNR through SQVI.
Hope it can fulfill your requirements.
Best Regards,
Ankur
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.