Skip to main content
Question

Differents currency in “units”

  • Sep 24, 2019 3:23 PM UTC
  • 6 replies
  • 93 views

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

  • Sep 25, 2019 8:36 AM UTC
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

  • Author
  • Level 5
  • Sep 25, 2019 10:11 AM UTC
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

  • Sep 25, 2019 10:46 AM UTC
Dear Laura, Please type VBAk.WAERk instead.

  • Author
  • Level 5
  • Sep 25, 2019 12:17 PM UTC
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:

  • Sep 25, 2019 11:37 PM UTC
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

  • Author
  • Level 5
  • Sep 26, 2019 7:11 AM UTC
Hi Kazuhiko, I already tried it last week, it is working but I loose the format :