topic Re: basic select in Application Development and Automation Discussions

basic select

Former Member — Tue, 22 Jul 2008 23:29:53 GMT

SELECT SINGLE

shkzg zfbdt zbd1t zbd2t zbd3t rebzg

FROM bseg

INTO CORRESPONDING FIELDS OF bseg

WHERE

belnr = int_cond-value.

I am not getting any values in bseg.but If I am manually looking at the table of bseg...I am able to see the entries..

is there some thing I need to take care..?

former_member194669 — Tue, 22 Jul 2008 23:50:27 GMT

what will be the sy-subrc value ?

Former Member — Tue, 22 Jul 2008 23:54:38 GMT

its always 4 and I am not getting values from select statement.

former_member194669 — Wed, 23 Jul 2008 00:14:14 GMT

Is int_cond-value variable is same as belnr?

Try for testing just hardcode the value


where
belnr = '0000001234' " Your table available value padded 
" with zeros and check

Former Member — Wed, 23 Jul 2008 02:03:23 GMT

When use INTO CORRESPONDING FIELDS OF bseg , you must use same bseg filednames in the program.

check it once.