3502309 - weekdays_between() function not working

Symptom

You try to use function weekdays_between(). However, following error message was shown:

column store error: column store error: exception 334036: Unable to read information from table or view FHC_CONFIGFZ - invalid schema name: FHC_CONFIG: line 1 col 15 (at pos 14) at SQLFrontend/SQLPreprocessor/Rules/Impl/TableValidation.cpp:253; $$detail$=Statement: 'SELECT 1 FROM {} WHERE CLIENT = ? AND KEY_FIELD = 'MIGRATION_COMPLETED' AND VALUE = 'X'', user: XX

Environment

HANA

Product

SAP Datasphere 1.0 ; SAP HANA 1.0, platform edition ; SAP HANA Cloud all versions ; SAP HANA, platform edition 2.0

Keywords

FHC_C_FCAL, FHC_C_FCAL_EXC, FHC_C_HCAL, FHC_C_HCAL_ASSGN, FHC_C_HOL, FHC_C_HOL_EASTER, FHC_C_HOL_FIXED, FHC_C_HOL_FLOAT, FHC_C_HOL_FLDATE, FHC_C_HOL_WKDAY, FHC_CONFIG , KBA , HAN-DB , SAP HANA Database , BC-SRV-ASF-CAL , Factory Cal., Holiday Cal., PC Calendar , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.