topic Re: problem with SE11 in Application Development and Automation Discussions

problem with SE11

Former Member — Tue, 11 Jan 2011 07:04:57 GMT

Hi all,

I have been experiencing a very different situtaion.

I creted a Z table and i tried entering the values first time through insert statement.

The statement worked fine and did not give any error.

After that when i tried seeing the values through SE11 i get message that "no enteries found"

how ever the same record that was inserted earlier is visible via txn SM30 and SE16N.

Please help.

Regards,

Kriti

Re: problem with SE11

Former Member — Tue, 11 Jan 2011 07:14:14 GMT

Hi,

Make sure after inserting the data into table.

if you change the Key fields or Data elements for the key fields the data willl be lost and did not appear in se16 or se11

if you create the table maintianance(sm30) before altering the table the old data will appear in sm30.

go to se14 and activate and adjust the data base.

Prabhudas

Re: problem with SE11

Former Member — Tue, 11 Jan 2011 07:30:21 GMT

Hi,

Mostly Inset statement work correct even without COMMIT WORK statement (Since change in Modules automatically calls DB commit). But just to be on safer side check if you did COMMIT WORK after Insert Statement.

Thanks,

Preyansh

Re: problem with SE11

Former Member — Tue, 11 Jan 2011 07:52:30 GMT

HI prabhudas,

Yes i tried that too...

Emptied the table, scheck and activated it through se14. and inserted it the values again the problem was still as it was.

Re: problem with SE11

Former Member — Tue, 11 Jan 2011 07:53:11 GMT

Hi preyansh,

I have used commit work after the insert statement... thats should not be a problem.

Re: problem with SE11

Former Member — Tue, 11 Jan 2011 09:32:47 GMT

Really sounds strange..Dont know the solution.. may be recreating the entire table will help.

Thanks,

Preyansh

Re: problem with SE11

Former Member — Tue, 11 Jan 2011 12:24:00 GMT

Hi,

Through Table Maintenance activate and adjut the database and check during activatation no error occured.

It will help you.

Reagrds

Arbind

Re: problem with SE11

Former Member — Thu, 13 Jan 2011 15:27:53 GMT

Hi...

go to se14 and activate and adjust the data base. Then activate the table.

Re: problem with SE11

Former Member — Thu, 13 Jan 2011 15:44:27 GMT

Hi,

I think recreation of the table and activating should solve it.

Cheers!

Vengal Rao.

Re: problem with SE11

suryasarathi_basu — Sat, 15 Jan 2011 07:15:09 GMT

Hi,

first activate the ztable. After writting the code write COMMIT WORK.

Regards,

SURYA

Re: problem with SE11

Former Member — Sat, 15 Jan 2011 09:02:33 GMT

Hi Kriti Nigam,

Sounds pretty strange. I would suggest you to raise a service message to SAP, surely they would help you out, coz logically there is no problem what you are doing.

Thanks & Regards,

Faheem.

Re: problem with SE11

Former Member — Mon, 17 Jan 2011 12:21:26 GMT

hii kriti,

please try to compare your code with the following code and try to debug.

have used modify stmt instead of insert to add record to the database table.

REPORT zbdc_de_enteries.

TABLES zstudent_bdc.

SELECTION-SCREEN BEGIN OF BLOCK b1.

PARAMETERS : div TYPE zstudent_bdc-zsdiv,

name TYPE zstudent_bdc-zsname,

roll_no TYPE zstudent_bdc-zsrollno,

class TYPE zstudent_bdc-zsclass,

age TYPE zstudent_bdc-zsage.

SELECTION-SCREEN END OF BLOCK b1.

DATA : it_zstudent TYPE STANDARD TABLE OF zstudent_bdc WITH NON-UNIQUE KEY zsdiv.

DATA : wa_zstudent LIKE LINE OF it_zstudent.

MOVE div to wa_zstudent-zsdiv.

MOVE name to wa_zstudent-zsname.

MOVE roll_no to wa_zstudent-zsrollno.

MOVE class to wa_zstudent-zsclass.

MOVE age to wa_zstudent-zsage.

modify zstudent_bdc FROM wa_zstudent. " TRANSPORTING zsdiv zsname zsrollno zsclass zsage.

if sy-subrc <> 0.

MESSAGE : i007(rec_append).

ENDIF.

hope it helps you.

regards,

akshay ruia

Re: problem with SE11

Former Member — Tue, 18 Jan 2011 08:50:30 GMT

Hi Kirti,

Is the issue resolved? Keen to know about root cause of issue and its resolution.

Thanks,

Preyansh

Re: problem with SE11

Former Member — Tue, 18 Jan 2011 09:54:49 GMT

hi all

thanks for ur input...

My problem is solved now... though i dont know the exact cause of the problem but deleting and rebuilding the table did help.