How does Half day holiday displayed in table TFACS

[shlomi_weiss]

Hi all

We are using table TFACS in order to load dates to Data Sphere
and it works fine

We have a need to hold Half days, we have found that we can maintain Half Day holiday in Holidays Calendar and assign it to factory calendar

But after that if we look at table TFACS we see a value of '0' for that day

In SAP Datasphere we would like to use the standard date functions of WORKDAYS_BETWEEN etc. and it works fine now without the Half Day issue

Any help will be appreciated

Shlomi

[Martin_Kuma]

Hi Shlomi, 

I would replicate (as remote table) the TFACS into a central space. 

Then either: 

# share to specific business spaces as view, where you can create a calculated column - half day

# create a view based on the TFACS in the central space with the calculated column - half day and share this view to business spaces directly. 

This way you have the logic in DSP and will not need to tackle any source system issues as with the factory calendar there are some discrepancies in S/4 releases as far as I am aware of. 

Martin

[shlomi_weiss]

Hi Martin

Sorry for my late response

I did replicate the table to DSP but I fail to understand how to add a column for Half day
the base table has a column for each month MON01, MON02 etc. I need to be able to have half days in the same columns
I would also want to be able to continue using the standard date functions of WORKDAYS_BETWEEN etc. and I believe that with new column they will not work

Regards

Shlomi

[shlomi_weiss]

Hi Martin,

[Martin_Kuma]

Hi Shlomi, np. better late then never :).

Just to be sure, you need to have the same values as in MON01..MON02 as half days? 

MON01..MON12 have each 31 chars, for each day one char: 1-working day / 0 - notworking day. For me half-day is the same as working day - so every '1' in the MON01...MON12 columns stays for working day, either half or full.

Do you need to have a difference between first-half or second-half day? If not, I would just duplicate the MON01...MON12 1:1, and when calculating with the duplicated columns, just divide by 2. 

Martin

[shlomi_weiss]

Hi Martin, you are correct. I count half day as 0.5 data and not as 1 so I wanted some kind of a solution like '2' as you mentioned but I want the regular functiom like workays_between to be able to take that info accout

[Martin_Kuma]

Hi Shlomi, now I have to apologize for the late response :). For this you need to create your own function. The workays_between calculates full-days regardless of what is in the TFACS, it just uses the factory calendar to identify working / not-working days (1/0).