SAP Knowledge Base Article - Preview

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

Symptom

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."


Read more...

Environment

SAP Tax Declaration Framework

Product

SAP ERP all versions ; SAP S/4HANA all versions

Keywords

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 page

This 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.