cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Mark-Pfister
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Dear Mark.

Thank you.

This gives me the information that I am looking for.

Regards,

Sachin

Answers (1)

Answers (1)

christoph_bergemann
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Dear Christoph.

Once again a very detailed and elaborate answer, the kind that we have come to expect from you.

Thank you for sharing the information and also on your tip to ensure to frame the question correctly.

The background of my question is a request from my customer to help them find for which properties(out of the the entire properties) they have values maintained. , and I a

From Mark's and your response, I believe I will get the data. If a value is maintained (or was maintained and later deleted) then a record for it will be created in ESTVH and I can get the corresponding VAT from ESTCAT.

The requirement is to get an approximate data, so a record creation, deletion and change using any change no. will not create complexity for my specific requirement.

Regards,

Sachin

christoph_bergemann
Active Contributor
0 Kudos

Dear Sachin

regarding: The background of my question is a request from my customer to help them find for which properties(out of the the entire properties) they have values maintained. ,

in SAP EHS you will find some "default output variants". For your purpose some of them are helpful; some of them are a good starting point to "develop" something which may be fit to the customer demand

E.:G

Ouputvariant

- EXCEl

- VALUATION

- SUB_OUTPUT

EXCEL > only useful if you are interesteed in <= 50 properties in one run (lack of support of DG properties)

VALUATION => not very user friendly but ok => this should fit the demand of customer

- SUB_OUTPUT => may be good starting point for customer specific development

Remember this:

if you use CG02 with Change number you will "see" only that data which is valid for the specific date. Now by using one the output variants you can display the data in property tree.

Honestly: none of the standard output variants fits in my opinion very well  the potential customer demand; but they are a good starting point. E.g.you could develop your own one. But here comes customer demand in place.

What is "really" the interest? E.g. let us imagine: current the SATNDARD tree does have may be 200 properties (did not count them),  IF you have a "huge" list of specifications in mind (e.g. > 100) then you could set an "X" per property in output. An X would "mark".at least one data record present. BUt normally roughly 50 - 75 properties are maintained per spec). So the issue is here more or less. how to prepare a really "usefull" output for customer which "really" helps? But in my opinion: an own develop output variant is the right choice to solve the demand. At least: VALUATION or SUB_OUTPUT can be used without development

C.B.

christoph_bergemann
Active Contributor
0 Kudos

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.