topic Re: Inserting data from internal table back to system in Application Development and Automation Discussions

Inserting data from internal table back to system

Former Member — Wed, 28 Feb 2007 17:04:00 GMT

This could be a relatively simple question/answer, but I've spent a rediculously long time trying to figure it out...

I have a program that is reading a tab delimited file into an internal table. I can see that the internal table is being populated correctly. How do I get the data from the internal table inserted into a database table?

The database table is YMMOM and has five fields: mandt (clnt 3), matnr (char 18), ylegacy (char 4), ycount (char 4), and zbismt (char 30). The internal table is set up as follows:

data: begin of in_tab occurs 0,
        matnr   like ymmom-matnr,
        ylegacy like ymmom-ylegacy,
        ycount  like ymmom-ycount,
        zbismt  like ymmom-zbismt,
      end of in_tab.

I've tried

MOVE-CORRESPONDING in_tab TO ymmom.

and I can see in the debugger that the structure is being populated, but when I go back and try to look at the contents of ymmom, the data hasn't been actually uploaded.

Thanks in advance for any help you can provide.

Re: Inserting data from internal table back to system

Former Member — Wed, 28 Feb 2007 17:18:36 GMT

Hi,

You have to user INSERT statement to insert records to the database table..

data: begin of in_tab occurs 0,

matnr like ymmom-matnr,

ylegacy like ymmom-ylegacy,

ycount like ymmom-ycount,

zbismt like ymmom-zbismt,

end of in_tab.

MOVE-CORRESPONDING in_tab TO ymmom.

ymmom-mandt = sy-mandt.

Insert the records to the databse table.

INSERT ymmom.

IF SY-SUBRC = 0.

COMMIT WORK.

ENDIF.

Thanks,

Naren

Re: Inserting data from internal table back to system

Former Member — Wed, 28 Feb 2007 17:23:01 GMT

Perhpas you're transfering records with the same key or that records are in the table YMMOM or you didn't do the insert.

Your code seems to be ok, only the insert is missing:

MOVE-CORRESPONDING in_tab TO ymmom.

INSERT YMMOM.

Max

Re: Inserting data from internal table back to system

Former Member — Wed, 28 Feb 2007 17:34:53 GMT

This did the trick, thanks! And especially for the quick response!

Re: Inserting data from internal table back to system

Former Member — Thu, 01 Mar 2007 03:42:59 GMT

Hi,

Nice query.

Kishore.

Re: Inserting data from internal table back to system

Former Member — Sun, 04 Mar 2007 07:20:13 GMT

Hi,

Use UPDATE statement to update Database table.

Regards,

Chandra

Re: Inserting data from internal table back to system

Former Member — Mon, 05 Mar 2007 09:54:55 GMT

Hi Bryan,

One important point is ..................... You can use either OPEN sql

commands or NATIVE sql commands. But, if you insert records into the table

through program either using OPEN sql commands or NATIVE sql commands,

be aware that you are inserting records WITHOUT any checks like Check table validation,Fixed values, and some others validations which are required for the field. Always, insert records into database through screen for consistency

of the data. In very extreme cases we insert records through program.

If you want to insert bulk amount of records.You can acheive this

using BDC technique( WITH consistency ) that is either using CALL TRANSACTION method or SESSION method, instead of using either OPEN sql commands or NATIVE sql commands(WITHOUT consistency) in program.

If you have queries regarding this, you are welcome.

If you already know this ignore this.

Hope that, the above desc. is helpful for you.

Regards,

V.Raghavender.