Skip to Content
avatar image
Former Member

How to find all real substances (REAL_SUB) based on characteristic values

Dear All,

I've already searched the forum but could not find an solution.

I'm a ABAP Consultant and new to EHS module, could you please help me find all the real substances which belong to a particular class or a characteristic value.

Is there any standard function module ? or a bapi so that I can make a whereused list of this characteristic value and find the respective real substances.

some thing similar to the function module <C1F0_PHRASES_USED>which finds all the real substances which belong to a particular phrase

or

also table's relation where I can find all the real substances belonging to a particular characteristic value.

Requirement:

We are planning to find all real substances' which belong to sensitizer characteristic value, so that we flag them as sensitizers.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 20, 2012 at 07:54 AM

    Hi Ashwin,

    Unfortunately there is no API available for this search functionality.

    You could use FM C1H0_SUB_FIND_BY_VALU - this is called by the CG02 transaction.

    The search parameters themselfs are set with FM C1H0_SUB_FIND_BY_VALU_PARA.

    I would suggest setting a break-point in these FMs and see how it works when called form CG02.

    Hope this helps

    Mark

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 20, 2012 at 08:17 AM

    Hello Ashwin,

    Actually, it is easier to use the search function in the main screen of CG02. Seacr for substances of the type REAL_SUB and at the botom of the screen click on "Substance with value assigned". Here you can enter in your specific characteristic either a specific value or at least flag this characteristic as being non-empty. Then create a hit list, which will show you all REAL_SUBs that carry this specific value in the the specific characteristic or have at least a value maintained in that characteristic, respectively.

    Ralph

    Add comment
    10|10000 characters needed characters exceeded