select stmt.

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.