Showing results for 
Search instead for 
Did you mean: 

Identify Records in SLT Table with preceding zeros missing

0 Kudos

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?



Accepted Solutions (0)

Answers (1)

Answers (1)

Product and Topic Expert
Product and Topic Expert

Hello swapnil.thakare5

despite that is more than unsuitable to use the SLT technology to replicate data to BW instead of using the proven standard extraction via data sources, check the setup of the SLT connection in the SLT Cockpit (LTRC)

Best Regards Rolandand please follow the Rules of Engagement