topic split command in Application Development and Automation Discussions

split command

Former Member — Fri, 24 Aug 2007 14:49:47 GMT

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

Re: split command

Former Member — Fri, 24 Aug 2007 14:53:52 GMT

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

Re: split command

RichHeilman — Fri, 24 Aug 2007 14:54:36 GMT

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

Regards

Rich Heilman

Re: split command

Former Member — Fri, 24 Aug 2007 14:55:32 GMT

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

Re: split command

Former Member — Fri, 24 Aug 2007 15:05:29 GMT

Hi,

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

regards,