Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

help

Former Member
0 Likes
473

while i review some source, i am wondering if the following source is possible for updating or inserting data into standard table? as far as i know, by using SAP GUI, only possible for handle cbo table, not handle(insert, update) standard table by abap code, so we are using bdc, or access to oracle db directly without sap instance.

UPDATE tka07

SET vspkz = 'X'

WHERE kokrs = 'H100'

AND versn = '500'

AND gjahr = g_gjahr.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
452

There is one standard syntax variant of the ABAP UPDATE verb for updating a transparent table.But in principle you should not use it for a standard table or you may introduce inconsistencies in the SAP system.

Therefore, never, ever write directly to a standard table. Yes, there are rare exceptions, but it's a good rule of thumb. You should be able to find sap standard function modules (bapis), or try BDCs.

2 REPLIES 2
Read only

Former Member
0 Likes
452

Hi,

You can update the table entries with UPDATE statement also.

Thanks,

Sriram Ponna.

Read only

Former Member
0 Likes
453

There is one standard syntax variant of the ABAP UPDATE verb for updating a transparent table.But in principle you should not use it for a standard table or you may introduce inconsistencies in the SAP system.

Therefore, never, ever write directly to a standard table. Yes, there are rare exceptions, but it's a good rule of thumb. You should be able to find sap standard function modules (bapis), or try BDCs.