How to calculate days between 2 dates excluding public holidays over SAP ?

[Former Member]

Hi

Have a universe over SAP data. Trying to calculate days between 2 dates. SAP holds Public Holiday data in various tables e.g Thol and data is updated via scal. Using my univeres as a source I want to run reports for different countries so need to have various bank holidays not just UK. In SAP function modules handle this. Has anyone designed a solution to cater for this situation in a universe ?

Thanks in advance

M

[former_member192142]

Hi,

I assume you mean SAP R/3 (ECC) when you write SAP and SAP BW.

Are you using BW? If so, I would load the data into SAP BW, create a query using customer exit variables and build your universe on top of that...

-J