topic Re: values not coming in select statement . in Application Development and Automation Discussions

values not coming in select statement .

Former Member — Tue, 26 Dec 2006 01:05:36 GMT

hii frnds

i am not able to get any value in both the variables in my select statement .

after the select statement i have to assign the text to another variable based on what value do i get in my variable through the select statement

TABLES : AUFK.

DATA : T_AUART LIKE AUFK-AUART,

T_TXT LIKE T003P-TXT,

T_AUFNR LIKE CAUFVD-AUFNR,

L_AUFNR LIKE AFIH-AUFNR ,

S_AUFNR LIKE AFIH-AUFNR,

T_DESC(25) type c .

t_desc1(25) type c .

READ TABLE in_tab WITH KEY name = 'CAUFVD-AUFNR' .

T_AUFNR = IN_TAB-VALUE.

SELECT SINGLE AUFNR AUART INTO (S_AUFNR,T_AUART) FROM AUFK WHERE

AUFNR = T_AUFNR .

if T_AUART = 'LM01' .

WRITE 'Description of PM ' to T_DESC .

elseIF

T_AUART EQ 'LM02'.

write 'Description of Defect' to T_DESC .

endif.

kindly help .

thanx

rohit

Re: values not coming in select statement .

Former Member — Tue, 26 Dec 2006 01:12:24 GMT

Hi Rohit

Please take care of the following:

READ TABLE in_tab WITH KEY name = 'CAUFVD-AUFNR' .

---> <b>Check whether the above statement is successful via SY-SUBRC</b>

T_AUFNR = IN_TAB-VALUE.

SELECT SINGLE AUFNR AUART INTO (S_AUFNR,T_AUART) FROM AUFK WHERE

AUFNR = T_AUFNR .

---> <b>Make sure that the value you are passing is having the necessary leading ZEROES. Also check if there is any corresponding entry in table AUFK via SE16 for the value</b>

Kind Regards

Eswar

Re: values not coming in select statement .

Former Member — Tue, 26 Dec 2006 01:21:29 GMT

hii eswar

thanx for ur help i actualy forgot to put that coversion exit . u just reminded me .

thanx a lot .

rohit

Re: values not coming in select statement .

Former Member — Tue, 26 Dec 2006 01:26:11 GMT

Glad could help you Rohit.

Regards

Eswar