Specification numeric values formatted after saving

[janez_stupar]

Hi experts, we have an issue with number values format after saving.

After switching on change documents for ESTVA, we notice, when entering numeric value for specification characteristic, decimals are formatted from characteristic value template.

Entered value is taken as provided e.g. 20,5, than SAP add UOM where set - 20,5 mg/L;

after saving result is 20,50000 mg/L in case characteristic template is e.g :_ _ _ , _ _ _ _ _ .

Did anybody had problem with such formatting?

We know that standard behaviour for chanracteristic is to format values, but in EHS up to now numbers were always saved as entered and no changes were done with any of upgrades.

[janez_stupar]

Hi Christoph, we received answer form SAP Support. Problem was that we activate 'standard' change log on ESTVA class. Result ws that EHS didn't store numeric values to ESAUSP table anymore. Than functionality was mixed with standard change and INOB/AUSP tables. After switching off this log we get in normal functionality back.

I advice that you remove link to

https://blogs.sap.com/2014/11/06/enabling-change-documents-log-for-specification-in-ehs-specificatio.../

as it instructions are wrong.

Thanks for helping with informations,

kind regards, J.

[christoph_bergemann]

Dear Janez

by hazard. we have seen "same" issue in our system (recently). We have realized that this OSS note is missing in our system. May be check your system as well.

OSS note 1772322

C.B.

[janez_stupar]

Hello, SAP Notes when correction was made are 641422 and 614561. And both corrections are inside code, so we expect that there is another loop when saving of new value which is not considering these corrections.

[janez_stupar]

Hi Christoph,

you are right, our experience was same until few months ago. Format mask was not affecting storing of entered value to characteristic. I know that in SAP core numeric characteristic is formatted for as long I know, but we used change docs there from beginning of use. Now same behaviour is on EHS part.

We experience this on all systems and for all users. Value is displayed properly, but when I save specification change, than formatting is performed. We checked older notes for similar problem and SAP made correction for display and storing numeric values in past. Now display after entering is ok, but after storing value is formeted. And older values entered before are stored in database and displayed without formatting.

We opened note to SAP and waiting analisys. Do you experience that in SAP ECC numeric value is formatted or not if entered in shorter value ? And do you use change docs for materisl class ?

[christoph_bergemann]

Hello

the "change doc story" in EHS is "complex". We have two types of change docs. Standard change docs and EHS specific ones (I will not explain the difference here); i assume you use now the EHS specific ones? (e.g. refer to: https://www.se80.co.uk/saptables/e/est_/est_change_docs.htm and https://www.se80.co.uk/sapreports/r/rc1_/rc1_change_docs_display.htm)

The story regarding "change docs" is not asked/discussed often here,

Examples are:

https://blogs.sap.com/2014/11/06/enabling-change-documents-log-for-specification-in-ehs-specificatio...

https://archive.sap.com/discussions/thread/3948240

https://archive.sap.com/discussions/thread/3794060 => THIS IS SOMETHING DIFFERENT

https://archive.sap.com/discussions/thread/3289981

https://archive.sap.com/discussions/thread/1558792

etc.

We have to be "precise" in wording. EHS is using SAP classes of type "100"; SAP is using for material master data type "001".

The "class/characteristic" story is, according to my knowledge, the same

if you use a "numeric type characteristic (with or without UOM assignment); you can define a "template" in the characteristic used for "formatting" purposes; therefore: the "use" and handling (in user interface and SAP internally) is the same if or if not this characteristic is used in 100 EHS class or 001 MM class.

I am not aware of any issues in EHS (to make it short: nether seen your effect in one EHS project).

Keep in mind this: "numeric characteristics" are "special". So you have EST_AUSP table (instead of AUSP) in the "game".(if i remember correct).

No further help possible from my side:

But some "may be useful" hints:

Using EHS you can change the "handling" in user interface (there are lots of User/Exits, BADis in the game). I assume. You use none of these options... Because then the standard SAP approach is "overwritten" potentially by some customer specific enhancement

C.B:

.PS: as add on check may be these threads as well:

https://answers.sap.com/questions/309958/ehs-change-document-log-retention-period-change.html

https://archive.sap.com/discussions/thread/2048913

https://archive.sap.com/discussions/thread/1781964

https://archive.sap.com/discussions/thread/2007069

https://archive.sap.com/discussions/message/15631636?tstart=0#15631636

[christoph_bergemann]

Hello

the "user interface" (Sap gui) has many settings which can have effect on "display" of data in EHS. Some of the settings can be stored in the "user profile" (so that look and feel is different from user to user)

Generally. EHS tries to store the data if possible "independent" of country, log on language used etc. (e.g. data format).

Now: if we take a look on "characteristic" then we have to pay attention. There is a "format mask" linked to the characteristic

But according to my experience: if you use "2.5" as the value this should not change to "2.5000" in display. Here normally EHS is just accepting what you enter.

I would assume that the effect you see is not ! linked to the fact that you have now "change docs" in place.

Is the effect happening in development, test and live system the same?

Is the effect user specific?

C.B.