SAP Knowledge Base Article - Preview

2552412 - The addition or variable with ID "XXX" is not allowed in conjunction with FOR ALL ENTRIES.

Symptom

During syntax check, following syntax error is raised:

The addition or variable with ID "XXX" is not allowed in conjunction with FOR ALL ENTRIES.

or

This command contains additions (such as expressions or new SQL syntax) that cannot be used with FOR ALL ENTRIES.

Host variables are used in the select list of the affected SELECT FOR ALL ENTRIES statement.

Example:

sql syntax.PNG

The syntax error may only happen on 745+ kernel, but doesn't happen on 742 kernel.


Read more...

Environment

Kernel Release >= 745.

Product

SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

OPEN SQL, FAE, SQL syntax, For all entries, syntax error , KBA , BC-ABA-LA , Syntax, Compiler, Runtime , BC-DB-DBI , DB Independent Database Interface , 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.