0PT_C01 Time & Labour > Eveything Before

[Former Member]

How does the standard cube 0PT_C01 for Time and Labour know that when an absence occurs between certain dates that it falls into a certain calendar month e.g. absence is Between March & April how does it know to portion part of the absence to March and part to April (0CALMONTH). I cant see that it's a day to reference against etc.

[Former Member · Accepted solution]

You cannot obtain the reference date for the absense only the month....you can enhance the extractor for load the date...

Regards

[Former Member]

> How does the standard cube 0PT_C01 for Time and Labour know that when an absence occurs between certain dates that it falls into a certain calendar month e.g. absence is Between March & April how does it know to portion part of the absence to March and part to April (0CALMONTH).

If employee enter his absence data for example March 23 to Apr 10 through PA20 transaction.

The data will store in PA2001 table like below for each day.

Empno March 23

Empno March 24

Empno ...

Empno .

Empno March 31

Empno Apr 01

Empno Apr02

Empno . ..

Empno .

Empno .

Empno Apr10

BI extractor gets the data from this table and converts each day (entry) to relevant cal month.

for example March 23 is converts to calendar month March

and Apr 01 will convert to calendar month April.

hope it clear.

Cheers,

Sree

[Former Member]

Yes... There is no Day reference for standard cube and Info source.

But actual time (Time and Labour) capturing from PA20 transaction at source system side (ECC or R/3) and populating the Absences (PA2001) table based on entered dates. The standard BI extractoru2019s gets from this Absences table and internally it converts based calendar day to Calendar Month.

Cheers,

Sree

[Former Member]

Can you please elaborate on how it does it? I want to the same on another cube but have no idea how.