Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to use a logical database's selection screen elements

Former Member
0 Kudos

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.

2 REPLIES 2

Former Member
0 Kudos

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
0 Kudos

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