can we update standard database table?

[Former Member]

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.

[Former Member]

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.

[former_member156446]

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

[Former Member]

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.

[Former Member]

What's the table and transaction?

Rob

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

can u give me entire FM structure with example?

[Former Member]

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

[Former Member]

Amit,

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

[Former Member]

>

> 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

[Former Member]

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.

[Former Member]

closing