External number range for products

[Former Member]

Hi forum,

I try to upload product in the transaction COMMPR01 with the function: CRMXIF_PRODUCT_MATERIAL_SAVE.

Everything is OK when the product id is not a number, but my client need to give to products a number.

I assign to my category a number range extern, but it doesnt work.

The error when i debug is the next:

A |COM_PRODUCT_SETTINGS|016 |7 : Product ID 7 has an invalid format

Any suggestion or idea about this problem¿?

Thanks in advance,

Mon

[Former Member]

Hi Mon,

This might be because of the numeric product ID there. if you see the product Id you are passing is 7, which is a number. But, you convert the same and store to database it will be stored with 0 prefixed. For eg. some thing like 0000000007. Number of 0's depends on the lenght of the field.

To avoid this probably you can suffix the product id (which is a numeral here) with 0's and use them. Probably you can use PACK/UNPACK (eith of these two ABABP statements) to get the required product ID.

This should work. please try.

Best Regards,

Sruendra

[Former Member]

Hi Surendra,

Tx for ur suggestion. It helps me to solve the error.

The error was in the type of the product_id. Product_id is a char(40), so i need to fill the field with zeros in the left.

So i use: CONVERSION_EXIT_ALPHA_INPUT

Regards,

Mon