topic TABLE INSERT CODING in Application Development and Automation Discussions

TABLE INSERT CODING

Former Member — Thu, 19 Jul 2007 06:44:32 GMT

HI ,

Can anybody provide me Table insert Coding.

Former Member — Thu, 19 Jul 2007 06:47:09 GMT

Example

In this example, a new airline is added to the database table SCARR.

DATA scarr_wa TYPE scarr.

scarr_wa-carrid = 'FF'.

scarr_wa-carrname = 'Funny Flyers'.

scarr_wa-currcode = 'EUR'.

scarr_wa-url = 'http://www.funnyfly.com'.

INSERT INTO scarr VALUES scarr_wa.

Regards,

Pavan

Former Member — Thu, 19 Jul 2007 06:48:28 GMT

Hi,

You can also insert Intrnal table, it is fast.

check this:-

Reward if useful!

Former Member — Thu, 19 Jul 2007 06:55:21 GMT

DATA scarr_wa TYPE scarr.

scarr_wa-carrid = 'FF'.

scarr_wa-carrname = 'Funny Flyers'.

scarr_wa-currcode = 'EUR'.

scarr_wa-url = 'http://www.funnyfly.com'.

INSERT INTO scarr VALUES scarr_wa. OR INSERT INTO scarr FROM scarr_wa.

DATA scarr_wa TYPE scarr.

DATA itab TYPE TABLE OF scarr

scarr_wa-carrid = 'FF'.

scarr_wa-carrname = 'Funny Flyers'.

scarr_wa-currcode = 'EUR'.

scarr_wa-url = 'http://www.funnyfly.com'.

APPEND scarr_wa to itab

INSERT INTO scarr FROM TABLE itab

<b>Rewards if useful</b>

Regards,

Nikhil