Skip to Content
0

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

Jan 10, 2017 at 05:37 PM

26

avatar image

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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Marcio Henrique Jan 10, 2017 at 05:43 PM
0

Follow the pictures:

Initial table


initial-table.png (12.1 kB)
final-table.png (10.9 kB)
Share
10 |10000 characters needed characters left characters exceeded
Marcio Henrique Jan 11, 2017 at 10:46 AM
0

Good morning,

Anyone please, can help me ?

Thanks,

Share
10 |10000 characters needed characters left characters exceeded