Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a SAP table with a Key column lets say Member ID with number values but with Zeros appended in the front. All the values in member ID are of length 6 so if the member ID is 789 , the column shoes it like 000789 and for 87 it is showing as 000087.
i want to link this table with another table which has member ID but the values there dont have appended Zeros so the member ID woul read like 789 and 87. i am facing diffciulty in linking them. I think there would a string fuction to do the same but I m not able to find a solution for the same.
Please assit.
BR-
VJ
Use Num() to remove leading zeros.
the field with 0 use
text(num(yourIDwith000,'#0#')) to link with the other table where the ID is without 0