topic Re: database table displays only current entry in Application Development and Automation Discussions

database table displays only current entry

Former Member — Wed, 09 Jan 2013 16:51:24 GMT

hello... i am facing some problem in database table....i created one database table (abap dictionary se11) after doing technical settings and TMG when i create enteries it will only display the current entry..it will not display the list of entries why?

Re: database table displays only current entry

Former Member — Wed, 09 Jan 2013 17:00:31 GMT

Hi Shilpa,

May i know how you are trying to see the entries. from se11? and it is showing only 1 entries into the table? is it?

I think when you are maintaining the data into table that time it is showing one entry over there, i suggest get out from there and try using se11 , i believe you can see all the data which you had maintained.

Thanks,

Re: database table displays only current entry

Former Member — Wed, 09 Jan 2013 17:20:03 GMT

i am checking enteries using se11 and se16..but it shows last created entry

Re: database table displays only current entry

Former Member — Wed, 09 Jan 2013 17:45:43 GMT

How are you creating entries in these table? Is it posible that you are overwriting the entries using MODIFYING with the same keys ?

Also, check if the table has the number of lines that you are expecting clicking on "Number of entries" in SE16

Regards,

Felipe

Re: database table displays only current entry

RaymondGiuseppi — Wed, 09 Jan 2013 18:06:14 GMT

Well did you define a primary key in addition to client (MANDT) if not you will only get one records (per client) in your database table, so TMG will never display a list of records...

Regards,

Raymond

Re: database table displays only current entry

marcosmata — Wed, 09 Jan 2013 19:27:27 GMT

Perhaps in the options of SE11 or SE16 you have limit the "Max Number of Hits" parameter to 1.

Re: database table displays only current entry

Former Member — Thu, 10 Jan 2013 07:17:52 GMT

i clicked on number of enteries and it will show only one latest record only......even i checked in se16 also at there only one record is updated...i created multiple enteries but it will show only last entry.......

Re: database table displays only current entry

Former Member — Thu, 10 Jan 2013 07:21:31 GMT

i define two primary key and client(mandt) also....can you tell me is my table related to maintain type and screen no in TMG...but i choose maintain type ..two step and screen num..overview screen 1 and single screen 9....

Re: database table displays only current entry

RaymondGiuseppi — Thu, 10 Jan 2013 07:26:31 GMT

i clicked on number of enteries and it will show only one latest record only....

Does it display "1" (what you wrote is not possible...)

Re: database table displays only current entry

Former Member — Thu, 10 Jan 2013 07:55:16 GMT

like this it shows only one entry....

Re: database table displays only current entry

Former Member — Thu, 10 Jan 2013 08:00:57 GMT

well i checked in se16 ....my width of output list is 250 and maximun no of hits are 200......you mean that i have to change my max no of hits from 200 to 1?

Re: database table displays only current entry

RaymondGiuseppi — Thu, 10 Jan 2013 08:03:31 GMT

From SE16

- Insure no selection criteria is filled

- click on "Number of Entries",

- you must get a pop-up window

Regards,

Raymond

Re: database table displays only current entry

Former Member — Thu, 10 Jan 2013 08:17:17 GMT

i have this in my se16...

Re: database table displays only current entry

RaymondGiuseppi — Thu, 10 Jan 2013 08:33:39 GMT

If you are sure to have recorded your new records , could you paste a printscreen of

- the first screen you get via SM30 after clicking on "maintain"

- the definition of the dialog (screen with screen numbers)

Regard,

Raymond

Re: database table displays only current entry

Former Member — Thu, 10 Jan 2013 08:59:17 GMT

Re: database table displays only current entry

Former Member — Thu, 10 Jan 2013 09:41:44 GMT

Hi Shilpa,

This screen shot has shows that only MANDT field is a key field ( Highlighed in blue). This means that you have created two key fields after creating the Table maintenance generator. Whatever changes you make in the table those are not reflected in the old TMG. You have to delete the existing TMG and again create a new TMG where there are two primary key fields. Doing this should solve your problem.

Hope this helps.

Thanks,

Tooshar Bendale

Re: database table displays only current entry

Former Member — Thu, 10 Jan 2013 09:50:17 GMT

Hi,

Tooshar is right... Ensure your key fields are properly defined, activate and adjust your table if necessary and re-create your maintenance view.

Kr,

Manu.

Re: database table displays only current entry

Former Member — Thu, 10 Jan 2013 12:16:39 GMT

Change the table properly adding key field(s) and then regenerate the table view.

Regards,

Felipe