sql problem

[Former Member]

dear all,below is my code

IF CHKPD = 'X'.

SELECT A_{MATNR A}MTART A_{SPART A}PRDHA A_{MEINS B}EKGRP B~DISPO

INTO CORRESPONDING FIELDS OF TABLE ISLOC

FROM MARA AS A INNER JOIN MARC AS B ON A_{MATNR = B}MATNR

INNER JOIN MARD AS D ON D_{MATNR = A}MATNR

INNER JOIN MKOL AS E ON E_{MATNR = A}MATNR

WHERE A_{MATNR IN S_MATNR AND A}MTART IN S_MTART AND

A_{SPART IN S_SPART AND A}PRDHA IN S_PRDHA AND

B~EKGRP IN S_EKGRP AND

( D_{LGORT IN S_LMAIN OR E}LGORT IN S_LMAIN ).

ENDIF.

i dun see any error in the coding,but when i execute,i get the following errors.

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.

How to correct the error

In the SIGN column, use only one of the values "I" or "E".

You may able to find an interim solution to the problem in the

SAP note system.

Can anyone pls tell me wat's the error about? thanks

[former_member186741]

are all the fields using 'IN' declared as select-options?

if so, have you populated some values yourself? maybe you haven't added entries correctly.

eg,

*default condition keys...

REFRESH s_kschl.

s_kschl-option = 'EQ'.

s_kschl-sign = 'I'.

s_kschl-low = 'ZXYZ'.

APPEND s_kschl.

[suresh_datti]

The piece of code pasted looks oK.. the error could be from the sel scr.. verify if u used any variants.. also, are you filling any of these sel options in the INITIALIZATION event? The error indicates that for one of the sel options the SIGN operator is left blank..

~Suresh

[Former Member]

yea,at initialization ,i hardcoded these

MOVE 'I' TO S_TEM-SIGN.

MOVE 'EQ' TO S_TEM-OPTION.

MOVE 'P190' TO S_TEM-LOW. APPEND S_TEM. CLEAR S_TEM-LOW.

MOVE 'P110' TO S_TEM-LOW. APPEND S_TEM. CLEAR S_TEM-LOW.

MOVE 'C250' TO S_TEM-LOW. APPEND S_TEM. CLEAR S_TEM-LOW.

MOVE 'I' TO S_LMAIN-SIGN.

MOVE 'EQ' TO S_LMAIN-OPTION.

MOVE 'L001' TO S_LMAIN-LOW. APPEND S_LMAIN. CLEAR S_LMAIN.

MOVE 'L002' TO S_LMAIN-LOW. APPEND S_LMAIN. CLEAR S_LMAIN.

MOVE 'I' TO S_VMAIN-SIGN.

MOVE 'EQ' TO S_VMAIN-OPTION.

MOVE 'V001' TO S_VMAIN-LOW. APPEND S_VMAIN. CLEAR S_VMAIN.

MOVE 'V002' TO S_VMAIN-LOW. APPEND S_VMAIN. CLEAR S_VMAIN.

MOVE 'I' TO S_LVPROD-SIGN.

MOVE 'EQ' TO S_LVPROD-OPTION.

MOVE 'L003' TO S_LVPROD-LOW. APPEND S_LVPROD. CLEAR S_LVPROD.

MOVE 'V003' TO S_LVPROD-LOW. APPEND S_LVPROD. CLEAR S_LVPROD.

[suresh_datti]

Change

CLEAR S_LMAIN to CLEAR S_LMAIN-LOW.

CLEAR S_VMAIN to CLEAR S_VMAIN-LOW.

CLEAR S_LVPROD to CLEAR S_LVPROD-LOW.

~Suresh

[former_member186741]

error..the clear after the append clears the whole structure and so the option and sign fields now have invalid values.

Hi Joan.....Suresh did just beat me and it looks like you've accidentally given me the points!

[Former Member]

thanks suresh ^^ problem solved

[Former Member]

thx for d infor Neil ^^

[suresh_datti]

Neil,

Actually both of us had the same timestamp.. so it is Joan's discretion and you are the chosen one.. good for you..

~Suresh

[former_member186741]

thanks for being so gracious about it Suresh but Joan's answers indicated that she'd given us both points but in fact she's given me 16 and you none! I think she just clicked on the wrong one and didn't check.

[Former Member]

huh? did i assigned wrong marks to both of u? i actually wana assigned 10marks for suresh and 6 marks for Neil. if can give both 10marks. in my display here, my 10 marks goes to suresh n 6marks goes to neil..how come suresh aint getting anymarks? hmm..sorry..i din know such problem wl occur

[Former Member]

yea..i manage to change the points d...sorry guys..

n sorry neil,if i can assign 10marks for more than one person,surely i wl give u tat 😛 anyway,thanks alot for the solutions again ^^ cheers

Joan