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 ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.