How to use a logical database's selection screen elements

[Former Member]

Hi all,

I have used the logical db, pnp, in my report, however when I want to select data about a personel , ie. her name surname plans-positions, how will I join the two tables pa0001 and logical db? and the table t528t - text for plans?

Thanks.

[Former Member]

Hi,

When u create ur progrm Z_ABCD,

in the Attributes pop up mention logical databse as PNP , hence it would be fetching allthe pernrs information for given Infotypes.

now to get the required report category, once u create u r prgm, go to attributes, click on HR Report category, click on report category, F4, u 'll find a big list and selct to ur requirement.

If , if u dont find ur required fields, go to create a Zreport category.

Regrads,

Rohini devi

[Former Member]

Hi Deniz,

First of all give Logical database PNP in program attributes(Goto->Attributes).

In program write the following code.

Infotypes : 0000,

0001.

start-of-selection.

get pernr.

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

if pnp-sw-found = '1'.

w_itab-pernr = p0001-pernr.

else.

reject.

endif.

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

if pnp-sw-found = '1'.

w_itab-vorna = p0001-plans.--->position

else.

reject.

endif.

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

if pnp-sw-found = '1'.

w_itab-vorna = p0002-vorna. -

---

>first name

w_itab-nachn = p0001-nachn.--->last name

else.

reject.

endif.

append w_itab to t_itab.

end-of-selection.

Dont forget to reward points if found useful.

Thanks,

Satyesh