Skip to Content
avatar image
Former Member

Product Description as alternative ID

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 31, 2011 at 06:33 AM

    HI Ahmed,

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

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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