Where (in which table) the value of 'Value assignment' of a substance will be stored?

[VijayaKrishnaG]

Hello experts,

In my system, the value of a 'Value assignment' for a substance will be updated from a third party interface and then values are also getting updated in AUSP table.

Below screenshot is from CG02 transaction:

But later if User changes the value (45 degrees celsius) in CG02, that value is not getting updated in the table AUSP.

And, when I tried to check the technical setting of the field, it is getting redirected to a Characteristic.

How to update this manually changed value into table?

Please let me know if my query wasn't clear or if any other inputs required.

Thank you,

Vijay Krishna G.

[VijayaKrishnaG]

Hello experts,

Please someone help me with this issue.

[christoph_bergemann]

Hello

you should not focus on the "table" topic; from my point of the view the question is:

Why do you would like to know this information? (yoru topic is not clear: "How to update this manually changed value into table?")

We have so many options to read data in EHS database (several function modules / BAPIs etc.) that there is no need to drill down by your own and try to read the data

On top: If the company is using "Change management" (with key dates) the answet to your question is may be more complex.

PLease check the many threads discussing the options: how to retrieve data from EHS?

You will find a regular discussion regaridng this topic here.

E.g. on simple option is to use one of the existing "output variants"

C.B.

[former_member541723]

Vijay,

Are you looking at the correct record in table AUSP?

The AUSP OBJECT is the concatenation of the RECN and the ACTN fields from table ESTVA records and the AUSP-ATINN number from table CABN for the Characteristic. Don't forget that ESTVA and ESTVH have Valid-From and Valid-To dates, Deletion Flag, and Inactive Flag. The correct ESTVA record is based on the RECNTVH = ESTVH-RECN and ORD Sort Sequence for the instance. Also, the ESTVA record contains the RECNROOT from table ESTRH.

Best Regards,

Jim

[VijayaKrishnaG]

Hello All,

I am extremely sorry, it was my mistake and as I don't have much knowledge on EHS module and idea on Characteristic values, I couldn't understand properly how those values will get updated and where they will be updated. May be that is why I couldn't explain my issue properly.

But now I got clarity on AUSP table and Characteristic values, my issue got resolved. I was fetching only one entry (object number) from AUSP table which was updated initially. But there are other object keys generated in the table with manually (later) changed values. So, now I am fetching all the object number and reading the latest entry and able to get the updated value.

jimhermann's answer was helpful.

Once again I am sorry for unclarified query but thank you all for you responses.

Hence closing this thread!

[satya11719]

Hallo vijaykrishna.gudala

Your question is bit confusing, you said initially AUSP is not getting updated, now you are telling AUSP is updating but you cannot see it in cg02 ?? or SDS ?

As it is custom VAT , please check the complete VAT & Class , Char design first.

If everything ok , Check this note 838602 - When editing a value assignment from the property tree, the value disappears after the data...

Hope this helps.

Regards

Satya

[raymond_giuseppi]

First browse table ESTAUSP (Shadow table)

If no record found, read OSS note 2838602 - When editing a value assignment from the property tree, the value disappears after the dat... - 'Cause: Incorrect SPRO configuration' (not exactly the same case but similar/inverse statement) - Fell free to look for other notes, and even raise an incident to OSS.

[satya11719]

Hello vijaykrishna.gudala

I could see that is a custom Characteritic (Value) ? and Class SADT ?

Without knowing the complete design how the value gettting updated , it is tough to provide inputs on your question.

Regards

Satya

[VijayaKrishnaG]

Hi Satyanarayana,

Yes, the field (with value 45) which I have marked is a custom Characteristic value with Class SADT.

For the first time its getting update with some IDOC or other interface (lets say value 50), then the value in this screen (CG02) and in table AUSP it is getting updated. But if user changing this value manually (to value 45), this is not getting replicated in AUSP table as 45, there it is still 50 only.

My question is, do we have scope to update this value to AUSP table from Characteristic value?

Please find the attached screenshot, when I press F1 on that 'Value' field to check technical characters (Table / data element) it is redirected to Characteristic screen.