Table Types

[Former Member]

Hello, I have an internal table declared as hash and i want to update a standard table. Is it at all possible? if yes, can you share the syntax please?

Thanks.

[former_member223917]

Hi Venkat,

          Can you share more detail like which standard table you need to update and what is the structure for the internal table?

Thanks

Hock Lin

[Former Member]

I have never tried it but can you check with following syntax.

I_tab_standard[] = I_tab_hash[].

~Lokesh.

[fcorodriguezl]

Hi, Venkat is right, only need this simple instruction. Regards.

[former_member1716]

Hi,

Yes it is possible simple queries will do it. Please follow the below discussion it will give you the result:)

http://scn.sap.com/thread/719551

Regards,

Satish

[Former Member]

See the discussion is about from standard table to standard table. when ever i try to use MOdiify or Update statements it says the they are not compatible.

My internal table is declared as hashed and i have all my data in that table then i want to dump this all data into a standard database table.

Thanks.

[former_member1716]

Okies, sorry I din see that...Did you try with the basic queries? What was the result?

Regards,

Satish

[matt]

INSERT LINES OF hashed_table INTO TABLE standard_table

[Former Member]

Probably I got lost in some point but If both tables had the same structure and no header, this should work standardtab = hashtab , right?

[matt]

Moving a hashed table to standard table directly is unlikely to work (I've not tried it), because you also pass the hash information at the same time, and the standard table won't know what to do with it.

[Former Member]

I agree, that is a clearer approach the insert lines, I assume the standard table just ignore the hash information, if you try it works

[kesavadas_thekkillath]

Hi ,

In each of your posts you are mentioning about standard table,standard database table...What is it exactly....is it an internal table of type standard or a DB table ?

Please be more precise .

Kesav

[matt]

In context, and following the other responses, it's clear it's an internal table of type standard that he's talking about.

[kesavadas_thekkillath]

Hello Matt,

I am still not sure about that. You can see that OP has responded only once and has the following statements.

when ever i try to use Modiify or Update

My internal table is declared as hashed and i have all my data in that table then i want to dump this all data into a standard database table.

It does not give much clarity for me 🙂 . Let me wait for his response.

[Former Member]

Sir, it is a standard database table. Sorry for the confusion.

[matt]

Kesavadas Thekkillath wrote:

Hello Matt,

I am still not sure about that. You can see that OP has responded only once and has the following statements.

when ever i try to use Modiify or Update

My internal table is declared as hashed and i have all my data in that table then i want to dump this all data into a standard database table.

It does not give much clarity for me :-) . Let me wait for his response.

And you were right!

It is a very basic question. I'll leave the discussion as it is reasonably interesting.

[matt]

Updating a database table from any internal table is basic abap programming. Refer to your course notes, or the ABAP keyword documentation.

Thread locked.