Insert Record into Standard Table...

[Former Member]

Dear All,

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

Regards.

[Former Member]

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??

VJ

Message was edited by: Vijayendra Rao

[Laxmana_Appana_]

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

[Manohar2u]

You should use INSERT table

Refer this link

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

Regds

Manohar

[Former Member]

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.

[Former Member]

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

[abdul_hakim]

hi

you can use the INSERT Statement..

INSERT <dbtable> FROM <wa>.

INSERT <dbtable> FROM TABLE <itab>.

Cheers,

Abdul Hakim

[Former Member]

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.