topic Re: Retrieving data from table pool and table cluster.. in Application Development and Automation Discussions

Retrieving data from table pool and table cluster..

Former Member — Fri, 17 Oct 2008 10:57:14 GMT

Hi all,

Please let me know the procedure to retreive data from table pool and table cluster.

Thanks

Re: Retrieving data from table pool and table cluster..

Former Member — Fri, 17 Oct 2008 11:04:56 GMT

Hi Raj,

Follow these lines : you may find your problem resolved.

Cluster Table:

Database table defined in the ABAP Dictionary, whose version on the database is not only assigned to one table defined in the ABAP Dictionary. Several cluster tables are assigned to a table cluster in the database. The intersection of the key fields of the cluster tables forms the primary key of the table cluster. The other columns of the cluster tables are stored in compressed form in a single column VARDATA of the table cluster. You can access cluster tables only via Open SQL, and only without using joins.

Similarly for pool table

Pool table:

A database table defined in the ABAP Dictionary whose database instance is assigned to more than one table defined in the ABAP Dictionary. Multiple pool tables are assigned to a table pool in the database. The key fields of a pool table have to be character-type fields. The table pool's primary key consists of two fields: TABNAME for the name of a pool table, and VARKEY for the interdependent contents of the key fields in the corresponding pool table. The non-key fields of the pool table are stored in compressed format in their own column, called VARDATA, of the table pool. The only way to access pool tables is by using Open SQL. Joins are not allowed.

Best Regards

Re: Retrieving data from table pool and table cluster..

ThomasZloch — Fri, 17 Oct 2008 11:34:43 GMT

nice copy/paste job from Kris' answer here:

Re: Retrieving data from table pool and table cluster..

Former Member — Fri, 17 Oct 2008 11:49:45 GMT

This message was moderated.

Re: Retrieving data from table pool and table cluster..

Former Member — Fri, 17 Oct 2008 11:50:13 GMT

This message was moderated.

Re: Retrieving data from table pool and table cluster..

Former Member — Fri, 17 Oct 2008 11:52:44 GMT

I can show same case i.e C&P that to from one of our leading contributor in SCN.

Then what

Re: Retrieving data from table pool and table cluster..

Former Member — Fri, 17 Oct 2008 11:58:28 GMT

Not sure, perhaps you are refering to Anji?

But in this case the reason is different => They are points gaming (same person).

Cheers,

Julius

Re: Retrieving data from table pool and table cluster..

Former Member — Fri, 17 Oct 2008 12:00:43 GMT

This message was moderated.

Re: Retrieving data from table pool and table cluster..

Former Member — Fri, 17 Oct 2008 12:02:10 GMT

No he is not!.Do you want me to mail the source and target messages.You feel so bad and will be in a dilemma as to what to do?

oops i didn't read your next sentence i don't know about that one.

Edited by: K.P.N on Oct 17, 2008 5:33 PM

Re: Retrieving data from table pool and table cluster..

Former Member — Fri, 17 Oct 2008 13:33:53 GMT

Actually this is the first time we have caught a ponits-gamer even before assigning the ponits to himself

Copy&pasting is indeed hard to spot and there is a grey area as well.

- Normally, the procedure is to remove the posts and let the person know.

- After that confront them and give them a few warnings with increasing "hazard to health" alerts.

- If they still carry on... then I wait for an opportunity to catch them "red-handed" breaking the rules and request guestification of them and all other accounts associated to their ID.

If you see copy&pasting without referencing the source, please click the "Abuse Report" button and provide a link to the (perhaps original) source in the "comments box". It will be dealt with, no matter who it is.

Cheers,

Julius

Re: Retrieving data from table pool and table cluster..

Former Member — Fri, 17 Oct 2008 19:00:08 GMT

who might be that, any guesses..?

Re: Retrieving data from table pool and table cluster..

Former Member — Sat, 18 Oct 2008 01:30:18 GMT

My first guess would be myself, because I know myself better than others.

Confession: About 2 years ago I copy&pasted an approach to a solution from another website (which I had known about for some time).

I soon after the post realized that this was a bad idea (meaning the C&P) so added a disclaimer that it was not my original text / code.

This is the only case I am aware of, and can "get off my shoulders".

