topic Re: Table maintenance in Application Development and Automation Discussions

Table maintenance

Former Member — Thu, 21 Sep 2006 09:54:44 GMT

Hi All,

I am creating a custom table.

1. Can the restriction be applied for only particular users?

If so how?

2. When the data is saved i need to validate the data by cross checking the existing data. How and where can it be done.

Say for e.g there are two fields valid from and valid to.

There should not be two records overlaping the date range.

How do i do it in the table maintenance?

If this is not possible with Table maintenance, then i would have to write a seperate program.

uselful ans will be awarded

thanks

Re: Table maintenance

Former Member — Thu, 21 Sep 2006 09:58:53 GMT

Hi,

1. You need to create a authorization group. Pls. refer this thread

2. Goto SE80. Select Function Group and enter your table name. Entire auto generated program would be displayed. Change the code as per your requirement

Best regards,

Prashant

Message was edited by: Prashant Patil

Re: Table maintenance

Former Member — Thu, 21 Sep 2006 10:01:34 GMT

hello,

u can do validations for table entries done vai SM30. u can do this in the program for table maintenance.

1. go to se11

2. utilities -> table maintenance generator. or SE55

3. now environment -> modifications -> events

here u can select event '05' for validations to be done before saving an entry into DBtable.

u can also check for the user like

IF SY-USNAME NE 'XXX'...

write back for more details..

reward if useful..

Re: Table maintenance

Former Member — Thu, 21 Sep 2006 10:03:40 GMT

hi,

small correction..

SY-UNAME and not sy-usname..

Re: Table maintenance

Former Member — Thu, 21 Sep 2006 10:07:15 GMT

Hi,

Point no.2 can be done. Use se80 to view your table maintenance's function group. From here search for screen no. 1000(i can not remember, as long as the screen no. use to capture the manual input). Double click into the screen no. you will get to the screen's flow logic. Put your additional module within PAI's LOOP AT xxx. ENDLOOP. And code you validation under this module.

Re: Table maintenance

Former Member — Thu, 21 Sep 2006 10:09:54 GMT

Hi,

1) BASIS can restrict user for creating

table using SE11 transaction using authorization

object

2) you can write your validations in table

maintainence screen in PAI block

of the Function group

Regards

amole

Re: Table maintenance

Former Member — Thu, 21 Sep 2006 11:13:09 GMT

Hi ,

For the custom table you are creating a program SAPZ<customtable name> will be created. You can go to the program create a Z include(Z*SODB) and inside that write your validation in Module End module.

Regards,

Balaji.

Re: Table maintenance

Former Member — Mon, 02 Oct 2006 04:04:19 GMT

thanks all for your valuable inputs.

I want to know how to access the current field entry while validating.

And i am thinking of using 01 event to write my select stmnt. if successful i do nothing, which means it would save the entry, if error then i say EXIT so that this entry is not saved and i write a error msg. please correct me.

thanks

Re: Table maintenance

Former Member — Mon, 02 Oct 2006 04:11:45 GMT

Do you want to check the field while creating the data or do you want to check while saving the data..

Thanks,

Naren

Re: Table maintenance

Former Member — Mon, 02 Oct 2006 04:46:48 GMT

What is the difference Narendran?

Re: Table maintenance

Former Member — Mon, 02 Oct 2006 04:50:28 GMT

If you are using the event '05' (Creating a new entry) you have to use the variable <table1> to get the current value..

if you are using the event '01' (Before saving the data) you have to use the internal table TOTAL to get the values...

Thanks,

Naren

Re: Table maintenance

Former Member — Mon, 02 Oct 2006 05:06:01 GMT

Thanks Narendran,

But creating a new entry means saving the data right?

Wht is the diff in 05 and 01.

I want to validate user data before saving, and return an error if invalid. which one should i use.

Also for 05 i shoudl use

<table1>-fieldname ?

for 01.

total-feildname ?

thanks

Shashi

Re: Table maintenance

Former Member — Mon, 02 Oct 2006 05:12:27 GMT

Hi,

Creating a new entry 05 means when a new entry is created in the screen and not in the database. They can even cancel and choose not to save it..

But the event 01 is called before saving the data...

TO access the field you have to do the following..

DATA: BEGIN OF WA.

INCLUDE STRUCTURE ZTABLE.

INCLUDE STRUCTURE VIMTBFLAGS.

DATA: END OF WA.

For 05 event

wa = <table1>.

if wa-field_name..

....

endif.

For 01 event

LOOP AT TOTAL.

WA = TOTAL.

if wa-fielname.

.....

endif.

ENDLOOP.

You have to move the values to the work area WA to access the fieldnames...You cannot directly use TOTAL-FIELDNAME OR <TABLE1>-FIELD..As it will give you a syntax error.

THanks,

Naren

Re: Table maintenance

Former Member — Mon, 27 Nov 2006 07:47:01 GMT

Hello,

I am trying to use your example, but , for event 01 (before save) , I always set an short dump at the wa = total statement.

The error is UC_OBJECTS_NOT_CONVERTIBLE.

Do you have any ideea what's happening?

I saw that I am not the only one with this problem here...

Thank you in advance!