topic Re: to update the database table in Application Development and Automation Discussions

to update the database table

Former Member — Tue, 29 May 2007 14:21:26 GMT

can sombody tell me how to update the data base table .

im wending a loop on different wage type of infotype 0008 now all the amount corresponding to this wage type should be changed in the data base table by 50%.

Re: to update the database table

amit_khare — Tue, 29 May 2007 14:24:40 GMT

Use HR_INFOTYPE_OPERATION with ACTION = 'MOD'.

Regards,

Amit

Reward all helpful replies.

Re: to update the database table

Former Member — Tue, 29 May 2007 14:30:15 GMT

Hi Madhvi,

Check this FM 'HR_INFOTYPE_OPERATION'.

Modify the infotype value and pass it to the FM...

CALL FUNCTION 'HR_INFOTYPE_OPERATION' "Updating infotype

EXPORTING

INFTY = '0008'

NUMBER = PERNR

SUBTYPE = SUBTY

OBJECTID = ' '

LOCKINDICATOR = ' '

VALIDITYEND = ENDDA

VALIDITYBEGIN = BEGDA

RECORDNUMBER = '001'

RECORD = RECORD of type p0008

OPERATION = 'MOD;

TCLAS = 'A'

DIALOG_MODE = '0'

IMPORTING

RETURN = L_RETURN.

Message was edited by:

albert joseph

Re: to update the database table

Former Member — Tue, 29 May 2007 15:05:16 GMT

hi albert,

actually im using an user exit to update the info type 0008. now i cant use any other fm since those fields can only be used that are in the import. so i have taken a loop on the amount field of the0008. now after updateing that captured field i got to update that database table so that it is displayed on the screen.

Re: to update the database table

Former Member — Tue, 29 May 2007 15:41:12 GMT

Hi Madhvi,

can u please tell me the user exit/transaction name.

Message was edited by:

albert joseph

Re: to update the database table

Former Member — Wed, 30 May 2007 06:39:38 GMT

Hi madhvi pandey,

The updation can be done using the function modules

1) 'HR_INFOTYPE_OPERATION'.

2) 'HR_MAINTAIN_MASTER_DATA'.