How to get the Material Number ( MATNR ) from internal characterstic ATINN

[Former Member]

Dear All,

I am working on TX. VA02. In the Transaction i have internal characterstic value ATINN. Now i need to put the validation on this internal characterstic. The values i need are stored in the table CAWN-ATINN. Now to solve my problem i need to find the corresponding Material Number (MATNR ) for this particular internal characterstic. I am unable to link these two fields. Any help would be appreciated.

Best Regards,

Pradeep Kumar

[Former Member]

Hi,

Try CL6B t.code, enter class and class type. and select characteristic with values. system will give list of materials for that characteristics and with values.

Regards,

Chandra

[Former Member]

Thanx for your reply, however how do i get the class name and class value. As i mentioned earlier, i only have values for CAWN-ATINN field. and i want the corresponding material number for that.

regards,

pradeep

[Former Member]

furthermore, i need to write a select query to do the validation in the program. I need some link, like tables or function modules by which i could get the corresponding MATNR for the internal characterstic ATINN.

regards,

[Former Member]

Hi,

Check AUSP table.

Enter characteristic in Internal char.field and execute. I think in Object field system displays the materials.

Regards,

Chandra

[Former Member]

Hi Pradeep,

I have the same requirement. For creating a custom transaction I have the Characteristic Description and charachteristic values. I need to fetch the material number from it.

If you have found a solution, Please tell me some table or Function module for it.