Skip to main content

Good morning community,

 

I'm trying to perform an extraction on a sizeable SAP table (AUSP) by linking it to another table (MCH1).

 

These tables are linked through a field that is not quite the same on both tables.

 

In AUSP, this field will be a value like '000000000000003641', whereas on MCH1 this value will be '3641'

 

Since I don't know if I can use any formulas to add X amount of '0' characters (this would be using something like repeat character '0' 18-Length(3641) times), I want to convert '000000000000003641' to Integer.

 

I have tried a number of variations of the following join:

image 

But I always get this error:

image 

Can anyone point me to what I'm doing wrong? Is Datatype Conversion perhaps not available for SAP ECC? Does anyone have any other ideas?

 

This is the Celonis Documentation I am following 

 

 

 

Thank you in advance!!!

You can play with LIKE

But just in case, we use cast(COLUMN as integer) to convert to integer instead of CAST_TO_INT.

It shouldn't matter, but... just in case...

 

 

HTH


Reply