In which table??

[JJAIMES]

Hi to anybody:

I am wondering, since last week (in the transaction boldCAT2), Which table can I retrieve the target hours values to every day In, specifically I'm refering to the planned working time?

Any info additional will be a plus for me.

Thanks.

[JJAIMES]

Hi to anybody:

I am wondering, since last week (in the transaction boldCAT2), Which table can I retrieve the target hours values to every day In, specifically I'm refering to the planned working time?

Any info additional will be a plus for me.

Thanks.

[Former Member]

Run transaction ST05 in parallel with CAT2 to see the tables hit.

Rob

[RaymondGiuseppi]

- Look at my answers in

- ST05 (SQL trace) or SE30(old)/SAT(new) can provide the information too.

Regards,

Raymond

[jrg_wulf]

Hi, AFAIK the values you're looking for, are stored in Table CATSDB.

Regards

Jörg

[JJAIMES]

Thanks, but in that table are the hours that the employess has worked per day.

[JJAIMES]

Raymond:

I was reading that info but there isn't a table to looking for the information.

[JJAIMES]

By example:

In this Company to a particular particular from Mon to Thu is equal 9,5 hrs and the Fri = 4,58.hrs.

To another employee with 15x7, his hours are:

(Mon to Fri = 6 AND Sat to Sun = 5 hrs ) each 2 weeks

and 0 hrs each 3 weeks.

Anyone has idea Where SAP save this data?

[RaymondGiuseppi]

As I wrote in other thread, start from Infotype 0007 and navigate thru foreign keys or perform analysis of FM BAPI_TIMEAVAILSCHEDULE_BUILD (Read source or execute this FM for a personal number and a range of date with transaction SE30/SAT, you should easily find table T508A and its link to PA0007...)

Regards,

Raymond

[jrg_wulf]

Hi,

sorry i got your request wrong in the first attempt.

The easiest way would be to perform FM HR_READ_TIMEDATA_PSP, to retreive shift info for every day in the interval.

Should the results in table pers_avail not satisfy your needs, you may want to read table T550A for more detailed information

SELECT * FROM t550a into ls_550a

WHERE tprog = pers_avail-tprog

and MOTPR = pers_avail-motpr

and varia = gpers_avail-varia

and pamod = pers_avail-pamod.

Regards

Jörg

[RaymondGiuseppi]

Actually call the FM I provided with SE30, and you will get a list of the table (filter analysis record selecting only Fetch and Select) and you will get the list of table which give the "personal availabiliy"

PA0000	HR Master Record: Infotype 0000 (Actions)
PA0001	HR Master Record: Infotype 0001 (Org. Assignment)
PA0002	HR Master Record: Infotype 0002 (Personal Data)
PA0003	HR Master Record: Infotype 0003 (Payroll Status)
PA0007	HR Master Record: Infotype 0007 (Planned Working Time)
PA0049	HR Master Record: Infotype 0049 (Red.Hrs./Bad Weather)
PA2001	HR Time Record: Infotype 2001 (Absences)
PA2002	HR Time Record: Infotype 2002 (Attendances)
PA2003	HR Time Record: Infotype 2003 (Substitutions)
PA2004	HR Time Record: Infotype 2004 (Availability)
PA2005	HR Time Record: Infotype 2005 (Overtime)
SXS_ATTR	Exit: Definition side: Attributes for an enhancement
T000	Clients
T001P	Personnel Area/Subarea
T503	Employee Group/Subgroup
T508A	Work Schedule Rules
T550A	Daily Work Schedule
T550P	Break Schedules
T552A	Monthly Work Schedule
T554S	Attendance and Absence Types
T777D	Infotypes - Dialog/Database Assignment
T77S0	System Table
V_EXT_ACT	Generated Table for View V_EXT_ACT

Do it on YOUR system to be in sync with the version of your system and your local Custromizing. (You may have activated some Exits or BAdIs)

Regards,

Raymond

[JJAIMES]

Thanks very much Jörg Wulf!!

Very usefully the FM!

[Former Member]

HI friend,

See the program RPTIME00 for all time related doubts.

You can find the solution from it.

If any issues please revert back to me i will help you.

Thanks,

Sri Hari