Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

TABLE INSERT CODING

Former Member

‎2007 Jul 19 7:44 AM

0 Likes
478

HI ,

Can anybody provide me Table insert Coding.

3 REPLIES 3
Read only

Former Member

‎2007 Jul 19 7:47 AM

0 Likes
418

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

Read only

Former Member

‎2007 Jul 19 7:48 AM

0 Likes
418

Hi,

You can also insert Intrnal table, it is fast.

check this:-

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3a6d358411d1829f0000e829fbfe/content.htm

Reward if useful!

Read only

Former Member

‎2007 Jul 19 7:55 AM

0 Likes
418

Hi

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.

OR

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