Wrong date format JJJJ-MM-TT vs. TT.MM.JJJJ

[Former Member]

Hello community.

We have upgraded our ERP from EHP3 to EHP7 (Base is 740 now).

So far everything seems to run quite well.

But we have on phenomen where we do not have a solution for right now. We already searched in the SCN and in the SAP Services but without any result.

We have an user in our order processing department with an unlogical date format. Sometimes when the user is openning a customer order in VA02 the date format looks this way: JJJJ-MM-TT.

This not the way we want it. Here is how it should look like: TT.MM.JJJJ

The problem ist that this does not happen all the time. Some time the user is opening the order and the date is correct.

Two minutes later the user is reopening the order and the date-format is wrong.

We already proofed

- country customizing

- GUI configuration

- SAP options

- user configuration

- user parameter

- authorizations

Does somebody know about a note for that problem?

Anybody facing the same problem?

Any ideas?

Thank you very much in advance.

DKarosser

[Former Member]

Hi Dominik

is this behavior happening for only this specific user ?

Or are other users ( performing exactly the same thing ) .. also facing this issue ? 

Also is this happening in all systems ( recently upgraded ) for this user ID or any specific system

If possible , create the user ID again copying it from someone else ..and see the problem persists.

Thanks

Rishi

[Former Member]

Hello all.

Thanks for the answers but we are still stuggling with that problem.

Now two other users reported the same problem in MM-transactions.

So it is not module-specific or user-specific anymore.

Any ideas?

Thanks in advance.

[Former Member]

Hi Dominik

if you are really struggling, can you answer to Rishi Das and myself?

cheers

a

[Former Member]

Hello Andrea.

Yes, we are really struggling with that.

Here are the answers:

andrea montella  wrote:

did you see the same misbehaviour using same userid in a different computer?

Answer: Now we see the misbehaviour for different users on different computers on different transactions.

when you say reopen order, you mean he/she reopens same order in a different date format?

Answer: She reopens the order and in the field for the delivery date SAP shows a different date format.

are there any enhancement against va02?

Answer: No.

Rishi Das wrote:

is this behavior happening for only this specific user ?

Answer: No, right now we have several users which reported the misbehaviour.

Or are other users ( performing exactly the same thing ) .. also facing this issue ? 

Answer: Yes.

Also is this happening in all systems ( recently upgraded ) for this user ID or any specific system

Answer: Yes.

If possible , create the user ID again copying it from someone else ..and see the problem persists.

Answer: Done, Persists.

[Former Member]

Hi Dominik

all clear

I guess you cannot isolate an example where issue happens always... Can you at least find out if only VA transactions are affected or it happens everywhere in your erp?

I had another thought about this, how do you see to put a trace on a most affected user? If you agree with the user to call you as soon as this happens we can analyze better what's going on

Meanwhile I'll give a look around

let me know

a

[Former Member]

Hi Andrea.

Also MM transactions are affected.

I will try to put a trace on the user. That is maybe a good idea.

I will get back to you with the result.

Thanks in advance.

[Former Member]

HI Dominik

perhaps you can also open an oss mex (i know that you dont have a clear case to reproduce but maybe they have already this misbehaviour in theyr great database of known errors)

let me know how it goes

a

[former_member182657]

Hi ,

Have you checked your time zone settings with Tx STZAC,also SAP picks up it's time & date from the Operating System,i suggest you to first reconfirm time zone settings on your SAP System box.After that run Tx STZAC to adjust SAP time zone settings.

Also check SAP Note 198411 .it may be helpful for you.

Thanks,

Gaurav Rana

[Former Member]

Hello all.

Thanks for your comments.

We now can reproduce the error but still do not have a solution for that problem.

Here is how the error appears.

When entering e.g. a delivery date in a "creation"-transaction like ME21N or VA01 we type DD.MM.JJJJ.

When we switch to the print preview and go back after checking the print preview the date format changed to JJJJ-MM-DD like we print on our forms.

This did not occur before the upgrade and we had no form changes.

Thanks again in advance. Hope to hear about some ideas from you gurus.

[Sriram2009]

Hi

Can you check this SAP Note 1918887 - Unexpected date format in print preview

Regards

Ram

[Former Member]

Hello everybody.

As suggested from andrea montella

we opened an ossnote and they had the correct answer for us.

The error was in a Z_form (smart forms) based on YBAA_MMPO and others.

The problem was SET_CONTRY in this coding

*initializing fields for tax totals

SELECT SINGLE land1 FROM lfa1 INTO h_land

WHERE lifnr = is_ekko-lifnr.

*

SET COUNTRY h_land.

*SET COUNTRY IS_EKKO-lands.

H_land = 'DE'

This is our new coding now:

SELECT SINGLE land1 FROM lfa1 INTO h_land
WHERE lifnr = is_ekko-lifnr.
*
if IS_EKKO-EBELN <> ' '.
SET COUNTRY h_land.
endif.
*SET COUNTRY IS_EKKO-lands.

Thanks everybody.

[Former Member]

More information might be helpful.

Which database?
Which operating system, of database server, and of SAP application servers?
More than one SAP application server?

[Former Member]

SQL 2008/R2

Windows Server 2008 R2 Enterprise

1 application server

[Sriram2009]

HI Doaminik

Can you check the user default setting data format in t-code SU01 as mention below screen shots

Regards

Sriram

[Former Member]

HI Domink

that looks really weird!

did you see the same misbehaviour using same userid in a different computer?

when you say reopen order, you mean he/she reopens same order in a different date format?

are there any enhancement against va02?

let me know

a