Skip to Content
avatar image
Former Member

Is there a way to find out which properties/classes are used

Hi

In a client SAP EHS implementation, is there any way to find out which properties/classes are getting used?

I am able to find out the entire list of EHS classes from table KLAH, but would like to know which of this classes are actually used by the client to maintain values and which are not.

Thanks,


Sachin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 21, 2015 at 07:26 AM

    Hi Sachin,

    DB table ESTVH contains all properties (Field ESTCAT).

    Customizing table TCG11 contains the link between properties and classes:

    TCG11-ESTCAT -> Property

    TCG11-CLVANAM -> Class

    Hope this helps

    Mark

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2015 at 07:44 PM

    Dear Sachin

    you need to pay attention with your question. The "STANDARD" tree contain value assignment having "classes" assigned and thos which haven't. Answer of Mark is therefore important.

    If you maintain a "property/value assignment" always data is written in ESTVH (if or if not a class is linked to the property).

    So in your case it is a "special" question.. Only those value assignment types having a "linked" class are of interest. Not knowing the background of this demand: once again answer of Mark is helping here.

    I am not sure (not checked it since years): if you create a data record in a "property" and delted it afterwards I believe ETVH is never "deleted" (set of "del" flag);

    So to be "precise": if you find no ESTVA entry (active, wihout del flag) then no data record is present in the corresponding value assignment type.

    But e.g. keep in mind. if you e.g. use "Change numbers" you will find ESTVH/ESTVA data records: But these need not to be "valid" for the current date.

    What is the background of your question?

    C.B.

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Sachin

      one additional comment/remark: for big companies (and even mid sized) changes are happing all the day in database. Maybe not always a change on the same spec; but including e.g. regular updates of content, use of rule sets etc. the data is more or less changed often. Even if many people believe that data in EHS is more "static"; in real life this is not the case.

      Therefore if you need deatils about data present, data deleted etc. check may be on the top:

      Discussion there could be of interest

      C.B.