Skip to Content
avatar image
Former Member

CAS Extraction

Hi,

How to extract CAS number present in all REAL_SUBs available in SAP EHS. Can anyone please explain step wise procedure? I would like to prepare following report:

Am unable to extract information using tables (ZSE16N)

CAS # SPEC ID Auth Grp Country

Regards

Karthik

Add comment
10|10000 characters needed characters exceeded

  • Dear Karthik

    proposal of Mark is the "simplest" option you can think of.

    1.) it is SAP stdanrd

    2.) it is user friendly

    3.) you don't need development

    Just execute inquiry as proposed and use stanbdard options

    If you need the information more than once (that means regularly) the ALE options might be the right choice (here you have an automatism). But other options exists as well

    C.B.

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 27, 2017 at 10:51 AM

    Hi Karthik,

    You can not use se16 for this because of inheritance / referencing of data.

    You would need to create a report for this using the Specification BAPI or API (Function Group C1F5).

    Another option could be to use the build in hit list in CG02. It displays:

    • SPEC Id
    • NUM-CAS or NUM-EINECs if no NUM-CAS is maintained

    If you search by Auht Grp you can build your own list in Excel.

    Where is Country maintained?

    Kind Regards

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Karthik

      the solution design depends on "clear requirements". Still your topic is not100% clear.

      The output variant SUB_OUTPUT is one of this in EHS which is quite flexible. There is only one "but": the EHS handling always depends a littble bit on data amount. E.g. if you would like ti use SUB_OUPTPUT with more than 1000 specs: you might get "time out"... But for daily "normal" business this output variant can be used,.

      What kind of requirement is now needed?

      First question you need to answer: should teh user do the job?

      Second question: ifanswer to first question is "no" tehn you should think of a "background" job doing something (but teh user must be abled to get in touch with the result)

      So you have lot of options to select

      C.B.

  • avatar image
    Former Member
    Mar 02, 2017 at 12:52 PM

    Dear Mark, Chris,

    Many thanks for all your input. This works. I still need to tweak little bit on output file but my main question is answered. I would build on this going forward.

    Regards

    Karthik

    Add comment
    10|10000 characters needed characters exceeded