09-10-2008 11:10 AM
Hi Expart ,
Plz. tell me how to add new record in database table without using table maintance ganerator ....give me one ex.
Regards
Bhabani
09-10-2008 11:13 AM
Hi Bhabaani,
Through the program you can enter records into database table.
take an internal table populate it with the data.
Now use Insert dbtable from table itab.
Regards,
Sujit
09-10-2008 11:14 AM
09-10-2008 11:14 AM
09-10-2008 11:15 AM
Hi,
Try using INSERT query either record by record or total one internal table.
If you create a view based on this table, if you inert records in that view underlying database table also updated.
Regards
Ravisankar
09-10-2008 11:22 AM
Hi,
The other way to safely handle the modification of tables is through is by programs that can be done with SE38 or SE80.
To insert into database table we use INSERT statement :
1. To insert a single line into a database table, use the following:
INSERT INTO <target> VALUES <wa>.
INSERT <target> FROM <wa>.
2. To insert a several lines into a database table, use the following:
INSERT <target> FROM TABLE <itaba>.
Or even we can use MODIFY statementas this single statement is used to insert as well as update the records of database table.
MODIFY <target> FROM <wa>.
or MODIFY <target> FROM TABLE <itab>.
thanx.
Edited by: Dhanashri Pawar on Sep 10, 2008 12:25 PM
Edited by: Dhanashri Pawar on Sep 10, 2008 12:30 PM
09-10-2008 11:22 AM
declare an internal table of the structure of DB table.
Populate the internal table with data.
MODIFY <DBtab> FROM <int_tab>.
09-10-2008 11:25 AM
Hi ,
Its not recomonded to do this if its a SAP standard Table , hope you are reffering a Z table .
1). Goto Se16n
2). type &sap_edit in the Command field and press Enter
3). open the relavant Table , there you have additional data maintainace buttons ( create record , delete ..ect )
Hope this will be useful
Br ,
Dilum
09-10-2008 11:37 AM
Hi ,
use this syntax
MODIFY <Database-tab> FROM <int_tab>.
Thanks&Regards,
Naresh.