split command

[Former Member]

SPLIT ZY310-ZBARCODE at '|' into VAR1 VAR2 VAR3.

SELECT BELNR MENGE FROM ZY310 INTO TABLE T_ZY310 WHERE VAR3 = P_ZCAM AND MATNR = P_ZPART.

when i execute the program , i'm getting VAR3 is unknown, pleae let me know

[Former Member]

Hi

In SELECT statement..WHERE x = y....x shud be a field of the table..

Here Var3 is not a field of the table

Cheers

~Arun

Message was edited by:

Arun Shekhar

[RichHeilman]

VAR3 is not a field in your table ZY310. This is the reason for the error.

Regards

Rich Heilman

[Former Member]

ELECT BELNR MENGE FROM ZY310 INTO TABLE T_ZY310 WHERE VAR3 = P_ZCAM AND MATNR

is var3 a filed in the table zy310.. if not you cannot do this..

in whre condition you are going to compare the value of a database table field not a field that you have declared in the program on the left side of the condition..

[Former Member]

Hi,

i think that the problem is that ZY310-ZBARCODE is not a char or a caracter.

regards,