Need help with a Bex Query Field

[Former Member]

The 'Rate' field in a Bex Query is showing all the values as $ (Amount). This field is KONV-KEBTR in ECC and can have a value as $ or %. The logic will be in KONV table, if the field KONV-KRECH(calculate.type) NOT equal to "A", then show $Amount and if KONV-KRECH = "A", then it should show %. Also, when the field KONV-KEBTR is %, the value should be value/10 (divided by 10). Please advice where is the best place to code - source system extractor or a customer exit in Bex?    Thanks!

[former_member182516]

Its better to implement the logic in Source system or you can write a field level routine and achieve this.

At BEx level - its will be a burden on the system, on the execution of the BEx query, it need to check the condition and calculate the results for output.

[Former Member]

Another workaround you can do is to create it as a NODIM and display in the BEx Query another Characteristic which shows $ or % in order to separate values.

[Former Member]

Hi Isaac,

You can achieve this in modeling and in customer exit/BAdi also. But a select statement from KONV table is expensive and hence I'd suggest you to finish this in modeling itself.

Br, H

[former_member182470]

This has to be achieved either in your extractor or in your transformation(field level routine) but not in Customer Exit.