limited number of Assessment within VAT's?

[former_member602203]

Hi Gurus,

strange syntome in CG02: I have a VAT with almost 100 of assessments. If I will enter values in CG02, I can't scroll down to the end of the whole list, I can onnly scroll the half of the VAT's...I have hadn't found any OSS note.

[christoph_bergemann]

Hello

i would assume that may be in our system we have as well some cases with more then 100 data records. But first question would be:

1.) you use a SAP standard property?

2.) you have set up property correct (assumption)

3.) do you have activated any of the possible "exits/badis" for property maintenance?

For the topic of "invert axis": if the VAT does have to many characteristics or the VAt does have to much data record: you can not "invert" as wished

But may be a "trick" might help; If you have a class based property and you use the "normal screens" of SAP you can not only "sort" but you can "filter". The filter works per "columns" of the "screen";

If you use the "filter" option: then by "coluimn" (= e.g. characteristic) you can use teh "f4" help of the filter. Normally SAP should now show all "values" for all data records

Using the "stupid" example of "color". May be you have "green", "yellow" etc. as value. Now you can "refine" the data records by applying the filter

Please test this: Can you at least generate a new VAT data records in such situatiotns?

It is clear that if you cannort scroll "perfect" than it might not be easy to "update" or "delete" data records. But may be then teh "filter" option is "ok"

I need to check our system if i can find such an example and I will then check regarding the "scroll"

C:B:

PS: In your screen I can not see the "filter" button; but it should be there

[former_member602203 · Accepted solution]

Hi together,

see OSS 1470313

[christoph_bergemann · Accepted solution]

Dear Holger

I checked the note. Now I understood better your challenge. I have no clue why you are using EHS as you are doing it but according to my understanding of the SAP note: You can extend the needed ABAP part and then you will succeed (that is my guess)

C.B.

PS: keep in mind: because of many reasons: There is a trend at SAP to "split" properties. They started with one "OEL" property; now we have four (per region one). I would suggest to check your data modell once. in SAP standard there is some example of a EHS class with many characteristics; but we do not have many similar examples

[former_member602203]

Hello Christoph,

of course you have had given helpful answers in the past to me, so I will answer you as well.

1.) I dont use standard properties for that case,

2.) yes I mean there are correct, because these are the same characteristics from the "first Version" where I used more than one class/vat

3.) I think there is al Standard, no UserExits or BadI's are in place

I can create new VAT's, Instances as usal.

You are right regarding the "filter". Now as you mentioned I see there is NO filter option possible although the filter option in "personalize toolbar" is active. But I check other specification categories and hole EHS and we have without excetions no "filter" in system. Is there a general switch or setting which should be switched on???

Thanks so far, I go one with your next comment.

[christoph_bergemann]

Dear Holger

regarding the "filter option"... what i can see (in reference to your picture) in our system the icons do have a different sequence

The most keft is the "invert icon" (if you do not create new data records); we have a quite old SAP release; and here we have the filter (and there is as well no modification, exit etc. used which i am aware about which might influence this)

I tried to find the place for the "icon" bar in the SAP EHS. Overall: there was no success. But there are some functions groups etc. in place which are needed for "preparation" of the output of the "subscreen" (of a VAT).

But you are showing the "Edit" mode. I did only check the "display" modein our system

The issue is. SAP has provided really a big framework for transaction "cg02/cg02bd"; there are to many places there you can "change" the look and feel.

E.g. with some release there was a change in look and feel for VATs of type "B" and "C" (new screen with much more capability are available):

I could not find by hazard a property in our system with so many data records. I would be interested to read some feadback for the "OSS dialog"

I hope you will find a solution

C.B.

[christoph_bergemann]

Dear Holger

quite interesting explanation...(and challenge).

I would like to explain what i have understood. Based on this understanding i have a proposal how you may be can handle your challenge.

1.) You create a specification (assumption of type "REAL_SUB)

2.) then you are executing on the "real" chemistry lot of measurements (e.g. may be depending on slight differences in compositions or what ever).

3.) then you would like to "write" down the resutls of the measurement by using GC02 and maintaining data based on the "initial" conditions of the measurement

