topic Re: can we update standard database table? in Application Development and Automation Discussions

can we update standard database table?

Former Member — Fri, 12 Dec 2008 16:34:28 GMT

HI experts,

I just want to know can we update standard database table using update statement?

i want to update some HR table with the data from flat file using update statement. please guide me.

Regards,

Murthy.

Re: can we update standard database table?

former_member156446 — Fri, 12 Dec 2008 16:37:13 GMT

it is possible but its not prefered..

its always a good practice to either go with a BDC of a tr. or use Tr so update the changes... or a BAPI which suits to the requirement..

Re: can we update standard database table?

Former Member — Fri, 12 Dec 2008 16:58:50 GMT

dear jay,

iam in an implementation project. During datatransfer we have ran LSMW to transfer the data to standard database table. but the database table contains some username and date fields which are system fields..so those two fields are updated by username and date who runs LSMW and LSMW runned date. so i need to update those two fields by another flatfile of data by running some report.

please guide me.

Re: can we update standard database table?

Former Member — Fri, 12 Dec 2008 17:02:06 GMT

What's the table and transaction?

Rob

Re: can we update standard database table?

Former Member — Fri, 12 Dec 2008 17:07:37 GMT

i need to update aedtm and uname fields in table pa9008 from the flatfile.

Re: can we update standard database table?

Former Member — Fri, 12 Dec 2008 17:14:33 GMT

Why not you are writing A BDC for PA30 with Infotype 9008?It will Update PA9008 automatically.

Either Use FM HR_MAINTAIN_MASTERDATA

ACTIO = 'MOD'"This is for changing the Master data.

Re: can we update standard database table?

Former Member — Fri, 12 Dec 2008 17:26:19 GMT

can u explain in detail? like what r the parameters to be passed to the FM?

Re: can we update standard database table?

Former Member — Fri, 12 Dec 2008 17:38:03 GMT

What Fields you have in your hand(File)?

This is the Importing parameter of FM:

PERNR                           00001123               
 MASSN                                                  
 ACTIO                           MOD

And this is the Proposed_Values from tables parameter:

Tables                          Value             
                                                    
  PROPOSED_VALUES                    1 Entry"here pass INFT = '9008'

For More Assistance Check FM BAPI_PTMGRATTABS_MNGCHANGE line 220 in ECC.

Re: can we update standard database table?

Former Member — Fri, 12 Dec 2008 17:42:22 GMT

can u give me entire FM structure with example?

Re: can we update standard database table?

Former Member — Fri, 12 Dec 2008 17:53:48 GMT

FM BAPI_PTMGRATTABS_MNGCHANGE line 220 in ECC,Have an entire structure with Example.

Re: can we update standard database table?

Former Member — Fri, 12 Dec 2008 18:00:29 GMT

Amit,

with that FM i can directly update the database table ? remember the data is large to update.

Re: can we update standard database table?

Former Member — Fri, 12 Dec 2008 18:28:12 GMT

> Why not you are writing A BDC for PA30 with Infotype 9008?It will Update PA9008 automatically. > Either Use FM HR_MAINTAIN_MASTERDATA >

ACTIO = 'MOD'"This is for changing the Master data.

Amit - will this be able to update fields that are not changeable on the screen?

Rob

Re: can we update standard database table?

Former Member — Sat, 13 Dec 2008 11:48:26 GMT

Dear amit,

i do have aedtm and uname fields to be modified for particular pernr. these 3 fiels will be taken from flat file. plz guide me with the example

Regards.

Re: can we update standard database table?

Former Member — Mon, 13 Jul 2009 12:28:34 GMT

closing