Reading Texts from Infotype

[Former Member]

Hi,

How can we read texts from the Infotype. There is this function module HR_ECM_READ_TEXT_INFOTYPE, but we need the Employee Number, Begin date and End Date as inputs.

I just want to check if a field with a particular value exists or not.

just like this works to check whether the field DAT35 with value 99991231 exits or not.

SELECT PERNR FROM PA0035 INTO V_PERNR WHERE DAT35 = '99991231'.

IF SY-SUBRC = 0.

ENDIF.

the same way for a text, but this text actually gets stored in a structure thats why we cannot use a select for infotype

Thanks in advance.

[Former Member]

Hi,

How can we read texts from the Infotype. There is this function module HR_ECM_READ_TEXT_INFOTYPE, but we need the Employee Number, Begin date and End Date as inputs.

I just want to check if a field with a particular value exists or not.

just like this works to check whether the field DAT35 with value 99991231 exits or not.

SELECT PERNR FROM PA0035 INTO V_PERNR WHERE DAT35 = '99991231'.

IF SY-SUBRC = 0.

ENDIF.

the same way for a text, but this text actually gets stored in a structure thats why we cannot use a select for infotype

Thanks in advance.

[Former Member]

Hi,

What i am getting from ur explanation is that u are having a probelm in accessing a text field from the infotype, i.e: the value field in included in the infotype table (PA0035) but its text is in another table.

If this is the problem, u should first use select statement on PA0035 to get the required infotype record. Then use F1 help on the required text field on the infotype screen to get the table and field name. Then u can use select statement on that table by specifying the relavant value field from the previous select in the where clause.

Hope this hepls

[Former Member]

I dont have a problem accessing the field in the Infotype.

I want to use it in my Report.

Like I said the text field gets stored in a structure which cannot be read by any select statement.