We are loading master data for infoobject 0IND_CODE. My issue is in master data I can see some values for industry code with leading zero and in that way it is creating two values for same industry code.
i.e there is industry code 11101 in ECC and loaded into BW system as 11101 and 0000011101. Data for other attributes are available for 11101 but its blank for 0000011101.
In reprot level user can see two records : one with data and other with # value. I dont understad why this leading zero value is appearing in BW. That leading zero value is not for all records but only for few records. I checked in ECC table and there is no leading zero value.
Please help me how to remove leading zero and cause of data getting created with leading zeros if some one has faced same set of issue.