Skip to Content
0
Former Member
Jun 10, 2009 at 03:17 PM

ABAP QUERY for HR-PA Data

61 Views

Hello,

I'm trying to create an ABAP Query report, which should present some employee's information (such as personnel data, Basic Pay etc) including their addresses data from IT 0006 (which I've included in the relevant Infoset).

The problem I'm facing is that if an employee has several addresses, each in a different Subtype of IT 0006, he receives several rows in the report, one row for each address record. For example, if an employee has, at the same time, a permanent home address record (corresponds to subtype '1') and a temporary residence record (subtype '2'), the query shows two rows for him, one for each address type, although I'm only interested in showing the addresses fields for permanent address (subtype '1').

I've tried to add the subtype field of IT 0006 to the selection screen with filtering for subtype = '1', however if the employee doesn't have that record, he isn't shown in the report at all.

I don't know the way to configure in the query that I'm only interested in a specific address subtype, BUT if the employee doesn't have that subtype record, I still want to see the rest of his information data (without the address fields in this case).

Can someone please assist?

Thank you very much

Liran