SAP Knowledge Base Article - Preview

3304647 - Executing FDA WRITE statements as natively for troubleshooting purposes

Symptom

As outlined in SAP note 2399993, FOR ALL ENTRIES statements are usually using the FDA WRITE functionality, which means using an internal table for transferring the content of the FAE table to the HANA database. Since FOR ALL ENTRIES is an ABAP language construct, no directly equivalent in HANA native SQL exists. However, for troubleshooting and tracing it is often helpful to have a possibility to execute those statements using native SQL, e.g., using the SQL Console in HANA Studio / Database Explorer.

"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 HANA Platform edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

KBA , HAN-DB-PERF , SAP HANA Database Performance , Problem

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.