cancel
Showing results for 
Search instead for 
Did you mean: 

VA05 Query Issue

former_member305466
Participant
0 Kudos

Dear Gurus

We have created a query for VA05...if we execute the query line items are getting repeated(Ex: sales order 10, line item 10...getting repeated 5 times in the output)

Join Condition

Output: order and line items are getting repeated

how can we avoid this issue

Accepted Solutions (1)

Accepted Solutions (1)

Jelena
Active Contributor
0 Kudos

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.

Answers (4)

Answers (4)

0 Kudos

'Left outer join' should help avoiding repeated lines. Right click on the connecting lines and try selecting this option.

TammyPowlas
Active Contributor
0 Kudos

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

Lakshmipathi
Active Contributor
0 Kudos

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

former_member305466
Participant
0 Kudos

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.

rob_ariaans
Contributor
0 Kudos

Does that sales order item have 5 schedule lines?

former_member305466
Participant
0 Kudos

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