Skip to main content

Hello Community,

I need you help in using the PQL Function QUANTITY_CONVERT

My objective is simple: I want to convert the SAP Field LIPS.BTGEW to Tons (TO). The original Unit is stored in field LIPS.GEWEI.

With this try I get an error

QUANTITY_CONVERT("LIPS"."BRGEW", FROM ("LIPS"."GEWEI"), TO ('TO'))

A PQL error is preventing this query from executing.

Syntax error near )] after reading QUANTITY_CONVERT("LIPS"."BRGEW", FROM ("LIPS"."GEWEI"), TO ('TO')] at line 32. Please refer to PQL documentation for available syntax.

 

What's the problem? If I understand the docu (https://docs.celonis.com/en/quantity_convert.html) correctly, I must not provide a conversation rates table?

This operator converts quantity units based on a QUANTITY_CONVERSION_RATES table, which is optionally provided by the user. If not provided by the user, a default QUANTITY_CONVERSION_RATES table will be used.

 

Where can I see the contents of the default QUANTITY_CONVERSION_RATES table?

Thanks for help

Best, Thomas

 

When I use it in this way, I also get an error:

QUANTITY_CONVERT("LIKP"."NTGEW", FROM("LIKP"."GEWEI"), TO('TO'), "LIKP"."VBELN")

PQL Error
A PQL error is preventing this query from executing.

Table with name ["QUANTITY_CONVERSION_RATES"] cannot be found.

 

So how can I use this PQL function correctly? How can I use the default table?

Reply


Community Code of Conduct