topic update database table in Application Development and Automation Discussions

update database table

Former Member — Tue, 14 Nov 2006 22:17:18 GMT

Hello Experts,

I need update database table MCHA from an internal table.

the code is:

data: begin of i_afko occurs 0,

date1 like mcha-fvdt2,

end of i_afko.

the contents of this internal table:

date1:

20061113

data: begin of i_mcha occurs 0,

charg like mcha-charg,

end of i_data.

i have one record in this internal table like this:

charg

132960

now i have to update table MCHA with date1 value where charg = i_mcha-charg.

could any one of please tell me how can i update that?

Thanks a lot.

Re: update database table

former_member186741 — Tue, 14 Nov 2006 22:33:23 GMT

sap strongly discourage direct updates to sap standrad tables, such as MCHA. Because of the way the tables are related to others it is very dangerous to manipulate them independently.You should use a standard transaction or write a program to call such a transation or a bapi.

However, MCHA does not have a field called DATE1 anyway...which field do you want to update?

Re: update database table

Former Member — Tue, 14 Nov 2006 22:38:57 GMT

Hi,

mcha-date1 = i_afko-date1.

update mcha.

I hope this helps.

Shreekant.

Re: update database table

Former Member — Tue, 14 Nov 2006 22:48:59 GMT

neil,

the thing is our business is needing to maintain a date calcualted through one of our programs on BATCH record's (MCHA-FVDT2) on Basic Data 2 tab.

If I wanna call a transaction(msc2n) to change the batch record through my program, would it be a better idea?

Re: update database table

Former Member — Tue, 14 Nov 2006 22:53:43 GMT

Unfortunately, MSC2N can't be used in batch input (according to OSS). They suggest using old transaction MSC2 instead.

You might also try BAPI_BATCH_CHANGE.

rob

Re: update database table

Former Member — Tue, 14 Nov 2006 22:58:13 GMT

cool!!!

Thnx Guyz.