cancel
Showing results for 
Search instead for 
Did you mean: 

Report for delivered but not billed orders

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

JL23
Active Contributor
0 Kudos

why dont you just execute VF04 billing due list.

Former Member
0 Kudos

The reason is because at the moment the value field is blank, so i am unable to know the amount which is unbilled. If there is anyway to display the value in this field, please let me know.

Vivek

Answers (1)

Answers (1)

csaba_szommer
Active Contributor
0 Kudos

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

)

Former Member
0 Kudos

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

csaba_szommer
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

csaba_szommer
Active Contributor
0 Kudos

Sorry...please use VBRP instead of VBRK. (to connect it to LIPS)