fetching

[dineshkumar_shanmugasabap]

abrw   bezei

y1      general clinic

y2      sunday clinic'

y3     special clinic

im using

SELECT ABRVW BEZEI FROM TVLVT INTO CORRESPONDING FIELDS OF TABLE IT_TVLVT

  WHERE ABRVW = 'Y1' OR ABRVW = 'Y2' OR ABRVW = 'Y3'.

instead of that can i pass 'Y *' or 'Y%' so that i can pass dynamically, and the function guys can maintain all the clinics in 'Y',no need to hard code.

but Y*   or Y% ,is not fetching ...

pls help .......

Moderator message: very basic, please do more research before posting, use more meaningful titles when posting.

Message was edited by: Thomas Zloch

[edgar_nagasaki]

You can do as following:

SELECT ABRVW BEZEI FROM TVLVT INTO CORRESPONDING FIELDS OF TABLE IT_TVLVT

  WHERE ABRVW LIKE 'Y%'.

Regards,

Edgar

[SreekanthKrishn]

Dinesh,

I would say the best option would be to use a range like this.

This method will work for sure, without any issues.

RANGES: R_VAR FOR ABRVW.

R_VAR-SIGN = 'I'.

R_VAR-OPTION = 'CP'.

R_VAR-LOW = 'Y*'.

APPEND R_VAR.

SELECT ABRVW BEZEI FROM TVLVT INTO CORRESPONDING FIELDS OF TABLE IT_TVLVT

  WHERE ABRVW IN R_VAR.

Thanks,

Sreekanth

[Former Member]

while using Y% don't use where ABRVW = 'Y%'.

use the below code.

SELECT ABRVW BEZEI FROM TVLVT INTO CORRESPONDING FIELDS OF TABLE IT_TVLVT

  WHERE ABRVW LIKE 'Y%'.

[Former Member]

Check dis Link..

http://help.sap.com/abapdocu_731/en/index.htm

Regard's

Smruti