Which SAP table contains the Material Classification values of type date and Numeric?

[Former Member]

Dear Experts,

I have attached a class of type 001(Material Class) to Material master(TEST) in classification view. This class contains characteristics which are of multiple Data Type NUM, DATE, CHAR etc.

My requirement is to report all the charcteristcs maintained against this material(TEST) along with contained values irrespective of Data Type.

Issue is that I am able to fetch CHAR type characterisctic values from AUSP-ATWRT but am not getting values of data types other than CHAR type.

Can anyone please suggest the table which links object-OBJEK / Internal chr no-ATINN/class type-KLART / Chr value-ATWRT(values of data type other than CHAR)

Many thanks for your help !

Regards,

Shobhit

[JL23 · Accepted solution]

Please make use of the search functionality.

Especially on weekends and holidays quicker than getting an answer in the forum

you can find such wonderful documents, wikis, discussions and blogs like this one:

http://scn.sap.com/people/srikanth.tulasi/blog/2008/12/09/issues-in-fetching-internal-characteristic...

[Former Member · Accepted solution]

Dear Jurgen,

Thanks for providing link to informative post. I have read the entire post discussed with my ABAPer but my query related to data type NUM and DATE is still unresolved as the provided tables do not contain this value.

Regards,

Shobhit

[former_member182673 · Accepted solution]

The numeric values are available in the field AUSP-ATFLV & AUSP-ATFLB. These two actually represents the range from & to values, but if you characteristic has only one value, then you will find it in the field AUSP-ATFLV.

Also the value will be in the form of exponential format.

[Former Member · Accepted solution]

Thanks for response Ramesh. Is there no other table-field where numercal value is stored ?

Where should I search for value stored for data type DATE?

[former_member182673 · Accepted solution]

Yes, if the characteristic has been defined as "Numeric", then the values with appear in AUSP-ATFLV & ATFLB only. But if you have defined it as "Character", but then enter numeric values, then this will appear in AUSP-ATWRT only.

Coming to date format, you will find the values in AUSP-ATWRT.

[Former Member · Accepted solution]

Numeric value is appearing in exponential form in AUSP-ATFLV but when my ABAPer is fetching that back to num data type(in report) the value is shown as seperated by " , " which is not desirable. Is there a way of getting rid of " , ".

[former_member182673 · Accepted solution]

Your ABAPr should find some standard function module to tackle this issue.

[Former Member]

This message was moderated.

[Former Member]

Hi

Please refer http://scn.sap.com/thread/935861 for various possibilities.