Product Description as alternative ID

[Former Member]

Dear All,

Is it possible to make the product description as an alternative ID? and How?

I tried to make a new ID type with Database table COMM_PR_SHTEXT and field SHORT_TEXT but when I click generate type it says that Table COMM_PR_SHTEXT no longer exists or has no field with the name SHORT_TEXT

Regards,

Ahmed

[Former Member]

HI Ahmed,

you can use the database table COMM_PRSHTEXT instead and use the field 'SHORT_TEXT'.

Hope this helps.

[Former Member]

tried them but error occurs with text "No entries found in table COMC_SETTYP_ATTR"

[Former Member]

any help on this issue?

[Former Member]

I really doubt if it is possible. COMM_PR_SHTEXT is not available as set type and Alternative ids can only be created with valid set types.

Can you explain the logic behind the purpose of making Description as alternative id?

Regards,

Shaik

[Former Member]

Hi Shaik,

I have around 30,000 Product, Agents dont know the IDs of the product, they want to type the description and then the match appear as pop up.

Thanks

[Former Member]

I think you should try to use expert mode for building Alternative id for your requirement.

Select the expert mode in the initial screen , then in the expert mode select the Do Not Generate check box.. Next build your own class by copying the CL_ALTID_PRODUCT_CUSTOMER_ID and in this class try to modify the methods to read the product descriptions for alternative id. You may look at the standard class for more details.

The idea is to create an ID that needs to reference particular table ( in your case , the product descriptions table )

I guess you have to explore more on this. It is not straight forward.

Hope it helps.

Regards,

Shaik