topic Table Maintainance query in Application Development and Automation Discussions

Table Maintainance query

ajay_sharma10 — Thu, 26 Feb 2009 04:59:39 GMT

Dear Freinds ,

i made a table and maintainance generator ,

it has one of the field is date field . (eg. target date)

Now i want the user to restrict enter only last date of the month , and not other date ...

if user enter any other date of the month , then it will say an error message ..

eg. for feb 2008 user is allowed to enter 29.02.2008

for feb 2009 user is allowed to enter 28.02.2009

all the above enteries are entereed in user maintainance i.e sm30 ...

Re: Table Maintainance query

AjayJangid — Thu, 26 Feb 2009 07:09:22 GMT

Copy the Function Group Name which you have given in Table maintenance Generator. Then Go to SE80 and Change the Module Pool Program Generated.

Ajay

Re: Table Maintainance query

keerthy_k — Thu, 26 Feb 2009 09:14:45 GMT

Hi,

U can modify the Fun grp generated . And u can use the FM CALL FUNCTION 'SLS_MISC_GET_LAST_DAY_OF_MONTH'

EXPORTING

day_in = sy-datum

IMPORTING

last_day_of_month = l_date

EXCEPTIONS

day_in_not_valid = 1

OTHERS = 2.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

to get the last day of the month.

Check that l_date is same as the date entered by the user. If not equal then u can give an error msg.

Keerthi.

Re: Table Maintainance query

tarangini_katta — Thu, 26 Feb 2009 16:45:55 GMT

Hi Ajay,

U said u have created the table maintance then u will be enter the values from Sm30 as i know.

On that case create the table eventes.

With the event 05.

with in the abap editor

Can function 'FKK_LAST_DAY_OF_MONTH'.

IMPORTING

DAY_IN = traget date.

exporting.

u will get the last day of the month.

IF sy-subrc NE '0'.

raise error message

endif.

Thanks

Re: Table Maintainance query

Former Member — Fri, 27 Feb 2009 07:49:12 GMT

Hi,

use view v_tvimf. SE16-> v_tvimf. Give ur table name. Use event '01'. create form routine, and in the routine, write your code to restrict the data, or to give error message

Regards,

Arun.

Re: Table Maintainance query

Former Member — Fri, 27 Feb 2009 08:39:35 GMT

Hi ,

See this thread

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

regards,

Arun.

Re: Table Maintainance query

Former Member — Fri, 27 Feb 2009 12:24:18 GMT

Hi Ajay,

Actually instaed of entering the values why can't you give the default dates in PBO of that screen.

You can write a logic for the years and the months and assign the default value to the date field.

so it will check for the current date and be defualt it will show the last date of that month and make that field as noneditable.

so there can not be any changes to that field in table maintianence Generator.

Regards,

Madhavi

Re: Table Maintainance query

Former Member — Mon, 02 Mar 2009 06:26:25 GMT

Hi,

Use the Table Maintenance Events.In your case use the event "01-Before saving the data in the database " and code in the respective FORM.

For details on how to use table maintenance events,check below link:-

https://wiki.sdn.sap.com/wiki/x/AoOUAQ

-Regards,

Bhumika

Re: Table Maintainance query

Former Member — Mon, 02 Mar 2009 11:06:55 GMT

Hi,

check below link for table maintanance generator

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8129f164-0a01-0010-2a8e-8765287250fc

Regards,

Madhu