I did however not add the source, as I was not (and still not) sure that the original source was their's either...

Most likely it was someone in Walldorf who is the "author" of this but did not hardcode his/her user name into the program...

You can read the thread here =>

For those who read the link in detail, there are some (release dependent) changes and certainly SAP can change it again.

We need to act ethically, even if we make some (historical) mistakes before thinking about our actions (or reading the rules).

I hope that you don't all think less of me for this, and that we can carry on having interesting discussions without other agendas.

This was the only case I ever copy&pasted something (though it is perhaps not realy a c&p), but I would like to come clean on it to set an example.

Cheers,

Julius

Re: Retrieving data from table pool and table cluster..

Former Member — Sat, 18 Oct 2008 01:38:55 GMT

I thought it is me who is KPN pointing to. when i started SDN in 2005's i copied and pasted twice , then i got a message, later onwards i used to post my own. may be you are thinking that i copied and pasted the code samples from some one else post. please let me know. i will correct myself. i wantedly never did , i always away from c&p(except my posts )

PS: KPN if it is me kindly point out , i will correct myself, if i am wrong.

Re: Retrieving data from table pool and table cluster..

Former Member — Sat, 18 Oct 2008 01:55:35 GMT

Perhaps an explanation for your 2 posts vs. my 1 is that copy&pasting secure coding also is a 50/50 case

It is of course much better if the security is beyond the boundaries of the input/import parameters of the Fm interfaces and Report screens,

or if they are going to be generic... then at least protected from changes to variants (and stupid submits...)...

Today we deleted a lot of user ID's from 100's of c&p trolls and dwarfs in the ABAP forums. Almost all of it was c&p (in both directions).

It will make me a very happy man when that comes to a gradual end (bar one or two mistakes, when the person realized their mistake).

I think that we have made a lot of progress there and created awareness for ethical behaviour in the ABAP forums (note => stupid interview questions are not unethical... they are just deleted...)

Cheers,

Julius

Edited by: Julius Bussche on Oct 18, 2008 4:14 AM

Re: Retrieving data from table pool and table cluster..

Former Member — Sat, 18 Oct 2008 02:30:41 GMT

Sorry Vijay yes its you.But my intention is to prove that its not a bad idea to use C&P if its helpful to others.I want to see whether action is same for all.

Also i confess that i have used C&P many times before but i can't edit them now.

But you are different vijay you are down to earth.my intention is never to point you but to a top contributor so that i can know rules are same for all or not

Rules are same for all

Re: Retrieving data from table pool and table cluster..

Former Member — Sat, 18 Oct 2008 02:35:01 GMT

ok, if possible can you share the link. so that i will see what is the wrong with me and correct myself.

Re: Retrieving data from table pool and table cluster..

Former Member — Sat, 18 Oct 2008 02:36:09 GMT

This is the link your answer has been removed

Re: Retrieving data from table pool and table cluster..

Former Member — Sat, 18 Oct 2008 02:41:16 GMT

hmm..subtotals link , i really wondered. i am not sure what is the code i used. i am sure its my own code. i am not sure. can you tell me what is source atleast where i copied. so that i will get more clarity .

All ALV programs i give i write myself or will take from my old posts collection.

yes rules are same for all, who ever it may be.

Re: Retrieving data from table pool and table cluster..

Former Member — Sat, 18 Oct 2008 02:45:42 GMT

SCN wont allow that link to be posted here.but i felt that i have seen same code somewhere and i referred to one of the site.its same as it is by some other author.

i know you wont do mistakes.its over now we will request both of these threads to delete as there is no use to this forum.

Re: Retrieving data from table pool and table cluster..

Former Member — Sat, 18 Oct 2008 02:50:49 GMT

ok. now you are coming very close. i got the site. why can't the person copied the code from my post.

i remember correctly the code i mentioned is the modified version from below thread. i modifed it a little and mentioned in the link which you have provided in earlier post.

> i know you wont do mistakes.its over now we will request both of these threads to delete as there is no >use to this forum.

we are humans , we do mistakes, if some points others mistakes then only we can correct ourselves.

Edited by: Vijay Babu Dudla on Oct 17, 2008 11:00 PM