on 07-12-2017 11:31 AM
It is possible to add custom fields to VA05, there is a user exit available. Additional information on this can be found in Google and SAP Notes. IMHO it'd be much better solution than reinventing the wheel with a query, especially if you are "new to it".
VA05 takes advantage of the index tables, which greatly improves the performance in pre-HANA world. Also it has authorization checks and additional features, such as mass changes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sree - depending on reporting needs, and if you are on a high enough enhancement pack, consider VA06 Sales Order Monitor as an option. So far I haven't done any custom reports or queries in SD
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
May be it would have been ideal had you indicated what you were trying to achieve or what is the requirement. By the way, instead of table join (which I could see you tried with), you could have tried with Logical Database VAV
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am new to queries...will try to create on more query with logical database VAV..Thanks for the Suggestion
The customer requires output with(material group1, price group, usage field, created by, created on, change by, shipping point, delivery date, ordered quantity etc) i have created a query using join tables, as in the VA05 standard report we didn't have all these fields.
Does that sales order item have 5 schedule lines?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
we dont have 5 schedule lines...It is because of we are using VBPA table which has 5 partner functions (SP, SH, BP, PY etc) it is repeating..we have removed VBPA table Join condition now and used VBAK-KUNNR to get customer no(previously i used to get customer number(SP-sold to party) from VBPA table
Thanks for the response...we have one more scenario in same report wanted to display ship to party in report output(customized query report(VA05))
if you have any inputs please let me know
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.