Storage of Characteristic values for a substances

[Former Member]

Hello EHS Expert!

I need to know a table or function module to get a value attributed a substances, in mass.

For example: I need to get the phrases number(CG12) are attributed to all substances in characteristics SAP_EHS_1011_010_APPL, but for a table, not in CG02.

Could someone help me?

[Mark-Pfister · Accepted solution]

Hi Ricardo,

The characteristic values are stored in table AUSP.

You could just go into SE16SA(n) enter AUSP as table and set SAP_EHS_1011_010_APPL as ATINN (Conversion exit will kick in and translate the ATNAM to the ATINN) and KALRT = "100".

Execute and you will get a list of phrase keys assigned to that characteristic in field ATWRT.

However you will not be able to see what specification / SUBID these values have been assigned to.

If you want the specification you would need to split AUSP-OBJEK into ESTVA-RECN ESTVA-ACTN

and select with that the RECNROOT from ESTVA.

With ESTVA RENCROOT = ESTRH-RECN you get the ESTRH-SUBID -> Specification.

You can do the same with FM C1H0_SUB_FIND_BY_VALUE (used in CG02) and reading the data with API C1F5 _SUBSTANCES_READ.

Hope this helps

;ark

[Former Member · Accepted solution]

Perfect!

thank you Mark