Symptom
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.