topic Re: In which table?? in Application Development and Automation Discussions

In which table??

JJAIMES — Mon, 06 Feb 2012 17:28:49 GMT

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.

Re: In which table??

Former Member — Mon, 06 Feb 2012 17:31:39 GMT

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

Rob

Re: In which table??

RaymondGiuseppi — Tue, 07 Feb 2012 08:01:40 GMT

- Look at my answers in

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

Regards,

Raymond

Re: In which table??

jrg_wulf — Tue, 07 Feb 2012 08:59:39 GMT

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

Regards

Jörg

Re: In which table??

Former Member — Tue, 07 Feb 2012 09:14:28 GMT

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

Re: In which table??

JJAIMES — Wed, 08 Feb 2012 16:56:32 GMT

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

Re: In which table??

JJAIMES — Wed, 08 Feb 2012 17:02:13 GMT

Raymond:

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

Re: In which table??

JJAIMES — Wed, 08 Feb 2012 17:20:12 GMT

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?

Re: In which table??

RaymondGiuseppi — Thu, 09 Feb 2012 07:42:28 GMT

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

Re: In which table??

jrg_wulf — Thu, 09 Feb 2012 08:34:54 GMT

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

Re: In which table??

RaymondGiuseppi — Thu, 09 Feb 2012 08:54:19 GMT

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

Re: In which table??

JJAIMES — Wed, 15 Feb 2012 21:27:36 GMT

Thanks very much Jörg Wulf!!

Very usefully the FM!