to update the database table

[Former Member]

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

[amit_khare]

Use HR_INFOTYPE_OPERATION with ACTION = 'MOD'.

Regards,

Amit

Reward all helpful replies.

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi Madhvi,

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

Message was edited by:

albert joseph

[Former Member]

Hi madhvi pandey,

The updation can be done using the function modules

1) 'HR_INFOTYPE_OPERATION'.

2) 'HR_MAINTAIN_MASTER_DATA'.