topic Re: select stmt. in Application Development and Automation Discussions

select stmt.

Former Member — Wed, 12 Jul 2006 04:20:46 GMT

i suppose to add ename and parvw to respective i_sales_cust1. here i am able to add itab but for particular means ename to i_sales_cust1-ename, the syntax i have forgotten. can u help me.

select single a_{PARVW B}ename from KNVP AS A INNER JOIN Pa0001 AS B

ON A_{prnr = B}prnr into i_SALES_CUST1

where kunnr = i_sales_cust1-pkunag.

Re: select stmt.

Former Member — Wed, 12 Jul 2006 04:29:37 GMT

Hi,

select single a~PARVW

B~ename

from KNVP AS A

INNER JOIN Pa0001 AS B

ON A_{PERNR = B}PERNR into i_SALES_CUST1

where kunnr = i_sales_cust1-pkunag.

If you know the values of VKORG

VTWEG

SPART

PARVW

PARZA

also include them in the where clause.

Best regards,

Prashant

Re: select stmt.

Former Member — Wed, 12 Jul 2006 04:30:47 GMT

Hi Kalyan,

Try below code.

select a_{PARVW B}ename into corresponding fields of i_sales_cust1 from KNVP AS A INNER JOIN Pa0001 AS B

ON A_{prnr = B}prnr into i_SALES_CUST1

where A~kunnr = i_sales_cust1-pkunag.

if sy-subrc = 0 "means first record selected

exit. "so that only 1 record is moved

endselect.

Cheers,

Vikram

Re: select stmt.

Former Member — Wed, 12 Jul 2006 04:41:24 GMT

Hi,

Just try this-

select single a~PARVW

B~ename

into corresponding fields of i_sales_cust1

from KNVP AS A INNER JOIN Pa0001 AS B

ON A_{prnr = B}prnr into i_SALES_CUST1

where A~kunnr = i_sales_cust1-pkunag.

Hope this helps u.

Regards,

Seema.

Re: select stmt.

Former Member — Wed, 12 Jul 2006 04:53:19 GMT

hey u can do like this na.

select single a_{PARVW B}ename into (i_sales_cust1-parvw, i_sales_cust1-ename) from KNVP AS A INNER JOIN Pa0001 AS B

ON A_{prnr = B}prnr where kunnr = i_sales_cust1-pkunag.