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:
But I always get this error:
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!!!