topic Re: problem while updating a database table in Application Development and Automation Discussions

problem while updating a database table

Former Member — Tue, 23 Oct 2007 06:48:36 GMT

Hi experts,

I've used the FM 'HR_INFOTYPE_OPERATION' to update the database table. In that i used the MOD operation to update the Infotype PA0315. But it return an error message like "Infotype does not exist". What could be the reason for this error?.

regards,

Shanthi.

Re: problem while updating a database table

Former Member — Tue, 23 Oct 2007 06:50:58 GMT

Hi,

The field would be having a foreign key relation ship with some other table.

Open the table in SE11 & check in ENTRY/HELP CHECK tab whether that field has a foreign key & Check table.

If yes, then 1st insert a entry in Check table.

Best regards,

Prashant

Re: problem while updating a database table

Former Member — Tue, 23 Oct 2007 06:52:17 GMT

Hi Shanthi,

R u passing infotype in codes ( ' ' ) like '0315'.

It might possible that infotype 0315 is not maintained for that employee.

Can u please paste code that u r using.

So that I can help u.

Regards,

Hemant

Message was edited by:

Hemant Goyal

Re: problem while updating a database table

Former Member — Tue, 23 Oct 2007 07:20:04 GMT

Hi,

I checked in PA0315. Only the Pernr and Lifnr have check table . I used only the values which are present in those check tables. But still the same error error is coming. Actually i'm updating the values PERNR, LIFNR, EBELN, EBELP, ZZKONNR, ZZNDEBI, BEGDA, ENDDA. How to solve this?

Regards,

Shanthi.

Re: problem while updating a database table

Former Member — Tue, 23 Oct 2007 07:32:15 GMT

Hi,

Here is my code for updation.

CALL FUNCTION 'BAPI_EMPLOYEE_ENQUEUE'

EXPORTING

NUMBER = P0315-pernr

IMPORTING

RETURN = wf_returne.

*----

Update Mode

CALL FUNCTION 'HR_INFOTYPE_OPERATION'

EXPORTING

INFTY = '0315'

NUMBER = P0315-PERNR

SUBTYPE = P0315-SUBTY

OBJECTID = P0315-OBJPS

LOCKINDICATOR = P0315-SPRPS

VALIDITYEND = P0315-ENDDA

VALIDITYBEGIN = P0315-BEGDA

RECORDNUMBER = P0315-SEQNR

RECORD = P0315

OPERATION = 'MOD'

TCLAS = 'A'

DIALOG_MODE = '0'

IMPORTING

RETURN = wf_return.

*----

Dequeue

CALL FUNCTION 'BAPI_EMPLOYEE_DEQUEUE'

EXPORTING

NUMBER = P0315-PERNR.