SQL KEYWORDS

[Former Member]

HI,

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

[Former Member]

Hi,

Check this,

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

Thanks.

[Former Member]

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]

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]

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