Skip to Content
avatar image
Former Member

VA05: One Line per Item, not One Line per Schedule Line

2017-02-07-pastedimage.png

Hello!

I have an issue using VA05. The report shows multiple schedule lines for an item. I need to see one single line per item. Using variant 1SAP, I still see multiple lines per item.

Please advise.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Feb 08, 2017 at 12:54 AM

    If you wish to restore the original combination of fields for 1SAP - here are the fields and the sequence.


    If you wish to have a single line per item in VA05 - just do not use in your layout fields, which get the information from the schedule line :)

    You have schedule line quantity at the moment, of course you will get multiple lines per item... and goods issue date is from the schedule line, Order quantity is also from the schedule line, use Order Quantity instead.

    There are probably more fields in your layout, which are causing problems for the same reason - just experiment a bit with a user-specific layout.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 03, 2017 at 03:14 PM

    May be you have user role authorization issue. Check in SU01 > Parameter. There check SD_VARIANT_MAINTAIN with value "A" is set. If not, set this and retry.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07, 2017 at 10:35 PM

    VA05 is fundamentally a schedule line level report. I'm actually not sure how what you are looking for could be possibly achieved using a variant (which is just an ALV layout). You can't really use a filter for schedule line # because it could have anything in it. (Some people wrongly assume it'd always have line 1.) I guess you could sort and then subtotal by line item but that would add total lines.

    I checked this variant in our system, it doesn't have any filters or totals and shows all schedule lines (unsurprisingly). Also it doesn't really seem to be protected, so anyone with authorization would be able to overwrite it.

    I'd suggest to ask your SAP support team about this.

    Add comment
    10|10000 characters needed characters exceeded