topic Re: employees joining table in Application Development and Automation Discussions

employees joining table

Former Member — Mon, 13 Oct 2008 05:26:36 GMT

HI,

How can i get no.of employees joined in a particular month.

please help me.

with regards,

jaya.

Re: employees joining table

GauthamV — Mon, 13 Oct 2008 05:29:27 GMT

hi,

you can use pa0000 table.

give action type as 01 and execute.

Re: employees joining table

satsrockford — Mon, 13 Oct 2008 05:33:08 GMT

Hi,

look at this sample code.

data: text(255).

data: v_x.

text = 'AA,17,2/19/2003,"9,999.00",USD,00,10,318,"193,275.31"'.

do.

v_x = ' '.

search text for '"' and mark.

if sy-subrc = 0.

replace first OCCURRENCE OF '"' in section offset sy-fdpos of text with

''.

replace first OCCURRENCE OF ',' in section offset sy-fdpos of text with

''.

replace first OCCURRENCE OF '",' in section offset sy-fdpos of text with

','.

v_x = 'X'.

endif.

if v_x = ' '.

exit.

endif.

enddo.

write:/ text.

regards

Satish

Re: employees joining table

satsrockford — Mon, 13 Oct 2008 05:34:05 GMT

sorry... the previous thread was nt 4 u...

Re: employees joining table

Former Member — Mon, 13 Oct 2008 05:36:07 GMT

Hi Jaya,

In the Actions infotype (0000) - pa0000 (in SE11) we require the fields Pernr, Endda, Begda, and Stat2 fields.

Your select query will be something like :

SELECT PERNR
   FROM PA0000
   INTO    ITAB
   WHERE BEGDA LE '20081001'    (FIRST DAY OF THIS MONTH)
         AND ENDDA GE '20081031'    (LAST DAY OF THIS MONTH)
         AND STAT2 EQ '3'.

Regards,

Swapna.

Re: employees joining table

Former Member — Mon, 13 Oct 2008 05:46:15 GMT

hi ,

I gave action type 01,but it is not working.where i have to give action type after where clause or what.

regards,

jaya.

Re: employees joining table

GauthamV — Mon, 13 Oct 2008 06:04:54 GMT

hi,

check this.


tables: pa0000.
select-options: s_pernr for pa0000-pernr.

DATA : BEGIN OF I_PA00 OCCURS 0,
       PERNR LIKE PA0000-PERNR,
       endda type pa0000-endda,
       begda type pa0000-begda,
       massn type pa0000-massn,
       stat2 type pa0000-stat2,
       END OF I_PA00.

  SELECT PERNR endda begda massn stat2 FROM PA0000
  INTO corresponding fields of TABLE I_PA00
  WHERE PERNR IN S_PERNR
  AND  massn = '01'.

  loop at i_pa00.

  write:/ i_pa00-pernr,i_pa00-begda,i_pa00-endda,i_pa00-massn.
  endloop.