SAP Knowledge Base Article - Preview

3390277 - 0FI_AR_9 : Delta fails with dump SAPSQL_INVALID_FIELDNAME

Symptom

Full extraction is working fine, while issue only occurs during delta load:

Runtime Errors         SAPSQL_INVALID_FIELDNAME
Exception              CX_SY_DYNAMIC_OSQL_SEMANTICS

|Short Text                                          
|    A dynamically specified column name is unknown. 

|    An Open SQL clause was specified dynamically. The contained field name         
|    "ZZCUSFLD1" does not exist in any of the database tables from the FROM clause. /* ZZCUSFLD1 is a custom field in the Extract Structure */

|    "SAPSQL_INVALID_FIELDNAME" "CX_SY_DYNAMIC_OSQL_SEMANTICS"
|    "SAPLBWFI3R" or "LBWFI3RU04"                             
|    "BWFI3R_READ_KNKK_AEDAT_DATA"
|>>>>>|      OPEN CURSOR WITH HOLD I_CURSOR FOR 
|     |      SELECT (I_SELECTED_FIELDS) FROM KNKK_AEDAT CLIENT SPECIFIED


Read more...

Environment

  • SAP R/3
  • SAP R/3 Enterprise
  • SAP ERP
  • SAP ERP Central Component
  • SAP enhancement package for SAP ERP
  • SAP enhancement package for SAP ERP, version for SAP HANA
  • SAP S/4HANA

Product

SAP ERP Central Component all versions ; SAP ERP all versions ; SAP R/3 Enterprise all versions ; SAP R/3 all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

Keywords

KBA , BW-BCT-FI , BW only - Financial Accounting , 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.