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
About this pageThis 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.