CRITICAL: Local time output not available on MB51.

[Former Member]

Hi Experts,

When users are tryiong to execute MB51 they are able not able to see the local time in the output even though we have maintained their local time in their user profiles. They always see the system time in MB51 output.

Please refer to this thread for more details on the issue:

Can you please let me know if there is any setting that must be done to put local time zone into effect in MB51 output.

Appreciate your help.

Regards

Rasheed

Edited by: Rasheed Ahmad on May 31, 2011 7:27 AM

[franciskaklei]

This is the normal system behavior.

You can also refer to the following notes:

968050- Time zones in material documents (MM)

2288306- Time zones in Material Documents

[Former Member]

thanks

[Former Member]

It seems to be the only way out but I didnt understand it completely. Could you please elaborate on the procedure to get local time output for MB51.

Regards

Rasheed

[former_member187989]

Assume answered.

[mauro_bianchi]

Hi Rasheed,

The report MB51 reads the Time of entry from the header of the material document: From the table MKPF, field CPUTM.

Taking this into account, we could say that the functionality you are requesting would be possible from a technical perspective, but, unfortunately, I have to tell you that it is not included within the standard program design. Nevertheless, you should be able to enhance the program in order to achieve that it meets your requirements.

When a transaction runs, the following information is always available in the program:

SY-DATUM system date

SY-UZEIT system time

SY-DATLO local date of users timezone

SY-TIMLO local time in users timezone

SY-ZONLO users timezone (e.g. CET)

When you post a material document, some of these dates are written into the document header table MKPF:

-> SY-DATUM is written to MKPF-CPUDT (Document entry date)

-> SY-UZEIT is written to MKPF-CPUTM (Document entry time)

These information refer to system time. For several applications within the standard program it is absolutely required to know the exact system date and time, when a document has been posted. There is no way to replace the information in

MKPF-CPUTM with the user's time (SY-TIMLO), what seems to be your demand. This would terrible disturb other processes and cause other customers complains.

In addition the local date is written into the 'Posting date':

-> SY-DATLO is written to MKPF-BUDAT (if no BUDAT was entered manually)

This information, the posting date, is required information in order to derive accounting data, such as the FI period, or the currency conversion rates.

However, you could try to use some customer enhancement (User-Exit, BADI) to write the local time from field SY-TIMLO into some document field. For example using user exit LMR1M004 you could write the local time into the documentsitem text (MSEG-SGTXT). Or you could extend the header table MKPF by an APPEND and write the TIMLO into you self-defined field...

Hope this can help

Regards,

Mauro