Custom Currency Reference in SQ02

[NooruBohra]

Hi Everyone,

I am trying to create an additional field in SQ02 infoset. The new field is calculated in code which is working fine. The problem is with the Currency Reference. As mentioned in the screenshot below I'm not able to put the currency reference field due to which the decimal places are coming incorrectly.

Any help on how to add a reference to currency can be done here?

Thanks,
Nooruddin Bohra

[Sandra_Rossi]

Whatever it's for SAP Query or other SAP frameworks, the relationship between currency amount and currency key fields is done via DDIC table/structure.

For SAP Query infoset, do that:

1. In SE11, find or create a table/structure with both currency amount and currency key fields (a relationship has to be defined between them), let say they are named ZZCURR and ZZCUKY
2. In the infoset, you must add an "additional structure", give any dummy name XXX and select the DDIC table/structure, and you'll see that the amount field ZZCURR will have as reference field XXX-ZZCUKY.
3. Enter code for the additional structure, initialize XXX-ZZCURR with the amount and XXX-ZZCUKY with the currency key you want. For instance, 3.14 JPY will be output 314 JPY

[NooruBohra]

Thank you Sandra. It was really helpful.