Skip to Content

Query for list of specifications

Hi Experts,

We need to execute query which should contain list of specifications with and without material assignments.Selection criteria is based on generation variant.

Please let us know from which tables we can get the above list.

Thanks for your help!!

Regards,

Sivasankar

Message was edited by: Sivasankar P

Message was edited by: Sivasankar P

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Mar 01, 2014 at 11:53 AM

    Dear Sivasankar

    I agree to comments of the other. The generation variant (or more precise the report) is not an useful link between specification and material. As mentioned:

    ESTRH is the spec header

    ESTMJ contains material assigned to specificacion

    ESTDH represnets the "report header".

    The answer to your quesstions depend on this question:

    a.) is the analysis something which the end user should do

    b.) or is this something related to consultants

    If the answer is: a consultant should do that then use simply SAP query. Check e.g:

    any many similar ones. If the query should be done by end use you should think of adding an userexit in CG02 to do so.

    C.B.

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Sivasankar


      I am sorry to say that your explanations did not convice me: I still would do the job using the standard options in Cg02/CG54/CG50.


      These are the major reasons for using SAP Standard.

      a.) full support of SAP access concept in EHS

      b.) can be extended easily etc.

      c.) full support regarding any CG02/CG54/CG50 search option


      Let us try the other way around and start with options in CG02:


      a.) in CG02 you can use either a list of materials or a list of specifications. Result is a hit list. Only con here: if you start with list of materials you do not know which material from original list is linked to which specification. To take care this (and may be other topics) an outputvairant is the right way to do it. Outputvariants are easily to be customized and out put can be specified flexible (e.g. using ALV). In CG02 you can use on top e.g. store hit lists; you can use "dynamic" search criterias to get the specified hit list etc.

      b.) Starting in either CG54 or CG50:


      Here as well you can use either a list of specifications or materials to get the report hit list. Using higher SAP releases you can use as well list of gen variants. In CG54;CG50 you can as well use an ALV (via existing user exit) to get the output as specificied by you


      May be check:; Customer Exits in SAP EHS MANAGEMENT


      Topic of output variants is not mentioned there but of yo checl SPRO you will easily get the picture


      Ignoring access topics. the tables needed are mentioned yet. Only may be one "crucial" topic might be missing: using the report hearder you can assign additional specifications for which the report is valid. This is called as well "referencing" (e.g. check: Problem with Reference Reports Repeating twice ... | SCN). I am not sure if your query srtil support this feature (Cg02,Cg54/Cg50 are supporting that !).


      C.B.


  • Feb 27, 2014 at 05:59 AM

    Not sure why you want to link substance with gen variant in your query, but normally you will have to use MSDS report to link those two together. Technically you can use below four tables.

    ESTRH = specification header

    ESTLP = gen var

    ESTDH = report header

    ESTMJ = material assignment

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 27, 2014 at 06:16 PM

    Hi Siva,

    Check this thread Here, you can get complete list of table information.

    FYI,

    ESTRH - EHS: Specification HeaderESTVA - EHS: Value AssignmentESTVH - EHS: Specification - Value Assignment Type AssignmentESTDF - Additional Information - User-Defined TextESTVP - EHS: Value Assignment Item ESTDR - EHS: Additional Information: Value Assignment AssessmentESTDU - EHS: Additional Information: Value Assignment UsageCCRCT_EHS_COMP - EHS: Composition (EH&S Data)CCRCC_CHCK_ON - EHS: Online Checks for Regulation/Scenario/Scenario Category

    Edward

    Add comment
    10|10000 characters needed characters exceeded