topic Re: getting access to subtypes in Application Development and Automation Discussions

getting access to subtypes

anupam_srivastava2 — Fri, 27 Mar 2009 13:13:57 GMT

Hi all

I want to access data from two infotypes 0002 and 0014.

for 0014 I need to access its subtypes as well.

Requirement is - for all the emp who has subtype (wagetype) from 8100 to 8124 for the current payroll period from infotype 0014 and name from infotype 0002.

Is there any macro which I can use.

Re: getting access to subtypes

Former Member — Fri, 27 Mar 2009 13:57:35 GMT

Hi,

You can do this using Logical Database PNP,

but you would still have to code a bit to fulfill the Wage Type requirement.

Instead of Macros, you can do this with 2 simple select statements:

1. get PERNRs from PA0014 where WageType Between 8100 and 8124

2. get Name ( VORNA & NACHN ) from PA0002 for all above selected PERNRS.

Regards,

Samson Rodrigues.

Re: getting access to subtypes

anupam_srivastava2 — Fri, 27 Mar 2009 14:09:01 GMT

Hi Samonos

I know using logical data base pnp....

I have written this provide statement after get pernr

provide * into ITAB_p0002 from p0002

into ITAB_p0014 from p0014 between pn-begda and pn-endda

where p0014-lgart in s_lgart.

endprovide.

but the thing is this provide statement is not selecting for a particular pernr all the relevant wage types, say pernr - 0001 has three wage type with in the range it selects only first.

I tried puting it into internal table and then extrancting but it doesnt work.

any idea how we can extract all the relevant wage types for a partucluar pernr.

Re: getting access to subtypes

Former Member — Sat, 28 Mar 2009 03:43:23 GMT

Hi,

In S_LGART, have you put all the wagetype OR only the first and the last,

Put all and check if it works, since you have used " IN " in the query.

Regards,

Samson Rodrigues

Re: getting access to subtypes

anupam_srivastava2 — Wed, 27 May 2009 12:52:39 GMT

thanks