Application Development 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SQL KEYWORDS

Former Member

‎10-09-2007 12:31 PM

0 Kudos

HI,

How can you write UPDATE and MODIFY statments on data base tables like MARA, EKKO etc...?

4 REPLIES 4

Former Member

‎10-09-2007 12:36 PM

0 Kudos

Hi,

Check this,

https://forums.sdn.sap.com/click.jspa?searchID=5795625&messageID=3893199

Thanks.

Former Member

‎10-09-2007 12:36 PM

0 Kudos

MODIFY mara from table it_mara.

insert into mara from table itab.

populate data into internal table n then do above way....

but this is not advisable...

use BDC for that.....as tehy r database tables.....n data should be validated....

using above statements validation is not done....

however if u use BDC validations will be taken care.,...

Former Member

‎10-09-2007 12:37 PM

0 Kudos

Hi,

UPDATE sflight SET seatsocc = seatsocc + 3

WHERE carrid = 'LH' AND

connid = '0400' AND

fldate = '20010228'.

DATA: wa TYPE scustom.

wa-id = '12400177'.

wa-name = 'Robinson'.

wa-postcode = '69542'.

wa-city = 'Heidelberg'.

wa-custtype = 'P'.

wa-discount = '003'.

wa-telephone = '06201/44889'.

MODIFY scustom FROM wa.

Assign points if useful

Former Member

‎10-09-2007 3:06 PM

0 Kudos

Yes, but it's bad practice. When SAP updates one of their standard tables, they often update others as well. It's important for them to be kept in sync. Standard SAP transactions or BAPIs are the way to update standard SAP tables.

Rob