topic Problem in table maintenance generator , in Application Development and Automation Discussions

Problem in table maintenance generator ,

Former Member — Tue, 29 Apr 2008 07:29:41 GMT

Dear all,

i created table maintenance genarator for one Z table and it contains CREATED ON field as pimary key field . when i am accessing data through SM30 through ENTER RESTRICTIONS. I am checking the CREATED ON field . and when giving the date in selection screen of SM30 it is not showing the records in output but data base table contain the records on that date .plz help points must be rewarded.

Re: Problem in table maintenance generator ,

former_member772790 — Tue, 29 Apr 2008 08:25:45 GMT

Hi,

please check ur table attributes in delivery and maintenance tab check box(in version 4.6c) or drop down list (in version > 4.6c). it should be checked (4.6c) or select 'display/maintenance allowed'. so that u won't get that error.

Reward if helpful.

-Prasanth

Re: Problem in table maintenance generator ,

Former Member — Tue, 29 Apr 2008 08:46:24 GMT

Hi,

Check once your table attribute whether you filled all the colums or not.

and again check your table maintainance generator attributes also like

Authorization group &NC&

function group

package

maintainance type

Reward if it useful.

Thanks in advance

lakshmi

Re: Problem in table maintenance generator ,

Former Member — Tue, 29 Apr 2008 10:27:44 GMT

i checked and created the table maintenance generator correctly . when i am accesing the data through sm30 by giving field other than date it is showing data . but when i am selected date field in sm30 selection criteria it is not showing the data and giving message no data selected in date criteria.

Re: Problem in table maintenance generator ,

Former Member — Tue, 29 Apr 2008 13:27:47 GMT

Hi,

Have you created the table with two steps? I guess the date or quantity fields don't appear in the first screen, you should try to generate the table maintenance with one step.

Reward if it useful.

Jen

Re: Problem in table maintenance generator ,

Former Member — Wed, 30 Apr 2008 09:01:47 GMT

Dear ,

i developed the TABLE MAINTENANCE GENERATOR with single step and also tried with two step also . when i am accessing data form TABLE MAINT GENERATOR by giving date in selection criteria . Table maint generator not accessing the data form database even data is their in database . plz give any idea how to access the data form table maintenance generator using date .

Re: Problem in table maintenance generator ,

vinod_vemuru2 — Wed, 30 Apr 2008 12:54:43 GMT

Hi Manoj,

I have checked this. I created a Ztable and entered data into it.

In SM30 i tried accessing using restrictions only based on date. Here if u enter the date other than user setting format

then it is saying no entries instead of throwing error saying wrong date format. Select the date from F4 help and check it once again. Also check the data in SE11/SE12/SE16 whether data exist for the given date range.

If u still have problems then delete the table maintenance and recreate it again. This may solve ur problem.

Thanks,

Vinod.

Re: Problem in table maintenance generator ,

Former Member — Fri, 02 May 2008 14:10:37 GMT

Dear ,

i deleted the table and i created the new table with new one step table maintenance generator even though when i am accessing the data through enter condition radio button by selecting the date field in selection crieteria it is not accesing the data from database even data is availalbe . i am putting the date by pressing the f4 only.

Re: Problem in table maintenance generator ,

Former Member — Mon, 05 May 2008 06:18:21 GMT

Hi Manoj,

Notes 1078292 and 1091604!

Regards,

Rekha