I call it now "measurement" number is the "header" combining the "inital conditions" and the "results (this is your story with the "sort number")

By change of data model you might get a solution. Proposal could be:

1.) invent a new specification type (e.g. call it "measurement"); define some property tree and assign this to the specification type; use some "unique identifier" for identifing the "measurement" number (like NAM, SYN; some "NUM" whatever).

Now you have some initial conditions (for measurement). These you should as well be stored on specification level; then you can store as well the measurement results in the property tree

Now you have e.g. a "REAL_SUB" and many "measurement" specifications; you would now like to link them. This could be done by using e.g. a property of type "composition" or "spec listing"

For any new "measurement" you would just generate a new spec. Then you need "only" to enter the new spec to REAL_SUB in the composition (as this is the link between REAL_Sub and measurement conditions and result)

If you need then some "output": the next best step might be to generate/define/specify a new "outputvariant"

The story could be like:

1.) generate a hit list of REAL_SUB

2.) use the "output variant"

The output variant could have this logic. Check the property tree (VAT) in which the composition is stored (which links to the "Measurement specs").

Collect all "specs". now you need to define "only" the wished "output". E.g. one output might be clearly list the "measurement identifer "describing the "measurement"; the you can define to do an output of "conditions" and "results" (which are stored on "measurement" specification); the output should be designed always to "link" initial conditions and the show the "output")

You can as well use a "WWI" approach (instead of output variant) to generate an "output"; the main difference would be: you will generate a document which can be stored in DMS and you have the option to use "versions"

I hope that my idea does have some value for you

C.B.

[former_member602203]

Hello Mark,

There's always a first time. 🙂 Ok, lets back to the problem and your questions. (I didn't expect so a huge interessting in this question, so I try to explain even the OSS is already on the way to SAP)

To add almost 100 of characteristics to one class / property is (unfortunately) a workaround which is not based only of my thoughs. Even a very experienced EHS Consultant recommend that as the "only way" for our business case. (you and he has the same EHS origin as I have taken from your CV) These are the main reasons for:

1) we have chemical/techni system with different initial conditions which influnce the mechnical properties like density, strenght for each measurement series....(in summary almost 100 properties /characteristics) These inital conditions like a head of the "subordinated" mechanical properties. The challange is to "link" the initial conditions to the related property. The instance number (my first thought) doesnt fulfil that requirement, which bring us to point

2.) we want to search not across the instance numbers of valutions with the CG02 search dialog. We want to enter the values for e.g. density and strenght and get the hit for ONE measaurement series which means the same instance# for all mechanical properties.

3.) furthermore we would like to use a WWI print out which shows the mechan properties related to the intial cond. in one table column by column.

4.) finally some measurement series could be just for histroic documentation in CG02 and dont should be print out. ->so we cant use a fix logic which related to the instance# of "head and subordinated..."

Thanks and I will inform you how ist going on....

[Mark-Pfister]

Hello Holger,

I've been doing EHS since 1998 and I never came across a property at one of my clients that had close to 100 characteristics assigned to one property / class. So I'm wondering a bit what the use case is - not saying that it wouldn't make sense - it's just not a common set-up.

Couldn't you split them up over multiple properties?

You could open up an OSS message...

Best

Mark

[former_member602203]

thanks, I tried page down, tabulator key, invert axles .... nothing works

[former_member3035]

And Invert axis? Can you check that? I upload screenshot recently in my above comment. It will make your Vertical list into horizontal !

[former_member602203]

dosn't work to invert axis... scroll sideway (horizontally) stopped at the same assessment as in vertically view

[former_member3035]

Understand now - You have lots of characteristic available - But unable to scroll till last - Have to try to use "Page Down" key in keyboard its allow to reach you till end?

Meanwhile I will also look other possible way to solve this.

Try also to click on 'Invert Axis' icon - I highlight in screenshot ! Let me know if it allow you now to scroll left & right side?

Thanks

Idrees

[former_member602203]

Hi Mohammed,

thanks, please see attached

[former_member3035]

Hello Holger,

Can you provide more details? You have Value Assignment which has 100 of Instances? Right ? Assessment means ? what exactly you are referring when you say 'Assessment'?

Can you share screenshot - Where you are unable to do scrolling ?