Skip to Content

BEx Query – filter ONE characteristic for the same material – BW 70

Good afternoon,

I have must show only one value per Material (bold lines). Follow the scenario:

Line 0material 0knart Zaktnr Zkbetr 1 5980 VKP0
12,19 2 35446 VKA0 P011385086 6,99 3 35446 VKP0
10,59 4 1790 VKA0 C011686989 8,90 5 1790 VKP0
7,95

In the scenario above, for instance:

Material 1790 and 35446

I have two records, but I must show only the record that contains the value VKA0 for the Info Object 0KNART.

Material 5980

Have only one record, and this case I must show the value 12,19

Final Result:

Line 0material 0knart Zaktnr Zkbetr 1 5980 VKP0
12,19 2 35446 VKA0 P011385086 6,99 4 1790 VKA0 C011686989 8,90

Please experts, what I have to do ???

Maybe create a Customer Exit ???

Thanks and advantage,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 10, 2017 at 05:43 PM

    Follow the pictures:

    Initial table

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2017 at 10:46 AM

    Good morning,

    Anyone please, can help me ?

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded