Skip to Content
Dec 09, 2021 at 09:49 AM

Identify Records in SLT Table with preceding zeros missing

127 Views Last edit Dec 09, 2021 at 10:13 AM 3 rev

Hi Experts,

We have BW reports built on SLT Tables which are real time. However recently there were few Customers posted in ECC table without preceding zeros in it.

We we execute reports based on this table, it gives us an Alpha Conversion error and no results are being displayed.

Error Message : Characteristic Value '12345678' of characteristic 0CUSTOMER is not ALPHA Converted

Do we have a SQL script to identify all such records with missing preceding zeros from any table?