on 08-26-2020 9:26 AM
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?
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.