SAP Knowledge Base Article - Preview

2869975 - SUIM | Runtime Errors SAPSQL_IN_ITAB_ILLEGAL_SIGN

Symptom

Transaction SUIM aborts with Runtime Errors SAPSQL_IN_ITAB_ILLEGAL_SIGN

dump.PNG


Read more...

Environment

This KBA applies for all SAP Products based on NetWeaver and S4H

Keywords

Category               ABAP Programming Error
Runtime Errors         SAPSQL_IN_ITAB_ILLEGAL_SIGN
ABAP Program           SAPLCD_READ
Application Component  BC-SRV-ASF-CHD
Date and Time          04.12.2019 11:58:13
---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------
|Short Text                                                                                        |
|    Invalid value in SIGN field of value table for IN itab operator.                              |
|    operator.                                                                                     |
---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------
|What happened?                                                                                    |
|    Error in the ABAP Application Program                                                         |
|                                                                                                  |
|    The current ABAP program "SAPLCD_READ" had to be terminated because it has                    |
|    come across a statement that unfortunately cannot be executed.                                |
---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------
|Error analysis                                                                                    |
|    The current ABAP/4 program attempted to execute an ABAP/4 Open SQL                            |
|    statement in which the WHERE condition contains an IN itab operator.                          |
|                                                                                                  |
|    The IN itab operator is used with internal tables which                                       |
|    have the following structure:                                                                 |
|                                                                                                  |
|       SIGN(1)   OPTION(2)   LOW LIKE db_field   HIGH LIKE db_field                               |
|                                                                                                  |
|    In the SIGN column, use only one of the values "I" or "E".                                    |
|    The value " " is not allowed here.                                                            |
---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------
|Trigger Location of Runtime Error                                                                 |
|    Program                                 SAPLCD_READ                                           |
|    Include                                 LCD_READF01                                           |
|    Row                                     4.467                                                 |
|    Module Type                             (FORM)                                                |
|    Module Name                             CD_SELECT_CDHDR_HDB                                   |
---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------
|Source Code Extract                                                                               |
----------------------------------------------------------------------------------------------------
|Line |SourceCde                                                                                   |
----------------------------------------------------------------------------------------------------
| 4437|               AND   tcode      IN pt_sl_tcode                                              |
| 4438|               AND (                                                                        |
| 4439|                    (                                                                       |
| 4440|                      udate =  pv_date_of_change                                            |
| 4441|                      AND                                                                   |
| 4442|                      utime >= pv_time_of_change                                            |
| 4443|                     )                                                                      |
| 4444|                     OR                                                                     |
| 4445|                      udate >  pv_date_of_change                                            |
| 4446|                    )                                                                       |
| 4447|               AND (                                                                        |
| 4448|                    (                                                                       |
| 4449|                      udate =  pv_date_until                                                |
| 4450|                      AND                                                                   |
| 4451|                      utime <= pv_time_until                                                |
| 4452|                     )                                                                      |
| 4453|                     OR                                                                     |
| 4454|                      udate <  pv_date_until                                                |
| 4455|                    )                                                                       |
| 4456|                     AND (                                                                  |
| 4457|           (  EXISTS ( SELECT * FROM cdpos_uid                                              |
| 4458|                           WHERE objectclas EQ cdhdr~objectclas                             |
| 4459|                           AND   objectid   EQ cdhdr~objectid                               |
| 4460|                           AND   changenr   EQ cdhdr~changenr                               |
| 4461|                           AND   tabname    IN pt_sl_tabname                                |
| 4462|                           AND   tabkey     IN pt_sl_tabkey254                              |
| 4463|                           AND   keyguid    IN pt_sl_keyguid ) )                            |
| 4464|            ).                                                                              |
| 4465|                                                                                            |
| 4466|    WHEN 0. " tabname                                                                       |
|>>>>>|      SELECT * FROM cdhdr APPENDING TABLE pt_cdhdr                                          |
| 4468|               WHERE objectclas IN pt_sl_objectclas                                         |
| 4469|               AND   objectid   IN pt_sl_objectid                                           |
| 4470|               AND   changenr   IN pt_sl_changenr                                           |
| 4471|               AND   username   IN pt_sl_username                                           |
| 4472|               AND   tcode      IN pt_sl_tcode                                              |
| 4473|               AND (                                                                        |
| 4474|                    (                                                                       |
| 4475|                      udate =  pv_date_of_change                                            |
| 4476|                      AND                                                                   |
| 4477|                      utime >= pv_time_of_change                                            |
| 4478|                     )                                                                      |
| 4479|                     OR                                                                     |
| 4480|                      udate >  pv_date_of_change                                            |
| 4481|                    )                                                                       |
| 4482|               AND (                                                                        |
| 4483|                    (                                                                       |
| 4484|                      udate =  pv_date_until                                                |
| 4485|                      AND                                                                   |
| 4486|                      utime <= pv_time_until                                                |
---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------
|Active Calls/Events                                                                               |
----------------------------------------------------------------------------------------------------
|No.   Ty.          Program                             Include                             Line   |
|      Name                                                                                        |
----------------------------------------------------------------------------------------------------
|   12 FORM         SAPLCD_READ                         LCD_READF01                          4467  |
|      CD_SELECT_CDHDR_HDB                                                                         |
|   11 FORM         SAPLCD_READ                         LCD_READF01                          4294  |
|      CD_SELECT_CDHDR_TABKEY                                                                      |
|   10 FORM         SAPLCD_READ                         LCD_READF01                          3025  |
|      CD_SELECT_CDHDR                                                                             |
|    9 FORM         SAPLCD_READ                         LCD_READF01                           359  |
|      CD_READ_CDHDR_DB                                                                            |
|    8 FORM         SAPLCD_READ                         LCD_READF01                           146  |
|      CD_READ_FROM_DB                                                                             |
|    7 FUNCTION     SAPLCD_READ                         LCD_READU01                           291  |
|      CHANGEDOCUMENT_READ_ALL                                                                     |
|    6 FUNCTION     SAPLSCD2                            LSCD2U03                               36  |
|      CHANGEDOCUMENT_READ_RANGES                                                                  |
|    5 METHOD       CL_SUIM_CHDOC=================CP    CL_SUIM_CHDOC=================CM006    36  |
|      CL_SUIM_CHDOC=>GET_CHDOC_WITHOUT_IDX                                                        |
|    4 FORM         SAPLSU_USER_CHANGE_DOC              LSU_USER_CHANGE_DOCF01               1153  |
|      SELECT_ROLES_DATA                                                                           |
|    3 FUNCTION     SAPLSU_USER_CHANGE_DOC              LSU_USER_CHANGE_DOCU03                 62  |
|      SUSR_CHANGE_DOC_ROLES                                                                       |
|    2 FORM         RSUSR100N                           SR100NF10                            3083  |
|      SUSR_CHANGE_DOC_USERS                                                                       |
|    1 EVENT        RSUSR100N                           SR100NE10                             203  |
|      START-OF-SELECTION                                                                          |
---------------------------------------------------------------------------------------------------- , KBA , BC-SEC-USR-IS , User Information System , BC-SRV-ASF-CHD , Change Documents , 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.