Creating Transparent Table by code in Memory

[Former Member]

Hi,

Iu2019m trying to create a transparent table by code using ABAP and store the table in the memory.

I want to be able to create a physical data dictionary table, just like using se11 (Database table -> Transp. Table), but I want to create it in the memory during runtime without actually creating the table in the system. Iu2019m not interested in using an internal table.

I want to simulate the existence of an transparent table in the system by creating it dynamically on runtime and have it available in the memory so that I can use it as any other table that is created using se11. Iu2019m aware of the FMs DD_CREATE_TABLE and DDIF_TABL_PUT, but these FMs actually create the table in the system, Iu2019m not interested in creating the table permanently.

Thanks & Regards,

Behzad

[brad_bohn]

Just one question...Why???

[ThomasZloch]

Hehe, I had the same question already typed in the box, but was called to an ad-hoc meeting.

What is good for? Where and how would this "virtual" transparent table be used?

Thomas

[Former Member]

And, his very first post, too.... I thought we called these internal tables.

[Former Member]

Hi,

I donu2019t want to be rude, but please, if you are unlettered and canu2019t understand why someone asks for something that you believe is unnecessary because you have never thought about it, just donu2019t answer the question.

Why Iu2019m asking this question is of course NOT because I donu2019t know what an internal table is or how to use it, but because Iu2019m trying to achieve a specific scenario that is not possible with internal tables.

What Iu2019m trying to accomplish is to build an structure in runtime that can be used with the SQL JOIN-statement without the need of creating the transparent table in the system permanently. Joining tables with SQL-query is not possible using internal tables, but if one could create an transparent table in memory on runtime that contains values from an internal table then this temporary transparent table could be used in the SQL-query scenario. This way different types of optimization could be performed on runtime.

So now, if someone can answer my question, without any ridicules and ignorant answer I would be really thankful.

Thanks in advance,

Behzad

[ThomasZloch]

I donu2019t want to be rude, but please, if you are unlettered and canu2019t understand why someone asks for something that you believe is unnecessary because you have never thought about it, just donu2019t answer the question.

You're wrong here. You walk out into the open and ask the community for help, so any return question about the context is just fine, if that context is not provided in the original post.

All too often a completely different (and better) solution than what the OP had in mind is suggested, once the context is known.

Now that you have provided more info, let's see if there are any suggestions.

Don't forget, you are asking the community for help, not the other way 'round.

Thomas

[Former Member]

Letu2019s assume Thomas Zloch is always right and everyone else is always wrong. Could someone answer my questions or should I redirect the answer to SAP directly and see if I can get an answer elsewhere?

Behzad

[kesavadas_thekkillath]

Hi,

These are professional forums and please try to be humble here .

We all are very aware of the Rob,Thomas,Kishan,Matt & their moderation terms. They are always right to their point .

Coming to your question...Really i have to say i cant even imaginr this way. SAP had provided buffered mechanisms at table level, Internal table to hold data in memory & some known methods to create dynamic structures other than the methods you proposed. I hope you are aware of them.

Its better you post it to SAP and revert here with their suggestion.

Keshav