topic Re: Insert Record into Standard Table... in Application Development and Automation Discussions

Insert Record into Standard Table...

Former Member — Sat, 12 Aug 2006 08:21:32 GMT

Dear All,

Which statement I have to use to insert a new record into SAP Standard Table.

Regards.

Re: Insert Record into Standard Table...

Former Member — Sat, 12 Aug 2006 08:22:57 GMT

USe BAPIS or Direct Update FM's

Dont use direct update to SAP.

Which table you want to insert? and What data you want to insert??

Message was edited by: Vijayendra Rao

Re: Insert Record into Standard Table...

Laxmana_Appana_ — Sat, 12 Aug 2006 08:24:10 GMT

Hi,

you can use normal insert statement to do this . but if you want to insert records into standard SAP table , then use any FM or BAPI to add new records to the table.

syntax :

insert <DBtable> from <workarea>

insert <DBtable> from table <internal table>

Regards

Appana

Re: Insert Record into Standard Table...

Manohar2u — Sat, 12 Aug 2006 08:24:35 GMT

You should use INSERT table

Refer this link

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3a6d358411d1829f0000e829fbfe/frameset.htm

Regds

Manohar

Re: Insert Record into Standard Table...

Former Member — Sat, 12 Aug 2006 10:22:55 GMT

Hello Davabap

see the syntex and example.

syntax :

insert <DBtable> from <workarea>

insert <DBtable> from table <internal table>

e.g.

INSERT kna1 FROM TABLE itab ACCEPTING DUPLICATE KEYS.

Here itab has same structure as kna1.

Re: Insert Record into Standard Table...

Former Member — Sat, 12 Aug 2006 12:39:12 GMT

The insert is not different from any other insert statement however, direct insert in SAP standard should be done only when none of the BAPI/FMs are helping you out. Standard BAPI/FMs does a lot of validations and your insert might not do all those validations.

hith

Sunil Achyut

Re: Insert Record into Standard Table...

abdul_hakim — Sat, 12 Aug 2006 12:55:48 GMT

you can use the INSERT Statement..

INSERT <dbtable> FROM <wa>.

INSERT <dbtable> FROM TABLE <itab>.

Cheers,

Abdul Hakim

Re: Insert Record into Standard Table...

Former Member — Sat, 12 Aug 2006 15:56:07 GMT

Proiorities

1) Check if transaction exists that will help you update the table.

2) Check Bapi/ FM which will be helpful in updating the table standard way.

3) Use modify command with by making internal table which is having same columns as of table.

4) Use native commands.

Hope this clarifies the issue. Please note this is as per my knowledge and understanding. Actual method may be different.

Geeta.

Note : Please reward points if it helps.