Symptom
DataSource 0FI_GL_10 (or 0FI_GL_12, generated 3FI_GL_xx_TT / 3FI_SL_xx_TT, or other GUSL-based SL extractors) extraction fails with runtime error SAPSQL_PARSE_ERROR (CX_SY_DYNAMIC_OSQL_SYNTAX) in program GP_GLX_FAGLFLEXT (or GP_GLX_HDB_FAGLFLEXT / GP_GLX_* generated programs).
Common parser messages:
- "The parser produced the error: The elements in the "GROUP BY" list must be separated using commas."
- "PRCTR is not valid here" (or similar field name errors).
The issue appears after an S/4HANA upgrade or support package application.
Read more...
Environment
- SAP S/4HANA 104 up to SP14
SAP S/4HANA 105 up to SP12
SAP S/4HANA 106 up to SP10
SAP S/4HANA 107 up to SP08
SAP S/4HANA 108 up to SP06
SAP S/4HANA 109 up to SP02
Product
Keywords
SAPSQL_PARSE_ERROR, CX_SY_DYNAMIC_OSQL_SYNTAX, GP_GLX_FAGLFLEXT, GP_GLX_HDB_FAGLFLEXT, 0FI_GL_10, 0FI_GL_12, 3FI_GL_xx_TT, PRCTR, GROUP BY, GUSL_SELECT, GUSL_SELECT_HDB, RSSGPCLA, RG_GUSL_GENERATE, FAGLFLEXT, ODP, S/4HANA upgrade , KBA , BW-BCT-FI-GL , BW only - General Ledger , FI-GL-GL , Basic Functions , 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.
SAP Knowledge Base Article - Preview