12-05-2005 11:10 AM
Hi,
i am trying to mass update to the database table
from the internal table.
it is giving an error that the internal table is not long enough..
can anyone help.
ADVance Thanks & Regards
Guhapriyan Subrahmanyam
12-06-2005 4:38 AM
Hi,
Check with this code......
****************
data ITAB like standard table of TABLE with header line.
After getting all you data into ITAB....
loop at ITAB.
update TABLE from ITAB.
if sy-subrc eq 0.
commit work.
else.
rollback work.
endif.
THANKS
If this helps you reward with points and close the thread.
12-05-2005 11:18 AM
Hi,
Check whether the internal table is been declared as that of the database table,
Hope this helps,
Rgds,
12-05-2005 11:25 AM
Hi Subrahmanyam ,
Assign the field symbol to internal table and then update the table .
Ex:
ASSIGN itab TO <F>.
UPDATE dbtab FROM TABLE <F>.
<i>Reward Points If It Helps YOU.</i>
Regards,
Raghav
12-05-2005 11:26 AM
hi.
thank you very much
it is declared same as the database table
but the table has an appended structure
i dont know how to insert data in this table.
thanks & regards
Guhapriyan subrahmannyam
12-05-2005 11:29 AM
12-05-2005 11:32 AM
if your itab is same structure as the dbtable, youcan simply use
modify <db table> from table <itab> .
Regards
Raja
12-05-2005 11:38 AM
modify ZGLSTPM_DEPLSCHD FROM TABLE i_in_data.
if sy-subrc <> 0.
Error in inserting data to table ZGLSTPM_DEPLSCHD
Message i137.
endif.
12-05-2005 11:43 AM
Hi,
Define the line type of the internal table similar to your database table.
For eg.
DATA itab LIKE TABLE OF mara.
REgards,
Abdul
12-05-2005 11:45 AM
12-05-2005 11:46 AM
12-05-2005 11:47 AM
hi..
i have used all the fields
and i cannnot use the like statement according to standards
i have declared manually.
Thanks & Regards
Guhapriyan
12-05-2005 12:03 PM
why dont you simply declare as below.
data: itab type standard table of <your dbtable> .
Regards
Raja
12-05-2005 12:21 PM
Hi
Can you paste ur piece of code for itab declaration here?
REgards,
Abdul
12-05-2005 11:28 AM
Hi,
Probably you have missed out some fields while declaring your itab.
Check it.
<b>
but the table has an appended structure
i dont know how to insert data in this table</b>.
For this you just insert those fields which are in appending structure to your itab then it should work.
Hope this helps
Reagrds
Amit
Message was edited by: Amit Kumar
12-06-2005 3:00 AM
If inserting new entries is what you are trying, try this:
insert <dbtable> from itab.
Also if you want to remove the previous entries do this first:
delete from <dbtable>
Message was edited by: Feroz Buksh
12-06-2005 4:04 AM
Hi Subrahmanyam,
First Declare the internal Table like below:
Data: <Internal-table> type standard table of <database-table> with header line.
Then use the below code to modify the Database table based on your conditions.
modify <database-table> from table <internal-table>.
I hope this help's you.
Regards,
Raja
12-06-2005 4:38 AM
Hi,
Check with this code......
****************
data ITAB like standard table of TABLE with header line.
After getting all you data into ITAB....
loop at ITAB.
update TABLE from ITAB.
if sy-subrc eq 0.
commit work.
else.
rollback work.
endif.
THANKS
If this helps you reward with points and close the thread.
12-08-2005 7:07 AM