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