on 02-10-2010 7:49 PM
Hello:
My customer wants a listing of open (unbilled) sales order lines. List of everything they have ordered and do not have a bill for yet. That seems to be spread between 'Open' Sales Orders - see VA05 (no outbound delivery created yet) AND outbound deliveries that have not yet been billed - see VL06O with Billing Status not completely processed.
How can both of these be merged into one?
Is there something else that can show this TOTAL picture?
Thanks.
Go to SQVI and table join VBBE (for open order quantities) with LIKP (for delivery header data), LIPS (for item related data) and VBFA (to check any subsequent document is there against a delivery). Assign a TCode for this and hand over to end user.
thanks
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
i dont think ther's a standard report for your requirement but the easiest way for you to come with the details is to get a ABAPer do the job for you, i think its pretty much straight forward the only thing is go to the screens and press F1, go to technical settings and find the field and table. then you can create a Z report for the fields for a particular selection criteria in your cas eit should be the sales order.
hope this helps.
regards
vignesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
To show all picture you can go for z report
Take data from table VBAK,VBAP,LIKP,LIPS,VBRK,VBRP,VBFA
Kapil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
6 | |
4 | |
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.