topic SQL KEYWORDS in Application Development and Automation Discussions

SQL KEYWORDS

Former Member — Tue, 09 Oct 2007 11:31:14 GMT

HI,

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

Re: SQL KEYWORDS

Former Member — Tue, 09 Oct 2007 11:36:36 GMT

Hi,

Check this,

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

Thanks.

Re: SQL KEYWORDS

Former Member — Tue, 09 Oct 2007 11:36:37 GMT

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

Re: SQL KEYWORDS

Former Member — Tue, 09 Oct 2007 11:37:18 GMT

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

Re: SQL KEYWORDS

Former Member — Tue, 09 Oct 2007 14:06:32 GMT

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