JR38012: ABAP SQL BUILDER RETURNS SYNTAX ERRORS WHEN SPECIFYING AN "IN" P ARAMETER WITH SPACES

APAR status

• Closed as fixed if next.

Error description

• Case reported from field and verified by QA. There is an issue
  with
  ABAP SQL Build. A syntax error occurs at program generation
  when specifying an IN parameter with spaces.
  
  QA verified that when spaces are included in the "IN"
  statement of a WHERE clause, a syntax error is returned by the
  'Generate Program" button. This error can be reproduced using
  the following syntax:
  
  this gives a syntax error (first screenshot) -> IN ( '0030',
  '0222', '0526' )
  this works fine (second screenshot) -> IN ('0030', '0222',
  
  '0526')
  
  The following error is returned at design-time (during program
  generation) and is displayed in the "ABAP Code Editor":
  
  
  Line = 66
  Offset = 0
  Error Message = Comma without preceding colon (after SELECT ?).
  
  
  QA Configuration:
  IS 8.1, FP1 (GA) with SAP R/3 6.5.0.1, GA build
  

Local fix

• Do not use spaces in the "IN" clause.
  

Problem summary

• ABAP SQL BUILDER RETURNS SYNTAX ERRORS WHEN SPECIFYING AN "IN" P
  ARAMETER WITH SPACES
  Case reported from field and verified by QA. There is an issue
  with
  ABAP SQL Build. A syntax error occurs at program generation
  when specifying an IN parameter with spaces.
  
  QA verified that when spaces are included in the "IN"
  statement of a WHERE clause, a syntax error is returned by the
  'Generate Program" button. This error can be reproduced using
  the following syntax:
  
  this gives a syntax error (first screenshot) -> IN ( '0030',
  '0222', '0526' )
  this works fine (second screenshot) -> IN ('0030', '0222',
  
  '0526')
  
  The following error is returned at design-time (during program
  generation) and is displayed in the "ABAP Code Editor":
  
  
  Line = 66
  Offset = 0
  Error Message = Comma without preceding colon (after SELECT ?).
  
  
  QA Configuration:
  IS 8.1, FP1 (GA) with SAP R/3 6.5.0.1, GA build
  

Problem conclusion

Temporary fix

• Do not use spaces in the "IN" clause.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• R650 PSY

     UP