topic Re: Inserting values into a DB table in Application Development and Automation Discussions

Inserting values into a DB table

Former Member — Thu, 04 Dec 2008 05:07:14 GMT

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

Re: Inserting values into a DB table

GauthamV — Thu, 04 Dec 2008 05:11:12 GMT

Plz do a search in SCN before asking basic questions.

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

Re: Inserting values into a DB table

abdul_hakim — Thu, 04 Dec 2008 05:11:14 GMT

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

Re: Inserting values into a DB table

Former Member — Thu, 04 Dec 2008 05:11:14 GMT

Hi,

You can press F1 on insert for syntax and other info

Thanks

Re: Inserting values into a DB table

Former Member — Thu, 04 Dec 2008 05:12:28 GMT

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

Re: Inserting values into a DB table

Former Member — Thu, 04 Dec 2008 06:22:30 GMT

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