Derive Classification value from material master

[saurabh_goel6]

Gurus!

I am using accounting based COPA and I need to derive classification value maintained in material master.

I have tried using table AUSP where I could get the classification and the charatestic value, but I am unable to derive it in COPA.

Please help me (with steps), if possible.

Regards

Saurabh

[former_member674271]

Saurabh Goel,

First the charactor "Product" has been taken account for "Costing Based+Acct Based", and you've done, right?

Second to maintain the derivation. Create "Table Lookup" derivation.

In "Source Fields for Table Lookup", maintain record to lookup based on relationship to ARTNR, the product number.

In "Assignment of Table Fields to Target Fields", maintain the field from AUSP and target field of PA

Is this helpful?

[saurabh_goel6]

Walter,

The problem is that table AUSP has 6 key fields without which it is not fething the value. I do not have these values in billing document. Further, I do not want to use several user defined characteristics for this purpose.

As a result, I have opted to go with an enhancement for the same.

Thanks

Saurabh

[venkatsatish_lolla]

Hi Saurabh ,

There are two aspects to this -

01. If the classification values just contain Alphanumeric codes for each of your Characteristics then the same can be fetched into COPA using " MOVE" derivation type wherein you fetch data from table AUSP - FIELDNAME into COPA - CHARNAME.

02. If the classification values contain only numeric codes for any of your characteristics , then the same are stored differently in table AUSP . They are stored in Exponents and you would be able to see the value as 1.000005+ ( as example ) . In this scenario you have to invariably use the User exit to convert those values into a Valid number and then populate the Characteristics in COPA.

Hope this helps.

Venkat.

[Former Member]

Hello Gurus,

I am facing a similar kind of problem. We have the Product Hierarchy in the Classification View of the Material Master and each hierarchy needs to be a Characteristic in COPA.

When I tried to do table lookup in KEDR, I am getting 6 fields from AUSP table which I do not need as a characteristic. Please help to proceed further.

Thanks a lot.

Regards,

PM

[Former Member]

hi

in copa you have to define your characterstics field and value field then map it.

[saurabh_goel6]

Thanks for your response!

However, this not add anything to what I already don't know.

This does not solve my probelm.

[saurabh_goel6]

Thanks for your response!

However, this not add anything to what I already don't know.

This does not solve my probelm.