Skip to main content
Question

Differents currency in “units”

  • September 24, 2019
  • 6 replies
  • 10 views
L
Level 5
Hi, I would not use VBAP.NETWR_CONVERTED and have the Net Value Order in the Document Currency. When I insert as KPI VBAP. NEWTR, I would like to insert in Units the Document Currency. I tried with:
  • VBAP.WAERS
  • <%=VBAP.WAERS%>
  • a variable : VBAP.WAERS
  • a variable : {VBAP.WAERS }
But it is not working. Any idea ? Thank you

6 replies

A
  • Anonymous
  • September 25, 2019
Dear Laura, Could you try it using VBAK.WAERK (header) instead VBAP.WAERS (item) ? By the way, why dont you use NETWR_CONVERTED ? If the reason is you do not get appropriate currency conversion record, you manually insert record as of today then run transformation again. Best regards, Kazuhiko
L
Level 5
  • laura.laura
  • Author
  • Level 5
  • September 25, 2019
Hi Kazuhiko, It is not working also with VBAk.WAERS. I am not using the NETWR_CONVERTED because the client want the document currency that can be in 8 differents currencies. The total of the net value is not important for him. It is just to do some check of the item on SAP. Best Laura
A
  • Anonymous
  • September 25, 2019
Dear Laura, Please type VBAk.WAERk instead.
L
Level 5
  • laura.laura
  • Author
  • Level 5
  • September 25, 2019
Sorry writing error. Below, what I tried at the moment. With VBAK.WAERK and {VBAP.WAERK } in units: With variable like VBAK.WAERK: With variable like VBAP.WAERK:
A
  • Anonymous
  • September 25, 2019
Dear Laura, I got your point. I also could not see the currency value, when determining currency field (either VBAK or VBAP) to Units field, Could you write formula in PQL editor like below ? vbap.netwr || vbap.waerk
L
Level 5
  • laura.laura
  • Author
  • Level 5
  • September 26, 2019
Hi Kazuhiko, I already tried it last week, it is working but I loose the format :
Community Code of ConductAccessibility statement