I got a requirement to load data from a Text file into BI with fixed length. There is a quantity field with lenght 13 and data type as QUAN.
When I tried to map this quantity field with Quantity Key figure then it throwed error saying lenght mismatch. So I created a Characteristic Info Object with data type as Number and given length as 13.
The problem is, now I am not getting correct values for Quantity field in BI.
For eg. when Quantity is 900.00 in text file, I am getting 90000 in BW. Could anyone let me know how to solve to this issue?
Thanks in advance.