cancel
Showing results for 
Search instead for 
Did you mean: 

All Open Sales Orders Extract to a flat file

Former Member
0 Kudos

Hi Guys,

I am basically a FI guy who has been asked to create this extarct - it would be great if you guys can help me out with it:

1) Sum of all open orders in the system which have not been shipped

2) Sum of all open orders in the system which have been shipped by not yet invoiced.

3) Sum of all open billing, invoice document created but no AR doc created.

Which tables i can consider - i have a lill. idea - VBUK and VBUP tables. What should be the criteria to get all the above.

Please help me out.

Thanks,

Maulik Shah

Accepted Solutions (0)

Answers (2)

Answers (2)

Lakshmipathi
Active Contributor
0 Kudos

Dear Maulik

1) Sum of all open orders - T.Code VA05 - Table VBBE

2) Sum of open orders shipped but not invoiced - T.Code VF04 Table VBFA. Here input M in the field Subs.doc.categ and execute. Wherever this field is blank, those are not invoiced

3) List of invoices created but Accounting document not created T.Code VFX3 - Table VBRK Field RFBSK where the status of the document would be A if Accounting document has not been generated and C if Accounting document would be created

thanks

G. Lakshmipathi

Former Member
0 Kudos

Hi Maulik Shah,

Good Day,

1) Sum of all open orders in the system which have not been shipped

Transaction VA05

2) Sum of all open orders in the system which have been shipped by not yet invoiced.

Transaction VF04

3) Sum of all open billing, invoice document created but no AR doc created.

Transaction VFX3

Best Regards,

KSK