Joining HRP1001 and PA0002 with SQ02

[Former Member]

Hi all,

I'm new to SQ02, I'm used to create report with ABAP.

I'm trying to create a simple query using HRP1001 and PA0002 joined by hrp1001-sobid and pa0002-pernr.

The fields are different so it's not possible to do it with the graphical join interface.

I know I should put some ABAP somewhere in the infoset but I don't know what code and in which code section.

Please provide me with step by step instructions to achieve this.

Thanks

[Former Member]

Hi,

Below are the necessary steps.

1. InfoSet based on LDB PNPCE.

2. Infotype selections for InfoSet

3. For data from HRP1001 you can use group “Infotypes of related objects”

which includes objects related to employee ( S – position, C – job …. )

Regards

[Former Member]

This seems to work, but I'm getting all the employees with their positions.

I need to have all positions with the employee assigned to it and even position without assignments.

[Former Member]

It's not possible without ABAP custom code. With SQ02 you only will archive this way.

[Former Member]

OK then, that's what I'll do.

Thanks all

[mohamedhassan_mohamedh]

you can join between the tables on filed HRP1001-SOBID and PA0002-PERSNO

because all of them the personal number

thank you.