cancel
Showing results for 
Search instead for 
Did you mean: 

SD Report

stedmuc
Participant
0 Kudos

Good afternoon everyone

Anyone know of a report that shows the SD sales order and your invoice? Hugs

Accepted Solutions (0)

Answers (5)

Answers (5)

stedmuc
Participant
0 Kudos

Thanks to everyone for answers, for sure each one has helped me understand and also discover the existence of Query's managed to resolve the concern ... thank you ... once again thank you all.

Hugs

sanilbhandari
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi

The table VBFA is the right one for developing a report

Regards

Sanil Bhandari

Former Member
0 Kudos

Kindly use T-Code VA05N this will be more fruitful

and VF05N this is amazing standard SD reports and you can have query for VBAK TYPE ='C' and then with key to VBRK

Thanking you

moazzam_ali
Active Contributor
0 Kudos

You can create your own report in SQVI or using SQ01,SQ02,SQ03. I hope you are familiar with Query reporting. Use tables VBAK,VBRK, and VBap and VBRP for item data. search forum for getting help that how to create report using ABAP Query reporting. Its very easy. Query report will be more reliable and fast as compare to Z report.

former_member209761
Active Contributor
0 Kudos

Dear Stedmuc,

Please check the forum before posting your query.

List of sales order - VA05

List of Billing documents - VF05

If your requirement is to show the sales order + invoice in one report, i think we have to go for a Z report with

VBFA (the sales order being your preceding document and invoice will be the subsequent document,considering the subsequent document type as invoice )

Thanks & Regards,

Hegal K Charles