problem with SE11

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi preyansh,

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

[Former Member]

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

Thanks,

Preyansh

[Former Member]

Hi Kirti,

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

Thanks,

Preyansh

[Former Member]

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.

[Former Member]

Hi,

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

It will help you.

Reagrds

Arbind

[Former Member]

Hi...

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

[Former Member]

Hi,

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

Cheers!

Vengal Rao.

[suryasarathi_basu]

Hi,

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

Regards,

SURYA

[Former Member]

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.

[Former Member]

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