Retrieving data from table pool and table cluster..

[Former Member]

Hi all,

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

Thanks

[Former Member]

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

[ThomasZloch]

nice copy/paste job from Kris' answer here:

[Former Member]

This message was moderated.

[Former Member]

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

Then what

[Former Member]

Not sure, perhaps you are refering to Anji?

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

Cheers,

Julius

[Former Member]

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

[Former Member]

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

[former_member188685]

who might be that, any guesses..?

[Former Member]

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

[former_member188685]

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.

[Former Member]

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

[Former Member]

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

[former_member188685]

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

[Former Member]

This is the link your answer has been removed

[former_member188685]

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.

[Former Member]

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.

[former_member188685]

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

[former_member188685]

i got the link, the person who posted the code is very recently. what ever code sample i give , mostly on sflight tables, and i use always upto 20 rows , 10 rows like that in select. the person name i don;t want to mention. he is former guest of SDN. he didn;t even change the name of the program. you search in SCN with the same name. you can find lot of my posts on that . it is always good to discuss these kind of things. and also we can't control this copy stuff , since it is not SCN. it is some other site. they should have some rules before accepting some articles. that site is a copy paste of SCN . 100% agree on that. if any one diagree let me know.

[ThomasZloch]

> provide a link to the (perhaps original) source

It will not alsways be possible to find the original. This discussion here led me to investigate again, and I found this older message containing the same text excerpts:

So seems to have c&p'ed as well (check out his business card picture...).

But I think whether the unnamed source is an original or already a clone should not matter much.

Thomas

By the way, we all started out at some point, so if a now esteemed community member might have done a few copy/pastes initially, so what? I signed my first forum question with "any help will surely be rewared"...

It is the systematic misuse that should get punished.

[former_member181995]

That's for sure most of the people who are doing outstanding job these days at the time of their teen age on SCN(Perhaps SDN that time) Might be doing(Not sure) C&P (here also count me in) at somewhere ,but i strongly believe too once the person realize their self mistake or intentionally made mistake should be forgotten and no longer in account for any remembrance or penalty since he is not repeated again.

Just My 2 cents ~

Confession: At the time of my childhood(Of SDN) if i remember correctly i also applied C&P formula in some few threads(Most are deleted).Soon after I promised to myself(Not with others) that it would not be repeated by me in future.

Believe me Guys i read the rules(Completely) in somewhere in last year in later and i registered myself on SDN(now SCN) Friday 3rd March 2007 At 11:03 AM, means almost an year after.

@Vijay:We are human

yes we are human not God.But i believe Even God made one mistake,once he sent Human on earth.

Heartly Appreciation to::Julius And Vijay.

Cheers,

Amit

[Former Member]

Okay, so we all feel better now?

(but I think Kris Donald still has some explaining to do about that photo... )

Just for the record again: The above guests were not just making a little mistake by c&p'ing.

It was the same person who created another user ID to give himself points!

So he needed a question and an answer and couldn't think of 2 of his own...

=> that shows explicit intention and not just a (thoughtless) mistake which can be corrected by a warning => guestification.

A nice weekend to all!

Julius

[former_member184657]

Okay, so we all feel better now?  

no no.. not yet . Ive got to make some confessions too. Without getting into details I would like to say that in the initial days(also read as under-moderated days) I had asked some stupid/basic questions too. Kept a few of them still as unanswered to remind myself not to repeat it again.

pk

PS: Is eutheansia legal in any country apart from Netherlands? This man is attempting suicide by bumping (old threads). I cant see him suffer. Would love to put an end to it.

Edited by: prashanth kishan on Oct 18, 2008 6:45 PM

[Former Member]

> This man is attempting suicide by bumping (old threads).

I deleted them all for about an hour, and then he eventually stopped.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.