topic Re: Table Types in Application Development and Automation Discussions

Table Types

Former Member — Tue, 30 Sep 2014 20:32:21 GMT

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.

Re: Table Types

former_member223917 — Wed, 01 Oct 2014 03:36:36 GMT

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

Re: Table Types

Former Member — Wed, 01 Oct 2014 04:18:05 GMT

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

I_tab_standard[] = I_tab_hash[].

~Lokesh.

Re: Table Types

fcorodriguezl — Wed, 01 Oct 2014 04:53:47 GMT

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

Re: Table Types

former_member1716 — Wed, 01 Oct 2014 05:04:26 GMT

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

Re: Table Types

Former Member — Wed, 01 Oct 2014 11:37:36 GMT

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.

Re: Table Types

former_member1716 — Wed, 01 Oct 2014 11:51:23 GMT

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

Regards,

Satish

Re: Table Types

matt — Wed, 01 Oct 2014 12:25:48 GMT

INSERT LINES OF hashed_table INTO TABLE standard_table

Re: Table Types

Former Member — Wed, 01 Oct 2014 14:38:09 GMT

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

Re: Table Types

matt — Wed, 01 Oct 2014 15:58:32 GMT

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.

Re: Table Types

Former Member — Wed, 01 Oct 2014 16:05:48 GMT

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

Re: Table Types

kesavadas_thekkillath — Wed, 01 Oct 2014 17:21:57 GMT

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

Re: Table Types

matt — Wed, 01 Oct 2014 17:46:34 GMT

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

Re: Table Types

kesavadas_thekkillath — Wed, 01 Oct 2014 20:06:21 GMT

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.

Re: Table Types

Former Member — Wed, 01 Oct 2014 20:49:26 GMT

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

Re: Table Types

matt — Thu, 02 Oct 2014 05:30:25 GMT


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.

Re: Table Types

matt — Thu, 02 Oct 2014 05:31:07 GMT

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

Thread locked.