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

[former_member330554]

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,

[former_member330554]

Good morning,

Anyone please, can help me ?

Thanks,

[former_member330554]

Follow the pictures:

Initial table