need the simplest code to select a table's content

[Former Member]

Hi!

We want to view the content of some tables which are NOT activated .

Could you provide a piece of ABAP code to help?

Points guaranteed. Thanks!

[Former Member]

hi Jennifer,

the tables which are NOT activated, from SAP point of view don't exist at all. If they don't exist, no data could be stored in these tables, so there is nothing to select and you cannot select from tables which don't exist... and so on...

hope this helps

ec

[Former Member]

HI

can u tell me what do uyou mean by 'Which are not Activated'?

Regards,

Waseem

[JozsefSzikszai]

hi Jennifer,

the tables which are NOT activated, from SAP point of view don't exist at all. If they don't exist, no data could be stored in these tables, so there is nothing to select and you cannot select from tables which don't exist... and so on...

hope this helps

ec

[Former Member]

OK, I give an example here:

I can do this at the UNIX level:

select * from SAPSR3DB.BC_SL_ACTIVE_PARTS;

and I get 3 lines returned. However if I try se16 for above table, I am told that is NOT activated in the dictionary

But for some systems I do not have UNIX access. So please help give some code to get it.

Thanks!

[Former Member]

Interesting - try native SQL.

Rob

[Former Member]

Jennifer,

That table doesnt exist in SAP. The table name can be 16 characters long max.

Rgds,

Naren

[Former Member]

It's existing at DB level. I can see it thru SQLPLUS.

Please provide ABAP code. <REMOVED BY MODERATOR>. Thanks!

Edited by: Alvaro Tejada Galindo on Feb 22, 2008 10:05 AM

[Former Member]

Native SQL is database dependent, so it's not possible to give a general answer. Please see:

[Native SQL|http://help.sap.com/saphelp_47x200/helpdata/EN/fc/eb3b8b358411d1829f0000e829fbfe/frameset.htm]

Rob

[Former Member]

This is Oracle10. Please give the exact code because I do NOT have any ABAP experience. Thanks!