P&PM Cloud - Conversion currency issue

[romuald_colletaz]

Hi all,

I've configured the currency conversion function in P&PM cloud. My exchange rates are stored in a Model table. My conversion function is successfully activated. When I execute it without input data, it works fine. But, as soon as I execute the conversion with data, I have the below error (CV1 is my conversion function):

currency/unit conversion error: "SAP_PAPM#SAP_PAPM"."P105ZPC0001CV1": search table error: No error; $message$=could not read currency precisions from table "H00"."SAP_PAPM"."TCURX" - invalid table name: Could not find table/view TCURX in schema SAP_PAPM: 250

TCURX is not the name of my currency table which is Y105ZPC0001MTEXC and I've checked that this table exists in my SAP_PAPM schema in the right client.

Any idea to solve this issue?

Thanks for your help,

Romuald

[zhiyitang · Accepted solution]

Hi romuald.colletaz,

When you use a custom table for the exchange rates, I'd recommend you to use another conversion type instead of the type 'M', for instance '100*' usually works well. The type 'M' apparently would haven been reserved for special purpose and it often returns errors when a custom table is used.

Best regards,

Zhiyi Tang

[romuald_colletaz]

Hi Zhiyi,

my mistake, my example wasn't relevant. I fixed it.

best regards,

Romuald

[romuald_colletaz]

Hi,

Now that the currency conversion works fine, I tried the unit conversion. I use a simple example to convert KW to KWH. Since I have no access to T006 and T006D tables, I created model tables to reproduce these 2 tables and copy the information related to units KW and KWH from an existing T006 table.

The activation of my function works fine but when I execute it the system doesn't find the units (KW to KWH in my example). I have the below message:

Message: currency/unit conversion error: "SAP_PAPM#SAP_PAPM"."P105ZPC0001CVU": search table error: No error; $message$=Conversion( "E_KW" ), row 0: could not determine valid conversion rate for value(s) 1234 from unit 'KW' to unit 'KWH'

I checked the formula generated by the function:

CONVERT_UNIT( "QUANTITY"=>E_KW, "CLIENT"=>'105', "SOURCE_UNIT_COLUMN"=>'KW', "TARGET_UNIT_COLUMN"=>'KWH', "SCHEMA"=>'SAP_PAPM#SAP_PAPM', "ERROR_HANDLING"=>'keep unconverted',"RATES_TABLE"=>'Y105ZPC0001MT06',"DIMENSION_TABLE"=>'Y105ZPC0001MT06D')

but I didn't find any issue. Any idea to investigate the issue or do you know a sample content where this function is used?

thanks for your help,

Romuald

[zhiyitang]

Well, by physical law it's impossible to convert Kilowatt to Kilowatt x Hour! They're units of different physical measures.

[romuald_colletaz]

Hi Zhiyi,

many thanks for your help. I saw that it worked fine with conversion type 100*

best regards,

Romuald

[romuald_colletaz]

Hi,

thank you for your answers. I created my own TCUR* and T006* tables. Regarding the error message, I found the solution: the name of the authoring schema was wrong.

best regards,

Romuald

[zhiyitang]

Hi romuald.colletaz,

the conversion function in PaPM on-premise uses the currency related tables (TCUR*) or unit related tables (T006*) from SAP ERP (ABAP schema). And such tables are in general already maintained and managed there. While PaPM cloud isn't coupled to SAP ERP anymore, there are no such tables existing in the underlying HANA cloud tenant, therefore you would need to manage and maintain the corresponding tables in your HANA cloud tenant. For instance in the corresponding PaPM schema. We've helped you create the TCUR* tables in your cloud tenant. The function you mentioned above does work properly. We would also add this note in PaPM cloud help document.

Best regards,

Zhiyi

[romuald_colletaz]

Hi,

I've checked the help pages and also the examples available in the sample content and I didn't find any difference between my configuration and the examples provided.

regards,

Romuald

[akki0785]

Hi Romuald,

Please take a look for below from help.sap.com.

Regards,

Akshay Georaikar