on 12-21-2007 1:39 PM
Hi All,
I am trying to build a query using logical database to extract all orders for which delivery has been done, but not yet billed. I believe i can extract this data using VAV logical database, but not quite sure if i should use VAV or VFV.
Can someone let me know, which database to use & also what input conditions i need to maintain to extract only the information which i am looking for?
Hope my question is clear, await inputs.
Vivek
why dont you just execute VF04 billing due list.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Vivek,
VAV doesn't contain tables about billing documents such as VBRP & VBRK so you should try VFV.
BR
Csaba
(you can create query about sales doc., delivery doc. & billing doc. e.g. using these tables: LIKP,LIPS, VBAP, VBAK, VBRP, VBRK
http://www.erpgenie.com/abap/tables_sd.htm
)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Csaba,
Thanks for the inputs, i tried with VFV, but unable to get the info. I believe VAV should be the database to be used, as the billing has not been done & hence the billing tables will not have any data if i am right.
Also i am not sure what input conditions will help to extract the desired information.
If you have any suggestions or alternatives please let me know.
Vivek
Hi Vivek,
What I wanted to say that you won't get information from VAV about billing since as far as I know it doesn't contain any relevant table.
You should try create a query using LIKP-LIPS-(joint type: left outer)-VBRK. This will connect deliveries to billing document, you can also get SO number. Please try this.
(Sorrowully I don't know which logical database would be good for you)
BR
Csaba
Hi Csaba,
Will try to build the infoset based on your inputs & hope to get the information i need. Also will keep you updated if i manage to extract the information using the logical database.
In the meantime if you can let me know why the value field does not get filled in VF04, it would be nice. At the moment, when i run VF04, the value field is blank.
Vivek
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
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.