cancel
Showing results for 
Search instead for 
Did you mean: 

How to view a summary of VA05 for customers?

0 Kudos

Hi Currently I run VA05 to get the customer wise sale. However it takes a long time because the data is pulled Sales order wise. Is there a table or a way where I can pull data for a sold to party and document type for a specific time period?

former_member30
Community Manager
Community Manager
0 Kudos

Hi and welcome to the SAP Community!

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful) and share screenshots of what you've seen/done. The more details you provide, the more likely it is that members will be able to assist you.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Cheers,

Julia SAP Community Moderator

Accepted Solutions (0)

Answers (3)

Answers (3)

jignesh_mehta3
Active Contributor

You can try to use Transaction VA05N.

You can also create a new SQVI Query by pulling the Data from respective Tables (VBRK, VBRP, etc). Here you can also define selection criteria as needed by Business.

Thanks,

cfilipiak
Explorer
0 Kudos

Using VBRK and VBRP in SQVI was the way to go.

Lakshmipathi
Active Contributor
0 Kudos

While trying to help the members, please see that you respond to a latest discussion and not an old one like this 🙂

0 Kudos

Hi karunat3

I would also recommend to use VBAK table data ,in that case speak to your abap team and request them to create a transaction code example ZV_VBAK and call VBAK in background .

Regards

Santosh Verma

Lakshmipathi
Active Contributor
0 Kudos

Not sure, in which version you are working and with what input parameters, you ran this report. In general, it will not take much time. If you are in ECC, after executing VA05, you can see Sold-To as the first input parameter where you maintain the required Sold-To and execute. Also there are couple of tabs below "List of sale orders" where you can also see "Further Sel. criteria". If you click that, you can see, you have the option to filter the report Document type wise. Also, you have a period here to restrict the search criteria. On the other hand, if you are in S/4 Hana, you have various input options which includes, Partner Functions, Customer Code, Sales Area etc.,

Even after maintaining all input fields and there is a performance issue, have a look at OSS note 541128 but this is applicable to older versions.