Skip to Content
0
Former Member
Nov 12, 2008 at 11:32 AM

error in select statement

43 Views

Hi frnds,

i am unable to write select statement given i need to check with the first 6 characters of CHARG field.

SELECT MATNR

WERKS

LGORT

CHARG

FROM MCHB

INTO TABLE IT_MCHB

FOR ALL ENTRIES IN IT_MARA

WHERE MATNR = IT_MARA-MATNR

AND WERKS = WERKS

AND LGORT = LGORT

AND CHARG+0(6) <= DATE_FRM

AND CHARG+0(6)>= DATE_TO.

above hilighted code giving me error.

I am getting error as field charg+0(6) is unknow.

regards,

sanjay

Edited by: sanjay jaju on Nov 12, 2008 12:32 PM