Community
Application Development and Automation 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: 
Read only

Master data table lookup

Former Member

‎2007 May 03 5:15 PM

0 Likes
695

Hi We have variable entry date of month/day/year and we need to look at the last day of this month that is entered and find it in a master data table. Has anyone done this before?

Hi We have variable entry date of month/day/year and we need to look at the last day of this month that is entered and find it in a master data table. Has anyone done this before?

Reply
4 REPLIES 4
Read only

Former Member

‎2007 May 03 5:19 PM

0 Likes
664

You can use function module LAST_DAY_OF_MONTHS.

Read only

Former Member
In response to Former Member

‎2007 May 03 5:25 PM

0 Likes
664

Great thanks! do you know how to look at the data in the table to get this value back?

Read only

Former Member
In response to Former Member

‎2007 May 03 5:37 PM

0 Likes
664

It is not a value stored in the tables but it is calculated .

Read only

sreeramkumar_madisetty
Active Contributor

‎2007 May 03 5:21 PM

0 Likes
664

Hi

Use the FM:

LAST_DAY_OF_MONTHS

Regards,

Sreeram