database table displays only current entry

[Former Member]

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?

[Former Member]

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,

Jo

[Former Member]

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

[Former Member]

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

[Former Member]

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.......

[RaymondGiuseppi]

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...)

[Former Member]

like this it shows only one entry....

[RaymondGiuseppi]

From SE16

- Insure no selection criteria is filled

- click on "Number of Entries",

- you must get a pop-up window

Regards,

Raymond

[Former Member]

i have this in my se16...

[RaymondGiuseppi]

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

[Former Member]

[Former Member]

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

Regards,

Felipe

[RaymondGiuseppi]

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

[Former Member]

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....

[Former Member]

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

[marcosmata]

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

[Former Member]

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?

[Former Member]

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.