topic Re: Infotype in Application Development and Automation Discussions

Infotype

Former Member — Tue, 06 Dec 2005 09:22:13 GMT

How to retrieve a field from an infotype.

Suppose in infotype P0017,the field name is KFZKZ.I want to compare this field with an internal table field.

1.Can I just use If P0017-KFZKZ = INTAB-FIELD or some thing else (because it is an infotype)

2.If i want to retrieve P0017-KFZKZ,how can i do this

Please reply immediately

Re: Infotype

Former Member — Tue, 06 Dec 2005 09:31:52 GMT

Hi Jayasree,

Use the following method

Infotypes : 0017.

Start-of-selection.

rp-provide-from-last p0017 space pn-begda pn-endda.

if p0017-kfzkz = intab-field.

*--so some thing

else.

*--do something.

endif.

Reward points if it help you.

Regards,

Sudhakar

Re: Infotype

Former Member — Tue, 06 Dec 2005 09:33:24 GMT

Hi Jayasree,

You need to seelct KFZKZ from table PA0017 (HR master record: Infotype 0017 (Travel Privileges) and then do the comparision.

Regards,

Raj

Re: Infotype

Former Member — Tue, 06 Dec 2005 09:36:07 GMT

Hi jayasree,

1. How to retrieve a field from an infotype

Before answering, this

how are u retrieing infotype data ?

2. Use the FM

HR_READ_INFOTYPE

(This is recommended by SAP)

as compared to getting data

thru SQLs

3. Yes, after retriving data,

u can compare the field, like any other table field.

(Make sure u compare the right record, bcos

the infotype internal table may contain

more than one record )

Regards,

Amit M.

Re: Infotype

suresh_datti — Tue, 06 Dec 2005 10:20:32 GMT

Hi Jayasree,

The mode of data retrieval really depends on the design of your report. If you have tied it to either PNP or PNPCE Logical Database, you can use the macro ie

RP-PROVIDE-FROM-LAST or LOOP AT P0017.. ENDLOOP. If you are not using the Logical Database, you are better off using the function call 'HR_READ_INFOTYPE' instead instead of direct SELECT on the PA0017 table.

Good Luck,

Suresh DAtti

Re: Infotype

Former Member — Wed, 07 Dec 2005 06:10:46 GMT

REPORT ZTEST.

INFOTYPES: 0017.

DATA:PERNR LIKE P0017-PERNR.

CALL FUNCTION 'HR_READ_INFOTYPE'

EXPORTING

TCLAS = 'A'

PERNR = PERNR

INFTY = 'P0017'

BEGDA = '18000101'
ENDDA = '99991231'
BYPASS_BUFFER = ' '
LEGACY_MODE = ' '
IMPORTING
SUBRC =

TABLES

INFTY_TAB = P0017

EXCEPTIONS

INFTY_NOT_FOUND = 1

OTHERS = 2

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

WRITE P0017-PERNR.

WRITE P0017-KFZKZ.

iF i EXECUTE THIS CODE , A SHORT DUMP IS OCCURING . IT IS TELLING INCORRECT FUNCTION MODULE.

PL REPLY IMMM

Re: Infotype

Former Member — Wed, 07 Dec 2005 06:18:22 GMT

Hi again,

1. While calling the FM

Use

infty = '0017'

instead of infty = 'P0017'

( Don't write P )

2. It will work. I tried here.

3. We have to give the name of the infotype.

(Not the internal table)

4. The above will solve your problem and

u will not get any short dump.

5. However i noticed in the code, that

u have not passed Pernr value.

ie. we have to pass the actual personnel number.

eg. 0001, 0002 ,0100 etc.

Then only u will get some data.

Otherwise no data in P0017.

regards,

amit m.

Message was edited by: Amit Mittal

Re: Infotype

Former Member — Wed, 07 Dec 2005 06:19:25 GMT

Hi Jayasree,

Try this one:

REPORT ZTEST.

INFOTYPES: 0017.

DATA:V_PERNR LIKE P0017-PERNR,

IT_0017 LIKE P0017.

V_PERNR = '1234'. "You need to pass Personnel no

CALL FUNCTION 'HR_READ_INFOTYPE'

EXPORTING

TCLAS = 'A'

PERNR = V_PERNR

INFTY = '0017'

BEGDA = '18000101'
ENDDA = '99991231'
BYPASS_BUFFER = ' '
LEGACY_MODE = ' '
IMPORTING
SUBRC =

TABLES

INFTY_TAB = IT_0017

EXCEPTIONS

INFTY_NOT_FOUND = 1

OTHERS = 2

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

WRITE IT_0017-PERNR.

WRITE IT_0017-KFZKZ.

Let me know still you are getting dump.

Award points if it helps you.

Regards,

Sudhakar.

Re: Infotype

Former Member — Wed, 07 Dec 2005 06:46:22 GMT

In HR Module keep few things in your mind

P0001, P0002....P0017....

All are line type of tables

PA0001, PA0002.....PA0017..

And their infotypes Are

0001, 0002.....0017...

So in your case instead of INFTY = P0017 use infty = 0017.

Hope you get your problem solved now

Regards

Amit

Re: Infotype

Former Member — Sun, 24 Jun 2007 12:48:09 GMT

hey,

declare the internal table type table pa0017..

pass the value of the Infotype...

i.e., instead of p0017, give '0017'