Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

problem while updating a database table

Former Member
0 Likes
1,043

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.

4 REPLIES 4
Read only

Former Member
0 Likes
865

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

Read only

0 Likes
865

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.

Read only

Former Member
0 Likes
865

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

Read only

0 Likes
865

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.