topic Re: need the simplest code to select a table's content in Application Development and Automation Discussions

need the simplest code to select a table's content

Former Member — Fri, 22 Feb 2008 14:30:31 GMT

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!

Re: need the simplest code to select a table's content

Former Member — Fri, 22 Feb 2008 14:32:42 GMT

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

Regards,

Waseem

Re: need the simplest code to select a table's content

JozsefSzikszai — Fri, 22 Feb 2008 14:34:07 GMT

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

Re: need the simplest code to select a table's content

Former Member — Fri, 22 Feb 2008 14:47:19 GMT

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!

Re: need the simplest code to select a table's content

Former Member — Fri, 22 Feb 2008 14:55:38 GMT

Interesting - try native SQL.

Rob

Re: need the simplest code to select a table's content

Former Member — Fri, 22 Feb 2008 14:56:11 GMT

Jennifer,

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

Rgds,

Naren

Re: need the simplest code to select a table's content

Former Member — Fri, 22 Feb 2008 15:02:52 GMT

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

Re: need the simplest code to select a table's content

Former Member — Fri, 22 Feb 2008 15:07:45 GMT

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

Re: need the simplest code to select a table's content

Former Member — Fri, 22 Feb 2008 15:13:41 GMT

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