on 09-30-2009 7:07 AM
Dear SAP Gurus,
my client needs to pull ot all the orders that is shipped from the existing zreport.
my plan is in the selection criteria there should be a check box for shipped , if the user click the shipped and execute the report all the orders that is shipped should come.
the existing field in the report is sold to party, ship to party,confirmed date,sales doc number, p.o number,cust mat info record,material id,requested date,confirmed date,commited date,,planned goods issue date,, delivery date , delivery number and plant.
pls let me know the logic from this existing report how to pull the orders that is shipped.
Awaiting for ur reply
Divya
Hi Divya
For your requirement , Use the tables VBEP ,VBAP , VEPVG. and the fields you need , just add in your Z report and then execute and then check the details . Your requirement can be fulfilled.
Regards
Srinath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We don't know your definition of the "shipped orders", how are we expected to "explain in detail". Have you tried to look at the tables yourself at all? Have you tried to do any research yourself, for that matter?
The status tables are VBUK and VBUP on header and item level respectively. Each item has different statuses, e.g. delivery status, billing status, etc. You can see them on the Status tab in the transactions (weren't you ever curious about those?). All the statuses can have only 4 values = blank (not relevant), A (not completed), B (partially completed), C (completed). If you want to know which orders have been referenced on delivery in full, check the delivery status on the header level. If you want to know what happened to the delivery, check the same table for the delivery #. Use your mind, analyze. That's what you're paid for.
Hi,
You wan to find the data on status of the Order or Delivery...
You can Fetch the data on VBUP table ...where you can find the Status of the Document....Whether you can Shippied or not.
Thanks
raj.
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 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.