Item Master Upload

Hi, We are on E8.11. As the category codes of many records of the item master F4101 are not updated, we were trying to run the report R41804/5 to upload F4101 and F4102. But in this peculiar case, we want to insert the category codes by selecting the 'Description', as a field (I think, the report code needs to use 'Like' condition instead of 'Where' condition.) Do we have any solution to update the cat codes by selecting the 'Description' field? Also, we want to know what would happen to all the old transaction records? Which are all the tables that need to be looked at, which would be impacted by updation of category codes? Especially in case of Sales / Purchase / Inventory transactions. Which are all the tables that we must look? Please suggest.

Hi Sanket,

One trick that usually do in this kind of situation is to use the GreaterThanOrEqualTo + LessThan operators. For example:

If you want to simulate WHERE Description LIKE 'SomeTextA%':

SomeTextA1
SomeTextA2
SomeTextA3
SomeTextB1
SomeTextB2
SomeTextB3

Do:

WHERE Description is GreaterThanOrEqualTo 'SomeTextA'
AND Description is LessThan 'SomeTextB'

Hope this helps.

Vince