cancel
Showing results for 
Search instead for 
Did you mean: 

To enhance va05 report

Former Member
0 Kudos

Hi All, We are using zva05 report which is a modified and enhanced version of standered VA05. We have below requirement on the same.

AS IS :- Report showing only Order Quantity colounm if at all schedule line confirmes the same day of order creation or in RDD.Which causes duplication of line items. (Order qty showing Zero confirms and other colounm showing Actual confirmes qty and therfore same line items are displayed twicely)

  

TO BE :- zva05n must show only order Qty and confirmed Qty for the same line item. So in that way duplication can be avoided.

Request you to provide technical design or logic to set-up only 02 colounms exactly simmiler with standered VA05 where we can see only Order Qty and Confirmed Qty for the same line item.

Thank you

Thanks,

SriMant

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Sri,

Standard VA05 will show duplication of line items if, confirmed qty date is different and the RDD is different. It may also show more than 2 records if a partial qty is confirmed.

So if your requirement is to eliminate the duplicate records, then how can the business know on what different dates the qtys are confirmed ? 

j_mathur
Explorer
0 Kudos

Hi Sri,

you can create a simple query using the data dump from table VBEP, here you can get the order quantity and the confirmed quantity together in the same report.

I am not sure what all data elements are further  required by your company apart from ordered quantity and confirmed quantity in this report, but this can be also easily achieved by a table join of VBAK/VBAP and VBEP.

-Jitendra