employees joining table

[Former Member]

HI,

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

please help me.

with regards,

jaya.

[GauthamV]

hi,

you can use pa0000 table.

give action type as 01 and execute.

[Former Member]

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.

[GauthamV]

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.

[satsrockford]

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

[satsrockford]

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

[Former Member]

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.