Inserting values into a DB table

[Former Member]

Hi frens, I need to know the syntax for inserting values into a database table, what ever I enter as parameters in the parameter fields..

Say I have material number as the parameter now wen I execute the program and give a material it has to get inserted to mara table..Using insert it is possible but wats the right syntax and codes for the same?

Regards & thanks

[GauthamV]

Plz do a search in SCN before asking basic questions.

Press F1 on insert you will get all the syntaxes for that keyword.

[abdul_hakim]

Hi

Your requirement itself is completely wrong. How do you insert the record into MARA table by inputting only the material number. You need to either upload the data from file or you need to write a BDC program.

Anyway the correct syntax for inserting records into db table as follows.

INSERT dbtab FROM WA.

INSERT dbtab FROM TABLE ITAB.

INSERT INTO dbtab VALUES WA.

Note WA and ITAB are work areas and internal table respectively.

Cheers,

Hakim

[Former Member]

Hi,

You can press F1 on insert for syntax and other info

.

Thanks

[Former Member]

Hi AJAY

please refr to this document

http://help.sap.com/saphelp_nw04s/helpdata/en/05/262640cf2eeb01e10000000a155106/frameset.htm

hope this helps

regards

Aakash Banga

[Former Member]

Dear all thanks so much for your replies..One thing what I want to make clear is I'm pretty new to both SAP as well as SDN, so kindly bear me with my poor knowledge on the rules of SDN forums..thanks again..

And Aakash Banga thanks for the link dude..helped a lot..