Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Reading Dates from Optimizer Log

former_member477235
Member

‎12-01-2019 11:38 PM

0 Kudos

Hello Experts

We need to read Stock Transfer(IT_ARCMAT) from Optimizer Log for reporting purposes. While we are able to find most of the data in table /SAPAPO/SNPOPARM, we are facing issues in reading the dates. The SNPOPLOG dates are in the format MM.DD.YYYY (or DD.MM.YYYY depending on system settings), however, the dates in the table are in Integer format.

I was not able to find a FM or another table through which we can convert the Integer format to Date format. Please let me know if you have any suggestions.

Thanks for your help.

1 REPLY 1

rupesh_brahmankar3
Active Contributor

‎12-03-2019 10:35 AM

0 Kudos

Hello,

Did you check transaction /SAPAPO/SNPOPLOG? How it fetch the data.

FM used are,

/SAPAPO/MSDP_OPT_SAVE_INP_LOG Save Optimizer Input Log /SAPAPO/MSDP_OPT_SAVE_OUTP_LOG Save Optimizer Output Log

Best Regards,

R.Brahmankar