3077004 - TDF - Table Function does not return data from the ERP

You noticed that a table function does not return any data from the ERP but a direct query on the SAP_ECC schema does.

For example, the following query to a table function yields no results:

SELECT TOP 10 * FROM "_SYS_BIC"."sap.glo.tmflocbr.ctr::TABLE_FUNCTION_ECC_ACC_BALANCE_FAGLFLEXT" ()

But a query directly  on FAGLFLEXA does:

SELECT TOP 10 * FROM "<SAP_ECC>"."FAGLFLEXT"

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP Tax Declaration Framework

table_function tablefunction TDF tax declaration framework HANA Studio MDC return result query PRV CTR , KBA , FIN-TMF-BR , Tax Management Framework Brazil , Problem