topic Re: select query offset. in Application Development and Automation Discussions

select query offset.

Former Member — Tue, 29 Apr 2008 10:53:06 GMT

hi ,

Is this select query Possible.

SELECT COUNT(*) FROM t179

WHERE prodh+8(3) IN so_fam

AND stufe = 4.

This query is showing error, how to validate the select query.

Regards,

Madhavi

Former Member — Tue, 29 Apr 2008 10:59:57 GMT

Hi Madhavi,

SELECT COUNT(*) FROM t179

WHERE prodh+8(3) IN so_fam

AND stufe = 4.

This is not a valid select query.

U proceed like,

Data: V_prodh like proth.

V_prodh = prodh+8(3).

SELECT COUNT(*) FROM t179

WHERE V_prodh IN so_fam

AND stufe = 4.

Reward if helpful.

Former Member — Tue, 29 Apr 2008 11:08:08 GMT

Hi,

Correct the code accordingly.

SELECT COUNT(*) into i_count FROM t179

WHERE where stufe = 4 and substr(prodh,8,12) in s_fam.

If it is helpfull pls reward pts.

Regards

Srimanta

Former Member — Tue, 29 Apr 2008 11:43:51 GMT

hi Srimathe,

This particular piece of code is not working in my system.

Will you please check once and send it to me.

Will you please send the standard SAP help for SUBSTR .

Madhavi

Edited by: varisetty madhavi on Apr 29, 2008 5:34 PM

Former Member — Wed, 03 Aug 2011 12:07:39 GMT

thanks