topic Master data table lookup in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/master-data-table-lookup/m-p/2157374#M455922 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Thu, 03 May 2007 16:15:40 GMT Former Member 2007-05-03T16:15:40Z Master data table lookup https://community.sap.com/t5/application-development-and-automation-discussions/master-data-table-lookup/m-p/2157374#M455922 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Thu, 03 May 2007 16:15:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/master-data-table-lookup/m-p/2157374#M455922 Former Member 2007-05-03T16:15:40Z Re: Master data table lookup https://community.sap.com/t5/application-development-and-automation-discussions/master-data-table-lookup/m-p/2157375#M455923 <HTML><HEAD></HEAD><BODY><P>You can use function module LAST_DAY_OF_MONTHS.</P></BODY></HTML> Thu, 03 May 2007 16:19:20 GMT https://community.sap.com/t5/application-development-and-automation-discussions/master-data-table-lookup/m-p/2157375#M455923 Former Member 2007-05-03T16:19:20Z Re: Master data table lookup https://community.sap.com/t5/application-development-and-automation-discussions/master-data-table-lookup/m-p/2157376#M455924 <HTML><HEAD></HEAD><BODY><P>Hi</P><P> Use the FM:</P><P></P><P>LAST_DAY_OF_MONTHS</P><P></P><P>Regards,</P><P>Sreeram</P></BODY></HTML> Thu, 03 May 2007 16:21:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/master-data-table-lookup/m-p/2157376#M455924 sreeramkumar_madisetty 2007-05-03T16:21:34Z Re: Master data table lookup https://community.sap.com/t5/application-development-and-automation-discussions/master-data-table-lookup/m-p/2157377#M455925 <HTML><HEAD></HEAD><BODY><P>Great thanks! do you know how to look at the data in the table to get this value back?</P></BODY></HTML> Thu, 03 May 2007 16:25:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/master-data-table-lookup/m-p/2157377#M455925 Former Member 2007-05-03T16:25:29Z Re: Master data table lookup https://community.sap.com/t5/application-development-and-automation-discussions/master-data-table-lookup/m-p/2157378#M455926 <HTML><HEAD></HEAD><BODY><P>It is not a value stored in the tables but it is calculated .</P></BODY></HTML> Thu, 03 May 2007 16:37:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/master-data-table-lookup/m-p/2157378#M455926 Former Member 2007-05-03T16:37:01Z