Storage of Characteristic values for a substances
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 replied
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