Skip to main content

Hi folks,

I have the task to model a HR - cube with some fact data.
One of the questions is:
How many hours a day a given person are “planned” or “normal workday” time?

The customer showed me the report “Personal Schedule” and I created some example data.
The report will give me explicit what I need:

 

 


This is the form of “plan” data I need.
EmpNo, Date, From, To, (Plan) Hours.
Later on I can compare the “plan” with the actual hours, like booked hours, even sick leave, customer visits, etc.

I traced the report to INFO_SERVICES_RPT and found the data the report is using.

 

I learned that RPT Tables are only for temporary data used for a specific report and are cleaned afterwards.

So is there another structure the report is fetching the data into the INFO_SERVICES_RPT?


Or is there a “master calendar”?

Hmm, I just checked on legal holiday like “Eastern” I saw that this personal schedule just show a normal work day.

Any hints are highly welcome.

all the best and stay safe.

 

Michael

 


 

Hi,

I think it is the best to have a look in TIME_PERS_DIARY_CL_SCHED_INFO.

 

The work days have to be checked from bottom to top.

Usually there is only DAY_TYPE filled, if there is also DEV_CYCLE_DAY_TYPE this is relevant.
If there is SUB_DAY_TYPE filled, this is relevant or the fourth would be relevant if filled DEV_DAY_TYPE.

For that day you have to check the WORK_SCHED_DAY_TYPE_OVERVIEW, how many hours that day has.

So you get the daily hours for any employee for any day, even if it a holyday or a weekend.

Terms & ConditionsCookie settings