Absence/Attendance type Issue

[Former Member]

Hi All,

To get Absence/Attendance type I am using 0HR_PT_2 Data source & Reporting Type 00000001 .To get Particular Reporting time type wise Absent days I am using T557G Table .

In 0HR_PT_2 Data source I have PERNR(Personnel Number) , KMONTH(Calendar year / month) , KDAY(Calendar day) & REPTT(Reporting Time Type) are coming . So I need Absence/Attendance type and Ps Grouping against this values in a record.

T557G Entrys are :

Reporting Time Type      PSG     A/ATYPE    UNIT

00000001                         1          0100           15

00000001                          1         0110            15

00000001                          1         0140            15

Can any one please help on this issue.

Regards,

Samar

[Former Member]

Hi,

I have changed the logic

when '0HR_PT_2'.

      loop at c_t_data into wa_PTDW_TIMES.

       ws_tabix = sy-tabix.

* Get Attendance/Absence type

      select single begda awart from PA2002

      INTO (l_begda, l_awart)

      where pernr = wa_PTDW_TIMES-pernr

      and begda = wa_PTDW_TIMES-KDAY.

      endloop.

[RamanKorrapati]

do the syntax check and run your data source at
RSA3.  later check the data output.

[RamanKorrapati]

Hi,

Means your data source have those fields? Absence/Attendance type and Ps Grouping .

if not then think about enhancement.

if you have those fields part of data source then where your facing this issue.

Thanks

[Former Member]

Hi ,

Absence/Attendance type and Ps Grouping fields i have enhanced . Problem is like it is fetching data from T557G , there are multiple absent types are available  but it is fetching only one( first )absent type .

Below code i have written.

SELECT

     GRBIW

     REPTT

     MOABW

     AWART

     TIMTY

     FROM T557G

     INTO TABLE LT_T557G

     WHERE REPTT = '00000001'.

   SORT L_T_DATA BY PERNR KMONTH.

   LOOP AT L_T_DATA INTO WA_DATA.

     READ TABLE LT_T557G INTO LS_T557G WITH KEY REPTT = WA_DATA-REPTT.

     IF SY-SUBRC = 0.

       WA_DATA-ZZAWART = LS_T557G-AWART.

       WA_DATA-ZZMOABW = LS_T557G-MOABW.

       MODIFY L_T_DATA FROM WA_DATA.

     ENDIF.

     CLEAR:LS_T557G.

Regards,

Samar

[RamanKorrapati]

Hi,

because your condition is like that only.

if REPTT = 00000001'. then only its pulling data.

better to look for other conditions which can satisfy to pull the data of all REPTT types.

Check data source base tables and T557G , check the available common fields between them.

use the right field/condition to pull the data.

take abaper help to find the proper conditions to pull the data form T557G for all reptt types.

Thanks

[Former Member]

Hi,

Actually , I don't  know the base table for this data source .

More over , When I am passing Reporting Time type to T557G , It is giving me multiple values.

I need to attendance type and PS grouping  in my record against PERNR , KMONTH , REPTT .

Regards,

Samar

[RamanKorrapati]

Hi,

at RSA3, increase data record calls and display calls.

extract the data and check it. as my guess you can see other types data also.

from rsa3 screen your seeing one data package only. you need to see other packages then you can see the data.

other wise, at RSA3 if you selection on REPTT, pass 00000001 and extract.

check the results.

Thanks

[Former Member]

Hi,

Extracted entire data in QA System RSA3 - Tcode

Reporting Time type - 0000001 , Absent Type - 100 only showing remaining types are not showing .

Can you please guide

Regards,

Samar

[RamanKorrapati]

take abap expert and debug your data source at RSA3.

we can find where will be the issue.