on 01-15-2014 7:10 PM
Hi Guys,
I works on FI module and I am looking for a report by which I can get the detail like Sales order#, Purchase order# and payer details in the Sales order when I update the delivery#, the report should be able to pull all these details when I run this for 200- 300 deliverys.
Even if you can provide multiple reports by which this can be achived will be of great help.
As we can see from the SAP menu, there is not much in terms of reporting for deiveries. VL06O is pretty much all there is. I'd say that normally the deliveries are not meant to stay open for long time, so most SAP customers probably don't require this kind of reporting.
Our FI users struggled for a while trying to combine Delivery Monitor data with VA05, but eventually I created a custom query for them, it's not difficult.
@Aayush - the PO is probably just the Customer PO from VBKD. A purchase order would exist in VBFA only in very specific scenarios.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
request abaper for the new custom report.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Justin,
First for find the Sales Order no, go to table LIPS enter the delivery no and then get the value of field VGBEL. this will give you the Sales Order number as shown below.
Now copy these sales order numbers and enter them in table VBPA along with partner function as PY or RG(german). you will get the corresponding payer as below:
For corresponding purchase order no, go to table VBFA enter the sales order no and in subsequent document category "V" i.e Purchase order and execute.
you will get the PO number as well. (i havev used a different Sales order in this case to show you how to find it)
Either you can run these steps manually each time or it would be much better if you get an ABAPer to right a simple report for this logic i explained. will hardly be 1 hour work.
Regards,
Aayush Jain
SAP SD Consultant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank You Aayush for the reply.. which will helped me to reduce my to long procedure.
Since I work as an end user the table names and the transaction codes doesn't helps, Ii have forwarded this procedure to the ABAP consultant of our organisation for further action.. Is it possible for you to tell me the transaction code that can be used by an AR accountant to arrive at this.. something like S_ALR_XXXXXXX, or else..
Hi Justin,
I am not aware of any S_ALR_***** report. i dont think there is any for this requirement.
Also As mentioned by Jelena below,
If you are considering Customer PO details...then instead of VBFA.. you should update your ABAPer to use table VBKD. Or if by PO, you meant a normal third party purchase order then VBFA is the correct table name.
Regards,
Aayush Jain
SAP SD Consultant
I guess only quick view would do it quickly. go to SQVI
SO #, PO # and PY Details will be in vbak
Delivery # would be vbfa
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 | |
7 | |
4 | |
4 | |
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.