topic Re: fetching in Application Development and Automation Discussions

fetching

dineshkumar_shanmugasabap — Fri, 11 Jan 2013 03:22:24 GMT

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

Re: fetching

edgar_nagasaki — Fri, 11 Jan 2013 03:50:52 GMT

You can do as following:

SELECT ABRVW BEZEI FROM TVLVT INTO CORRESPONDING FIELDS OF TABLE IT_TVLVT

WHERE ABRVW LIKE 'Y%'.

Regards,

Edgar

Re: fetching

SreekanthKrishn — Fri, 11 Jan 2013 04:04:33 GMT

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

Re: fetching

Former Member — Fri, 11 Jan 2013 05:53:08 GMT

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

Re: fetching

Former Member — Fri, 11 Jan 2013 06:22:06 GMT

Check dis Link..

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

Regard's

Smruti