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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.