topic Re: endselect in Application Development and Automation Discussions

endselect

Former Member — Thu, 06 Dec 2007 19:11:20 GMT

hi am using the following stmt, it says endselect missing.

data v_prctr like viob03-prctr.

SELECT PRCTR FROM VIOB03 INTO V_PRCTR WHERE BUKRS EQ P_BUKRS.

can some one help.

Re: endselect

Former Member — Thu, 06 Dec 2007 19:12:40 GMT

data v_prctr like viob03-prctr.

SELECT single PRCTR FROM VIOB03 INTO V_PRCTR WHERE BUKRS EQ P_BUKRS.

Use single

Re: endselect

naimesh_patel — Thu, 06 Dec 2007 19:13:05 GMT

Put SINGLE

SELECT <b>SINGLE</b> PRCTR FROM VIOB03 INTO V_PRCTR WHERE BUKRS

EQ P_BUKRS.

Regards,

Naimesh Patel

Re: endselect

Former Member — Thu, 06 Dec 2007 19:13:06 GMT

Try this

data v_prctr like viob03-prctr.
SELECT PRCTR FROM VIOB03 INTO V_PRCTR WHERE BUKRS EQ P_BUKRS. 
ENDSELECT.

OR

SELECT SINGLE PRCTR FROM VIOB03 INTO V_PRCTR WHERE BUKRS 
EQ P_BUKRS.

Re: endselect

Former Member — Thu, 06 Dec 2007 19:18:07 GMT

thanks guyz its working.

Re: endselect

Former Member — Thu, 06 Dec 2007 19:41:00 GMT

It may be working, but I doubt if the results will be what you want. It's just taking the first record for the company code.

Rob